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

Compare with Current View Page History

« Previous Version 25 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  
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_CAR4_M

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_CAR4_M

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

 
Demand Order BookDisplay 

DynaSys

Table EXP_FORE_DR

Field CF_QUANTITY

Ratio K_DOBQTY / fixed KGQCT_MATNR5  
OB (ETD) Display 

DynaSys

Table EXP_FORE_DR

field ORDER_BOOK

K_OB_QTY QCT_MATNR5  
OB Price CURR/KGDisplay 

 

     
OB Qty in KG Hidden   K_OB_QTY No Conversion  
OB Price CURR/UNITDisplay

     
OB Net SalesDisplay 

DynaSys

Table EXP_FORE_DR

field ORDER_BOOK_VALUE

K_OB_VAL CTK_CAR4_M  
Sales Team Forecast ETD

Display

  

DynaSys

Table EXP_FORE_DR

field STF_ETD

Ratio K_DYN_044 / 0UNIT

QCT_MATNR5 

 


Sales Team Price LC/KG 

     
ST Net Sales (LC)   

DynaSys

Table EXP_FORE_DR

field XX

 Ratio K_STSALES No Conversion  
Weighted Sales Team Price CURR/KG 

     
Sales Team Forecast ETD in KGHidden  K_DYN_044No Conversion  
Weighted Sales Team Price CURR/UNIT 

     
        
        
      


       

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

 

 

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 Price ValueHidden 

DynaSys

Table EXP_FORE_DR

field ST_PRICE

Ratio K_FFEUR

CTK_CAR4_M

 

 

 

 

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