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 - Segementation Report (Core query) |
|---|---|
| Technical Name | BW_QRY_MVDYN11_0007 |
Application | DP - Demand Planning |
Info-provider | MultiProvider MVDYN11 |
Usage type | Direct execution via Analysis |
Expected users |
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
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) | |
| 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 | Restricted or Calculated KeyFigure | Source | 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' |
Characteristics
Same axis than BW - DP - Budget Review (Core Query)
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
Cells
If you have 2 structures and special cells calculations, explain here.
Conditions
4 conditions are created on this BW Bex Query
| 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 | ||