The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description	BW - DP - Budget Review (Core query)
Technical Name	BW_QRY_MVDYN11_0001
Application	DP - Demand Planning
Info-provider	MultiProvider MVDYN11
Usage type	Direct execution via Analysis
Expected users

Workbook/Query General Description

General parameters

Global properties

Tab	Screenshot	Comment
Display
Rows/Columns
Value Display
Planning
Extended

Variables

Definitions

Same axis than DR/FA queries

Variable Name	Info-object	Selection Type	Required	Description/Explanation

Variable Sequence

Filters

Object	Filter Value	Explanation
InfoProvider (0INFOPROV)	= DYN Reporting (CRDYN11)
Concerned Period (C_FLGMTH)	= 'M'	Only current values are requiered

Key figures

All keyfigures without decimals as in Dynasys

KeyFigures of the Demand Review + following ones

Description	type	Source	Calculation rule	Conversion
Sales Team Forecast ETD	Display	DynaSys Table EXP_FORE_DR field STF_ETD	Ratio K_DYN_044	QCT_MATNR5
Sales Team Price	Display
Nb DC	Hidden		constant = 1
Nb BU	Hidden		constant = 1
Nb Period	Hidden		constant = 1
Nb Material	Hidden		constant = 1
Nb Ship-to (including Prospects)	Hidden		constant = 1
Sales Team Price Value	Hidden	DynaSys Table EXP_FORE_DR field ST_PRICE	Ratio K_FFEUR	CTK_ZRHO3M
Sales Team Forecast Value ETD	Display	DynaSys Table EXP_FORE_DR field STF_VALUE_ETD	Ratio K_DYN_031	CTK_ZRHO3M
Sales Team Contribution Margin ETD	Display	DynaSys Table EXP_FORE_DR field ST_CONTRIBUTION_	Ratio K_DYN_045	CTK_ZRHO3M
Sales Team Gross Margin ETD	Display	DynaSys Table EXP_FORE_DR field ST_GROSS_MARGIN_	Ratio K_DYN_033	CTK_ZRHO3M
Final Forecast ETD	Display	DynaSys Table EXP_FORE_DR field FF_ETD	Ratio K_DYN_034	QCT_MATNR5
Final Forecast Contribution Margin	Display	DynaSys Table EXP_FORE_DR field FF_CONTRIBUTION_	Ratio K_DYN_046	CTK_ZRHO3M
Final Forecast Gross Margin	Display	DynaSys Table EXP_FORE_DR field FF_GROSS_MARGIN	Ratio K_DYN_047	CTK_ZRHO3M
Budget Contribution Margin	Display	DynaSys Table EXP_FORE_DR field BUDGET_CONTRIBUT	Ratio K_DYN_048	CTK_ZRHO3M
Budget Gross Margin	Display	DynaSys Table EXP_FORE_DR field BUDGET_GROSS_MAR	Ratio K_DYN_030	CTK_ZRHO3M
BFR6 Contribution Margin	Display	DynaSys Table EXP_FORE_DR field BFR6_CONTRIBUTIO	Ratio K_DYN_032	CTK_ZRHO3M
BFR6 Gross Margin	Display	DynaSys Table EXP_FORE_DR field BFR6_GROSS_MARGI	Ratio K_DYN_020	CTK_ZRHO3M

Characteristics

Same axis than DR/FA queries

Location	Info-object Name	Info-object Text	Explanation (if needed)

Cells

Conditions

Condition Name

Active

By default

Key Figure

(Structure)

Operator

Value

Characteristic Assignement

Exceptions

Exception Name