cancel
Showing results for 
Search instead for 
Did you mean: 

STEP BY STEP EXTRACTION OF DATA FROM R3 TO BI 7.O

Former Member
0 Kudos

Hi,

I am new to BI 7.0.

Can anybody explain me about the steps involved in extracting data from R3 to BI 7.0?

I know the steps in R3 side.I want to know how to replicate the datasource in BI 7.0 and assigning the Infosource.

Regards,

Sudheer.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Steps for extraction (This will be an overview only)

1. Log into ur R3 system

1.1) Find ur datasource by using tcode RSA5

1.2) To view the records for the particular datsource , use tcode RSA3. verify the records with your functional consultant or customer . IF any more fields are needed then use "Enhancement" strategy.

2. Log into ur BW system

2.1) using Tcode RSA1 - Locate your source system.

2.2) Find your datasource in the sourcesystem and then replicate.

2.3) Locate your Infocube or DSO , where you want to add the datsource.

2.4) I'm giving eg of Infocube : Rt Click your infocube , Select transformation.

2.5) In transformation - Source of Transformation Header , select object type "RSDS Datasource" , Lcoate your source system and then the datasource.

2.6) MAp the fields in the transformation and activate it.and load the infopackage

2.7) Correpsonding DTP would be created, Activate and execute it. The data would be loaded in the cube.

2.8) to check the data has been added in the cube , Rt click Infocube , Manage tab , and see the requests. There will be a column names "Added records". this shows records are added

Even in SDN lot of topic regarding extractiona re given.Just have a go thru.

From

Manesh

Former Member
0 Kudos

Sudheer -

Search in SDN. This question was discussed in forums many times.

Anesh B

chemicala_srimallikarjuna
Active Contributor
0 Kudos

Hi,

Check the following links.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b06...

check the following

http://help.sap.com/bp_biv235/BI_EN/html/bw.htm

business content

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/g-i/how%20to%2...

https://websmp203.sap-ag.de/co

http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/frameset.htm

(navigate with expand left nodes)

also co-pa

http://help.sap.com/saphelp_nw04/helpdata/en/53/c1143c26b8bc00e10000000a114084/frameset.htm

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/fb07ab90-0201-0010-c489-d52...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/1910ab90-0201-0010-eea3-c4a...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ff61152b-0301-0010-849f-839...

LO Extraction

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/f83be790-0201-0010-4fb0-98b...

Check these links:

/people/sap.user72/blog/2004/12/16/logistic-cockpit-delta-mechanism--episode-one-v3-update-the-145serializer146

/people/sap.user72/blog/2004/12/23/logistic-cockpit-delta-mechanism--episode-two-v3-update-when-some-problems-can-occur

/people/sap.user72/blog/2005/01/19/logistic-cockpit-delta-mechanism--episode-three-the-new-update-methods

/people/sap.user72/blog/2005/02/14/logistic-cockpit--when-you-need-more--first-option-enhance-it

/people/sap.user72/blog/2005/04/19/logistic-cockpit-a-new-deal-overshadowed-by-the-old-fashioned-lis

Also Refer this link:

http://www.sap-img.com/business/lo-cockpit-step-by-step.htm

FI-CO 'Data Extraction -Line Item Level-FI-CO

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/a7f2f294-0501-0010-11bb-80e...

FI-GL

http://help.sap.com/saphelp_nw04/helpdata/en/c9/fe943b2bcbd11ee10000000a114084/frameset.htm

http://help.sap.com/saphelp_470/helpdata/en/e1/8e51341a06084de10000009b38f83b/frameset.htm

http://www.sapgenie.com/sapfunc/fi.htm

FI-SL

http://help.sap.com/saphelp_nw2004s/helpdata/en/28/5ccfbb45b01140a3b59298c267604f/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/41/65be27836d300ae10000000a114b54/frameset.htm

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

How to do basic LO extraction for SAP-R3-BW

1. Go to transaction code RSA3 and see if any data is available related to your DataSource. If data is there in RSA3 then go to transaction code LBWG (Delete Setup data) and delete the data by entering the application name.

2. Go to transaction SBIW --> Settings for Application Specific Datasource --> Logistics --> Managing extract structures --> Initialization --> Filling the Setup table --> Application specific setup of statistical data --> perform setup (relevant application)

3. In OLI*** (for example OLI7BW for Statistical setup for old documents : Orders) give the name of the run and execute. Now all the available records from R/3 will be loaded to setup tables.

4. Go to transaction RSA3 and check the data.

5. Go to transaction LBWE and make sure the update mode for the corresponding DataSource is serialized V3 update.

6. Go to BW system and create infopackage and under the update tab select the initialize delta process. And schedule the package. Now all the data available in the setup tables are now loaded into the data target.

7.Now for the delta records go to LBWE in R/3 and change the update mode for the corresponding DataSource to Direct/Queue delta. By doing this record will bypass SM13 and directly go to RSA7. Go to transaction code RSA7 there you can see green light # Once the new records are added immediately you can see the record in RSA7.

8.Go to BW system and create a new infopackage for delta loads. Double click on new infopackage. Under update tab you can see the delta update radio button.

9.Now you can go to your data target and see the delta record.

find your scenario and find what data sources do you need on R3 side and ensure they are active as well:

http://help.sap.com/saphelp_nw04/helpdata/en/37/5fb13cd0500255e10000000a114084/frameset.htm

find your scenario -> data sources -> go to R3 -> sbiw and activate required data source

replicate data sources in BW:

RSA1 -> source systems -> right click on your source system -> replicate

then activate your BC:

service.sap.com/bi -> BI Business Content -> General Information -> SAP BW Business Content - Activation

and execute infopackage (it should be delivered with BC)

Useful links:

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

Pls chk this cookbook for step by step;

http://www.erpgenie.com/sapgenie/docs/MySAP%20BW%20Cookbook%20Vol%201.pdf

http://www.erpgenie.com/sapgenie/docs/MySAP%20BW%20Cookbook%20Vol%202.pdf

Step by step Generic extraction:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d3219af2-0c01-0010-71ac-dbb4356c...

How To doc link

https://www.sdn.sap.com/irj/sdn/howtoguides

Hope this helps

Regards

CSM Reddy