Net Markdown Sales Summary

Query Query: 0RPM_VP06_Q0060

This query displays the net markdown sales summary of selected material groups for selected stores over specified time periods. For the selected stores and material groups, the query also provides the variance of net markdown sales during the specified time periods. Users can drill down to view results by store and/or material group.

Users can select the currency in which to display the data in order to more easily compare the results, for example, for stores located in different countries.

The query can be filtered by data status.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Material	`0RPM_MAT`	Restricted by variable 0P_RPM_MAT
Characteristic	Cust. No. of Plant	`0RPM_RSI`	Restricted by variable 0P_RPM_STORES
Characteristic	Task Canceled	`0RPM_CANC`	Restricted by variable 0P_RPM_TASK_CANCELED
Characteristic	Credit/Debit Indicat	`0RPM_TRD`	Excluding: `X`
Characteristic	Business Transaction	`0RPM_BTY`	Including: 1
Characteristic	Classification of Sa	`0PM_RIC`	Restricted by variable 0P_RPM_CAT_MULTI
Characteristic	Classification of Sa	`0RPM_RISC`	Restricted by variable 0P_RPM_SCAT
Characteristic	Data Status	`0RPM_DAT`	Restricted by variable 0P_RPM_DATA_STATUS
Characteristic	Material Group	`0RPM_MATGRP`	Restricted by variable 0P_RPM_MATGRP
Characteristic	Markdown Sales Trans	`0RPM_MARK`	1
Characteristic	Document Currency	`0DOC_CURRCY`	Restricted by variable 0P_RPM_CURRCY

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Cust. No. of Plant	`0RPM_RSI`
Characteristic	Material Group	`0RPM_MATGRP`
Characteristic	Task Canceled	`0RPM_CANC`
Characteristic	Data Status	`0RPM_DAT`
Characteristic	Material	`0RPM_MAT`
Characteristic	Trans. Type Code	`0RPM_TTC`
Characteristic	Retail Type Code	`0RPM_RTC`

Variables
Object Type	Name	Technical Name
Variable	POSDM Sales Analysis Stores List	`0P_RPM_STORES`
Variable	POSDM Sales Analysis Material Group	`0P_RPM_MATGRP`
Variable	POSDM Sales Analysis Material	`0P_RPM_MAT`
Variable	POSDM Sales Analysis Date Range 1	`0I_RPM_DATE1`
Variable	POSDM Sales Analysis Date Range 2	`0I_RPM_DATE2`
Variable	POSDM Sales Analysis Time Range 1	`0I_RPM_TIME1`
Variable	POSDM Sales Analysis Time Range 2	`0I_RPM_TIME2`
Variable	POSDM Sales Analysis Data Status	`0P_RPM_DATA_STATUS`
Variable	POSDM Sales Analysis Sub-Category	`0P_RPM_SCAT`
Variable	POSDM Sales Analysis Category	`0P_RPM_CAT_MULTI`
Variable	POSDM Sales Analysis Task Canceled	`0P_RPM_TASK_CANCELED`
Variable	POSDM Sales Analysis Currency	`0P_RPM_CURRCY`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Net Markdown Sales Range 1	`SEL_RPM_RK016`	Net Markdown Sales for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure) The net markdown sales are calculated as follows: Net Markdown Sales = Normal Sales Value `(0RPM_NSA)` — Tax Included `(0RPM_TXI)` — Distributed Included Transaction Tax `(0RPM_DITXI)` — Distributed Discount `(0RPM_DID)` applied only to items that have a promotion ID, a distributed discount or a discount.
Key Figure	Net Markdown Sales Range 2	`SEL_RPM_RK017`	Net Markdown Sales for a date range specified using variable 0I_RPM_DATE2 and time range specified using variable 0I_RPM_TIME2 (Restricted Key Figure). Net Markdown Sales are calculated as follows: Net Markdown Sales = Normal Sales `(0RPM_NSA)` — Tax Included `(0RPM_TXI)` — Distributed Included Transaction Tax `(0RPM_DITXI)` — Distributed Discount `(0RPM_DID)` applied to items with a promotion ID, a distributed discount or a discount.
Key Figure	Net Markdown Sales Variance	`CKF_RPM_CK024`	Variance between Net Markdown Sales Range 1 and Net Markdown Sales Range 2 (Calculated Key Figure). Net Markdown Sales are calculated as follows: Net Markdown Sales = Normal Sales `(0RPM_NSA)` — Tax Included `(0RPM_TXI)` — Distributed Included Transaction Tax `(0RPM_DITXI)` — Distributed Discount `(0RPM_DID)` applied to items with a promotion ID, a distributed discount or a discount.