Top-Selling Items/Non-Moving Items (SAP Library - BW

Top-Selling Items/Non-Moving Items

Technical name: 0RT_C31_Q0001

Use

This Query provides an overview of the performance of articles in individual POS receipts. You can sort during an article drilldown or use exceptions/conditions to obtain detailed information on top-selling items/non-moving items. Some predefined exceptions/conditions are provided, which you can use when you run the Query.

Conditions: Top10, Top50, Top10%
Exceptions: Sales margin (traffic-light function)
Sales margin for material < 25% Red
Sales margin for material >= 25% and <=50% Yellow
Sales margin for material > 50% Green

Because of the expected volume of data, this Query is restricted to one store only.

Rows

InfoObject	Description of the InfoObject (also restrictions or calculation formulas)
0MATERIAL	Article Number

Columns

InfoObject	Description of the InfoObject (also restrictions or calculation formulas)
0RT_C31_CK001	Sales Margin (see formulas)
0RT_SALRESA	Sales Quantity in Sales Unit (POS Receipt)
0RT_PRICDIF	Price Difference Between POS Retail Value and R/3 (POS Receipt)
0RT_SALSLPU	Sales / Cost Value (POS Receipt)
0RT_POSSAL	Sales (POS Receipt)

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