Items Net Markdown Sales for a Given Department - SAP Documentation

Items Net Markdown Sales for a Given Department

Query Query: 0RPM_VP06_Q0067

This query is used to display net markdown sales for a given department.

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	Item ID	`0RPM_ITI`
Characteristic	Item Qualifier	`0RPM_IQU`
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 List	`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 Time Range 1	`0I_RPM_TIME1`
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) 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.