Sales and Sales Promotions 
Technical Name: 0CP_SLSC1
Use
This InfoCube contains essential header data and item data from sales documents: It does not contain schedule line data. This allows you to evaluate quantities and values of sales orders, deliveries and returns, and invoices and credit memos on a product basis. The evaluations can be performed using internal organizational data (such as sales organization and division) or sold-to party, sales promotions, and sales promotion type. You can run evaluations for individual promotion activities, and make forecasts about what share of the sales will be generated by base business and what share by promotions.
All values are converted to local currency at the current rate of exchange. The complex pricing common for consumer products manufacturers is taken into account in as far as total price reductions are determined, as well as the gross and net values. For sophisticated trade spend analyses, the condition subtotals are available in InfoSource 2LIS_40_S276 and can be set up in R/3 Customizing.
There is also a distinction made between internal and external sales, which is important for cross-border distribution in Europe.
A further distinction is made between your own deliveries and third-party business.
The evaluation options are demonstrated using numerous calculated or restricted key figures, as well as predefined structures that supply examples for evaluations over the time axis.
InfoSources
The InfoCube is updated from the InfoSource 2LIS_40_S276 or (as of 2.0B) from the InfoSources 2LIS_11_VAITM, 2LIS_12_VCITM, and 2LIS_13_VDITM. All the transaction keys are evaluated during the update, so that each key figure of the InfoCube is calculated using a routine.
The update is performed daily. It is a requirement of the consumer products industry to be informed about sales revenue growth as soon as possible.
The BW regulations require that key figures are updated with minimum or maximum aggregation (for example, "first billing date”) for each record from the InfoSource. If there is no billing document, either a very low or very high dummy date is entered for the billing date.
The “price reduction” field has not been chosen from the InfoStructure for the "price reduction" key figure, since the InfoStructure field is made up of the “gross value”, “net value”, and “tax” fields. An update has been proposed using the condition subtotal 1.
Characteristics
InfoObject |
Description |
Dimension |
Navigational Attributes |
0SALESDEAL |
Sales Promotion |
Sales Promotion |
0SALESDEAL__0DEALTYPE |
0SALESDEAL__0PROMOTION |
|||
0SALESDEAL__0DATE_TO |
|||
0SALESDEAL__0DATE_FROM |
|||
0SALESORG |
Sales Organization |
Sales Area |
|
0DISTR_CHAN |
Distribution Channel |
||
0DIVISION |
Division |
||
0MATERIAL |
Material Number |
Product |
0MATERIAL__0DIVISION |
0MATERIAL__0PROD_HIER |
|||
0CUST_SALES |
Customer Number |
Customer |
0CUST_SALES__0SALES_DIST |
0SOLD_TO |
Sold-to Party |
0SOLD_TO__0COUNTRY |
|
0PLANT |
Plant |
Delivering Plant |
|
· Sales promotions are included as a separate dimension in the InfoCube.
· The sales area is the “sales area of the sales document“. This means that 0DIV_HEAD should be chosen instead of 0DIVISION. Since the customer (0CUST_SALES) contains 0DIVISION in the key, this InfoObject must also be used for the division in the sales area.
·
Two
“customer” InfoObjects have been added to the customer
dimension:
0CUST_SALES since the customer hierarchy is attached to it, and 0SOLD_TO as it
contains a lot of customer information. Since only one sales area is generally responsible
for a customer, it is unlikely that the dimension table will become too
full.
Time Characteristics
InfoObject |
Description |
Dimension |
Navigational Attributes |
0CALDAY |
Calendar Day |
Time |
|
0CALWEEK |
Calendar Year/Week |
||
0CALMONTH |
Calendar Year/Month |
||
0CALQUARTER |
Calendar Year/Quarter |
||
0CALYEAR |
Calendar Year |
Key Figures
InfoObject |
Description |
IO Unit |
Aggregation |
0CPSALORDNI |
Sales Order / Number of Items |
|
Summation |
0CPSALORDBU |
Sales Order (Base Unit of Measure) |
0BAS_UOM |
Summation |
0CPSALORDPV |
Sales Order / Purchase Value |
0LOC_CURRCY |
Summation |
0RTSALORDSV |
Sales Order / Sales Value |
0LOC_CURRCY |
Summation |
0CPSALORDSU |
Sales Order (Sales Unit) |
0SALES_UNIT |
Summation |
0CPDIRORDNI |
Third-Party Order / Number of Items |
|
Summation |
0CPDIRORDBU |
Third-Party Order (Base Unit of Measure) |
0BAS_UOM |
Summation |
0RTDIRORDSV |
Third-Party Order (Sales Value) |
0LOC_CURRCY |
Summation |
0CPDIRORDSU |
Third-Party Order (Sales Unit) |
0SALES_UNIT |
Summation |
0CPTODEEXNI |
Total Deliveries (External Customers) / Number of Items |
|
Summation |
0CPTODEEXBU |
Total Deliveries -External Customers (Base Unit of Measure) |
0BAS_UOM |
Summation |
0CPTODEEXSU |
Total Deliveries -External Customers (Sales Unit) |
0SALES_UNIT |
Summation |
0SALESSTART |
First Billing Date |
|
Minimum |
0ENDOFSALES |
Last Billing Date |
|
Maximum |
0CPSAEXCUNI |
Absolute Sales (Number of Items) |
|
Summation |
0CPSAEXCUBU |
Absolute Sales (Base Unit of Measure) |
0BAS_UOM |
Summation |
0CPSAEXCUPV |
Absolute Sales (Purchase Value) |
0LOC_CURRCY |
Summation |
0RTSAEXCUSV |
Absolute Sales (Sales Value) |
0LOC_CURRCY |
Summation |
0CPSAEXCUSU |
Absolute Sales (Sales Unit) |
0SALES_UNIT |
Summation |
0CPSALINTBU |
Sales from Intercompany Billing (Base Unit of Measure) |
0BAS_UOM |
Summation |
0CPSALINTSU |
Sales from Intercompany Billing (Sales Unit) |
0SALES_UNIT |
Summation |
0CPSALINTSV |
Sales from Intercompany Billing (Sales Value) |
0LOC_CURRCY |
Summation |
0CPSADIDENI |
Third-Party Sales (Number of Items) |
|
Summation |
0CPSADIDEBU |
Third-Party Sales (Base Unit of Measure) |
0BAS_UOM |
Summation |
0RTSADIDESV |
Third-Party Sales (Sales Value) |
0LOC_CURRCY |
Summation |
0CPSADIDESU |
Third-Party Sales (Sales Unit) |
0SALES_UNIT |
Summation |
0CPSALREDSV |
Price Reduction Billing (External Customer) |
0LOC_CURRCY |
Summation |
0CPRETORDNI |
Returns Order (Number of Items) |
|
Summation |
0CPRETORDBU |
Returns Order (Base Unit of Measure) |
0BAS_UOM |
Summation |
0CPRETORDPV |
Returns Order (Purchase Value) |
0LOC_CURRCY |
Summation |
0RTRETORDSV |
Returns Order (Sales Value) |
0LOC_CURRCY |
Summation |
0CPRETORDSU |
Returns Order (Sales Unit) |
0SALES_UNIT |
Summation |
0CPREDEEXNI |
Return Delivery (External Customers) / Number of Items |
|
Summation |
0CPREDEEXBU |
Return Delivery (External Customers) (Base Unit of Measure) |
0BAS_UOM |
Summation |
0CPREDEEXSU |
Return Delivery (External Customers) (Sales Unit) |
0SALES_UNIT |
Summation |
0CPCREENTNI |
Credit Memo (Number of Items) |
|
Summation |
0CPCREENTBU |
Credit Memo (Base Unit of Measure) |
0BAS_UOM |
Summation |
0CPCREENTPV |
Credit Memo / Purchase Value |
0LOC_CURRCY |
Summation |
0RTCREENTSV |
Credit Memo (Sales Value) |
0LOC_CURRCY |
Summation |
0CPCREENTSU |
Credit Memo (Sales Unit) |
0SALES_UNIT |
Summation |
0CPCREINTBU |
Sales from Intercompany Billing (Base Unit of Measure) |
0BAS_UOM |
Summation |
0CPCREINTSU |
Sales from Intercompany Billing (Sales Unit) |
0SALES_UNIT |
Summation |
0CPCREINTSV |
Credit Memo from Intercompany Billing (Sales Value) |
0LOC_CURRCY |
Summation |
0CPCEDIDENI |
Third-Party Credit Memo (Number of Items) |
|
Summation |
0CPCEDIDEBU |
Third-Party Credit Memo (Base Unit of Measure) |
0BAS_UOM |
Summation |
0RTCEDIDESV |
Third-Party Credit Memo (Sales Value) |
0SALES_UNIT |
Summation |
0CPCEDIDESU |
Third-Party Credit Memo (Sales Unit) |
0LOC_CURRCY |
Summation |
0CPCREREDSV |
Price Reduction Credit Memo (Ext. Customer) |
0LOC_CURRCY |
Summation |
0COUNT_DEAL |
Frequency in Sales Promotion |
|
Summation |
Exception aggregation "Counter (All Values)" using 0SALESDEAL |
|||
Restricted Key Figures
InfoObject |
Description |
Restriction |
0CP_SLSC1_RK001 |
External Net Sales in Current Year |
0CP_SLSC1_CK001 for 0CALYEAR |
0CP_SLSC1_RK002 |
External Net Sales (Business Unit of Measure) in Current Year |
0CP_SLSC1_CK004 for 0CALYEAR |
Calculated Key Figures
InfoObject |
Description |
Formula |
0CP_SLSC1_CK001 |
External Net Sales |
Absolute sales (sales value) – sales from intercompany billing (sales value) – credit memo (sales value) + credit memo from intercompany billing (sales value) |
0CP_SLSC1_CK002 |
Net Sales from Intercompany Billing |
Sales from intercompany billing (sales value) – credit memo from intercompany billing (sales value) |
0CP_SLSC1_CK003 |
Net Price Reduction |
Price
reduction billing document (ext. customer) |
0CP_SLSC1_CK004 |
External Net Sales in Base Unit of Measure |
Absolute sales (base UoM) – sales from intercompany billing (base UoM) – credit memo (base UoM) + credit memo from intercompany billing (base UoM) |
0CP_SLSC1_CK005 |
Net Price per Base Unit of Measure |
External net sales |
0CP_SLSC1_CK006 |
Net Sales from Intercompany Billing in Base Unit of Measure |
Sales from intercompany billing (base UoM) – credit memo from intercompany billing (base UoM) |
0CP_SLSC1_CK007 |
Net Order Value |
Sales
order (sales value) |
0CP_SLSC1_CK008 |
Net Order Quantity (Base Unit of Measure) |
Sales
order (base UoM) |
0CP_SLSC1_CK009 |
Contribution Margin 1 |
Absolute sales (sales value) |
0CP_SLSC1_CK010 |
Net Delivery in Base Unit of Measure |
Total delivery (external customers) (base UoM) – return delivery (ext. customers) (base unit of measure) |
0CP_SLSC1_CK011 |
Credit Memo without Third-Party (Base Unit of Measure) |
Credit memo (base UoM) |
0CP_SLSC1_CK012 |
Credit Memo without Third-Party (Sales Value) |
Credit memo (sales value) |
Templates/Structures:
InfoObject |
Description |
Element |
Formula |
0CP_SLSC1_QT01 |
Comparison With Previous Year |
Current Year up to Previous Month |
&0CYTLM& |
Same Period in Previous Year |
&0CYTLM&–12 |
||
Change in % |
Current year up to previous month |
||
0CP_SLSC1_QT02 |
Quarterly Comparison |
Q&0T_CQUAT& – &0T_QYEAR& |
&0CQUART& (current quarter) |
Q&0T_CQUAT& – &0T_QYEAR& |
&0CQUART&–1 |
||
Q&0T_CQUAT& – &0T_QYEAR& |
&0CQUART&–2 |
||
Q&0T_CQUAT& – &0T_QYEAR& |
&0CQUART&–3 |
||
Q&0T_CQUAT& – &0T_QYEAR& |
&0CQUART&–4 |
||
0CP_SLSC1_QT03 |
Net Sales / Price |
Net Sales |
0CP_SLSC1_CK001 |
Share of Sales |
%CT ‘Net Sales’ |
||
Net Sales Quantity |
0CP_SLSC1_CK004 |
||
Net Price/Unit |
0CP_SLSC1_CK005 |
||
Net Price Reduction |
0CP_SLSC1_CK003 |
||
Price Reduction/Unit |
'Net
price reduction' |
||
0CP_SLSC1_QT04 |
Monthly Increase in % |
&0T_CMNTH& – &0T_MYEAR& |
&0CMONTH& |
Increase in % |
'Month'% 'Month-1' |
||
&0T_CMNTH& – |
&0CMONTH&-1 |
||
Increase in % |
'Month-1'% 'Month-2' |
||
... |
|
||
0CP_SLSC1_QT05 |
Sales Value / Quantity |
Net Sales |
0CP_SLSC1_CK001 |
Net Sales Quantity |
0CP_SLSC1_CK004 |
Units
InfoObject |
Description |
0BASE_UOM |
Base Unit of Measure |
0SALES_UNIT |
Sales Unit |
0LOC_CURRCY |
Local Currency |