topic Re: fetch the data from AFRU table in Application Development and Automation Discussions

fetch the data from AFRU table

Former Member — Fri, 26 Sep 2014 12:34:29 GMT

Hi Experts,

i have an requirement that , i need to fetch confirmation details (IW47) by passing Order no.(AUFNR).

the required output fields are available in AFRU table , but the input filed AUFNR is not key filed in table AFRU.

if i fetch the data from AUFR using order no , is leads to performance issue in Production environment

Please advice , is there any other way to get the data?

Regards

niru

Re: fetch the data from AFRU table

former_member188724 — Fri, 26 Sep 2014 13:25:43 GMT

Hi Niru,

You have the key fields

RUECK

RMZHL

of AFRU in table AFKO.

You can take These fields from AFKO based on AUFNR and pass it to AFRU.

Hope this helps.

Regards,

K.S

Re: fetch the data from AFRU table

former_member188724 — Fri, 26 Sep 2014 13:31:00 GMT

Hi Niru,

In Addition you can check the view /ISDFPS/V_ORCONF also which has the same relation.

Regards,

K.S

Re: fetch the data from AFRU table

Former Member — Fri, 26 Sep 2014 14:41:17 GMT

Niru,

You can go directly using AUFNR to AFRU. But take care to get Valid confirmation from available confirmations of Order. While fetching the data use the below fields in Where condition.

Ex :

AND vornr EQ '0010' - Activity (Ex : Activity 0010)

AND learr EQ 'LDS000' - Activity Type for Confirmation (Ex: Confirmation LDS000)

AND stokz EQ space - Indicator: Document Has Been Reversed

AND stzhl EQ space. - Confirmation counter of cancelled confirmation

So the Performance issue will not be there. If you will go with only AUFNR you will get multiple
Confirmations/Cancellations and you need to filter it again which will hamper the SAP system.

Thanks,

Venkatmani.

Re: fetch the data from AFRU table

Arun_Prabhu_K — Sat, 27 Sep 2014 08:29:01 GMT

Hello Niru Reddy.

You can use BAPI_PRODORDCONF_GETLIST by passing order (AUFNR) to fetch the entire confirmations.