Show TOC

Departments Net Sales for a Given Location and Items Net Sales for a Given Department Locate this document in the navigation structure

Query Query: 0RPM_VP02_Q0026

 

This query displays the net sales for selected material groups within a selected store. It also displays the net sales for items (products) within a selected 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 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

Item ID

0RPM_ITI

Characteristic Characteristic

Item Qualifier

0RPM_IQU

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

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

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

Net Sales Range 1

SEL_RPM_RK005

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

Net Sales are calculated as follows:

Net Sales = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID)