The new wiki link for this data flow is here:
BW - DP - Budget Review (Core Query)
Please update the new doc there and no longer here.
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 Name | BW_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
| Tab | Screenshot | Comment |
|---|---|---|
| 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_ZONEH1 | Selection Option | No | Will be added in V2 |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider (0INFOPROV) | = DYN Reporting (CRDYN11) + DYN Reporting SnapShot (CRDYN13) + APO Novecare Snapshot (CRAPO005) + APO Special Chem Snapshot (CRAPO003 + CRAPO011) | 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 APO Novecare Snapshot (CRAPO005) => added 2019/05/09 APO Special Chem Snapshot (CRAPO003 + CRAPO011) => added 2020/07/23 |
| 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
| Description | type | Source / Restricted /Calculated Keyfigure | Calculation rule | Conversion | Comments |
|---|---|---|---|---|---|
Gross History qty | Display | DynaSys Table EXP_FORE field GH_QUANTITY | Ratio K_GHQTY / fixed KG | QCT_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 EUR | CTK_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 KG | QCT_MATNR5 | Previous to 13/11/2017 : description was "FF Quantity" |
| Demand Review Forecast | Display | DynaSys Table EXP_FORE_DR Field DEMAND_REVIEW_F | Ratio K_DREVF / 0UNIT | QCT_MATNR5 | |
| Demand Review Quantity (ETD) | K_DYN_061 / 0UNIT | ||||
| Demand Review Net Sales (€) | DynaSys Table EXP_FORE_DR Field BFR09_VALUE | K_BFR9EUR / fixed EUR | Reuse of object/field BFR9 Value | ||
| Demand Review Contribution Margin (€) | K_DYN_062 / fixed EUR | ||||
| Demand Review Gross Margin (€) | K_DYN_063 / fixed EUR | ||||
| Statistical Forecast | Display | DynaSys Table EXP_FORE_DR Field STAT_FCT_QUANTIT | Ratio K_DYSTATF / 0UNIT | QCT_MATNR5 | |
| Customer Forecast | Display | DynaSys Table EXP_FORE_DR field CF_QUANTITY | Ratio K_DYCUSTF / 0UNIT | QCT_MATNR5 | |
| CSR Forecast | Display | DynaSys Table EXP_FORE_DR Field CSRF_QUANTITY | Ratio K_DYCSRF / 0UNIT | QCT_MATNR5 | |
| Sales Team Forecast | Display | DynaSys Table EXP_FORE_DR Field STF_QUANTITY | Ratio K_DYSTF / 0UNIT | QCT_MATNR5 | |
| BFR03 | Display | DynaSys Table EXP_FORE_DR Field BFR03 | Ratio K_DYBFR3 / 0UNIT | QCT_MATNR5 | |
Available since August 2017 Dynasys only Will be removed soon. | |||||
| BFR06 | Display | DynaSys Table EXP_FORE_DR Field BFR06 | Ratio K_DYBFR6 / 0UNIT | QCT_MATNR5 | |
| BFR06 Net Sales | Display | DynaSys Table EXP_FORE_DR Field BFR06_VALUE | Ratio K_BFR6EUR | CTK_CAR4_M | Available since August 2017 Dynasys only Will be renammed 'BFR06 Net Sales' instead of 'Value' |
| BFR6 Net Sales ($) | K_DYN_067 / Fixed USD | No Conversion | |||
| BFR6 NetBack Sales ($) | K_DYN_059 / Fixed USD | No Conversion | |||
| BFR09 | Display | DynaSys Table EXP_FORE_DR Field BFR09 | Ratio K_DYBFR9 / fixed EUR | QCT_MATNR5 | |
Available since August 2017 Dynasys only Will be removed soon. | |||||
| Budget | Display | DynaSys Table EXP_FORE_DR Field BUDGET | Ratio K_DYBUD / 0UNIT | QCT_MATNR5 | |
| Budget Price CURR/KG | Display | | |||
| Budget qty in KG | Hidden | Ratio K_DYBUD / 0UNIT | No Conversion | ||
| Budget Net Sales | Display | DynaSys Table EXP_FORE_DR Field BUDGET_VALUE | Ratio K_BUDEUR / fixed EUR | CTK_CAR4_M | Available since August 2017 Dynasys only Will be renammed 'Budget Net Sales' instead of 'Value' |
| Budget Net Sales ($) | K_DYN_066 / Fixed USD | No Conversion | |||
| Budget NetBack Sales ($) | K_DYN_058 / Fixed USD | No Conversion | |||
| Budget Contribution Margin | Display | DynaSys Table EXP_FORE_DR field BUDGET_CONTRIBUT | Ratio K_DYN_048 / 0CURRENCY | CTK_CAR4_M | |
| Budget Contribution Margin ($) | K_DYN_064 / Fixed USD | No Conversion | |||
| Budget Gross Margin | Display | DynaSys Table EXP_FORE_DR field BUDGET_GROSS_MAR | Ratio K_DYN_030 / 0CURRENCY | CTK_CAR4_M | |
| Budget Gross Margin ($) | K_DYN_065 / Fixed USD | No Conversion | |||
Upside Forecast | Hidden | DynaSys Table EXP_FORE_DR Field UPSIDE_FORECAST | Ratio K_UPSIDE / 0UNIT | QCT_MATNR5 | Available since 14/03/2017 |
| Demand Order Book | Display | DynaSys Table EXP_FORE_DR Field CF_QUANTITY | Ratio K_DOBQTY / fixed KG | QCT_MATNR5 | |
| OB (ETD) | Display | DynaSys Table EXP_FORE_DR field ORDER_BOOK | K_OB_QTY / 0UNIT | QCT_MATNR5 | |
| OB Price CURR/KG | Display |
| |||
| OB Qty in KG | Hidden | K_OB_QTY / 0UNIT | No Conversion | ||
| OB Price CURR/UNIT | Display |
| |||
| OB Net Sales | Display | DynaSys Table EXP_FORE_DR field ORDER_BOOK_VALUE | K_OB_VAL / 0UNIT | 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 SALES_TEAM_NET_S
field LC | Ratio K_STSALES / 0LOC_CURRCY | No Conversion | ||
| Weighted Sales Team Price CURR/KG |
| ||||
| Sales Team Forecast ETD in KG | Hidden | K_DYN_044 / 0UNIT | No Conversion | ||
| Weighted Sales Team Price CURR/UNIT |
| ||||
Sales Team Forecast Net Sales | Display | DynaSys Table EXP_FORE_DR field STF_VALUE_ETD | Ratio K_DYN_031 / 0CURRENCY | CTK_CAR4_M | |
Sales Team Contribution Margin | Display | DynaSys Table EXP_FORE_DR field ST_CONTRIBUTION_ | Ratio K_DYN_045 / 0CURRENCY | CTK_CAR4_M | |
| Sales Team Gross Margin | Display | DynaSys Table EXP_FORE_DR field ST_GROSS_MARGIN_ | Ratio K_DYN_033 / 0CURRENCY | CTK_CAR4_M | |
| Final Forecast ETD | Display | DynaSys Table EXP_FORE_DR field FF_ETD | Ratio K_DYN_034 / 0UNIT | QCT_MATNR5 | |
| Final Sales Price CURR/KG |
| ||||
| Final Forecast ETD in KG | K_DYN_034 / 0UNIT | No Conversion | |||
| Final Sales Price CURR/UNIT |
| ||||
| Final Forecast Net Sales | Display | DynaSys Table EXP_FORE_DR Field FF_VALUE | Ratio K_FCSTAMT / 0CURRENCY | CTK_CAR4_M | 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 |
| Final Forecast NetBack Sales ($) | K_DYN_057 / Fixed USD | No Conversion | |||
| Final Forecast Contribution Margin | DynaSys Table EXP_FORE_DR field FF_CONTRIBUTION_ | Ratio K_DYN_046 / 0CURRENCY | CTK_CAR4_M | ||
| Final Forecast Gross Margin | DynaSys Table EXP_FORE_DR field FF_GROSS_MARGIN | Ratio K_DYN_047 / 0CURRENCY | CTK_CAR4_M | ||
| BFR6 Contribution Margin | Display | DynaSys Table EXP_FORE_DR field BFR6_CONTRIBUTIO | Ratio K_DYN_032 / 0CURRENCY | CTK_CAR4_M | |
| BFR6 Contribution Margin ($) | K_DYN_068 / Fixed USD | No conversion | |||
| BFR6 Gross Margin | Display | DynaSys Table EXP_FORE_DR field ORDER_BOOK | Ratio K_DYN_020 / 0CURRENCY | CTK_CAR4_M | |
| BFR6 Gross Margin ($) | K_DYN_069 / Fixed USD | No conversion | |||
| Sales Team Forecast vs Budget Volume |
| ||||
| Sales Team Forecast vs Budget Net Sales |
| ||||
| Sales Team Forecast vs Budget Contribution Margin |
| ||||
| Final Forecast vs Budget Volume |
| ||||
| Final Forecast vs Budget Net Sales |
| ||||
| Final Forecast vs Budget Contribution Margin |
| ||||
| Final Forecast vs Sales Team Forecast Volume |
| ||||
| Final Forecast vs Sales Team Forecast Net Sales |
| ||||
| Final Forecast vs Sales Team Forecast Contribution Margin |
| ||||
| Constrained Demand | Display | DynaSys Table EXP_FORE_DR Field CONST_FCST_QUANT | Ratio K_CONFOR / 0UNIT | QCT_MATNR5 | APO only Available for DynaSys since 30/10/2017 |
| Constrained Demand Net Sales | DynaSys Table EXP_FORE_DR Field BFR03_VALUE | K_BFR3EUR / Fixed EUR | reuse of objet/field BFR3 Value | ||
| Constrained Demand NetBack Sales ($) | K_DYN_060 / Fixed USD |
| Sales Price | Display | Formula: Sales Price Value / Qty - 1 Kg | Available since August 2017 Dynasys only | ||||
| Sales Price Value | Hidden | DynaSys Table EXP_FORE_DR Field SALES_PRICE | Ratio K_SALPEKG | CTK_ZRHO3M | Available since August 2017 Dynasys only | ||
| Qty - 1 Kg | Hidden | RAtio K_QTY1KG | QCT_MATNR5 | Available since August 2017 Dynasys on |
| Sales Team Price Value | Hidden | DynaSys Table EXP_FORE_DR field ST_PRICE | Ratio K_FFEUR | CTK_CAR4_M |
Characteristics
See page : BW - DP - List of axis in DP queries
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
Exceptions
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Yes/No | |||||