Versions Compared

Old Version 84

changes.mady.by.user PERRILLAT-COLLOMB, Nathalie

Saved on

compared with

New Version Current

changes.mady.by.user PERRILLAT-COLLOMB, Nathalie

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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


Table of Contents
maxLevel3

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