Technical name: 0RT_C30_Q0012
Use
This Query compares promotion sales with total sales.
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0PLANT |
Plant |
Columns
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0RT_SALSLPU |
Sales / Cost Value (Receipt) |
0RT_POSSAL |
Sales (POS Receipt) |
0RT_PRMSAL |
Promotion Sales (POS Receipt) |
0RT_PRMSALP |
Promotion Sales in Cost Value (Receipt) |
Share of Promotion Sales (see formulas) | |
0RT_C30_CK001 |
Sales Margin (see formulas) |
0RT_C30_CK006 |
Promotion Sales Margin (see formulas) |
Formulas:
The Margin key figure is calculated from the sales (or promotion sales), cost and retail value (with or without tax):
Margin with tax =
100 ´ (Sales in Retail Value with Tax – Sales in Cost Value)
¸ Sales in Retail Value with Tax
Share of Promotion Sales =
100 ´ Promotion Sales ¸ Sales (POS Receipt)