Sales and Trade Promotions (Actual) 

Technical Name: 0CP_SLSC7

Use

This InfoCube contains data on billing and promotion costs.

The data is also contained in the InfoCube CO-PA: Consumer Products Industry (S_CP) (0COPA_C04). The focus on account and promotion analyses makes it necessary to incorporate a second InfoCube into the standard business content. The second InfoCube is supplied with data from CO-PA. The two InfoCubes differ in the following respects:

·        The cost structure of a product is not mapped in detail in the InfoCube Sales and Trade Promotions (Actual), but summarized in the key figure Internal Value (0INT_VALUE). This procedure facilitates sales planning and specification of targets since margins can be calculated independently of fluctuating manufacturing costs. The key figure can be derived in CO-PA from the condition type VPRS, for example. In this InfoCube, it is updated from the material direct costs and material overhead costs.

·        The InfoObjects contained in the InfoCube Sales and Trade Promotions (Actual) refer to CRM master data. The Business Partner (0BPARTNER) takes the place of the Customer (0CUSTOMER), the CRM Product (0CRM_PROD) the place of the Material (0MATERIAL), and the CRM Sales Organization (0CRM_SALORG) the place of the Sales Organization (0SALESORG).

·        The InfoCube also contains the characteristic European Article Number/Universal Product Code (0EANUPC). This lets you establish a reference to syndicated data or POS data.

Planning data is copied to the InfoCube Sales and Trade Promotions (Planned+Actual) in SU (0CP_SLSCA) within the planning application Sales and Promotion Planning for the Consumer Products Industry.

Update

The update is made alternatively using the InfoSource 0CP_CO_PA.

The update from a CO-PA InfoSource was chosen since condition records from the billing document can be converted to key figure values in CO-PA. Key figure values for a CRM promotion that cannot be determined from the billing document can be merged in CO-PA. These values can be expenses incurred for a purchase order for external services, for example, or costs paid by check and posted straight to FI. There must be a reference to the CRM promotion for a purchase order for external service or for a direct account assignment in FI. Otherwise, the promotion expenses are not taken into account in the update.

The update maps SAP R/3 master data to the corresponding SAP CRM master data:

InfoObject	Derivation
0BPARTNER	Attribute for 0CUSTOMER
0BP_GRP	Derivation for following attributes: ·         0CUSTOMER, 0DISTR_CHAN, 0DIVISION from the update record ·         0CRM_SALORG ·         0HIER_TYPE. You must specify the SAP R/3 customer hierarchy category (0HIER_TYPE) in the start routine for the update to be able to identify the relevant hierarchy that has been replicated in SAP CRM using 0BP_GRP.
0CRM_MKTELM	Attribute for 0CRM_MKTELE
0CRM_PROD	Attribute for 0MATERIAL
0CRM_SALORG	Determination of value from 0ORG_UNIT with ·        0SALESORG (from update record) ·        0CRMSALORGX = X ·        0DATETO >= System date
0CRMVERSION	0
0EANUPC	Attribute for 0MATERIAL
0PERIOD_TYP	50 if 0CRM_MKTELE is filled; otherwise no update
0VERSION	000

Data records are only updated if they fulfill the following prerequisites:

·        Value type ‘10’ (actual data)

·        Currency type (0CUR_TYPE) that is determined in the start routine (this is the company code currency in the standard delivery)

·        Customer number where the attribute Business Partner (0BPARTNER) is filled

·        Material number where the attribute CRM product (0CRM_PROD) is filled

·        Record type ‘F’ ("billing document") or filled result object Marketing Element (CRMELEM)

There is an additional selection process for the marketing element (CRMELEM): Data records with a marketing element are only updated if the following prerequisites are fulfilled:

·        The corresponding CRM marketing element is a trade promotion (0CRM_OBTYP3 = 'TPM' or 'TPT').

·        The data record does not contain the record type ‘A’ (sales order)

This makes sure that values from sales orders and billing documents are not mistakenly added up in a query.

 

The delivered CO-PA Business Content can include the following:

·        InfoCube

·        InfoSource (communication structure)

·        Update rules

The following cannot be delivered:

·        DataSource

You create DataSources manually in the IMG for the OLTP system (which can be accessed using transaction SBIW) under Customer-Defined DataSources ® Profitability Analysis ® Create DataSource.

·        Transfer rules (assignment of DataSource to InfoSource)