In which table can we know the production order delivery date?

[Former Member]

In which table can we know the production order delivery completion date?

[former_member211676 · Accepted solution]

Hi Mallika

In production order when we are receive the materials with deficit quantity we manually check the delivery completed or if we receive complete then automatically delivery completes. All these are recorded with system status DLV.

So if we get the date of status  DLV  activated means delivery completed date.

Follow the steps to get DLV status date.

We can look it in production order header -> status changes.

or

1) In table AUFK pass the production order number and get OBJNR value.

2) In table JCDS pass the OBJNR, STAT (system status DLV number I0012 in the field STAT (Get this BS22)) and get the delivery completed date with the field UDATE.

Regards

Kesava

[Former Member · Accepted solution]

Thank you for the answer, it helped me.

[Former Member]

Hi Naga,

Check AUFM table where you can find production order goods receipt document date :

Select your production order (AUFNR) and pass in AUFM table with movement type 101 (BWART) so you can get BUDAT which is posting date of GR for production order.

Hope this is your requirement.

If not revert your exact requirement.

Regards,

Tejas

[Former Member]

Hello Naga,

Do you want to find out the date on which the system status DLV was set on the production order?,

Follow the steps below,

1. Pass you order number in AUFK as AUFNR & get OBJNR.

2. Pass this OBJNR in JCDS with 'Status (STAT)' as I0012 (code for system status DLV) with 'Status Inact' (INACT) as not equal to 'X'.

3. You will get date (UDATE) as well as time (UTIME).

Mangesh S

[Former Member]

Thank very much, it very helpful

[former_member206498]

Hi Naga,

You can find it on AFKO table, field GLTRI (actual finish date). This date will be updated once Goods Receipt has been done and "Delivery Completed" indicator for the production order has been set.

Regards,

Julian

[Former Member]

Hi Naga,

Is this what you are looking for.

AUFK-PDAT2 -> Planned completion date

Thanks,

Barkha

[Former Member]

I am looking for delivery completion date

[Former Member]

Hi,

Pl. refer following options,

1.COOIS- Select confirmations-select order row ---details-check posting date/delivery completion date

2.table AFRU-Enter order number-check posting date-delivery date

Devendra

[Former Member]

Hi Mallika,

To find the corresponding table name you can follow the below path:

Select the field, click on F1. Select the technical button from documentation.This is one of the easiest way to find the table name.

Regards,

Reema

[Former Member]

Hi Reema,

That field indictes the structure name, not the table name.

[Former Member]

Hi Naga,

you can view the structure and the other table associated in SE11. Even simple direct click on the structure should direct you.

Regards,

Reema