How to extract data from SAP-CRM to BW ?

[Former Member]

How to extract data from SAP-CRM to BW ?

[Former Member · Accepted solution]

hi

connect sap crm and sap bw with rfc connection.

activate data source in CRM,

you can test it later in RSA3.

in SAP BW activate objects that exist in data flow for you object (eg activities).

regards

radek

[Former Member]

HI

Go to transaction GNRWB

Select BUS_TRANS_MSG

Select (on the right, the services): BWA_DELTA3, BWA_FILL, BWA_queue

Press Generate.

Also check for the following:

1. The delta should have been initialized successfully.

2. Confirm that all Bdocs of type BUS_TRANS_MSG

are processed with success in SMW01.

3. If there are queues in SMQ1 with erroneous status then activate

these queues.

In Transaction SMQ1 if there are Queues existing with

names beginning with CRM_BWAn (n is number) then

activate these queues in the same transaction.

4.a)If required activate the datasource

Go to transaction BWA5 > select the required datasource and

activate.

4 b) The Delta may not be active ,activate the delta in BWA7 by

selecting the name of the datsource and pressing the candle icon for

'activate delta'.

5. In BW system

Go to transaction RSA1 > modeling > infosources > select the

info source > right mouse click on the selected

infosource > choose option replicate datasource

Activate the infosource.

6. Go to the scheduler for the infosource > select delta in the

update >choose the option PSA only (in the Processing tab)

start immediately

Check the entry in the RSA7 in the OLTP(CRM system)

Regards.

nagaraju.v

[Former Member]

HI

CRM data sources will work as a ERP FI data sources, means we don't have any setup tables concept in CRM.

do what you follow to load the fi data in ERP.same way you can apply for CRM

Regards,

Chandra.

[Former Member]

pretty similar as to loading ECC (R/3) data into BW

[Former Member]

ok.. IS LO-COCKPIT extration is there in crm ...........