I would like to know how to identify a particular item that is bought, if it is a raw material that will be used for further processing to build any other finished product or if it is a finished product that can be sold directly. I need to find out which table and which column we can find the information from?
For example, we bought an item like motherboard, which is used as a raw material to build a laptop.
I suppose it is clear, so, can any one let me know which table has this kind of information. Is it available in the Purchasing module tables like PO_Headers_all, etc..
Check table MTL_SYSTEM_ITEMS_B, COLUMN BOM_ITEM_TYPE.
BOM_ITEM_TYPE = 1 (Model)
= 2 (Option Class)
= 3 (Planning)
= 4 (Standard )
So if BOM_ITEM_TYPE 1 means it is configurable. & 4 means it can be used as raw material as well as individual product ex. keyboard.