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)
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	Restricted or Calculated KeyFigure	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"
Final Forecast val.	Display		DynaSys Table EXP_FORE_DR Field FF_VALUE	Ratio K_FCSTAMT / 0CURRENCY	CTK_ZRHO3M	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
Demand Review Forecast	Display		DynaSys Table EXP_FORE_DR Field DEMAND_REVIEW_F	Ratio K_DREVF / 0UNIT	QCT_MATNR5
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 STAT_FCT_QUANTIT	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'
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	$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2018-3-27 15:36:7.png$
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 Contribution Margin	Display		DynaSys Table EXP_FORE_DR field BUDGET_CONTRIBUT	Ratio K_DYN_048	CTK_CAR4_M
Budget Gross Margin	Display		DynaSys Table EXP_FORE_DR field BUDGET_GROSS_MAR	Ratio K_DYN_030	CTK_CAR4_M
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	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	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			DynaSys Table EXP_FORE_DR field ORDER_BOOK_VALUE	K_OB_VAL	CTK_CAR4_M
Sales Team Forecast ETD	Display		DynaSys Table EXP_FORE_DR field STF_ETD	Ratio K_DYN_044 / 0UNIT	QCT_MATNR5

Constrained Forecast	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
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	Display		$TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:39:10.png$
Nb DC	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:33:50.png$
Nb BU	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:35:37.png$
Nb Period	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:36:14.png$
Nb Material	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:36:50.png$
Nb Ship-to (including Prospects)	Hidden		constant = 1 $TECHNO - BI TEAM > BW - DP - Budget Review (Core Query) /!\ Obsolete /!\ > image2017-12-14 10:37:23.png$
Sales Team Price Value	Hidden	DynaSys Table EXP_FORE_DR field ST_PRICE	Ratio K_FFEUR	CTK_CAR4_M
Sales Team Forecast Value ETD	Display	DynaSys Table EXP_FORE_DR field STF_VALUE_ETD	Ratio K_DYN_031	CTK_CAR4_M
Sales Team Contribution Margin ETD	Display	DynaSys Table EXP_FORE_DR field ST_CONTRIBUTION_	Ratio K_DYN_045	CTK_CAR4_M
Sales Team Gross Margin ETD	Display	DynaSys Table EXP_FORE_DR field ST_GROSS_MARGIN_	Ratio K_DYN_033	CTK_CAR4_M
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_CAR4_M
Final Forecast Gross Margin	Display	DynaSys Table EXP_FORE_DR field FF_GROSS_MARGIN	Ratio K_DYN_047	CTK_CAR4_M


BFR6 Contribution Margin	Display	DynaSys Table EXP_FORE_DR field BFR6_CONTRIBUTIO	Ratio K_DYN_032	CTK_CAR4_M
BFR6 Gross Margin	Display	DynaSys Table EXP_FORE_DR field ORDER_BOOK	Ratio K_DYN_020	CTK_CAR4_M

Sales Team Price		DynaSys Table EXP_FORE_DR field SALES_TEAM_NET_S	K_STSALES
		DynaSys Table EXP_FORE_DR field LC	0LOC_CURRCY
Final Forecast NetBack Sales ($)			K_DYN_057
Budget NetBack Sales ($)			K_DYN_058
BFR6 NetBack Sales ($)			K_DYN_059
Constrained Demand Net Sales (€) (<- BFR3 Value)		DynaSys Table EXP_FORE_DR Field BFR03_VALUE	K_BFR3EUR
Constrained Demand NetBack Sales ($)			K_DYN_060
Demand Review Quantity (ETD)			K_DYN_061
Demand Review Net Sales (€) (<- BFR9 Value)		DynaSys Table EXP_FORE_DR Field BFR09_VALUE	K_BFR9EUR
Demand Review Contribution Margin (€)			K_DYN_062
Demand Review Gross Margin (€)			K_DYN_063
Budget Net Sales ($)			K_DYN_066
Budget Contribution Margin ($)			K_DYN_064
Budget Gross Margin ($)			K_DYN_065
BFR6 Net Sales ($)			K_DYN_067
BFR6 Contribution Margin ($)			K_DYN_068
BFR6 Gross Margin ($)			K_DYN_069

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