Production Order Tables

[Former Member]

Having the Assembly Material # and the Assembly Serial # as the input in which table if I pass these 2 parameters I will get the production order number.

Also where can I find the table to check the Production order status ( Whether it is Closed or Teco).

[muthusamy_sankaran · Accepted solution]

Hi,

pls use function module READ_STATUS

or

use table AUFK --> AUFNR, OBJNR --> JEST-OBJNR --> Status

closed (I0046), Teco (I0045) and inact ne 'X'

AUFK Production order headers

JEST Object status

AFKO Order header data PP orders

AFPO Order item

RESB Order componenten

AFRU Order completion confirmations

AFVC Order operations

AFVV Quantities/dates/values in the operation

JSTO Status profile

Regards,

Sankaran

[Former Member · Accepted solution]

Hi Shankar,

Thanks. I could get the status.

[Former Member]

Hi,

Go and check the table TJ02T. It will help you.

Regards,

Satyajit

[Former Member]

Hi Priya,

Prod.order tables are AUFK( DB ) & AFKO(header) / AFPO(item).

For status, this could be complicated to retrieve ( table JEST ), I suggest you, if u can, use function module READ_STATUS

Hope this helps,

Erwan

[Former Member]

Hi,

Check up with the foll. tables...

AFKO  -       Order Header

AFPO  -       Order Item Detail

AFVC  -       Order Operations Detail

AFFL   -       Order Sequence Details

- Thaila Shree