This DataSource replaces the two obsolete DataSources 0CRM_MKTELM1_PSMD and 0CRM_MKTELM2_PSMD. It fills the attribute 0CRM_MKTELM of InfoObject 0WBS_ELEMT.
In CRM Marketing Analytics, the InfoObject 0WBS_ELEMT is used when marketing projects maintained in the CRM Marketing Planner, such as campaigns or marketing plans, are transferred to a connected ERP system. In this process, WBS elements are created in the ERP system. WBS elements serve to calculate costs and revenues for CRM marketing projects in Profitability Analysis (CO-PA). After extraction to the BI system, the WBS elements are visible as values of InfoObject 0WBS_ELEMT. While all other attributes of 0WBS_ELEMT originate in the ERP system, the CRM marketing projects from which the WBS elements were created originate in the CRM system.
In BI Content, the CO-PA data is extracted from the ERP system to InfoCube 0COPA_C02. In this InfoCube, however, only the ERP fields are filled properly. The corresponding CRM fields are not filled since this information is not available in the ERP system: Instead of the business partner (0BPARTNER), the CO-PA data uses the customer number (0CUSTOMER) mapped and created during the transfer to ERP; instead of the CRM product (0CRM_PRODUCT), it uses the material number (0MATERIAL); instead of the CRM marketing element (0CRM_MKTELM), it uses the WBS element (0WBS_ELEMT or 0CRM_MKTELE, which has 0WBS_ELEMT as a reference).
For a more elaborate success measurement, the CO-PA data needs to be enhanced with the CRM references. Filling the CRM fields during the extraction of the CO-PA data from the ERP system to the BI system can lead to data corruption if the attribute 0BPARTNER of 0CUSTOMER is not up to date. This also applies to attributes 0CRM_PROD of 0MATERIAL and 0CRM_MKTELM of 0WBS_ELEMT. The data would then have to be reloaded from the ERP system. To avoid this, the CO-PA data is enhanced with CRM references in a secondary staging process during which data from 0COPA_C02 is propagated to 0MKTG_C04.
Application Component | CRM Marketing Master Data (0CRM_MKT-IO) |
---|---|
Available as of Release | SAP CRM 5.0 |
Shipment | SAP NetWeaver 2004s |
Content Versions | 700 |
RemoteCube-Capable | No |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | No |
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
---|---|---|---|
|
Project Planning: External Identifier of an Element |
|
|
|
Work Breakdown Structure Element (WBS Element) |
|
|
|
Date When the Object was Changed |
|
|
|
Date When the Object was Created |
|
|