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

 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"

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


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