Merchandise Manager - OTB Plan Segment, Retail

Query Query: 0RPM12A03_IRQ0002

This query is part of the merchandise plan and is used to analyze and forecast sales, inventory, and purchasing information. It enables you to forecast the open to buy amount for all retail locations by sales organization, posting period, and segment. Some of the data presented within the query includes:

BOP inventory at cost
Sales at retail with tax
Sales tax
Net sales
Percent cont net sales
Net sales variable percent
Sales at cost
Gross margin
Gross margin percent
Gross margin percent contribution

Structure

Filters
Name	Technical Name	Value Restriction / Calculation
Division	`0CM_CDT1`	Variable 0P_0CM_CDT1_MM_01
Department	`0CM_CDT2`	Variable 0P_0CM_CDT2_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 (SAP Exit) 0P_0FISCVARNT_SM_01
Hierarchy ID	`0CM_HIEID`	Variable (SAP Exit) 0P_0CM_HIEID_DM_01
Industry	`0CM_MCATDIV`	Variable (SAP Exit) 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	Sales @ Retail Tax		Calculated: ‘Sales @ Retail Tax &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&’
Key Figure	Sales @ Retail Tax Plan Year 1	`0RTBAINSAST`	Hidden. Version variable 0P_0VERSION_MM_01/ InfoProvider variable 0P_0INFOPROV_SM_01/Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Sales @ Retail Tax Plan Year 2	`0RTBAINSAST`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Sales @ Retail Tax Plan Year 3	`0RTBAINSAST`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Sales Tax %		Calculated per Net Sales @ Retail Plan Year row: NDIV0 (((‘Sales @ Retail Tax &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ – ‘Net Sales @ Retail &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) %A ‘Net Sales @ Retail &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) )
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	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	Gross Margin %		Calculated per Net Sales @ Retail & Sales @ Cost Plan Year row: NDIV0 (((‘Net Sales @ Retail &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ – ‘Sales @ Cost &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) %A ‘Net Sales @ Retail &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) )
Key Figure	Gross Margin		Calculated per Net Sales @ Retail & Sales @ Cost Plan Year row: ‘Net Sales @ Retail &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ – ‘ Sales @ Cost &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’
Key Figure	GM % Contribution		Calculated per Gross Margin Plan Year row: %GT ‘Gross Margin &OT_0VERSION_RM_01& &OT_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	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	Cumulative On Order		Calculated: ‘Cum. On Order &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&
Key Figure	Open to Buy		Calculated per Net Receipts &On Order Plan Year row: ‘Net Receipts &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01& - ‘On Order &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&’
Key Figure	Open to Spend		Calculated per Net Receipts & Cum. On Order Plan Year row: ‘Net Receipts &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01& - ‘Cum. On Order &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&’
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	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	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 %		Calculated per Write Off Adjust. & BOP Inv. @ Cost Plan Year row: NDIV0 ((‘Write Off Adjust. &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ %A ‘BOP Inv @ Cost &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’ ) )
Key Figure	Vendor Allowance Plan Year 1	`0RTVALLPV`	Version variable 0P_0VERSION_MM_01/ Info Provider variable 0P_0INFOPROV_SM_01/ Fiscal Year variable 0P_0FISCYEAR_MM_03
Key Figure	Vendor Allowance Plan Year 2	`0RTVALLPV`	Version variable 0P_0VERSION_MM_02/ Info Provider variable 0P_0INFOPROV_SM_02/ Fiscal Year variable 0P_0FISCYEAR_MM_04
Key Figure	Vendor Allowance Plan Year 3	`0RTVALLPV`	Version variable 0P_0VERSION_MM_03/ Info Provider variable 0P_0INFOPROV_SM_03/ Fiscal Year variable 0P_0FISCYEAR_MM_05
Key Figure	Inventory Turn		Hidden & Calculated per WOS Plan Year row: ‘Weeks of Supply &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&’
Key Figure	Weeks of Supply		Hidden & Calculated per WOS Plan Year row: ‘Weeks of Supply &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&’
Key Figure	Weeks of Supply Plan Year 1	`0RP_WKOFSUP`	Hidden. Version variable 0P_0VERSION_MM_01/ InfoProvider variable 0P_0INFOPROV_SM_01/Fiscal Year variable 0P_-FISCYEAR_MM_03
Key Figure	Weeks of Supply Plan Year 2	`0RP_WKOFSUP`	Hidden. Version variable 0P_0VERSION_MM_02/ InfoProvider variable 0P_0INFOPROV_SM_02/Fiscal Year variable 0P_-FISCYEAR_MM_04
Key Figure	Weeks of Supply Plan Year 3	`0RP_WKOFSUP`	Hidden. Version variable 0P_0VERSION_MM_03/ InfoProvider variable 0P_0INFOPROV_SM_03/Fiscal Year variable 0P_-FISCYEAR_MM_05
Key Figure	EOP Inv @ Cost Plan Year 1	`0RTTPSTPV`	Hidden. 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`	Hidden. 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`	Hidden. 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 EOP Inv @ Cost Plan Year row: ‘EOP Inv @ Cost &OT_0VERSION_RM_01& &OT_0FISCYEAR_RM_01&’
Key Figure	Week Counter		Hidden: 1
Key Figure	Avg. Inventory		Hidden & Calculated per BOP & EOP Inv @ Cost Plan Year row: NOERR ( ( ( ‘BOP Inv @ Cost &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01& ‘ + ‘EOP Inv @ Cost &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&’ ) / ( ‘Week Counter’ + 1 ) ) )
Key Figure	Avg. Sales @ Cost		Hidden & Calculated per Sales @ Cost Plan Year row: ‘Sales @ Cost &0T_0VERSION_RM_01& &0T_0FISCYEAR_RM_01&’

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