Show TOC

Gross Sales Rolling Time Period Trend Locate this document in the navigation structure

Query Query: 0RPM_VP02_Q0011

 

This query displays the trend of gross sales for selected material groups and selected stores over a specified time period. It also provides the trend of gross sales during the same time period for the previous year. Users can drill down to view the results by year, month, week, day, or hour.

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

Retail Type Code

0RPM_RTC

Characteristic Characteristic

Calendar Day

0RPM_DAY

Characteristic Characteristic

Calendar Month

0RPM_MTH

Characteristic Characteristic

Calendar Week

0RPM_WEK

Characteristic Characteristic

Calendar Year

0RPM_YER

Characteristic Characteristic

Hour

0RPM_HOR

Variables

Object Type

Name

Technical Name

Variable Variable

POSDM Sales Analysis Stores List

0P_RPM_STORES

Variable Variable

POSDM Sales Analysis Currency

0P_RPM_CURRCY

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

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).