cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to obtain the BOM (Bill of Materials)

KlausWangc
Explorer
0 Kudos
1,416

Dear experts:

How to obtain the BOM (Bill of Materials)
The BOM has enabled ECM management, and it is necessary to retrieve the production start and end dates of the BOM components.

Can you provide me with a case study or which tables to use?

KlausWangc_0-1757304988902.png

As shown in the above figure, extract all components of the BOM, and the effective start and end dates of each component need to be specified。

thanks

View Entire Topic
Lakshmipathi
SAP Champion
SAP Champion
0 Kudos

Query STKO for MATNR = FG1234, WERKS = 1000, STLTY = 'M', get STLNR = 00000001, STLAL = 01.

Query STPOZ for STLNR = 00000001, STLAL = 01. For each component, get IDNRK, DATUV, DATUB, AENNR.

Query AENR for each AENNR to get change details. This gives you a complete list of BOM components with their validity periods, as governed by ECM.