Status Conditions (SAP Library - Industry-Specific Analyses)

Status Conditions

Technical Name: 0CP_SLSM1_Q0011

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 key figures – each cumulated up to the end of the current fiscal year period – for the key figures from the contribution margin scheme (conditions, contribution margins, and so on) and determines the relative variant. You can carry out this analysis for any combination of customer and product. To select the version (sales role), the query for characteristic 0VERSION with the variable 0P_VERS3 is used.

For more information on the contribution margin scheme used, see Sales and Trade Promotions (Planned+Actual) in SU.

Filters

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

Free Characteristics

Element	InfoObject, Restriction, Formula
Product	0CRM_PROD restricted to 0SCRMPRO
BP: Group (Hierarchy)	0BP_GRP restricted to 0S_BPGRP
Fiscal Year Variant	0FISCVARNT 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

Contribution Margin Scheme Structure (0CP_SLSM1_QTDB)

Element	InfoObject, Restriction, Formula
Billing Quantity in Sales Units	0INV_QTY
Revenue	0COPAREVEN
Direct Discounts	0OFFINVDISC
Rebate	0VOL_REBATE
Other Sales Deductions	0COPAODSCNT
Total sales deductions	0CP_SLSM1_CK008
Net Revenue	0COPANETRV
Internal Value	0INTVALUE
Contribution Margin 1	0CP_SLSM1_CK0001
Listing Fee	0CP_LSTFEE
Funds	0CP_INSTFEE
Direct Promotion Costs	0PROMOTIONS
Other Customer Costs	0OTHCUSTCST
Total Customer Costs	0CP_SLSM1_CK009
Contribution Margin 2	0CP_SLSM1_CK010
Retailer’s Margin	0CP_SLSM1_CK007
Net/Net Revenue	Contribution margin 2 + internal value
Shelf-Edge Price in Sales Units	0CP_SPRC_SU
Net/Net Margin	Shelf-edge price in sales units % (contribution margin 2 + internal value)/billing quantity in sales units

Columns

Matrix 3 (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	0FISCYEAR restricted to 0I_PFYTD 0VERSION restricted to C00 (CP: Copy the actual data to the plan InfoCube) 0VTYPE restricted to 10 (actual)
Forecast YTM	OFISCYEAR restricted to 0FYTCFP (cumulative up to current fiscal year period) 0VERSION restricted to CAF (CP: current forecast) 0VTYPE restricted to 20 (planned)
&0T_VERSI&	OFISCYEAR 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	0FISCYEAR restricted to OFYTCFP (cumulative up to current fiscal year) 0VERSION restricted to C00 (CP: Copy the actual data to the plan InfoCube) OVTYPE restricted to 10 (actual)
Delta Previous Year - Current Year Actual YTM	Current year actual YTM % previous year actual YTM
Delta Plan - Actual YTM	Current year actual YTM % &0T_VERSI&
Delta Forecast - Actual YTM	Current year actual YTM % Current forecast current year YTM

The Matrix 3 structure (0CP_SLSM1_QTQ0003) enables you to display versions and value types for condition key figures in the form of a matrix. The structure element Previous Year YTM (year to month) shows, independently of date, the values for the previous year up to and including the current fiscal year period.