You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 85 Next »

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

 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

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