Sales and Trade Promotions (Planned+Actual) in Sales Units 

Technical Name: 0CP_SLSCA

Use

This InfoCube is the central data store for:

·        The SAP SEM BPS planning application Sales and Promotion Planning for the Consumer Products Industry

·        Sales, account and promotion analyses

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

You can carry out planning using both SAP SEM BPS and the SAP CRM Marketing Planner.

·        If you carry out planning directly in SAP SEM BPS, you can also plan the contribution margin as well as sales revenue and sales quantities.

·        If you plan using the SAP SEM-BPS extended planning layout embedded in the SAP CRM Marketing Planner, you can generate conditions from key figure planning.

The following tables indicate the relationships and the differences.

Contribution Margin Scheme

In the contribution margin scheme, the position of the key figures is determined by the following method of sales deduction:

·        Direct and customer-dependent

·        Indirect and customer-dependent

·        Customer-dependent

 

Row	InfoObject		Derivation/Remark
1	0COPAREVEN	Revenue	Revenue = billing quantity * list price
2	0CUST_DSCNT	Customer Discount
3	0PROD_DSCNT	Material Discount	These key figures are not planned, so they are only available in the InfoCube Sales and Trade Promotions (Actual) 0CP_SLSC7.
4	0QTY_DSCNT	Quantity Discount
5	0CASH_DSCNT	Cash Discount
6	0REG_DISC	Total of All Regular Discounts	2+3+4+5
7	0OFFR_DSCNT	Variable Promotion Discount (Invoice Markdown)
8	0FRGO_DSCNT	Free Goods Discount
9	0OFFINVDISC	Direct Discounts	6+7+8
10	0BONUS_SCAN	Variable Bonus Based on Scanner Data
11	0BONUS_SHIP	Variable Bonus Based on Sales Quantity
12	0VOL_REBATE	Retail Rebate (Bonus)
13	0COPAODSCNT	Other Sales Deductions
14	0COPADISCT	Total Sales Deductions	9+12+13
15	0COPANETRV	Net Revenue	1-14
16	0INTVALUE	Internal Value	Using condition type VPRS, see also SAP Note 547570
17	0COPAMRGN1	Contribution Margin 1	15-16, if internal value = cost of goods manufactured
18	0CP_LSTFEE	Listing/Shelf Space Fee
19	0BONUS_DISP	Fixed Bonus for Displays
20	0BONUS_FEAT	Fixed Bonus for Features
21	0CP_INSTFEE	Funds	19+20
22	0PROMOTIONS	Direct Promotion Costs (External Service)
23	0OTHCUSTCST	Other Customer Costs
24	0COPAMRGN2	Contribution Margin 2	17-18-21-22

 

Sales, Sales Deductions and Costs for Trade Promotions

The position of the key figures is determined in accordance with:

·        Regular sales deductions

·        Sales deductions that are granted as part of the trade promotion

·        Costs arising as a result of a trade promotion

The numbering corresponds to the previous table.

 

Row	InfoObject		Derivation/Remark
1	0COPAREVEN	Revenue	Revenue = billing quantity * list price
2	0CUST_DSCNT	Customer Discount
3	0PROD_DSCNT	Material Discount	These key figures are not planned in Trade Promotions, so they are only available in the InfoCube Sales and Trade Promotions (Actual) 0CP_SLSC7.
4	0QTY_DSCNT	Quantity Discount
5	0CASH_DSCNT	Cash Discount
6	0REG_DISC	Total of All Regular Discounts	2+3+4+5
7	0OFFR_DSCNT	Variable Promotion Discount (Invoice Markdown)	Variable promotion discounts
8	0FRGO_DSCNT	Free Goods Discount
10	0BONUS_SCAN	Variable Bonus Based on Scanner Data
11	0BONUS_SHIP	Variable Bonus Based on Sales Quantity
15	0COPANETRV	Net Revenue	1-6-7-8-10-11

 

Other Promotion Sales Deductions and Costs

19	0BONUS_DISP	Fixed Bonus for Displays	With condition generation in the SAP CRM Marketing Planner
20	0BONUS_FEAT	Fixed Bonus for Features
22	0PROMOTIONS	Direct Promotion Costs (External Service)	Entry of actual data using CO-PA cost element
25	0BUDGET	Promotion Budget	7+8+10+11+19+20+22

 

The following list contains InfoObjects for the relevant prices and conditions per sales unit:

Row	InfoObject (Value Field)		Condition
1	0COPAREVEN	Revenue	0PRC_LST_SU	List price
6	0REG_DISC	Total of All Regular Discounts	0PRC_REG_SU	Regular sales price
7	0OFFR_DSCNT	Variable Promotion Discount (Invoice Markdown)	0OFFR_DSCSU	Variable promotion discount (invoice markdown)
8	0FRGO_DSCNT	Free Goods Discount
10	0BONUS_SCAN	Variable Bonus Based on Scanner Data	0BONUS_SCSU	Variable bonus based on scanner data
11	0BONUS_SHIP	Variable Bonus Based on Sales Quantity	0BONUS_SHSU	Variable bonus based on sales quantity
15	0COPANETRV	Net Revenue	0NET_PRC	Net price

 

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)
		‘60’	Forecast
0VERSION	Version	The version contains the plan type, for example the master plan or the current rolling forecast.
		C00	CP: Copy the actual data to the plan InfoCube
		CMA	CP: Marketing plan
		010	CP: Plan sales manager
		020	CP: Plan account manager
		CRA	CP: Plan regional account manager
		CAC	CP: Account plan
		CVE	CP:  Sales plan
		CMP	CP: Business plan
		CLF	CP: Last forecast (FC)
		CAF	CP: Current forecast (FC)
		TPM	Trade promotion
		CKV	Customer agreement
		CB%	CP: Plan % of gross sales
		CP%	CP: Plan %
		CD%	Delta forecast - target
		CMY	CP: Help version YTD plan
		CIY	CP: Help version YTD plan
0CRMVERSION	CRM plan version	The CRM plan version contains a simulation ID for a plan. It also indicates whether a plan has been released or not.
0CRM_ACCPLN	CP: Account plan	The CRM account plan contains an ID that can be used to identify a plan in SAP CRM.
0PERIOD_TYP	Promotion phase	The values for the promotion phase are supplied exclusively from SAP CRM Marketing Planner using a Business Add-In (BAdI). The following values are used in the delivered BAdI.
		‘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 are granted.
		‘70’	Phase after a promotion: Due to the special conditions of a previous promotion, sales in the post-dip phase are lower than usual.

 

Update

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

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

·        Reading of key figures by means of a user exit in SAP SEM-BPS

For the key figure Predicted Uplift Quantity (0UPLI_PQTY), this takes place in planning layout 4TPM1551 for planning level 4TPM1500 in planning area 4TPM1000.

·        Planning functions of SAP SEM-BPS, especially copying

For example, 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 from the InfoCube Sales and Trade Promotions (Actual) (0CP_SLSC7) using the Planning Services in SAP SEM-BPS

Copying should be carried out in background processing while the InfoCube is being updated for the actual data. This procedure ensures that the queries defined using the InfoCube access the latest data.

Since the data is actual data, it is generated for value type ‘10’ and version ‘C00’.

The following characteristics can also be derived from a business partner group or product hierarchy during the copy process.

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

¡        Business Partner Group Level 2 (0BP_GRP_A02 sapurl_link_0003_0008_0016)

¡        Business Partner Group Level 3 (0BP_GRP_A03 sapurl_link_0003_0008_0016)

¡        Business Partner Group Level 4 (0BP_GRP_A04 sapurl_link_0003_0008_0016)

¡        Business Partner Group Level 5 (0BP_GRP_A05 sapurl_link_0003_0008_0016)

¡        Business Partner Group Level 6 (0BP_GRP_A06 sapurl_link_0003_0008_0016)

¡        Business Partner Group Level 7 (0BP_GRP_A07 sapurl_link_0003_0008_0016)

¡        Category (0CP_CATEG sapurl_link_0003_0014_0016)

¡        Subcategory (0CP_SCATEG)

¡        Product Segment (0CP_SEGMENT sapurl_link_0003_0015_0016)

¡        Product Subsegment (0CP_SSEGMNT sapurl_link_0003_0015_0016)

¡        Article Group (0CP_ARTGRP)

¡        Brand (referencing 0PROD_CATEG) (0CP_BRND sapurl_link_0003_0016_0016)

¡        Sales Category (0PR_CAT_SAL)

The derivation can only take place if you have stored a derivation rule for the user exit UPX_EXIT_HIERARCHY_DERIVE for the characteristics Business Partner (0BPARTNER), BP: Business Partner Group (from Hierarchy) (0BP_GRP) or CRM Product (0CRM_PROD) in SAP SEM-BPS and created a relevant hierarchy derivation rule in Customizing for Planning Services.

For more information, see Planning Services.

When you are copying, you should only reduce the number of hierarchy levels if the hierarchies remain stable over extended periods. This is normally certain with those customer and product hierarchies in the consumer products industry that are used for strategic planning. You should ensure that hierarchy changes are only permitted at particular times, for example, at the end of the month, as it is necessary to repost InfoCube data after hierarchy changes.