on 10-10-2007 5:38 AM
Hi All,
Can I know from which table can I get the production order completion date.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
hi
Field name GLTRI in table AFKO
Chandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Priya Rajaram,
check in AFKO table for field GLTRI - Actual Finish Date.
Regards
Mangal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
please check with field (DGLTP) in AFPO table
regards
pradeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
you can check with the production order completion date table AFVV (Quantities/dates/values in the operation)
regards,
Mohan R
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.