Database fields and tables for BOM

Former Member — Sat, 24 Mar 2007 12:44:43 GMT

Please help on following points which are from requirement on the new program i have to develop.

(1) Source the Material Quantity

The new program will need to search all plant/s if the plant field in the search criteria is blank, or alternatively, search the material, plant and storage location criteria combination, for the current unrestricted stock quantity of material/s.

i can find this Unrestricted stock value from the material master field – MARD-LABST. am i correct?

(2)Locate the Bill of Material High Level materials.

When the quantity of material/s at the plant/s is sourced, the program will then need to goto the Bill of Material (BOM) functionality in SAP to find the Valid (on the current date) High Level material/s, associated with the BOM Low Level material number entered into the program screen. If the materials entered into the program matnr field is not a Low Level BOM, then report the error in the spool report.

this is the point where i am stuck,please tell me how cani do this. i mean from which tables i have to fetch the high lavel material associated with BOM low level material number. also i don't know how do we identify the high and low lavel materials in a BOM.

Finally i have to create a batch program for Transfer Posting (Material to Material Transfer) to convert Low lavel BOM material into high lavel BOM via transaction MB1B, which can be done only when above secoond issue is resolved.

Re: Database fields and tables for BOM

Former Member — Sat, 24 Mar 2007 12:59:56 GMT

BOM Header Data - STKO

BOM item data - STPO

topic Re: Database fields and tables for BOM in Application Development and Automation Discussions

Database fields and tables for BOM

Re: Database fields and tables for BOM

Re: Database fields and tables for BOM