|
How to extract data using BW from CRM?
Steps for Extracting data from CRM: Configuration Steps: 1. Click on -> Assign Dialog RFC destination
2. Execute Transaction SBIW in CRM 3. Open BC DataSources. 4. Click on Transfer Application Component Hierarchy
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
8. Click on Copy data sources
9. Logon to BW system and execute transaction RSA1.
10. Business content activation for CRM sales area is done 11. Click on source system and choose replicate datasources.
In CRM6.0, do we need to use BWA1 tcode to map the fields between CRM and BW, the way we used to do in earlier CRM versions? Below are the steps for CRM(6.0) extraction as per my knowledge: 1. Activate the DS in RSA5.
Notes: If you are have SAP CRM 5.x or later, you would activate the DataSources in RSA5 and maintain in RSA6 as you do for FI DataSources in R3/ECC. The only difference in the technology is that the extraction
goes through a BW Adaptor on SAP CRM and passes through a Service API to
SAP BW. In the end, though, it's really no difference than FI.
Same as FI extractors in R3/ECC. After you have activated the DataSource in RSA5: 1) Go to RSA6 and click on the Enhance Extraction Structure
button.
There is no interval settings required, like there are for FI. Here's the technical description of the CRM extraction process for both Full and Delta extraction. 1) SAP BW calls the BW Adapter using the Service API.
Some considerations for Delta are: 1) Net changes in CRM are communicated via BDoc.
CRM systems use what is called as a BW adapter to extract data - for other systems it is the Service API - hence these tcodes will be used - this is because CRM systems are based on BDocs and traditional R/3 systems are based on iDocs and ALE technology. Tcodes:
SAP CRM Books
SAP CRM Hints
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|
|