Show TOC

Gross Sales Top Location Performers Locate this document in the navigation structure

Query Query: 0RPM_VP02_Q0012

 

This query displays the top ranking stores based on the gross sales for the selected stores and the selected material groups during the specified time period. The query provides the total amount of the gross sales 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

Gross Sales Range 1

SEL_RPM_RK009

Display top 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

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

Trans. Type Code

0RPM_TTC

Characteristic Characteristic

Retail Type Code

0RPM_RTC

Variables

Object Type

Name

Technical Name

Variable Variable

POSDM Sales Analysis Stores List

0P_RPM_STORES

Variable Variable

POSDM Sales Analysis Material Group

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

Gross Sales Range 1

SEL_RPM_RK009

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

Gross sales are calculated as follows:

Gross Sales = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) + Distributed Discount (0RPM_DID) + Discount Value (0RPM_REA).