Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Database fields and tables for BOM

Former Member
0 Likes
1,637

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.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
757

BOM Header Data - STKO

BOM item data - STPO

BOM Header Data - STKO

BOM item data - STPO

2 REPLIES 2