Technical name: 0RT_C01_Q0013
Use
This analysis provides an overview of the most important margins in the retail cycle. By comparing margins, the purchasing and sales departments can make decisions regarding the relationship between pricing and markdown planning.
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) |
0RT_C01_CK006 |
Margin – Sales at Retail Value (see formulas) |
0RT_C01_CK0018 |
Margin – Purchase Order/Vendor/DelDate/Retail Value (see formulas) |
0RT_C01_CK017 |
Margin – Purchase Order/Vendor/DelDate/Retail Value with Tax (see formulas) |
0RT_C01_CK007 |
Margin – Sales at Retail Value with Tax (see formulas) |
0RT_C01_CK0019 |
Margin – Total Goods Receipt/Vendor/Retail Value (see formulas) |
0RT_C01_CK0020 |
Margin – Total Goods Receipt/Vendor/Retail Value with Tax (see formulas) |
0RTSPRENSV |
Revaluation at Retail (Negative) / Retail Value |
0RTSPRENST |
Revaluation at Retail (Negative) / Retail Value with Tax |
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