Regular Sales and Promotion Sales 
Regular Sales and Promotion Sales
Technical Name: 0CP_SLSC6_Q0003
Based on the InfoCube Sales and Trade Promotions (Planned+Actual) (
0CP_SLSC6).Use
This query provides historical data on regular sales and promotion sales for an offline planning application.
See also
Net Sales with Customers
(
0COPA_C04_Q0010)
Filters
|
Element |
InfoObject, Restrictions, Formula |
|
Fiscal year variant |
0FISCVARNT restricted to the value ‘K4’ |
|
Request ID |
0REQUID restricted to the selection variable 0S_RQMRC |
|
Value type |
0VTYPE restricted to the selection variable 0P_WTYP |
|
Life cycle status |
0CRM_MKTELM__0STAMKTSYS0 restricted to the values # and ‘30’ |
|
Version |
0VERSION restricted to the value ‘000’ |
Rows
|
Element |
InfoObject, Restrictions, Formula |
|
Business partner |
0BPARTNER restricted to the selection variable 0P_BPART |
|
Sales org. CRM |
0CRM_SALORG |
|
Distribution channel |
0DISTR_CHAN |
|
Sales category |
0PR_CAT_SAL |
|
Regular billing quantity base UoM |
0CP_SLSC6_RK002 |
|
Promotion billing quantity (base UoM) |
‘Billing quantity base UoM’ – ‘regular billing quantity’ |
|
Billed quantity base UoM |
0BILL_QTY |
|
Fixed promotion discounts and costs |
0CP_SLSC6_CK004 |
|
Variable promotion discounts |
0CP_SLSC6_CK003 |
|
Total promotion discounts |
‘Fixed promotion discounts and costs’ + ‘variable promotion discounts’ |
Columns
|
Element |
InfoObject, Restrictions, Formula |
|
Fiscal year/period |
0FISCPER restricted to selection variable 0I_FPER |