Technical name: 0RT_C01_Q0007
Use
This Query provides an overview of the sales of individual article categories.
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0MATERIAL__0MATL_CAT |
Article 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 |
0RT_C01_CK006 |
Margin – Sales at Retail Value (see formulas) |
0RT_C01_CK007 |
Margin – Sales at Retail Value with Tax (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