How do I find the materials consumed from production ticket

[former_member647589]

Hello! I'm completely new to SAP structures, and I'm really lost on this.

I found the total production from a center using AUFK, AFKO and AFPO.

But I need to find the theoretical and actual material consumption in each production ticket.

Does anyone know how can I find it?

[anitaarifin04]

you're welcome, lapenas

[RAF]

The link production order to goods movement is within AUFM table

[anitaarifin04]

Hi Robert Forster,

Thanks for reminder.

Hi lapenas ,

you can use AUFM table too as suggestion from Robert

Best regards

Anita

[former_member647589]

Thank you so much, Anita/Robert,

I really appreciate your help.

Best Regards

Luis

[Caetano]

Hello Luis

Usually, you don't need to go to the tables to find this kind of information. You can get all the information related to a production order in transaction COOIS.

Otherwise, if you need to develop a custom program, you can use BAPI BAPI_PRODORDCONF_GETDETAIL.

Regards,

Caetano

[former_member647589]

Thank you, Caetano Almeida,

I wish I could use this option, but the goal is to create a dataset for a data science team on a sql database for them to work their ML models.

Considering that, I think I can't use that option, can I? Also I don't have developer access to ABAP.

Regards,

Luis

[anitaarifin04]

Hai Luis Peña,

for actual material consumption you can use table MSEG (movement type 101 for GR production and movement type 261 for GI) and table AFRU for actual activity type consumption.

Best regards

Anita A.

[former_member647589]

Thank you so much, Anita Arifin! I'll give it a try right away.