Skip to Content
author's profile photo Former Member
Former Member

Extractor 0FI_AR_4

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 05:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 06:31 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.