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 Name | BW_QRY_MVDYN11_0006 |
Application | DP - Demand Planning |
Info-provider | MultiProvider MVDYN11 |
Usage type | Direct execution via Analysis |
Expected users | Ex: GBU zone and WW controllers |
Workbook/Query General Description
Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display |  | |
| Rows/Columns |  | |
| Value Display |  | |
| Planning |  | |
| Extended |  |
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
V_0COUNTRY_0003 Ship-to Country (Selection option, Optional) | 0COUNTRY | SelectionOption/Optional/ManualEntry | No |
|
CALMONT2 Calendar Month/Year (Interval, Mandatory) | 0CALMONTH | Interval/Mandatory/ManualEntry | YES | |
V_C_CUSTGP2_0001 Enterprise Customer Group (Section option, Optional) | C_CUSTGP2 | SelectionOption/Optional/ManualEntry | No | Ship-to info |
V_CPFCTR1_2_0008 Global Business Unit (Selection Option, Optional, Auth) | CPFCTR1_2 | SelectionOption/Optional/Authorization/ManualEntry | No | |
V_0DISTR_CHAN_0001 Distribution Channel (Selection option, Optional) | 0DISTR_CHAN | SelectionOption/Optional/ManualEntry | No | |
VPROD_HIER Product Hierarchy (Selection option, optional) | C_MATNR2__0PROD_HIER | SelectionOption/Optional/ManualEntry | No | |
V_C_SHIPTO_0001 Ship-to Party (Selection option, Optional) | C_SHIPTO | SelectionOption/Optional/ManualEntry | No | |
CPROD01 Commercial Product (Select option, Optional) | C_MATNR2__C_PROD | SelectionOption/Optional/ManualEntry | No | |
V_C_MATNR2_0001 Material (Selection option) | C_MATNR2 | SelectionOption/Optional/ManualEntry | No | |
V_C_GRCUST_0001 Industrial Group (Selection option, Optional) | C_CUSTOMR__C_GRCUST | SelectionOption/Optional/ManualEntry | No | Ship-to info |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider (0INFOPROV) | = DYN Reporting (CRDYN11) | |
| Concerned Period (C_FLGMTH) | = 'M' | Only current values are requiered |
Key figures
| Description | type | Restricted or Calculated KeyFigure | Calculation rule | Conversion |
|---|---|---|---|---|
GH Quantity | Display | Ratio K_GHQTY | No | |
| FF Quantity | Display | Ratio K_FFQTY | No | |
| Demand Review Forecast | Display | Ratio K_DREVT | No | |
| Statistical Forecast | Display | Ratio K_DYSTATF | No | |
| Customer Forecast | Display | Ratio K_DYCUSTF | No | |
| CSR Forecast | Display | Ratio K_DYCSRF | No | |
| Demand Order Book | Display | Ratio K_DOBQTY | No | |
| Sales Team Forecast | Display | Ratio K_DYSTF | No | |
| BFR03 | Display | Ratio K_DYBFR3 | No | |
| BFR06 | Display | Ratio K_DYBFR6 | No | |
| BFR09 | Display | Ratio K_DYBFR9 | No | |
| Budget | Display | Ratio K_BUDGET | No |
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Column | 0CALMONTH | Calendar Year/Month | Text |
| Rows | 0LOGSYS | Source System | Key |
| Rows | C_MATNR2 | Material | Key + Text |
| Rows | C_SHIPTO | Ship-to | Key + Text |
| Rows | 0DISTR_CHAN | Distribution Channel | Key + Text Available for RCS only. For SOLVAY it corresponds to the 2 first characters of the BU. |
| Free | CPFCTR1_2 | BFC Global Business Unit | Key + Text From DSO DBDYN02 to get the BU (C_DYN_010), then MasterData C_DYN_010 to get the GBU |
| Free | C_MATNR2__0PROD_HIER | Prod. Hierarchy | Key + Text |
| Free | C_MATNR2__C_PROD | Commercial Product | Key + Text Commercial Product is only available for RCS WP1. Do not exists for SOLVAY PF1. |
| Free | C_CUSTGP2 | Enterprise Customer Group | Key + Text |
| Free | C_SHTCTRY | Ship to country | Text |
| Free | C_CUSTOMR__C_GRCUST | Industrial Group | Text |
Cells
If you have 2 structures and special cells calculations, explain here.
Conditions
If you have conditions, explain here.
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
| Ex : Excl if <=10 | Yes/No | Sales Value | Greater Than | 10 | Ex : All Independently |
Exceptions
If you have conditions, explain here.
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Ex : Red if <=10 | Yes/No | Bad 3 | Lesser Than | 10 | |