Skip to Content

Applies to:

SAP NetWeaver BI 7.0 and SAP CRM 5.0(and above).

Summary

This paper explains the enhancements specific to business partner in CRM and then retracting BW relevant data to CRM.

Author: Akella Kameswari

Company: Deloitte Consulting

Created on:  25 March 2012

Author Bio

Kameswari Akella is currently working in Deloitte Consulting on SAP BI/BW.

Scenario

There is a need to write attribute values for the business partner into SAP CRM and store this data in a table in CRM .I want to transfer infoobject attributes (Address and Gender) for the infoobject Business Partner. For transferring data from SAP BW, start by defining a data target in SAP CRM, and then use this data target in SAP BW to model the data transfer process in the form of an analysis process. I want to store the transferred data from SAP BW in the form a table in CRM, so that this custom table can be used for other purposes. 

To achieve this, we have to first create a data target in CRM of the type “Enhancements Specific to Business Partners” and then create an analysis process in BW to retract the BW data to CRM.

Enhancements Specific to Business Partners (Steps in CRM)

Step 1: Create a table ‘ZTABLE_APD’  in CRM. It should fall within the customer namespace (that is, the table name has to begin with Y or Z) and it has to have the business partner number as its key.

/wp-content/uploads/2012/03/1_82907.png

Step 2: You should have authorizationfor the authorization object C_CRMBWTGT to perform step 3

/wp-content/uploads/2012/03/2_82908.png

Step 3: Goto SPRO –>Integration with Other mySAP Components –>Data Transfer from SAP Business Information Warehouse

/wp-content/uploads/2012/03/3_82909.png

Now, execute ‘Release Data Targets for Replication from SAP BW’ or if you want to jump to the below screen without following the navigation, directly use transaction code ‘CRMBWTARGETS’. Define the table ‘ZTABLE_APD as a data target and target attributes as ‘ADDRESS’ and ‘GENDER’ and specify their corresponding BW InfoObjects(0ADDR_LINE0 and 0GENDER respectively) in Customizing for SAP CRM.

/wp-content/uploads/2012/03/4_82910.png

BW Retraction

Model an analysis process “ZAPDRR” for transferring data from attributes (0ADDR_LINE0 and 0GENDER) of 0BPARTNER to CRM attributes (ADDRESS and GENDER),which are the fields of  the table ‘ZTABLE_APD’. To achieve this, create the analysis process with source as 0BPARTNER infoobject and Data target of the type CRM with selection of the data target that is defined in step 3(above). You set a data flow arrow between the datasource and the data target to assign the BW attributes ‘0ADDR_LINE0’ and ‘0GENDER’ to the fields ‘ADDRESS’ and ‘GENDER’ of the table ‘ZTABLE_APD’ that is created. The screenshot for the datasource is given below:

/wp-content/uploads/2012/03/5_82911.png

/wp-content/uploads/2012/03/6_82912.png

Data target should be of the type CRM with selection of the data target that was defined previously.

Select the datatarget as ‘Enhancements Specific to Business Partners’ and the subobject should be the table created in step1. The table fields will be available as data targets.

The screenshots are given below:

/wp-content/uploads/2012/03/7_82913.png

Select the table fields of the table(table is created in step1) from list of  Available Attributes to the Selected Attributes.

/wp-content/uploads/2012/03/8_82914.png

Double click on the dataflow arrow between the datasource and the datatarget. Initially, no assignments will be present between the source structure and target structure.

/wp-content/uploads/2012/03/9_82915.png

Now, assign 0BPARTNER of the source to the target field Business Partner ID. The screenshot is given below:

/wp-content/uploads/2012/03/10_82916.png

Now, assign 0ADDR_LINE0 of the source to ADDRESS field of target table(ZTABLE_APD). The screenshot is given below:

/wp-content/uploads/2012/03/11_82917.png

Now, assign 0GENDER of the source to GENDER field of target table(ZTABLE_APD). The screenshot is given below:

/wp-content/uploads/2012/03/12_82918.png

The final screen looks as follows:

/wp-content/uploads/2012/03/13_82919.png

Now check analysis process.

/wp-content/uploads/2012/03/14_82920.png

Activate the above analysis process.

Give the technical name for the above analysis process.

/wp-content/uploads/2012/03/15_82921.png

/wp-content/uploads/2012/03/16_82922.png

Execute the analysis process.

/wp-content/uploads/2012/03/17_82923.png

The logs are shown below:

/wp-content/uploads/2012/03/18_82924.png

The data is transferred from SAP BW into the CRM table ZTABLE_APD which we have created.

Results

Execute the 0BPARTNER in BW for few business partners and compare the address and gender values in BW and CRM. In BW, let us restrict data to 6 Business Partners. The screenshot is given below:

/wp-content/uploads/2012/03/19_82925.png

The attributes Address Line 0 and Gender values for the corresponding 6 Business Partners is given below:

/wp-content/uploads/2012/03/20_82926.png

In CRM,execute the table ‘ZTABLE_APD’ with the same restrictions as in BW i.e., for the 6 Business Partners with which we have restricted data in BW.

The screenshot of the selection screen for the table ‘ZTABLE_APD’ in CRM is given below:

/wp-content/uploads/2012/03/21_82927.png

The address and genders are populated correctly for the corresponding Business Partners. The screenshot is given below:

/wp-content/uploads/2012/03/22_82928.png

In this way, enhancements specific to Business Partners can be done in CRM and then data can be retracted from SAP BW to CRM.

Related Content

Analysis Process Designer

CRM Attributes

Data Targets for SAP CRM

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply