Show TOC

Discounts Bottom Location Performers Locate this document in the navigation structure

Query Query: 0RPM_VP02_Q0033

 

This query displays the bottom ranking stores based on discounts for the selected stores and the selected material groups during the specified time period. The query provides the total amount of the discounts for each store included in the query.

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.

Conditions

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic

Discounts Range 1

SEL_RPM_RK013

Display bottom stores. This number is defined using variable 0P_RPM_SINGLE

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Material

0RPM_MAT

Restricted by variable 0P_RPM_MAT

Characteristic Characteristic

Cust. No. of Plant

0RPM_RSI

Restricted by variable 0P_RPM_STORES

Characteristic Characteristic

Task Canceled

0RPM_CANC

Restricted by variable 0P_RPM_TASK_CANCELED

Characteristic Characteristic

Credit/Debit Indicat

0RPM_TRD

Excluding: X

Characteristic Characteristic

Business Transaction

0RPM_BTY

Including: 1

Characteristic Characteristic

Classification of Sa

0RPM_RIC

Restricted by variable 0P_RPM_CAT_MULTI

Characteristic Characteristic

Classification of Sa

0RPM_RISC

Restricted by variable 0P_RPM_SCAT

Characteristic Characteristic

Data Status

0RPM_DAT

Restricted by variable 0P_RPM_DATA_STATUS

Characteristic Characteristic

Material Group

0RPM_MATGRP

Restricted by variable 0P_RPM_MATGRP

Characteristic Characteristic

Document Currency

0DOC_CURRCY

Restricted by variable 0P_RPM_CURRCY

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Cust. No. of Plant

0RPM_RSI

Characteristic Characteristic

Material Group

0RPM_MATGRP

Characteristic Characteristic

Task Canceled

0RPM_CANC

Characteristic Characteristic

Data Status

0RPM_DAT

Characteristic Characteristic

Material

0RPM_MAT

Characteristic Characteristic

Trans. Type Code

0RPM_TTC

Variables

Object Type

Name

Technical Name

Variable Variable

POSDM Sales Analysis Stores List

0P_RPM_STORES

Variable Variable

POSDM Sales Analysis Material Group List

0P_RPM_MATGRP

Variable Variable

POSDM Sales Analysis Material

0P_RPM_MAT

Variable Variable

POSDM Sales Analysis Date Range 1

0I_RPM_DATE1

Variable Variable

POSDM Sales Analysis Time Range 1

0I_RPM_TIME1

Variable Variable

POSDM Sales Analysis Single Parameter

0P_RPM_SINGLE

Variable Variable

POSDM Sales Analysis Data Status

0P_RPM_DATA_STATUS

Variable Variable

POSDM Sales Analysis Sub-Category

0P_RPM_SCAT

Variable Variable

POSDM Sales Analysis Category

0P_RPM_CAT_MULTI

Variable Variable

POSDM Sales Analysis Task Canceled

0P_RPM_TASK_CANCELED

Variable 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 Key Figure

Discounts Range 1

SEL_RPM_RK013

Discounts for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure).

Discounts are calculated as follows:

Discounts = Distributed Discount + (ORPM_DID) Discount Value (0RPM_REA).