Entering content frame!--a11y-->

InfoCube documentation 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 Structure linkPlanning Services.

Note

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.

 

Leaving content frame