crm load to bw

[Former Member]

Can anybody please let me explain followings-

1. step by step procedure to load crm data from an existing crm data source(both crm and bw side)

2. procedure to enhance an existing crm data source

Thanks

Deep

[chemicala_srimallikarjuna]

Hi,

Data from CRM to BW is divided into diiferant Data sources.

First need to find data source name.

Use the following seps

First of all, activate the CRM DSs by scenario:

1) Activate the application component hierarchy (tcode RSA9). Changes made to the application component hierarchy in the CRM system can be transferred to the BW using the "Edit Application Component Hierarchy" (SBIW - Postprocessing of DataSources).

SAP Note 434886 must be implemented in CRM 3.0 before the application component hierarchy is activated.

2) Activate the Business Content DataSources (tcode RSA5).

Select/enter the application component and choose Execute (F8).

To compare the shipped and active versions, choose the 'Select Delta' pushbutton. If there is no active version of the DataSource, it is selected automatically.

To activate the shipped version, choose the 'Transfer DataSources' pushbutton.

3) Management of the versions of the BW-Adapter metadata (tcode BWA5). All DataSources are displayed that are managed by the BW Adapter.

As in transaction RSA5 (Service API Metadata Activation), the 'Select Delta' function can be used to select the inactive DataSources or compare shipped and active versions.

You can also go directly to the screen for maintaining DataSources that are managed by the BW Adapter.

The 'Compare Version' function makes a detailed comparison of the shipped and active versions.

All BW-Adapter metadata is considered when versions are compared:

Header information (Table SMOXHEAD)

Mapping information (Table SMOXRELP)

Global selection conditions (Table SMOXGSEL)

Attribute key fields (Table SMOXAFLD)

It is depends if you want to use in BW some ready made (Business Content) data analysis models.If so, you need to find your data source in RSA5 in CRM and activate it. See this link http://help.sap.com/saphelp_nw2004s/helpdata/en/04/47a46e4e81ab4281bfb3bbd14825ca/frameset.htm to find Cube you want to analyze in BW, and Data Source connected to it.

BW CRM analysis.

http://help.sap.com/bp_biv135/html/bw.htm

Pls chk this link for Crm enhancement

BWA1 is for all standard crm datsource maintaince

rsa2 for generic datasource

BWA5 i think we use this Tcode after RSA5 activation additionally.

yes(incase of delta)

BWA7 do we have to use this tcode along with BWA1 for standard datasources also or else only for generic datasource.

irrespective of the type of dtasource,use it if you want to load delta(you need to delta enable the datasource here)

So we don't need to put the code as we traditionally do it for R/3 , if we just mapp the fields that would bring the data for these fields.

as i told in CRM we willwrite code in BADI in case you have done enhancement

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/biw/a-c/customer%2...

also chk this(credit goes to the writer)

CRm enhancement:

1. Enhance Extract Structure with the required fields. (Create & include an append structure to the extract structure via transaction RSA6).

2.a) Release the fields of the append for usage. ( To do this, double click on the Datasource and remove the flags in the column 'Hide Field' for all fields of Append).

2.b) If the new fields cannot be seen in the extract structure of the transaction BWA1 then change and save the datasource, and then activate it in RSA6.

3. Define your mappings in BADI (CRM_BWA_MFLOW) to fill these fields.

Goto SPRO . Follow the path ->SAP Implementation guide ->Implementation with other mySAP components ->Data transfer to the Business Information Warehouse-> Settings for the application specific datasources (CRM)->Settings for BW adapter-> Badi :BW adapter :Enhancement of datasources in messaging flow.

4. Replicate the new Datasource to BW.

5. Expand the Communication Structure in BW.

6. Maintain transfer Rules for the new Datasource.

7. Activate the trasfer rules and perform the upload.

Refer to the SAP Note 692195 for more info ......

.

*pls assign points,if link is useful*

Regards

CSM Reddy