Extractor 0FI_AR_4

[Former Member]

Hi,

For Loading the Accounts Receivable Data in BW i am using the Extract sructure 0FI_AR_4. I need the information of Billing Document and Item from the above Data Source for the Corresponding Accounting Document.

The Billing document is stored in 0DOC_NUMBER. How do i get the ITem no o the Billing docuemnt.

Can any one let me know how to derive the Billing No and Item No for the corresponding Account document No.

Let me know the Tables used on the R/3 side, or if there any fields availbale in the extractor 0FI_AR_4 for storing the Item No of the Billing Document.

Thanks,

Saketh.

[Former Member]

HI,

I suggest you to create Generic data source by View type.

Pick up all the realted fields from below mentioned tables and create one view.

View is recomeded because performance would not be affected.

If you try to enhance 0FI_AR_4 data source then it will performance would be degraded as it has read so many tables due to so many joins in coding.

Pick BUKRS / BELNR / GJAHR from BSID / BSAD

2. Go to BKPF - for the above input and for AWTYP = VBRK - pick up value of AWKEY

3. AWKEY is the billing document number

4. Go to VBRP and get billing information at a line item level.

AWKEY and AWTYP are part of the extractor - you can check with 'rsa3' whether they get populated or not.

Regards

Sujan

[Former Member]

Hi,

0FI_AR_4 is based out of BSID / BSAD tables in the source system. The billing document tables in R/3 are VBRK and VBRP. Accounting tables are BKPF / BSEG.

Here is how you can obtain billing document number from accounting document:

1. Pick BUKRS / BELNR / GJAHR from BSID / BSAD

2. Go to BKPF - for the above input and for AWTYP = VBRK - pick up value of AWKEY

3. AWKEY is the billing document number

4. Go to VBRP and get billing information at a line item level.

AWKEY and AWTYP are part of the extractor - you can check with 'rsa3' whether they get populated or not.

You might choose to enhance the extractor and store information pertaining to line item level.

Assign points if useful.

regards,

Pinaki