Gross Margin for Store Planning (SAP Library - BW

Gross Margin for Store Planning

Technical name: 0RT_C20_Q0001

Use

This Query enables you to monitor value-based gross margin planning at store level for the Store Planning step in the Best Practice Scenario 1_SAP.

The Query displays target and actual data and their variances in relation to the key figures Markdown, Price reduction, Sales, Calculated sales, Goods usage, Margin, Stock shrinkage, Returns, and Gross Margin.

The gross margin is calculated according to the following formula:

Sales at retail value =

- Sales at cost value

- Total returns at retail value

- Negative stock correction due to physical inventory at retail value

Free Characteristics

InfoObject	Description
0RT_SEASON	Season
0SALESORG	Sales Organization
0DISTR_CHAN	Distribution Channel
0PLANT	Plant
0CALMONTH	Calendar Year/Month

Rows

InfoObject	Description of the InfoObject (also restrictions or calculation formulas)
0RT_C20_CK005	Calculated Sales
0RT_C20_CK006	Calculated Sales%
0RTMSPRENSV	Markdowns
0RT_C20_CK002	Markdowns%
0RTMINSADST	Price Reduction
0RT_C20_CK003	Price Reduction%
0RTMBAINSSV	Sales
0CPMBAINSPV	Goods Usage
0RT_C20_CK001	Margin
0RTMINCINSV	Shrinkage
0RT_C20_CK004	Shrinkage%
0RTMTRETVSV	Returns
0RT_C20_CK007	Returns%
0RT_C20_CK008	Gross Margin
0RT_C20_CK009	Gross Margin%

Columns

InfoObject	Description of the InfoObject (also restrictions or calculation formulas)
0P_VERS4	Actual Version
0P_VERS1	Plan Version &0T_VERS&
	Planned/Actual Difference
	Variance%