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.
| 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 - Budget Review (Core queryQuery) |
|---|---|
| Technical Name | BW_QRY_MVDYN11_0001 |
Application | DP - Demand Planning |
Info-provider | MultiProvider MVDYN11 |
Usage type | Direct execution via Analysis |
Expected users |
| Table of Contents | ||
|---|---|---|
|
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 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
Same axis than DR/FA queries
Characteristics
See page : BW - DP - List of axis in DP queries
Cells
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 | ||||||||||||