Status: Selected Key Figures (SAP Library - Industry-Specific Analyses)

Status: Selected Key Figures

Technical Name: 0CP_SLSM1_Q0003

This query is based on the MultiProvider Plan/Actual Evaluation: Customer (0CP_SLSM1).

Use

Account managers can use this query to monitor the current status of target achievement and determine whether action needs to be taken.

The query compares different plan versions with current actual figures – each cumulated up to the end of the current fiscal year period – for selected key figures (net revenue, billing quantity in sales units, net price, funds, and so on) and determines the relative variant. This analysis is carried out along the entire product and customer hierarchy. To select the version (sales role), the query for characteristic 0VERSION with the variable 0P_VERS3 is used.

For an example of how the query is used, see the query view 0CP_SLSM1_Q0003_V02.

Filters

Element	InfoObject, Restriction, Formula
Request ID	0REQUID restricted to 0S_RQMRC

Free Characteristics

Element	InfoObject, Restriction, Formula
Fiscal Year Variant	0FISVARNT restricted to 0P_FYVAR
CRM Sales Organization	0CRM_SALORG restricted to 0CRM_S01
Distribution Channel	0DISTR_CHAN restricted to 0DISCHAN
Division	0DIVISION restricted to 0DIVISIO
CRM Marketing Element	0CRM_MKTELM
Tactic	0CRM_TACTIC

Rows

Element	InfoObject, Restriction, Formula
BP: Group (Hierarchy)	0BP_GRP restricted to 0S_BPGRP
Product	0CRM_PROD restricted to 0SCRMPRO

Columns

Matrix Structure 5 (0CP_SLSM1_QTQ0003)

Element	InfoObject, Restriction, Formula
Actual Previous Year	0FISCYEAR restricted to OFYEAR-1 (current fiscal year -1) 0VERSION restricted to C00 (CP: copy the actual data to the plan InfoCube) OVTYPE restricted to 10 (actual)
Previous Year Actual YTM	0FISCPER restricted to 0I_PFYTD 0VERSION restricted to C00 (CP: copy the actual data to the plan InfoCube) 0VTYPE restricted to 10 (actual)
Forecast YTM	OFISCPER restricted to 0FYTCFP (cumulative up to current fiscal year period) 0VERSION restricted to CAF (CP: current forecast) 0VTYPE restricted to 20 (planned)
&0T_VERSI&	OFISCPER restricted to 0FYTCFP (cumulative up to current fiscal year period) 0VERSION restricted to 0P_ VCMP (plan version) 0VTYPE restricted to 20 (planned)
Current Year Actual YTM	0FISCPER restricted to OFYTCFP (cumulative up to current fiscal year period) 0VERSION restricted to C00 (CP: copy of actual data to the plan InfoCube) OVTYPE restricted to 10 (actual)
Delta Previous Year – Current Year Actual YTM	Current year actual/Previous year actual YTM
Delta Plan – Actual YTM	Current year actual YTM / &0T_VERSI&
Delta Forecast – Actual YTM	Current year actual YTM/Forecast YTM

Key Figures Structure

Element	InfoObject, Restriction, Formula
Net Revenue	0COPANETRV
Billing Quantity in Sales Units	0INV_QTY
Listing Fee	0CP_LSTFEE
Funds	0CP_INSTFEE
Contribution Margin 1	0CP_SLSM1_CK0001
Contribution Margin 2	0CP_SLSM1_CK010
Net price (EUR not scaled)	NODIM (Net Revenue / Billing Quantity in Sales Units x 1000)