Show TOC

Function documentationIntegration with SAP BI for Reporting Locate this document in the navigation structure

 

CRM ICM is a cross-industry solution that processes variable compensation for employees and partners, such as commissions and incentives. For reporting purposes, SAP BI combines CRM sales data with its corresponding ICM data.

Integration

The SAP BI extractor for the ICM engine is generated automatically, based on the configuration of the commission application. You can also access an ICM InfoSource, created by the Financials group, that contains the following:

  • The four most important result key figures of the calculation process:

    • Calculated commission/incentive

    • Commission/incentive to be paid

    The corresponding InfoObjects already exist inside the standard content for the ICM engine, but are to be renamed (these new InfoObjects reference the existing InfoObjects), because the current names are not fully compatible with CRM.

  • All CRM reference information that enables a combination of CRM and ICM content, including the technical key (order header GUID, order item GUID).

This information is transferred from CRM to the ICM engine, and from there is extracted into SAP BI.

Prerequisites

Before ICM can begin its calculations, it requires context data (for example, product details, such as product category; and customer details, such as region) to drive the commission creation process effectively. This data is obtained by reading the CRM sales documents from the corresponding SAP BI ODS table. The information in the ODS tables is stored at item level as well. In addition to the status fields and the key figures, these tables already provide a lot of master data information (for example, customer hierarchy) that is not read from the CRM master data tables.

Critical information is also extracted into SAP BI after the calculation process. The SAP BI content of the CRM ICM solution is based on the existing content of CRM Sales and the content of FIN ICM.

For more information, see SAP Help Portal under:   Business Information Warehouse   BI Content   Customer Relationship Management   CRM Incentive and Commission Management.  .