Promotion Sales - Article 
Promotion Sales - Article
Technical name: 0RT_C01_Q0005
Use
This Query compares sales with promotion sales. This Query also compares the quantity sold with the quantity sold during promotions and the margins with the promotion margins. This evaluation takes place at merchandise category level. Evaluations may be performed weekly or monthly.
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0MATERIAL__0MATL_GROUP |
Merchandise category |
Columns
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0CPBAINSABU |
Sales / BUn |
0CPBAINSAPV |
Sales / Cost Value |
0RTBAINSASV |
Sales / Retail Value |
0RTBAINSAST |
Sales / Retail Value with Tax |
0RTPRINSABU |
Promotion Sales / BUn |
0RTPRINSAPV |
Promotion Sales / Cost Value |
0RTPRINSASV |
Promotion Sales / Retail Value |
0RTPRINSAST |
Promotion Sales / Retail Value with Tax |
0RT_C01_CK006 |
Margin – Sales at Retail Value (see formulas) |
0RT_C01_CK007 |
Margin – Sales at Retail Value with Tax (see formulas) |
0RT_C01_CK005 |
Margin – Promotion Sales at Retail Value (see formulas) |
0RT_C01_CK004 |
Margin – Promotion Sales at Retail Value with Tax (see formulas) |
Formulas
The margin is calculated from the sales (or promotion sales), cost and retail value (with or without tax). A margin with tax is calculated as follows:
Margin with tax =
100 ´ (Sales in Retail Value with Tax – Sales in Cost Value)
¸ Sales in Retail Value with Tax