Sales and Trade Promotions (Planned+Actual) in
Sales Units
Technical Name: 0CP_SLSCA
Use
This InfoCube is the central data store for:
· The Business Planning and Simulation (BW-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 plan using both BW-BPS and planning services in SAP Customer Relationship Management (SAP CRM) Marketing. If you plan directly in BW-BPS, you can also plan the contribution margin as well as sales revenue and sales quantities.
Key Figures
Key Figures for InfoCube 0CP_SLSC9
Some of the key figures in the 0CP_SLSCA InfoCube are calculated using key figures from the 0CP_SLSC9 InfoCube. This section documents those 0CP_SLSC9 key figures.
Technical Name |
Description |
Calculation |
Scenario |
0BASE_QTY |
Base Sales Quantity in Base Units of Measure |
|
Generic |
0UPLI_QTY |
Uplift Quantity in Base Unit of Measure |
|
Generic |
Update
An update is not provided with this transactional InfoCube. The InfoCube receives information from four sources:
● Entry of planned values in a BW-BPS planning layout (value type ‘20’)
● Reading of key figures by means of a user exit in BW-BPS
For the key figure Predicted Uplift Quantity (0UPLI_PQTY), this takes place in planning layout 4TPM9711 for planning level 4TPM9710 in planning area 4TPM9000.
● Planning functions of BW-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 BW-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)
○ 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)
○ Subcategory (0CP_SCATEG)
○ Product Segment (0CP_SEGMENT)
○ Product Subsegment (0CP_SSEGMNT)
○ Article Group (0CP_ARTGRP)
○ Brand (referencing 0PROD_CATEG) (0CP_BRND)
○ 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 BW-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.