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

Clarification: Extraction from R3 to BW

Hello,

Can you give all the steps and transactional codes (involved to see the table on R3 and to retrieve data) if I have to retrieve data from the standard general ledger extractor to BW environment?

The extraction is supposed to be delta with Fiscal Year/Period as selection criteria.

By the way, what actually an extractor? A program or just a table of fields?

I have already seen different SAP links and I have the general idea but can you directly answer my question if you were in front of a computer and needs to implement what I described?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 19, 2006 at 06:51 AM

    hi amanda,

    Extractor z nothing but Datasource which u r using in R/3 say 2LIS_02_HDR.

    steps involved in R/3 extraction

    1. Go to tcode LBWE

    2. choose the Data source i.e extractor which suits to ur business scenario.

    3. u need maintain the DS i.e where u can add or remove the fields 4m d extract structure....we can add d fields simply tranfering fields from Communication Structure to the Extract Structure.

    4.u have generate the Data Source .

    5.Activate the Data source.

    6.choose which type of update is needed i.e it could be either Direct, Unserialised V3 or Queued delta.

    7.delete the setup tables by tcode LBWG.

    8.run statitistical setup by tcode OLI*BW, * depends upon the application say 2-purchasing,11-sales order, 12-shipment, 13-billing....etc.

    goto RSA6 in R/3 system and say transport the DS.

    9.Go to bw system->source system in Modelling say replicate DS and activate the transfer rules and do all d need work on bw side .

    regards

    bhaskar...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 12:47 AM

    0fi_gl_6 would be the extractor which you are looking for and it is delta enabled...

    rsa5 - to activate the datasource...

    after you activate you can check it in rsa6...

    goto rsa3 (extractor checker) to see how many records you have or to look at the records...

    for tables you can use se16 or se11 ...tables would GLT0..

    so after you activated the datasource and checked using RSA3...goto BW -->source system and replicate datasources...you then install the Infosource in BW for this..transfer rules...cube and the update rules...

    assign points if it helps

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2006 at 03:55 AM

    Hi Amanda,

    Adding to the above, Extractors are programs.

    Regards

    Sajeed

    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.