Promotion Week (Store): 
Promotion Week (Store):
Technical name: 0RT_C31_Q0004
Use
This Query provides an overview of the promotion sales by store. The promotions can be modeled as far as article level. The Query enables you to compare standard and promotion sales.
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0CALWEEK |
Calendar year/week |
Columns
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0RT_SALRESA |
Sales Quantity in Sales Unit (Receipt). |
0RT_POSSAL |
Sales (POS Receipt) |
0RT_SALSLPU |
Sales / Cost Value (Receipt) |
0RT_C31_RK001 |
Standard Sales Quantity in SUn (see restrictions) |
0RT_C31_RK002 |
Standard Sales Cost Value (see restrictions) |
0RT_C31_RK003 |
Standard Sales (see restrictions) |
|
Promotion Sales (see formulas) | |
|
Promotion Sales Cost Value (see formulas) | |
|
Sales Margin (see formulas) | |
|
Promotion Sales Margin (see formulas) | |
|
Standard Sales Margin (see formulas) | |
|
Promotion Sales Quantity in SUn (see formulas) |
Constraints:
This key figure is restricted to the values that are not assigned to a promotion.
This key figure is restricted to the values that are not assigned to a promotion.
This key figure is restricted to the values that are not assigned to a promotion.
Formulas:
Sales - Standard Sales
Sales in Cost Value - Standard Sales in Cost Value
100 ´ (Sales (Receipt) – Sales in Cost Value (Receipt)) ¸ Sales (Receipt)
100 ´ (Promotion Sales – Promotion Sales in Cost Value ) ¸ Promotion Sales
100 ´ (Standard Sales – Standard Sales in Cost Value ) ¸ Standard Sales
Sales Quantity in Sales Unit - Standard Sales Quantity in Sales Unit