Technical name: 0RT_C30_Q0019
Use
This Query shows the POS receipt with the biggest sales per store and week. The report contains the "TOP-1" condition, which finds only the POS receipt with the biggest sales.
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0CALWEEK |
Calendar Year/Week |
0RT_RECNOR |
Receipt Number (Unique) |
0PLANT |
Site |
Columns
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0RT_POSSAL |
Sales (POS Receipt) |
0RT_SALRESA |
Sales Quantity in Sales Unit (POS Receipt) |
0RT_SALSLPU |
Sales / Cost Value (POS Receipt) |
0RT_NOMGRRE |
Number of Merchandise Categories |
0RT_NOARTRE |
Number of Articles |
0RT_C30_CK001 |
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