Merchandise Category Performance (SAP Library - BW

Merchandise Category Performance

Technical name: 0RT_C31_Q0002

Use

This Query provides an overview of merchandise category performance. The "Number of POS Receipts" key figure in the InfoCube indicates the number of receipts in which the merchandise category is found if the merchandise category is expanded simultaneously. This Query includes an example of the "traffic light functions for each definition of an exception:

Merchandise Category Sales Margin < 25% Color: red
Merchandise Category Sales Margin > = 25% and <=50% Color: yellow
Merchandise Category Sales Margin > 50% Color: green

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_SALSLPU	Sales / Cost Value (POS Receipt)
0RT_POSSAL	Sales (POS Receipt)
0RT_SALRESA	Sales Quantity in Sales Unit (POS Receipt)
0RT_PRICDIF	Price Difference Between POS Retail Value and R/3 (POS Receipt)
0RT_C31_CK002	Intensity of Use (see formulas)
0RT_C31_CK001	Sales Margin (see formulas)

Formulas:

Margin:

The Margin key figure is calculated from the 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

Intensity of Use

Sales (POS Receipt) ¸ Sales Quantity in Sales Unit (POS Receipt).