Sales and Trade Promotions (Planned+Actual) 

Technical Name: 0CP_SLSC6

Use

This InfoCube is the central data store for

·        The SEM planning application Sales and Promotion Planning for the Consumer Products Industry. For more information on the planning application, see the SAP library under Strategic Enterprise Management ® Business Planning and Simulation ® Planning Applications ® Customer Relationship Analytics.

·        Sales and promotion analyses

·        The generation of a knowledge base on promotions, which is stored in the InfoCube Promotion Knowledge Base (0CP_SLSC8).

The following conventions apply for technical characteristics:

InfoObject	Description	Value	Meaning
0VTYPE	Value Type	'10'	Actual data
		'20'	Planning figures (approved or not yet approved)
		'50'	Budget (binding plan that is drawn up once a year and includes expenses and sales targets)
0VERSION	Version	'000'	Plan/actual version: the approved version for planning figures, for example, a monthly rolling planning. Actual figures should also be assigned to version ‘000’. All queries delivered by SAP are based on this assignment, since it makes the query definition clearer and more efficient.
		Other	Planned figures that have not yet been approved
0CRMVERSION	CRM Plan Version		Assigned by the person responsible for planning in the SAP CRM Marketing Planner
0PERIOD_TYP	Promotion Phase	'30'	Phase before a promotion: Due to the special conditions of an upcoming promotion, sales in the pre-dip phase are lower than usual.
		'50'	Phase during a promotion in which special conditions apply.
		'70'	Phase after a promotion: Due to the special conditions of a previous promotion, sales in the post-dip phase are lower than usual.

The values for 0PERIOD_TYP are supplied exclusively from the SAP CRM Marketing Planner.

Update

An update is not possible with this transactional InfoCube. The InfoCube receives information from four sources:

·        Entry of planned values in an SEM layout (value type ‘20’)

·        Reading of key figure values using a user exit in SEM. For the key figure Predicted Uplift Quantity (0UPLI_PQTY), they are read in layout 4TPM1551 for planning level 4TPM1500 in planning area 4TPM4000.

·        SEM planning functions, especially copying. A copy can be made from one version to another, or from value type ‘20’ (planned) to value type ‘50’ (budget) and version ‘000’.

·        Copies within the SEM planning application Sales and Promotion Planning for the Consumer Products Industry from the InfoCube Sales and Trade Promotions (Actual) (0CP_SLSC7). Since the data is actual data, it is generated for value type ‘10’ and version ‘000’. The following characteristics can also be derived from a business partner group or product hierarchy during the copy process. The prerequisite is that a derivation rule for the user exit UPX_EXIT_HIERARCHY_DERIVE has been stored for the characteristics Business Partner (0BPARTNER) or CRM Product (0CRM_PROD), and that a hierarchy derivation rule has been created in Customizing for SEM Sales Planning.

...

¡        Distribution Channel (0CP_CHANNEL)

¡        Business Partner Group Level 1 (highest level) (0BP_GRP_A01)

¡        Business Partner Group Level 2 (0BP_GRP_A02)

¡        Business Partner Group Level 3 (0BP_GRP_A03)

¡        Business Partner Group Level 4 (0BP_GRP_A04)

¡        Business Partner Group Level 5 (0BP_GRP_A05)

¡        Business Partner Group Level 6 (0BP_GRP_A06)

¡        Business Partner Group Level 7 (0BP_GRP_A07)

¡        Category (0CP_CATEG)

¡        Product Segment (0CP_SEGMENT)

¡        Brand (referencing 0PROD_CATEG) (0CP_BRND)