Show TOC Entering content frame

Query Productivity Scorecard for Fashion Locate the document in its SAP Library structure

Technical Name: 0RMP_MC21_Q0008

Use

This query is a plan/actual comparison used to evaluate sales efficiency. It shows how much of the overall sales were based on temporary markdowns, permanent markdowns, and shrinkage, giving you an idea of the consumers’ price sensitivity. You can evaluate several levels of data, drilling down from categories to subcategories and segments and then to the product and color/size levels. In addition, you can evaluate seasonal trends within categories and segments.

Filter

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0FISCVARNT

Fiscal Year Variant

0SALESORG

Sales Organization

0DISTR_CHAN

Distribution Channel

0REQUID

Request ID

0FISCYEAR

Fiscal Year

 

Free Characteristics

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CM_MCATDIV

Division

0CM_CDT1

Category

0CM_CDT2

Subcategory

0CM_CDT3

Segment

0RT_SEASON

Season

0RT_SEASYR

Season Year

0RT_SKUROLL

SKU Rollout

0RT_ASORT

Assortment

0RT_COLOR

Color

0RT_SIZE

Size

0FISCPER

Posting Period

 

Variables Used

 

Variable

Description

0P_GJVM

Fiscal Year Variant

0P_SAORG

Sales Organization

0P_DCHAN

Distribution Channel

0S_RQMRC

Request ID

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

 

Rows

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CM_SKU

Product

 

Columns

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

Product KPIs

0RMP_MC21_QT07

Calculated Sales at Retail

0RMP_MC21_CK013 

Sales at Retail

0RTBAINSASV

Price Reduction

0RTINSADIST

Markdown

0RTSPRENSV

Shrinkage at Retail

0RTINCOINSV

Price Reduction Contribution to Sales

Price Reduction / Sales at Retail

Markdown Contribution to Sales

Markdown / Sales at Retail

Shrinkage Contribution to Sales

Shrinkage / Sales at Retail

 

 

 

 

Query Basics Inventory Scorecard

Technical Name: 0RMP_MC21_Q0007

Use

This query is a plan/actual comparison that gives you an overview of inventory-related key figures. For each key figure, the report shows planned, actuals (this year) and actuals (last year). Deviations of planned sales and actuals TY are calculated to see immediately whether the considered segment is performing as planned or not. You can drill down through the segments to the product level.

This query is identical to the Basics Inventory Scorecard, except that color, size and seasonality are not considered.

Filter

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0FISCVARNT

Fiscal Year Variant

0SALESORG

Sales Organization

0DISTR_CHAN

Distribution Channel

0REQUID

Request ID

0FISCYEAR

Fiscal Year

 

Free Characteristics

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CM_MCATDIV

Division

0CM_CDT1

Category

0CM_CDT2

Subcategory

0CM_CDT3

Segment

0RT_ASORT

Assortment

0FISCPER3

Posting Period

 

Variables Used

 

Variable

Description

0P_GJVM

Fiscal Year Variant

0P_SAORG

Sales Organization

0P_DCHAN

Distribution Channel

0S_RQMRC

Request ID

0P_GJAHR

Fiscal Year

0P_DIVIS

Division

0P_CATG

Category

0P_SCAT

Subcategory

0P_SEGM

Segment

0P_ASMT

Assortment

 

Rows

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CM_SKU

Product

 

Columns

 

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0RMP_MC21_CK013 

Calculated Sales at Retail

0RTBAINSASV

Sales at Retail

0RTINSADIST

Price Reduction

0RTSPRENSV

Markdown

0RTINCOINSV

Shrinkage at Retail

Price Reduction / Sales at Retail

Price Reduction Contribution to Sales

Markdown / Sales at Retail

Markdown Contribution to Sales

Shrinkage / Sales at Retail

Shrinkage Contribution to Sales

0P_VERS

Plan Version

0P_GJAHR and 0P_VERS4

Actuals

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

0P_GJAHR –1 and 0P_VERS4

Actuals Last Year

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

Actuals / Actuals Last Year

Deviation %

 

 

Leaving content frame