This content has been marked as final. Show 2 replies
I am working on a BIP report on our Asset usage. Can anyone please help me to find out any table or view where I can get the master details of Assets like Asset Category, Asset Id, Asset description etc.
Assets data is stored just like items.
So assets are in mtl_system_items_b.
Categories are in mtl_item_categories
You may try extracting details from CSI_ITEM_INSTANCES which holds ASSET SERIAL NUMBER-wise details. The MTL_SYSTEM_ITEMS (item master) can be linked via INVENTORY_ITEM_ID for getting concerned ASSET GROUP details.
-Praful Talekar (Atul Ltd).