Show TOC Entering content frame

Query Basics Sales Scorecard Locate the document in its SAP Library structure

Technical Name: 0RMP_MC21_Q0005

Use

This query is a plan/actual comparison used for basics planning. It gives you an overview of the sales-related key performance indicators (KPIs). For each key figure, the report shows planned, actuals (this year) and actuals (last year). Deviations for planned and actual sales show whether the segment is performing as planned or not. You can drill down through the segments to the product level.

This query is identical to the Fashion Sales 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)

0RTBAINSASV

Sales at Retail

0RTBAINSAPV

Sales at Cost

0CPBAINSABU

Sales (Base Unit of Measure)

0RMP_MC21_CK002

Gross Margin (Retail – Cost)

0RMP_MC21_CK003

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

0RMP_MC21_CK004

Average Retail Price (Retail / Quantity BUOM)

% of Total Sales at Retail

Sales Contribution

0P_VERS

Plan Version

0P_GJAHR and 0P_VERS4

Actuals

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

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