PP: Production order consumption of serialized components - In which table is it stored?

[john_hawk]

Hi Gang,

Trying to create a report with the component material number and the PO Serial number from which the component was made associated with the consuming production order.

Is this data stored in a table? Which one?

Is this information displayed in a transaction code? If so, which one?

Thanks,

John Hawk

[former_member202945 · Accepted solution]

Hi John,

Yes these details are stored in Tables.

Follow the below steps to get serial numbers of components of a production order:-

1) Pass Order Number, Component Number, Movement type as 261 into Table MSEG, this will give you the Material Document against which the components are consumed.

2)Pass Material Document got from the Step1 to SER03 Table, this will give Object List number corresponding to Material Document.

3)Pass Object List number to OBJK TABLE, this will give us the list of serial numbers of a specific components.

The above logic will give u the Serial Numbers of the components consumed in a Production order.

Hope this should answer your question, if yes please mark this as Answered.

[former_member202945]

Hi John,

Yes these details are stored in Tables.

Follow the below steps to get serial numbers of components of a production order:-

1) Pass Order Number, Component Number, Movement type as 261 into Table MSEG, this will give you the Material Document against which the components are consumed.

2)Pass Material Document got from the Step1 to SER03 Table, this will give Object List number corresponding to Material Document.

3)Pass Object List number to OBJK TABLE, this will give us the list of serial numbers of a specific components.

The above logic will give u the Serial Numbers of the components consumed in a Production order.

Hope this should answer your question, if yes please mark this as Answered.

[Caetano]

Hi John

Goods movements for a production order are stored in table AUFM, as long as this is active in the order type customizing. Transaction COOIS will also show the documented goods movements.

Regards,
Caetano

[john_hawk]

Thanks for the information, but I am looking for the the consumption of the component material's serial number.

John Hawk