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 - Demand Review (Core query)

Technical NameBW_QRY_MVDYN11_0006

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

TabScreenshotComment
Display

Rows/Columns

Value Display

Planning

Extended

Variables

Definitions

Variable Name

Info-object

Selection Type

Required

Description/Explanation

CALMONT2

Calendar Month/Year (Interval, Mandatory)

0CALMONTHInterval/Mandatory/ManualEntryYes

V_CPFCTR1_2_0008

Global Business Unit (Selection Option, Optional, Auth)

CPFCTR1_2SelectionOption/Optional/Authorization/ManualEntryNo

V_0CURRENCY_0006

Currency





VBASE_UOM_05

Conversion Unit (Single, Required)


SingleYes

V_C_MATNR2_0001

Material (Selection option)

C_MATNR2SelectionOption/Optional/ManualEntryNo

CPROD01

Commercial Product (Select option, Optional)

C_MATNR2__C_PRODSelectionOption/Optional/ManualEntryNo

VPROD_HIER

Product Hierarchy (Selection option, optional)

C_MATNR2__0PROD_HIERSelectionOption/Optional/ManualEntryNo

V_CUSTID_0002

Ship-to (Selection option)

C_SHIPIDSelectionOption/Optional/ManualEntryNo

Previously it was C_SHIPTO but description were not daily updated.

No filter possible on SF Prospects


V_0DISTR_CHAN_0001

Distribution Channel (Selection option, Optional)

0DISTR_CHANSelectionOption/Optional/ManualEntryNo

V_C_GBR6_0001

GBR Customer Group (Select Option, Optional)

C_GBR13__C_GBR6SelectionOption/Optional/ManualEntryNo

Ship-to info

V_0COUNTRY_0003

Ship-to Country (Selection option, Optional)

C_SHTCTRY

SelectionOption/Optional/ManualEntry

No



V_C_GRCUST_0001

Industrial Group (Selection option, Optional)

C_SOLDID__C_GRCUSTSelectionOption/Optional/ManualEntryNo

Sold-to info

V1 => Ship-to info (C_CUSTOMR__C_GRCUST)

V_C_SAL_GRP

Sales Group (Selection option, Optional)

C_DYN_017__C_SAL_GRP

SelectionOption/Optional/ManualEntryNoSales Group = Sales Rep = only for RCS

V_C_GZONE

Geo Zone (Selection option, Optional)

C_SHTCTRY__C_GZONESelectionOption/Optional/ManualEntryNoFrom Ship-to Country

V_C_PLANT_0010

Plant (Selection Option, Optional)

C_DYN_018__C_MPPLANTSelectionOption/Optional/ManualEntryNo

V_C_PROSP_0001

SF Prospect ( 'X' only prospects, <> 'X' exclude prospects)

C_DYN_024__C_PROSPSelectionOption/Optional/ManualEntryNo

V_C_ZONE_0005

BFC Geo/Zone (Selection option)

C_SHTCTRY__C_ZONESelectionOption/Optional/ManualEntryNo

Variable Sequence

Filters

ObjectFilter ValueExplanation
InfoProvider (0INFOPROV)

= DYN Reporting (CRDYN11)

+ APO

+ DYN Reporting SnapShot (CRDYN13)

 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

Concerned Period (C_FLGMTH)= 'M'Only current values are requiered


Key figures

All keyfigures without decimals as in Dynasys

DescriptiontypeRestricted or Calculated KeyFigureSourceCalculation ruleConversionComments

Gross History qty

Display
DynaSys

Table EXP_FORE

 field GH_QUANTITY

Ratio K_GHQTYQCT_MATNR5

For Soda = Shipped history GI Date (fichier SH_GI)

For Aroma, Perox, Silica, TS, Novecare = file Sales history del date (fichier DH_DELDAT)
For EP = Sales history departure date (fichier DH_GIDAT)


Previous to 13/11/2017 : description was "GH Quantity"


GH Quantity can be compared to interface file DYS_BW_DH_DELDAT for Technologie Solution (TS) or Aroma (PA). For others DYS_BW_IH.csv (removed rule not correct 09/04/2019)

Gross History val.

Display
DynaSys

Table EXP_FORE

 field GH_VALUE

Ratio K_GHEURCTK_ZRHO3M

Available since August 2017

Dynasys only

Previous to 13/11/2017 : description was "GH value"

GH Amount can be compared to interface file DYS_BW_DH_DELDAT for Technologie Solution (TS) or Aroma (PA). For others DYS_BW_IH.csv

Final Forecast qty

Display
DynaSys

Table EXP_FORE_DR

Field FF_QUANTITY

Ratio K_FFQTYQCT_MATNR5Previous to 13/11/2017 : description was "FF Quantity"

Final Forecast val.

Display
DynaSys

Table EXP_FORE_DR

Field FF_VALUE

Ratio K_FCSTAMT

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 ForecastDisplay

DynaSys

Table EXP_FORE_DR

Field DEMAND_REVIEW_F

Ratio K_DREVTQCT_MATNR5
Statistical ForecastDisplay

DynaSys

Table EXP_FORE_DR

Field STAT_FCT_QUANTIT

Ratio K_DYSTATFQCT_MATNR5
Customer ForecastDisplay

DynaSys

Table EXP_FORE_DR

Field CF_QUANTITY

Ratio K_DYCUSTFQCT_MATNR5
CSR ForecastDisplay

DynaSys

Table EXP_FORE_DR

Field CSRF_QUANTITY

Ratio K_DYCSRFQCT_MATNR5
Demand Order BookDisplay

Ratio K_DOBQTYQCT_MATNR5
Sales Team ForecastDisplay

Ratio K_DYSTFQCT_MATNR5

Sales Team Forecast Net Sales

no display 

DynaSys

Table EXP_FORE_DR

field STF_VALUE_ETD

Ratio K_DYN_031 / 0CURRENCY

CTK_ZRHO3Mwill be add soon
BFR03Display

Ratio K_DYBFR3QCT_MATNR5
BFR03 valueDisplay

Ratio K_BFR3EURCTK_ZRHO3M

Available since August 2017

Dynasys only

BFR06Display

Ratio K_DYBFR6QCT_MATNR5
BFR06 valueDisplay

Ratio K_BFR6EURCTK_ZRHO3M

Available since August 2017

Dynasys only

BFR09Display

Ratio K_DYBFR9QCT_MATNR5
BFR09 valueDisplay

Ratio K_BFR9EURCTK_ZRHO3M

Available since August 2017

Dynasys only

BudgetDisplay

Ratio K_DYBUDQCT_MATNR5
Budget ValueDisplay

Ratio K_BUDEURCTK_ZRHO3M

Available since August 2017

Dynasys only

Upside Forecast

Display

Ratio K_UPSIDEQCT_MATNR5

Available since 14/03/2017

Downside (- DELTA)Display

Ratio K_DOWNSIDQCT_MATNR5Solstice Only
Forecast AmountDisplay

Ratio K_FCSTAMTCONVERSIONSolstice Only
Estimated Actuals (Qty)Display

Calcul : GH quantity + FF quantity
Caution GH quantity has to be only for past, FF only for Future)		QCT_MATNR5Solstice Only
Estimated Actuals (Amount)Display

Calcul : GH quantity + FF quantity
Caution GH amount has to be only for past, FF only for Future)

Solstice Only

Amount part not available yet

Constrained ForecastDisplay

Ratio K_CONFORQCT_MATNR5

APO only

Available for DynaSys since 30/10/2017

Sales PriceDisplay

Formula: Sales Price Value / Qty - 1 Kg

Available since August 2017

Dynasys only

Sales Price ValueHidden

Ratio K_SALPEKGCTK_ZRHO3M

Available since August 2017

Dynasys only

Qty - 1 KgHidden

RAtio K_QTY1KGQCT_MATNR5

Available since August 2017

Dynasys only


















DynaSys

Table EXP_FORE_DR

Field CONST_DEMAND_CON







DynaSys

Table EXP_FORE_DR

Field CONST_DEMAND_GRO







DynaSys

Table EXP_FORE_DR

Field FF_NET_SALES




Estimated Actuals (Qty)Display
DynaSys

Table EXP_FORE_DR

Field EA_QTY

Ratio K_DYN_073

Available since May 2018

Dynasys only

Estimated Actuals (Amount)Display
DynaSys

Table EXP_FORE_DR

Field EA_EURO

Ratio K_DYN_074

Available since May 2018

Dynasys only

Estimated Actuals (Amount $)Display
DynaSys

Table EXP_FORE_DR

Field EA_DOLLAR

Ratio K_DYN_075

Available since May 2018

Dynasys only

Delta ForecastDisplay
DynaSys

Table EXP_FORE_DR

Field DELTA_FCT_QTY

Ratio K_DYN_082QCT_MATNR5

Will be available soon

Dynasys only

Delta Forecast Amount (€)Display
DynaSys

Table EXP_FORE_DR

Field DELTA_FCT_EURO

Ratio K_DYN_076

Will be available soon

Dynasys only

Delta Forecast Amount ($)Display
DynaSys

Table EXP_FORE_DR

Field DELTA_FCT_USD

Ratio K_DYN_077

Will be available soon

Dynasys only

Upside Forecast Amount (€)Display
DynaSys

Table EXP_FORE_DR

Field UPSIDE_FCT_EURO

Ratio K_DYN_078

Will be available soon

Dynasys only

Upside Forecast Amount ($)Display
DynaSys

Table EXP_FORE_DR

Field UPSIDE_FCT_USD

Ratio K_DYN_079

Will be available soon

Dynasys only

Delta EADisplay
DynaSys

Table EXP_FORE_DR

Field DELTA_EA_QTY

Ratio K_DYN_083QCT_MATNR5

Will be available soon

Dynasys only

Delta EA Amount (€)Display
DynaSys

Table EXP_FORE_DR

Field DELTA_EA_EURO

Ratio K_DYN_080

Will be available soon

Dynasys only

Delta EA Amount ($)Display
DynaSys

Table EXP_FORE_DR

Field DELTA_EA_USD

Ratio K_DYN_081

Will be available soon

Dynasys only


Characteristics

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


Cells

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic 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

OperatorValue

Other parameters

(if different from default)

Ex : Red if <=10 Yes/NoBad 3 Lesser Than 10