Skip to Content
author's profile photo Former Member
Former Member

crm load to bw

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



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 05, 2008 at 01:23 PM


    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 to find Cube you want to analyze in BW, and Data Source connected to it.

    BW CRM analysis.


    Pls chk this link for Crm enhancement

    Enhance standard data sources in CRM

    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

    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*


    CSM Reddy

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.