CMA Store Gross Margin Plan

Query Query: 0RMP_MC12_IRQ0104

This query shows the key measurements for the gross margin plan. Initially, all key figures are displayed in the rows by category with various posting periods in the columns.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Local Currency	`0LOC_CURRCY`	Restricted to value of variable 0P_MAP_CURR
Characteristic	Fiscal Year	`0FISCYEAR`	Restricted to value of variable 0P_MAP_YEAR and 0P_MAP_YEAR-1
Characteristic	Version	`0VERSION`	Restricted to value 0 (actual) and variable 0P_MAP_VERSION_STOR (plan version)
Characteristic	Fiscal Year Variant	`0FISCVARNT`	Restricted to value of variable 0P_MAP_VARNT_FINE
Characteristic	Comparable Store Indicator	`0RT_COMP`	Restricted to value: -O: New Store -N: Non-Comparable -C: Comparable

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Sales Organization	`0SALESORG`
Characteristic	Distribution Channel	`0DISTR_CHAN`
Characteristic	Assortment Type	`0RF_ASTYP`
Characteristic	Industry	`0CM_MCATDIV`
Characteristic	Category	`0CM_CDT1`
Characteristic	Comparable Store Indicator	`0RT_COMP`

Variables
Object Type	Name	Technical Name
Characteristic	Local Currency	`0P_MAP_CURR – variable selection is provided in the template`
Characteristic	Plan Year	`0P_MAP_YEAR – varable selection is provided in the template`
Characteristic	Fiscal Year Variant	`0P_MAP_VARNT_FINE – variable selection is provided in the template`
Characteristic	Time Hierarchy	`0H_MAP_FISCPER3_FINE`
Characteristic	Store Plan	`0P_MAP_VERSION_STOR – variable selection is provided in the template`
Characteristic	Store Hierarchy	`0H_MAP_PLANT – variable selection is provided in the template`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
	Plant	`0PLANT`	Activate hierarchy display using hierarchy variable 0H_MAP_PLANT
Key Figure	Sales at Retail	`0RTBAINSASV`	Entered. Restricted as follows: 0INFOPROV=0RMP_A11 0VERSION=0P_MAP_VERSION_STOR 0FISCYEAR=0P_MAP_YEAR
Key Figure	Sales at Cost	`0RTBAINSAPV`	Entered. Restricted as follows: 0INFOPROV=0RMP_A11 0VERSION=0P_MAP_VERSION_STOR 0FISCYEAR=0P_MAP_YEAR
Key Figure	LY Sales at Retail	`0RTBAINSASV`	Reference. Display. Restricted as follows: 0VERSION=0 0FISCYEAR=0P_MAP_YEAR-1
Key Figure	LY Sales at Cost	`0CPBAINSAPV`	Reference. Display. Restricted as follows: 0VERSION=0 0FISCYEAR=0P_MAP_YEAR-1
Key Figure	Gross Margin at Retail		Calculated: [Sales at Retail]-[COGS]
Key Figure	Gross Margin %		Calculated: 100 * [Gross Margin at Retail] / [Sales at Retail]
Key Figure	LY Gross Margin at Retail		Calculated: [LY Sales at Retail]-[LY COGS]
Key Figure	LY Gross Margin %		Calculated: 100 * [LY Gross Margin at Retail] / [LY Sales at Retail]
	GM Var LY Retail %		Calculated: ([Gross Margin Retail]-[LY Gross Margin Retail]) / [LY Gross Margin Retail]
Key Figure	EOP at Cost	`0RTENINPV`	Reference. Hidden. Restricted as follows: 0INFOPROV=0RMP_A11 0VERSION=0P_MAP_VERSION_STOR 0FISCYEAR=0P_MAP_YEAR
Key Figure	Avg. EOP at Cost		Hidden. Calculated: [EOP at Cost] Exception Aggregation: Average on FISCPER3
Key Figure	GMROI		Calculated: [Gross Margin at Retail] / [Avg. EOP at Cost]
Key Figure	LY EOP at Cost	`0CPTOTSTOPV`	Reference. Hidden. Restricted as follows: 0VERSION=0 0FISCYEAR=0P_MAP_YEAR-1
Key Figure	LY Avg. EOP at Cost		Hidden. Calculated: [LY EOP at Cost] Exception Aggregation: Average on FISCPER3
Key Figure	LY GMROI		Calculated: [LY Gross Margin at Retail] / [LY Avg. EOP at Cost]
Key Figure	Miscellaneous Adjustments at Cost	`0RTINCOPV`	Hidden. Entered. Restricted as follows: 0INFOPROV=0RMP_A11 0VERSION=0P_MAP_VERSION_STOR 0FISCYEAR=0P_MAP_YEAR
	COGS		Calculated: [Sales at Cost]+[Miscellaneous Adjustments at Cost]
Key Figure	LY Miscellaneous Adjustments at Cost	`0RTINCOPV`	Reference. Hidden. Restricted as follows: 0VERSION=0 0FISCYEAR=0P_MAP_YEAR-1
	LY COGS		Calculated: [LY Sales at Cost]+[LY Miscellaneous Adjustments at Cost]

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
	Posting Period	`0FISCPER3`	Activate hierarchy display using hierarchy variable 0H_MAP_FISCPER3_FINE