tables?

[Former Member]

Which tables have PM orders header & line item data.

Plz guide.

Thanks in advance

[Former Member]

Hello,.

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 

Regards,

Vasanth