cancel
Showing results for 
Search instead for 
Did you mean: 

table of the order production operation details and confirmation details

Former Member
0 Kudos

Which is the table of the order production operation details? I need to get the activities for production order :

Setup, Labor, Machine, Confirmed and to confirm.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

That is probably the hardest information to piece together, I used 5 tables with multiple joins to get User Fields

for operations in a production order. Maybe you can use something simular.

AFKO - this is for your basic production header info - order number, basic finish date etc

S022 - this is for your operation header details - operation number, Work centre etc if you are only after the

header details such as setup time and execution time, you can probably stop here without going to AFVC or AUFV (you

definitely need AUFK if you want order status)

AUFK - this is for your order master data - Order released flag, order complete flag, technically complete date,

you'll need this to filter out closed orders

AFVC - this is to link to the detail table - however I used the control key field in it so I would know whether it

was a MILE stone or GPP1 for confirmation's sake

AUFV - this is the user field table - you may want to replace this with whatever detail you are after

Delete all the automatic joins:

AFKO -> AUFK on:

AUFNR -> AUFNR

AFKO -> S022 on:

AUFNR -> AUFNR

PLNBEZ -> MATNR

AFKO -> AFVC on:

AUFPL -> AUFPL

S022 -> AFVC on:

WERKS -> WERKS

PLNFL -> PLNFL

VORNR -> VORNR

The join below is for user fields in operation detail, you will have to find your own relevant table, but I assume

the two key fields will be the same??

AFVC -> AFVU on:

AUFPL -> AUFPL - Routing number of operations in the order APLZL -> APLZL - General Counter for order

Please check www.sap-img.com.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Shwetha,

one important thing i wiold like to highlite is

You will find all activities in PLPO Table.

Fields LAR01....LAR06

but if

Referance indicatore is flagged in workcenter for these activities then system will copy this values as it is in routing (grayed out) but not update above fields.

in order to update these fields in PLPO you have to remove that referance indicator in workcenter and mannualy put those acitivies in routing then only these values will update in PLPO ...

which can be used for any report purpose...

hope this will help you in your problem solving..

Regards

Hemant Gadhari

Former Member
0 Kudos

Hi Shwetha,

one important thing i wiold like to highlite is

You will find all activities in PLPO Table.

Fields LAR01....LAR06

but if

Referance indicatore is flagged in workcenter for these activities then system will copy this values as it is in routing (grayed out) but not update above fields.

in order to update these fields in PLPO you have to remove that referance indicator in workcenter and mannualy put those acitivies in routing then only these values will update in PLPO ...

which can be used for any report purpose...

hope this will help you in your problem solving..

Regards

Hemant Gadhari

Former Member
0 Kudos

Hi Swetha,

You can check these tables

PLAS Task list - selection of operations/activities

PLFL Task list - sequences

PLKO Task list - header

PLKZ Task list: main header

PLMZ Allocation of bill of material items to operations

PLPO Task list - operation/activity