cancel
Showing results for 
Search instead for 
Did you mean: 

How to extract data from SAP-CRM to BW ?

Former Member
0 Kudos

How to extract data from SAP-CRM to BW ?

Accepted Solutions (0)

Answers (1)

Answers (1)

pavan_kumargali
Explorer
0 Kudos

Hi Siva,

Steps for Extracting data from CRM:

Configuration Steps

1.Click on ->Assign Dialog RFC destination

If your default RFC destination is not a dialog RFC destination, you need to create an additional dialog RFC destination in addition and then assign it to your default RFC destination

2.Execute Transaction SBIW in CRM

3.Open BC DataSources.

4.Click on Transfer Application Component Hierarchy

Application Component hierarchy is transferred.

5.SPRO in CRM .Go to CRM->CRM Analytics

6.Go to transaction SBIW-> Settings for Application specific Data Source ->Settings for BW adapter

7.Click on Activate BW Adapter Metadata

Select the relevant data sources for CRM sales

8.Click on Copy data sources

Say yes and proceed

9.Logon to BW system and execute transaction RSA1.

Create a source system to establish connectivity with CRM Server

A source system is created. (LSYSCRM200)(Prerequisites: Both BW and CRM should have defined Back ground, RFC users and logical systems)

10.Business content activation for CRM sales area is done

11.Click on source system and choose replicate datasources.

-


Also you can find some docs in BI Best Practice

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

'customer relationship managment'

http://help.sap.com/bp_biv335/BI_EN/html/BW/CRMAnalytics.htm

http://help.sap.com/bp_biv335/BI_EN/BBLibrary/documentation/B84_BB_ConfigGuide_EN_DE.doc

http://help.sap.com/bp_biv335/BI_EN/BBLibrary/documentation/B03_BB_ConfigGuide_EN_DE.doc

http://help.sap.com/bp_biv335/BI_EN/BBLibrary/documentation/BS4_BB_ConfigGuide_EN_DE.doc

and e.g lead analysis

http://help.sap.com/bp_biv335/BI_EN/BBLibrary/documentation/B72_BB_ConfigGuide_EN_DE.doc

For any other information, feel free to reply me.

Thanks and Regards,

Pavan Kumar Gali.