fetch the data from AFRU table

[Former Member]

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

[former_member188724]

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

[former_member188724]

Hi Niru,

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

Regards,

K.S

[Former Member]

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.

[Arun_Prabhu_K]

Hello Niru Reddy.

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