Show TOC Entering content frame

Query Assortment Analysis and Assessment Locate the document in its SAP Library structure

Technical Name: 0RMP_MC21_Q0001

Use

This query analyzes the performance of each product within an assortment, as well as the performance of the assortment as a whole. You can evaluate several levels of data, drilling down from categories to subcategories and segments. The raw data can be used for bar charts and bubble charts.

Filter

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0FISCVARNT

Fiscal Year Variant

0SALESORG

Sales Organization

0DISTR_CHAN

Distribution Channel

 

Free Characteristics

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0RT_SEASON

Season

0RT_SEASYR

Season Year

0RT_SKUROLL

SKU Rollout

0CM_MCATDIV

Division

0CM_CDT1

Category

0CM_CDT2

Subcategory

0CM_CDT3

Segment

0RT_ASORT

Assortment

0CM_SKU

Product

0FISCPER

Period

 

Variables Used

 

Variable

Description

0P_GJVM

Fiscal Year Variant

0P_SAORG

Sales Organization

0P_DCHAN

Distribution Channel

0P_GJAHR

Fiscal Year

0P_OSAIS

Season

0P_SEASY

Season Year

0P_SKUR

Rollout

0P_DIVIS

Division

0P_CATG

Category

0P_SCAT

Subcategory

0P_SEGM

Segment

0P_VERS4

Version

 

Rows

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0RT_ASORT

Assortment

0RTBAINSASV

Sales at Retail

0CPBAINSAPV

Sales at Cost

0RMP_MC21_CK004

Average Retail Price (Retail / Quantity BUOM)

0RMP_MC21_CK002

Gross Margin (Retail – Cost)

0RMP_MC21_CK003

Gross Margin % (Retail – Cost / Retail x 100)

% of Total Sales at Retail

Sales Contribution

0RMP_MC21_CK011

Range of Coverage (Inventory / Average Sales at Retail)

0RMP_MC21_CK009

Inventory Turnover (Sales at Retail / Average Inventory)

0RMP_MC21_CK001

GMROI (Gross Margin % x Inventory Turnover)

 

Columns

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0RTBAINSASV

Sales at Retail

0CPBAINSAPV

Sales at Cost

0RMP_MC21_CK004

Average Retail Price (Retail / Quantity BUOM)

0RMP_MC21_CK002

Gross Margin (Retail – Cost)

0RMP_MC21_CK003

Gross Margin % (Retail – Cost / Retail x 100)

% of Total Sales at Retail

Sales Contribution

0RTINCOINSV

Shrinkage

0RMP_MC21_CK011

Range of Coverage (Inventory / Average Sales at Retail)

0RMP_MC21_CK009

Inventory Turnover (Sales at Retail / Average Inventory)

0RMP_MC21_CK001

GMROI (Gross Margin % x Inventory Turnover)

0P_GJAHR and 0P_VERS4

Actuals

Restriction: 0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Actuals Version = 0)

0P_GJAHR –1 and 0P_VERS4

Actuals Last Year

Restriction: 0P_GJAHR –1 (Fiscal Year = Last Year) and 0P_VERS4 (Actuals Version = 0)

Actuals / Planned 

Deviation %

 

 

Leaving content frame