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

Compare with Current View Page History

« Previous Version 23 Next »

t

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

Technical NameBW_QRY_MVDYN11_0001

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

Same axis than DR/FA queries

Variable Name

Info-object

Selection Type

Required

Description/Explanation

GBU Zone (hier. 1) (Selection Option, Optional)

V_C_ZONEH1_0001

C_GBUZONE__C_ZONEH1Selection OptionNoWill be added in V2

Variable Sequence

Filters

ObjectFilter ValueExplanation
InfoProvider (0INFOPROV)

= DYN Reporting (CRDYN11)

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

 

Key figures

All keyfigures without decimals as in Dynasys

KeyFigures of the Demand Review + following ones

Exchange rate type = CAR4

 

DescriptiontypeRestricted or Calculated KeyFigureSourceCalculation ruleConversionComments

Gross History qty

Display DynaSys

Table EXP_FORE

 field GH_QUANTITY

Ratio K_GHQTY / fixed KGQCT_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"


Gross History Net Sales

Display DynaSys

Table EXP_FORE

 field GH_VALUE

Ratio K_GHEUR / fixed EURCTK_ZRHO3M

Available since August 2017

Dynasys only

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

Will be renammed 'Gross History Net Sales' instead of 'Value'

Final Forecast qty

Display DynaSys

Table EXP_FORE_DR

Field FF_QUANTITY

Ratio K_FFQTY / fixed KGQCT_MATNR5Previous to 13/11/2017 : description was "FF Quantity"

Final Forecast val.

Display DynaSys

Table EXP_FORE_DR

Field FF_VALUE

Ratio K_FCSTAMT / 0CURRENCY

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_DREVF / 0UNITQCT_MATNR5 
Statistical ForecastDisplay 

DynaSys

Table EXP_FORE_DR

Field STAT_FCT_QUANTIT

Ratio K_DYSTATF / 0UNITQCT_MATNR5 
Customer ForecastDisplay 

DynaSys

Table EXP_FORE_DR

field STAT_FCT_QUANTIT

Ratio K_DYCUSTF / 0UNITQCT_MATNR5 
CSR ForecastDisplay 

DynaSys

Table EXP_FORE_DR

Field CSRF_QUANTITY

Ratio K_DYCSRF / 0UNITQCT_MATNR5 
Demand Order BookDisplay 

DynaSys

Table EXP_FORE_DR

Field CF_QUANTITY

Ratio K_DOBQTY / fixed KGQCT_MATNR5 
Sales Team ForecastDisplay 

DynaSys

Table EXP_FORE_DR

Field STF_QUANTITY

Ratio K_DYSTF / 0UNITQCT_MATNR5 
BFR03Display 

DynaSys

Table EXP_FORE_DR

Field BFR03

Ratio K_DYBFR3 / 0UNITQCT_MATNR5 
BFR03 valueDisplay  Ratio K_BFR3EURCTK_ZRHO3M

Available since August 2017

Dynasys only

Will be removed soon.

BFR06Display 

DynaSys

Table EXP_FORE_DR

Field BFR06

Ratio K_DYBFR6 / 0UNITQCT_MATNR5 
BFR06 Net SalesDisplay 

DynaSys

Table EXP_FORE_DR

Field BFR06_VALUE

Ratio K_BFR6EURCTK_ZRHO3M

Available since August 2017

Dynasys only

Will be renammed 'BFR06 Net Sales' instead of 'Value'

BFR09Display 

DynaSys

Table EXP_FORE_DR

Field BFR09

Ratio K_DYBFR9 / fixed EURQCT_MATNR5 
BFR09 valueDisplay  Ratio K_BFR9EURCTK_ZRHO3M

Available since August 2017

Dynasys only

Will be removed soon.

BudgetDisplay 

DynaSys

Table EXP_FORE_DR

Field BUDGET

Ratio K_DYBUD / 0UNITQCT_MATNR5 
Budget Price CURR/KGDisplay

    
Budget qty in KGHidden  Ratio K_DYBUD / 0UNITNo Conversion 
Budget Net SalesDisplay 

DynaSys

Table EXP_FORE_DR

Field BUDGET_VALUE

Ratio K_BUDEUR / fixed EURCTK_ZRHO3M

Available since August 2017

Dynasys only

Will be renammed 'Budget Net Sales' instead of 'Value'

Budget Contribution MarginDisplay 

DynaSys

Table EXP_FORE_DR

field BUDGET_CONTRIBUT

Ratio K_DYN_048

CTK_CAR4_M 
Budget Gross MarginDisplay 

DynaSys

Table EXP_FORE_DR

field BUDGET_GROSS_MAR

Ratio K_DYN_030

CTK_CAR4_M 

Upside Forecast

Hidden 

DynaSys

Table EXP_FORE_DR

Field UPSIDE_FORECAST

Ratio K_UPSIDE / 0UNITQCT_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 

DynaSys

Table EXP_FORE_DR

Field CONST_FCST_QUANT

Ratio K_CONFOR / 0UNITQCT_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 

DynaSys

Table EXP_FORE_DR

Field SALES_PRICE

Ratio K_SALPEKGCTK_ZRHO3M

Available since August 2017

Dynasys only

Qty - 1 KgHidden  RAtio K_QTY1KGQCT_MATNR5

Available since August 2017

Dynasys on

Sales Team Forecast ETD

Display 

DynaSys

Table EXP_FORE_DR

field STF_ETD

Ratio K_DYN_044 / 0UNITQCT_MATNR5

 


Sales Team Price

Display 

 

  
Nb DCHidden

 

 

constant = 1

  
Nb BUHidden  

constant = 1

  
Nb PeriodHidden  

constant = 1

  
Nb MaterialHidden  

constant = 1

  
Nb Ship-to (including Prospects)Hidden  

constant = 1

  
Sales Team Price ValueHidden 

DynaSys

Table EXP_FORE_DR

field ST_PRICE

Ratio K_FFEUR

CTK_CAR4_M

 

Sales Team Forecast Value ETD

Display 

DynaSys

Table EXP_FORE_DR

field STF_VALUE_ETD

Ratio K_DYN_031

CTK_CAR4_M 

Sales Team Contribution Margin ETD

Display 

DynaSys

Table EXP_FORE_DR

field ST_CONTRIBUTION_

Ratio K_DYN_045

CTK_CAR4_M


Sales Team Gross Margin ETDDisplay 

DynaSys

Table EXP_FORE_DR

field ST_GROSS_MARGIN_

Ratio K_DYN_033

CTK_CAR4_M 
Final Forecast ETDDisplay 

DynaSys

Table EXP_FORE_DR

field FF_ETD

Ratio K_DYN_034

QCT_MATNR5 
Final Forecast Contribution MarginDisplay 

DynaSys

Table EXP_FORE_DR

field FF_CONTRIBUTION_

Ratio K_DYN_046

CTK_CAR4_M 
Final Forecast Gross MarginDisplay 

DynaSys

Table EXP_FORE_DR

field FF_GROSS_MARGIN

Ratio K_DYN_047

CTK_CAR4_M 
       
       
BFR6 Contribution MarginDisplay 

DynaSys

Table EXP_FORE_DR

field BFR6_CONTRIBUTIO

Ratio K_DYN_032

CTK_CAR4_M 
BFR6 Gross MarginDisplay 

DynaSys

Table EXP_FORE_DR

field

ORDER_BOOK

Ratio K_DYN_020

CTK_CAR4_M 
OB Qty  

DynaSys

Table EXP_FORE_DR

field ORDER_BOOK

K_OB_QTY  
OB Price      
OB Price      
OB Value  

DynaSys

Table EXP_FORE_DR

field ORDER_BOOK_VALUE

K_OB_VAL  
Sales Team Price  

DynaSys

Table EXP_FORE_DR

field SALES_TEAM_NET_S

K_STSALES  
   

DynaSys

Table EXP_FORE_DR

field LC

0LOC_CURRCY  
Final Forecast NetBack Sales ($)  

 

K_DYN_057  
Budget NetBack Sales ($)   K_DYN_058  
BFR6 NetBack Sales ($)   K_DYN_059  
Constrained Demand Net Sales (€) (<- BFR3 Value)  

DynaSys

Table EXP_FORE_DR

Field BFR03_VALUE

K_BFR3EUR  
Constrained Demand NetBack Sales ($)   K_DYN_060  
Demand Review Quantity (ETD)   K_DYN_061  
Demand Review Net Sales (€) (<- BFR9 Value)  

DynaSys

Table EXP_FORE_DR

Field BFR09_VALUE

K_BFR9EUR  
Demand Review Contribution Margin (€)   K_DYN_062  
Demand Review Gross Margin (€)   K_DYN_063  
Budget Net Sales ($)   K_DYN_066   
Budget Contribution Margin ($)   K_DYN_064  
Budget Gross Margin ($)   K_DYN_065  
BFR6 Net Sales ($)   K_DYN_067  
BFR6 Contribution Margin ($)   K_DYN_068  
BFR6 Gross Margin ($)   K_DYN_069  

 

Characteristics

Same axis than DR/FA queries

LocationInfo-object NameInfo-object TextExplanation (if needed)
    
    

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