‎2006 Mar 27 11:22 AM
for each material find whether the components exist for that material. In case it is a production BOM retrieve all the components from the MAST, STPO and STKO tables.
how to fetch that and what is production bom means
‎2006 Mar 27 11:58 AM
Hi Janardhan,
A production BOM refers to the BOM usage (STLAN).
All the components that are needed to produce a material will be a part of the production BOM.
The easiest way to retrieve data is to do a select join on the three tables ( MAST, STKO, and STPO )
If you know that the BOM Category ( STLTY = 'M') then you can also use the function module :
CALL FUNCTION 'CS_BOM_EXPL_MAT_V2'
EXPORTING
capid = space
datuv = sy-datum
mtnrv = material number
stlal = '01'
stlan = '1' "prod bom
werks = space
mehrs = 'X'
IMPORTING
topmat = v_topmat
dstst = v_dstst
TABLES
stb = vit_stb
EXCEPTIONS
OTHERS = 1.
Regards,
Urmila
‎2006 Mar 27 12:16 PM
Hi,
Pass '1' to field STLAN while querying MAST to get the BOM number, pass the bom number to get components from STPO.