Skip to Content
avatar image
Former Member

Extracting Question for BW 7.0 - step by step

First I would like to apologize for a very basic question, I am having difficulty understanding this, especially with 7.0 changes.

If data (ex. data from vbrk) from R/3 needs to be extracted to BW infocube, what are the steps taken? Can you please be detailed and include tcodes. I'm assuming whatever the first step is, finding SAP provided standard programs to avoid customizing is the highest priority.

If anyone can provide a link or explain it would be much appreciated. I could not find step by step instructions anywhere.

Thanks in advance.

Edited by: Zain13 on Sep 20, 2010 5:37 AM

Edited by: Zain13 on Sep 20, 2010 6:14 AM

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 20, 2010 at 04:31 AM

    Dear ZAIN,

    R/3 SIDE

    =========

    LBWE:- MANITAIN EXTRACT STRUCTURE AND DATASOURCE ; ( EXAMPLE : FOR VBRK TABLE GO FOR 2LIS_13_VDHDR.)

    LBWG:- DELETE SET UP TABLES (EXAMPLE FOR 2LIS_13_VDHDR ---> 13)

    SBIW(0R)OLI*BW :- FILLING UP SET UP TABLES (EXAMPLE: OLI9BW FOR 2LIS_13_VDHDR)

    RSA3:- EXTRACTOR CHECKER (GIVE THE DATASOURCE NAME : 2LIS_13_VDHDR )

    RSA7 :-BW DELTA QUEUE

    BW SIDE.

    =======

    REPLICATE THE DATASURCE THROUGH FUNCTION MODULE (RSDS_DATASOURCE_REPLICATE IN SE37)

    CREATE THE TRANSFORMATION WITH THE DATASOURCE

    CREATE AN INFOPACKAGE AND LOAD.

    regards,

    Suman.T

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi,

      1. Yes .. You need to check for datasource in R/3.. If its not there you can create custom datasource.

      2. Go to RSA3 / RSA6 and there you can check for available datasources.

      3. There are datasources which can extract data from more than 1 table and also you can create your customized datasource to extract data from more than 1 table.

      4. Also you can do some amendments to standard datasource ..

      Hope this helps...

      Thanks,

      Vikrant