t

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)

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

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

Same axis than DR/FA queries

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

Cells

If you have 2 structures and special cells calculations, explain here.

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