Average Items Sold per Transaction Top Merchandise Category Performers

Query Query: 0RPM_VP09_Q0094

This query displays the top ranking material groups based on the average items sold per transaction for the selected stores and the selected material groups during the specified time period. The query provides the total amount of the average items sold per transaction for each material group 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	Base Count Date Range 1	SEL_RPM_RK020	Display Top Merchandise Category, this number is defined using variable 0P_RPM_ SINGLE

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Base Unit	`0BASE_UOM`	Restricted by variable 0P_RPM_BUOM
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

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	Trans. Type Code	`0RPM_TTC`
Characteristic	Item ID	`0RPM_ITI`
Characteristic	Item Qualifier	`0RPM_IQU`
Characteristic	Base Unit	`0BASE_UOM`

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 Single Parameter	`0P_RPM_SINGLE`
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 Base Unit of Measure	`0P_RPM_BASE_UNIT_OF_MEASURE`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Base Count Date Range 1	`SEL_RPM_RK020`	Average Items Sold per Transaction for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure). Average Items Sold per Transaction are calculated as follows: Average Items Sold per Transaction = Total Number of Items per Transaction / Number of Transactions.