The new wiki link for this data flow is here:

BW - DP - Budget Review (Core Query)

Please update the new doc there and no longer here.

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	Ex: GBU zone and WW controllers

Workbook/Query General Description

Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.

General parameters

Global properties

Tab	Screenshot	Comment
Display	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:31:46.png$
Rows/Columns	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:31:23.png$
Value Display	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:30:53.png$
Planning	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:30:5.png$
Extended	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2016-11-4 16:18:11.png$

Variables

Definitions

Same axis than DR/FA queries

Variable Name

Info-object

Selection Type

Required

Description/Explanation

GBU Zone (hier. 1) (Selection Option, Optional)

V_C_ZONEH1_0001

C_GBUZONE__C_ZONEH1

Selection Option

No

Will be added in V2

Variable Sequence

$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-1-12 16:11:28.png$

Filters

Object

Filter Value

Explanation

InfoProvider (0INFOPROV)

= DYN Reporting (CRDYN11)

+ DYN Reporting SnapShot (CRDYN13)

+ APO Novecare Snapshot (CRAPO005)

+ APO Special Chem Snapshot (CRAPO003 + CRAPO011)

DYN Reporting SnapShot (CRDYN13) added 12/02/2019

GBU PX/PY/PV not visible via current query as associated cubes not in the filtered Infoproviders

APO Novecare Snapshot (CRAPO005) => added 2019/05/09

APO Special Chem Snapshot (CRAPO003 + CRAPO011) => added 2020/07/23

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

Exchange rate type = CAR4

Description	type	Source / Restricted /Calculated Keyfigure	Calculation rule	Conversion	Comments
Gross History qty	Display	DynaSys Table EXP_FORE field GH_QUANTITY	Ratio K_GHQTY / fixed KG	QCT_MATNR5	In DynaSys, it is filled by "shipped ETA". Will be "Shipped ETD" when US will be ready to move in DynaSys. Previous to 13/11/2017 : description was "GH Quantity"
Gross History Net Sales	Display	DynaSys Table EXP_FORE field GH_VALUE	Ratio K_GHEUR / fixed EUR	CTK_ZRHO3M	Available since August 2017 Dynasys only Previous to 13/11/2017 : description was "GH value" Will be renammed 'Gross History Net Sales' instead of 'Value'
Final Forecast qty	Display	DynaSys Table EXP_FORE_DR Field FF_QUANTITY	Ratio K_FFQTY / fixed KG	QCT_MATNR5	Previous to 13/11/2017 : description was "FF Quantity"
Demand Review Forecast	Display	DynaSys Table EXP_FORE_DR Field DEMAND_REVIEW_F	Ratio K_DREVF / 0UNIT	QCT_MATNR5
Demand Review Quantity (ETD)			K_DYN_061 / 0UNIT
Demand Review Net Sales (€)		DynaSys Table EXP_FORE_DR Field BFR09_VALUE	K_BFR9EUR / fixed EUR		Reuse of object/field BFR9 Value
Demand Review Contribution Margin (€)			K_DYN_062 / fixed EUR
Demand Review Gross Margin (€)			K_DYN_063 / fixed EUR
Statistical Forecast	Display	DynaSys Table EXP_FORE_DR Field STAT_FCT_QUANTIT	Ratio K_DYSTATF / 0UNIT	QCT_MATNR5
Customer Forecast	Display	DynaSys Table EXP_FORE_DR field CF_QUANTITY	Ratio K_DYCUSTF / 0UNIT	QCT_MATNR5
CSR Forecast	Display	DynaSys Table EXP_FORE_DR Field CSRF_QUANTITY	Ratio K_DYCSRF / 0UNIT	QCT_MATNR5
Sales Team Forecast	Display	DynaSys Table EXP_FORE_DR Field STF_QUANTITY	Ratio K_DYSTF / 0UNIT	QCT_MATNR5
BFR03	Display	DynaSys Table EXP_FORE_DR Field BFR03	Ratio K_DYBFR3 / 0UNIT	QCT_MATNR5
~~BFR03 value~~	~~Display~~		~~Ratio K_BFR3EUR~~	~~CTK_ZRHO3M~~	Available since August 2017 Dynasys only Will be removed soon.
BFR06	Display	DynaSys Table EXP_FORE_DR Field BFR06	Ratio K_DYBFR6 / 0UNIT	QCT_MATNR5
BFR06 Net Sales	Display	DynaSys Table EXP_FORE_DR Field BFR06_VALUE	Ratio K_BFR6EUR	CTK_CAR4_M	Available since August 2017 Dynasys only Will be renammed 'BFR06 Net Sales' instead of 'Value'
BFR6 Net Sales ($)			K_DYN_067 / Fixed USD	No Conversion
BFR6 NetBack Sales ($)			K_DYN_059 / Fixed USD	No Conversion
BFR09	Display	DynaSys Table EXP_FORE_DR Field BFR09	Ratio K_DYBFR9 / fixed EUR	QCT_MATNR5
~~BFR09 value~~	~~Display~~		~~Ratio K_BFR9EUR~~	~~CTK_ZRHO3M~~	Available since August 2017 Dynasys only Will be removed soon.
Budget	Display	DynaSys Table EXP_FORE_DR Field BUDGET	Ratio K_DYBUD / 0UNIT	QCT_MATNR5
Budget Price CURR/KG	Display
Budget qty in KG	Hidden		Ratio K_DYBUD / 0UNIT	No Conversion
Budget Net Sales	Display	DynaSys Table EXP_FORE_DR Field BUDGET_VALUE	Ratio K_BUDEUR / fixed EUR	CTK_CAR4_M	Available since August 2017 Dynasys only Will be renammed 'Budget Net Sales' instead of 'Value'
Budget Net Sales ($)			K_DYN_066 / Fixed USD	No Conversion
Budget NetBack Sales ($)			K_DYN_058 / Fixed USD	No Conversion
Budget Contribution Margin	Display	DynaSys Table EXP_FORE_DR field BUDGET_CONTRIBUT	Ratio K_DYN_048 / 0CURRENCY	CTK_CAR4_M
Budget Contribution Margin ($)			K_DYN_064 / Fixed USD	No Conversion
Budget Gross Margin	Display	DynaSys Table EXP_FORE_DR field BUDGET_GROSS_MAR	Ratio K_DYN_030 / 0CURRENCY	CTK_CAR4_M
Budget Gross Margin ($)			K_DYN_065 / Fixed USD	No Conversion
Upside Forecast	Hidden	DynaSys Table EXP_FORE_DR Field UPSIDE_FORECAST	Ratio K_UPSIDE / 0UNIT	QCT_MATNR5	Available since 14/03/2017
Demand Order Book	Display	DynaSys Table EXP_FORE_DR Field CF_QUANTITY	Ratio K_DOBQTY / fixed KG	QCT_MATNR5
OB (ETD)	Display	DynaSys Table EXP_FORE_DR field ORDER_BOOK	K_OB_QTY / 0UNIT	QCT_MATNR5
OB Price CURR/KG	Display	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 15:45:44.png$
OB Qty in KG	Hidden		K_OB_QTY / 0UNIT	No Conversion
OB Price CURR/UNIT	Display	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 15:47:38.png$
OB Net Sales	Display	DynaSys Table EXP_FORE_DR field ORDER_BOOK_VALUE	K_OB_VAL / 0UNIT	CTK_CAR4_M
Sales Team Forecast ETD	Display	DynaSys Table EXP_FORE_DR field STF_ETD	Ratio K_DYN_044 / 0UNIT	QCT_MATNR5
Sales Team Price LC/KG		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 15:53:33.png$
ST Net Sales (LC)		DynaSys Table EXP_FORE_DR field SALES_TEAM_NET_S field LC	Ratio K_STSALES / 0LOC_CURRCY	No Conversion
Weighted Sales Team Price CURR/KG		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 15:56:23.png$
Sales Team Forecast ETD in KG	Hidden		K_DYN_044 / 0UNIT	No Conversion
Weighted Sales Team Price CURR/UNIT		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 15:57:48.png$
Sales Team Forecast Net Sales	Display	DynaSys Table EXP_FORE_DR field STF_VALUE_ETD	Ratio K_DYN_031 / 0CURRENCY	CTK_CAR4_M
Sales Team Contribution Margin	Display	DynaSys Table EXP_FORE_DR field ST_CONTRIBUTION_	Ratio K_DYN_045 / 0CURRENCY	CTK_CAR4_M
Sales Team Gross Margin	Display	DynaSys Table EXP_FORE_DR field ST_GROSS_MARGIN_	Ratio K_DYN_033 / 0CURRENCY	CTK_CAR4_M
Final Forecast ETD	Display	DynaSys Table EXP_FORE_DR field FF_ETD	Ratio K_DYN_034 / 0UNIT	QCT_MATNR5
Final Sales Price CURR/KG		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:3:0.png$
Final Forecast ETD in KG			K_DYN_034 / 0UNIT	No Conversion
Final Sales Price CURR/UNIT		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:4:48.png$
Final Forecast Net Sales	Display	DynaSys Table EXP_FORE_DR Field FF_VALUE	Ratio K_FCSTAMT / 0CURRENCY	CTK_CAR4_M	Available since August 2017 Dynasys only Previous to 13/11/2017 : description was "FF value" Previous to 30/10/2017, the ratio was K_FFEUR. It has been changed to be aligned with Logility
Final Forecast NetBack Sales ($)			K_DYN_057 / Fixed USD	No Conversion
Final Forecast Contribution Margin		DynaSys Table EXP_FORE_DR field FF_CONTRIBUTION_	Ratio K_DYN_046 / 0CURRENCY	CTK_CAR4_M
Final Forecast Gross Margin		DynaSys Table EXP_FORE_DR field FF_GROSS_MARGIN	Ratio K_DYN_047 / 0CURRENCY	CTK_CAR4_M
BFR6 Contribution Margin	Display	DynaSys Table EXP_FORE_DR field BFR6_CONTRIBUTIO	Ratio K_DYN_032 / 0CURRENCY	CTK_CAR4_M
BFR6 Contribution Margin ($)			K_DYN_068 / Fixed USD	No conversion
BFR6 Gross Margin	Display	DynaSys Table EXP_FORE_DR field ORDER_BOOK	Ratio K_DYN_020 / 0CURRENCY	CTK_CAR4_M
BFR6 Gross Margin ($)			K_DYN_069 / Fixed USD	No conversion
Sales Team Forecast vs Budget Volume		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:14:35.png$
Sales Team Forecast vs Budget Net Sales		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:15:21.png$
Sales Team Forecast vs Budget Contribution Margin		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:16:9.png$
Final Forecast vs Budget Volume		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:16:54.png$
Final Forecast vs Budget Net Sales		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:18:3.png$
Final Forecast vs Budget Contribution Margin		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:18:49.png$
Final Forecast vs Sales Team Forecast Volume		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:19:35.png$
Final Forecast vs Sales Team Forecast Net Sales		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:20:25.png$
Final Forecast vs Sales Team Forecast Contribution Margin		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 16:22:20.png$
Constrained Demand	Display	DynaSys Table EXP_FORE_DR Field CONST_FCST_QUANT	Ratio K_CONFOR / 0UNIT	QCT_MATNR5	APO only Available for DynaSys since 30/10/2017
Constrained Demand Net Sales		DynaSys Table EXP_FORE_DR Field BFR03_VALUE	K_BFR3EUR / Fixed EUR		reuse of objet/field BFR3 Value
Constrained Demand NetBack Sales ($)			K_DYN_060 / Fixed USD


Sales Price	Display		Formula: Sales Price Value / Qty - 1 Kg		Available since August 2017 Dynasys only
Sales Price Value	Hidden	DynaSys Table EXP_FORE_DR Field SALES_PRICE	Ratio K_SALPEKG	CTK_ZRHO3M	Available since August 2017 Dynasys only
Qty - 1 Kg	Hidden		RAtio K_QTY1KG	QCT_MATNR5	Available since August 2017 Dynasys on

Sales Team Price Value

Hidden

DynaSys

Table EXP_FORE_DR

field ST_PRICE

Ratio K_FFEUR

CTK_CAR4_M

Characteristics

See page : BW - DP - List of axis in DP queries

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

Operator

Value

Characteristic Assignement

Ex : Excl if <=10

Yes/No

Sales Value

Greater Than

10

Ex : All Independently

Exceptions

If you have conditions, explain here.

Exception Name

Active

By default

Alert Level

Operator

Value

Other parameters

(if different from default)

Ex : Red if <=10

Yes/No

Bad 3

Lesser Than

10