Merchandise Manager - Unit Flow Subsegment, Retail

Query Query: 0RPM12A08_IRQ0001

This query is part of the merchandise inventory flow. You can use it to analyze and plan various inventory and unit-based key performance indicators, for all retail locations by subsegment and posting period. Some of the data presented within the query includes:

BOP inventory at cost
Sales at retail with tax
Sales tax
Net sales at retail
Percent cont net sales
Sales variance
Sales at cost
EOP inventory at cost

Structure

Filters
Name	Technical Name	Value Restriction / Calculation
Division	`0CM_CDT1`	Variable 0P_0CM_CDT1_MM_01
Departmnent	`0CM_CDT2`	Variable 0P_0CM_CDT2_MM_01
Segment	`0CM_CDT3`	Variable 0P_0CM_CDT3_MM_01
Season	`0RT_SEASON`	Variable 0P_0RT_SEASON_MO_01
Posting Period	`0FISCPER3`	Hierarchy 0RP_FISCHIERID01/ excl. #
Geo. Hier. Level 2	`0RP_GEOLEV2`	Variable 0P_0RP_GEOLEV2_MO_01
Geo. Hier. Level 1	`0RP_GEOLEV1`	Variable 0P_0RP_GEOLEV1_MM_01
Fiscal Year	`0FISCYEAR`	Variables 0P_0FISCYEAR_MM_03/ 0P_0FISCYEAR_MM_04/ 0P_0FISCYEAR_MM_05
Sales Organization	`0SALESORG`	Variable 0S_SALESORG_MO_01
Base Unit	`0BASE_UOM`	Variable 0P _0BASE_UOM_DM_01
Local Currency	`0LOC_CURRCY`	Variable 0P_0LOC_CURRCY_RM_01
Fiscal Year Variant	`0FISCVARNT`	Variable 0P_0FISCVARNT_SM_01
Hierarchy ID	`0CM_HIEID`	Variable 0P_0CM_HIEID_DM_01
Industry	`0CM_MCATDIV`	Variable 0P_MCATDIV_DM_01
Distribution Channel	`0DISTR_CHAN`	Variable excl. # / variable 0P_0DISTR_CHAN_MM_01

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Season	`0RT_SEASON`	—
Key Figure	BOP Inv @Cost (Plan Year 1)	`0RT_IBOPPV`	Hidden. Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	BOP Inv @Cost (Plan Year 2)	`0RT_IBOPPV`	Hidden. Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	BOP Inv @Cost (Plan Year 3)	`0RT_IBOPPV`	Hidden. Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	BOP Inv @ Cost		Calculated per ‘hidden’ BOP Inv @ Cost Plan Year row: BOP Inv @ Cost &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&
Key Figure	BOP Inv @ Unit		Calculated per ‘hidden’ BOP Inv. @ Unit Plan Year row: ‘BOP Inv @ Unit &OT_VERSION_RM_01& &OT_0FISCYEAR_RM_01&’
Key Figure	BOP Inv @ Unit Plan Year 1	`0RP_BOPUNIT`	Hidden. Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	BOP Inv @ Unit Plan Year 2	`0RP_BOPUNIT`	Hidden. Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	BOP Inv @ Unit Plan Year 3	`0RP_BOPUNIT`	Hidden. Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Net Sales @ Retail Plan Year 1	`0RTBAINSASV`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Net Sales @ Retail Plan Year 2	`0RTBAINSASV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Net Sales @ Retail Plan Year 3	`0RTBAINSASV`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	% Cont Net Sales		Calculated per Net Sales @ Retail Plan Year row: %GT ‘Net Sales @ Retail & OT_0VERSION_RM_01& & OT_0FISCYEAR_RM_01&’
Key Figure	Net Sales Var %		Calculated: ‘Net Sales @ Retail &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ % ‘Net Sales @ Retail &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’
Key Figure	Sales @ Cost Plan Year 1	`0CPBAINSAPV`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Sales @ Cost Plan Year 2	`0CPBAINSAPV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Sales @ Cost Plan Year 3	`0CPBAINSAPV`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Sales @ Cost Var %		Calculated: ‘Sales @ Cost &0T_0VERSION_RM_01& &0T_FISCYEAR_RM_01&’ % ‘Sales @ Cost &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&
Key Figure	Sales Units Plan Year 1	`0CPBAINSABU`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Sales Units Plan Year 2	`0CPBAINSABU`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Sales Units Plan Year 3	`0CPBAINSABU`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	AUR Sales		Calculated per Net Sales @ Retail and Sales Unit Plan Year row: NDIV0 ((‘Net Sales @ Retail &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ / ‘Sales Units &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) )
Key Figure	AUC Sales		Calculated per Net Sales @ Retail and Sales Unit Plan Year row: NDIV0 ((‘Sales @ Cost &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ / ‘Sales Units &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) )
Key Figure	Gross Receipts Plan Year 1	`0CPGRPDVPV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Gross Receipts Plan Year 2	`0CPGRPDVPV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Gross Receipts Plan Year 3	`0CPGRPDVPV`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Net Receipts		Calculated per Gross Receipts & RTV Plan Year row: ‘Gross Receipts &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ - ‘RTV &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’
Key Figure	AUC Receipts		Calculated per Gross Receipt $ & Receipt Unit Plan Year row: NDIV0 ((‘Gross Receipts &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ / ‘Receipt Units &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ))
Key Figure	Receipt Units Plan Year 1	`0CPGRPDVBU`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Receipt Units Plan Year 2	`0CPGRPDVBU`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Receipt Units Plan Year 3	`0CPGRPDVBU`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	On Order Plan Year 1	`0CPOPOQDVPV`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	On Order Plan Year 2	`0CPOPOQDVPV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	On Order Plan Year 3	`0CPOPOQDVPV`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	AUC On Order		Calculated per On Order $ & On Order Unit Plan Year row: NDIV0 ((‘On Order &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ / ‘On Order Units &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ))
Key Figure	On Order Unit Plan Year 1	`0CPOPOQDVBU`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	On Order Unit Plan Year 2	`0CPOPOQDVBU`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	On Order Unit Plan Year 3	`0CPOPOQDVBU`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	RTV Plan Year 1	`0RTRETVPV`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	RTV Plan Year 2	`0RTRETVPV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	RTV Plan Year 3	`0RTRETVPV`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	RTV %		Calculated per RTV & Gross Receipts Plan Year row: NDIV0 ((‘RTV &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ %A ‘Gross Receipts &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) )
Key Figure	RTV Units Plan Year 1	`0RTRETVBU`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	RTV Units Plan Year 2	`0RTRETVBU`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	RTV Units Plan Year 3	`0RTRETVBU`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Inventory Adjust. Plan Year 1	`0RTINCOPV`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Inventory Adjust. Plan Year 2	`0RTINCOPV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Inventory Adjust. Plan Year 3	`0RTINCOPV`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Inventory Adjust %		Calculated per Inventory Adjust. & Sales @ Cost Plan Year row: NDIV0 ((‘Inventory Adjust. &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ %A ‘Sales @ Cost &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) )
Key Figure	AUC Inventory		Calculated per BOP Inv. $ & Unit Plan Year row: NDIV0 ((‘BOP Inv @ Cost &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ / ‘BOP Inv @ Unit &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ))
Key Figure	Invent. Adj. Units Plan Year 1	`0RTINCOBU`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Invent. Adj. Units Plan Year 2	`0RTINCOBU`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Invent. Adj. Units Plan Year 3	`0RTINCOBU`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Write Off Adjust Plan Year 1	`0RP_WOFFADJ`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Write Off Adjust Plan Year 2	`0RP_WOFFADJ`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Write Off Adjust Plan Year 3	`0RP_WOFFADJ`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Write Off Unit Plan Year 1	`0RP_WOFFADU`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Write Off Unit Plan Year 2	`0RP_WOFFADU`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Write Off Unit Plan Year 3	`0RP_WOFFADU`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	EOP Inv. @ Cost Plan Year 1	`0RTTPSTPV`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	EOP Inv. @ Cost Plan Year 2	`0RTTPSTPV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	EOP Inv. @ Cost Plan Year 3	`0RTTPSTPV`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	EOP Inv. @ Cost		Calculated per ‘hidden’ EOP Inv.@ Cost Plan Year row: ‘EOP Inv @ Cost &OT_VERSION_RM_01& &OT_0FISCYEAR_RM_01&’
Key Figure	EOP Inv @ Unit Plan Year 1	`0RTTPSTBU`	Hidden. Version variable 0P_0VERSION_MM_01/ InfoProvider variable 0P_0INFOPROV_SM_01/Fiscal Year variable 0P_-FISCYEAR_MM_03
Key Figure	EOP Inv @ Unit Plan Year 2	`0RTTPSTBU`	Hidden. Version variable 0P_0VERSION_MM_021/ InfoProvider variable 0P_0INFOPROV_SM_02/Fiscal Year variable 0P_-FISCYEAR_MM_04
Key Figure	EOP Inv @ Unit Plan Year 3	`0RTTPSTBU`	Hidden. Version variable 0P_0VERSION_MM_03/ InfoProvider variable 0P_0INFOPROV_SM_03/Fiscal Year variable 0P_-FISCYEAR_MM_05
Key Figure	EOP Inv @ Unit		Calculated per ‘hidden’ EOP Inv. @ Unit Plan Year row: ‘EOP Inv @ Unit &OT_VERSION_RM_01& &OT_0FISCYEAR_RM_01&’

Columns
Name	Technical Name	Value Restriction / Calculation
Sales Organization	`0CM_CDT1`	—
Subsegment	`0CM_CDT4`	—
Posting Period	`0FISCPER3`	Hierarchy [0RP_FISCHIER01] Year/Season/Month/Week