0FIAR_C03 Open line items

[Former Member]

Hi,

I am trying to load open items using 0FIAR_C03, i am in confuse to choose between 0FI_AR_3 AND 0FI_AR_4. Which one must i choose to pull open items from bsid table, but i needs to add SHKZG, DMBTR,WRBTR, INFAE, UMSKS,ZUDNR FIELDS TO THAT EXTRACT STRUCTURE.

PLEASSSE HELP ME

regards

raja

[Former Member]

Hi , Raja .

U should use ODS for Delta and then u can load the ODS data into cube ..

Regrds..

[Former Member]

Hi Raja ,

u should use fi_ar_4 , as 0FI_AR_3 is replaced by 0FI_AR_4.

And this data source is extracting the data from BSID and BDAD tables , so u can get both open as well cleared items.

U donn't need to add fields line SHKZG , DMBTR , WRBTR as it is available in target.

DMBTR is available as 0DEB_CRE_LC and WRBTR is available as 0DEB_CRE_DC . U also have CREDIT_LC and DEBIT_LC which canserve the purpose for SHKZG (As it is mean for debitand credit identifier but u r getting the value in two diffrent info object 0CREDIT_LC and 0DEBIT_LC) .

UMSKS,ZUDNR are also available , please check ..

Regds..

[Former Member]

Hi Akash,

thanks for your reply, and one more thing in this case is it necessary to use ods for delta or can we avoid using ods for delta uploading.

how to select selection fields transfer structure,

regards

raja

[Former Member]

Hi Raja,

0FI_AR_3 is replaced by 0FI_AR_4, Refer OSS note 410797 for mor detaild.

This will pull data from BSID and BSAD.

Also refer this link for more details.

http://help.sap.com/saphelp_nw04/helpdata/en/ee/cd143c5db89b00e10000000a114084/frameset.htm

Hope it helps

Jayasudha