Need your help on below:
I need to read table AFRU, but unfortunately i just have value AUFNR - Order Oumber as a filter. Since table AFRU's key field is <b>RUECK - Confirmation</b>. So i <b>can not</b> use Order number as a filter because it will kill the performance.
So, pls comment is there any FMs that i can use by supply Order Number and system will return me those Confirmation info(like AFRU). Or comment table linkage to get the Confirmation number.
Thanks in advance.
From which table are you getting/taking the Order Number AUFNR field?
If you are using the table AFKO, you can take the field RUECK from AFKO along with AUFNR and can use it to get data from AFRU.
Even if you are not using AFKO for getting AUFNR, select a single RUECK field from AFKO and use it for getting data from AFRU? or you can join AFKO and AFRU tables also.
Hi Andrey Ryazanov,
Thanks for your reply. I did tried using your way to get the confirmation number from table AFVC.
But in my system, there are some valid confirmation number that <b>doesn't</b> exist in table AFVC at all. And eventually nothing can be get from table AFRU.
Pls help on what are the alternative to cover the scenario. thanks in advance.
I think that's better for me to explain my scenario here in order to us to get to the problem.
Im in 4.6C, basically for each of the Process Order extracted i need to get its <b>Actual Finish date</b> to perform data filtering against the input from selection screen. To view the <b>Actual Finish date</b>, im using TCode COR3-> Tab Dates/qtys -> <b>Actual Finish date</b> display as the last column under Dates.
I did check on table CAUFV and AFKO whereby there is field GLTRI that i can use. The main problem is, for some of the Process Order, field GLTRI doesn't populate with any value but if i view under COR3, the Actual Finish date is there.
What is the consistent way for me to extract the <b>Actual Finish date</b> ?
Im banging my head now. Guys, pls comment.
Thanks in advance.
I had same problem...solution is
The GLTRI field from the AFKO table is no longer used in the standard R/3 System, therefore, it is not always updated.
As an alternative, you can use the LTRMI field from the AFPO table.This field is also used for displaying the confirmed finish date end of the order in the transactions for displaying and changing production or process orders, which also ensures that the same date is used.
The RUECK and RMZHL fields are not getting populated in the AFKO table. There are work arounds to handle this. But I would like to know why these are not being populated. What is the customizing setting that we might need to perhaps change to make this happen? Please advise.