cancel
Showing results for 
Search instead for 
Did you mean: 

Production Order Completion date

Former Member
0 Kudos

Hi All,

Can I know from which table can I get the production order completion date.

Accepted Solutions (1)

Accepted Solutions (1)

former_member196398
Active Contributor
0 Kudos

Priya,

There are different thoughts as you did not clearly explain what you meant by Order Completion date.

If you are looking at based on,

Confirmation then AFKO-GETRI

Goods Delivery then AFPO-LTRMI

If you are looking at Based on Status CLSD then you need to find the status change document using table JCDS-TJ02 with referance to the Object Number of the Production order from AUFK table.

Regards,

Prasobh

Former Member
0 Kudos

Hi Prasobh,

I am looking at the completion date after the order is closed.

I am not very clear of what u have said.

Can u pls tell me stepwise.

former_member196398
Active Contributor
0 Kudos

Priya,

Order status changes documents are available in JCDS table, but the primary key there is Object Number which you need to get it from AUFK table. Here is how you can fetch,

1. Get value of AUFK-OBJNR by passing the value of AUFNR(Order Number) in AUFK table.

2. Get value of JCDS-UDATE by passing already fetched OBJNR value along with values of STAT=I0046(CLSD status) and INACT = " "(Blank).

Hope this helps...

Regards,

Prasobh

Former Member
0 Kudos

Hi Prasobh,

Thanks a lot. I got the completion date from JCDS table

former_member196398
Active Contributor
0 Kudos

Priya,

Welcome.

Regards,

Prasobh

Answers (4)

Answers (4)

Former Member
0 Kudos

hi

Field name GLTRI in table AFKO

Chandra

former_member184655
Active Contributor
0 Kudos

Dear Priya Rajaram,

check in AFKO table for field GLTRI - Actual Finish Date.

Regards

Mangal

Former Member
0 Kudos

Hi,

please check with field (DGLTP) in AFPO table

regards

pradeep

Former Member
0 Kudos

hi,

you can check with the production order completion date table AFVV (Quantities/dates/values in the operation)

regards,

Mohan R