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
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.
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |