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


Workbook/Query General Description

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

Condition Name

Active

By default

Key Figure

(Structure)

OperatorValueCharacteristic Assignement






Exceptions

Exception Name

Active

By default

Alert Level

OperatorValue

Other parameters

(if different from default)

Yes/No






  • No labels