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 |
Workbook/Query General Description
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 |
|---|---|---|---|---|
CALMONT2 Calendar Month/Year (Interval, Mandatory) | 0CALMONTH | Interval/Mandatory/ManualEntry | Yes | |
V_CPFCTR1_2_0008 Global Business Unit (Selection Option, Optional, Auth) | CPFCTR1_2 | SelectionOption/Optional/Authorization/ManualEntry | No | |
V_0CURRENCY_0006 Currency | ||||
VBASE_UOM_05 Conversion Unit (Single, Required) | Single | Yes | ||
V_C_MATNR2_0001 Material (Selection option) | C_MATNR2 | SelectionOption/Optional/ManualEntry | No | |
CPROD01 Commercial Product (Select option, Optional) | C_MATNR2__C_PROD | SelectionOption/Optional/ManualEntry | No | |
VPROD_HIER Product Hierarchy (Selection option, optional) | C_MATNR2__0PROD_HIER | SelectionOption/Optional/ManualEntry | No | |
V_CUSTID_0002 Ship-to (Selection option) | C_SHIPID | SelectionOption/Optional/ManualEntry | No | Previously it was C_SHIPTO but description were not daily updated. No filter possible on SF Prospects |
V_0DISTR_CHAN_0001 Distribution Channel (Selection option, Optional) | 0DISTR_CHAN | SelectionOption/Optional/ManualEntry | No | |
V_C_GBR6_0001 GBR Customer Group (Select Option, Optional) | C_GBR13__C_GBR6 | SelectionOption/Optional/ManualEntry | No | Ship-to info |
V_0COUNTRY_0003 Ship-to Country (Selection option, Optional) | C_SHTCTRY | SelectionOption/Optional/ManualEntry | No |
|
V_C_GRCUST_0001 Industrial Group (Selection option, Optional) | C_SOLDID__C_GRCUST | SelectionOption/Optional/ManualEntry | No | Sold-to info V1 => Ship-to info (C_CUSTOMR__C_GRCUST) |
V_C_SAL_GRP Sales Group (Selection option, Optional) | C_DYN_017__C_SAL_GRP | SelectionOption/Optional/ManualEntry | No | Sales Group = Sales Rep = only for RCS |
V_C_GZONE Geo Zone (Selection option, Optional) | C_SHTCTRY__C_GZONE | SelectionOption/Optional/ManualEntry | No | From Ship-to Country |
V_C_PLANT_0010 Plant (Selection Option, Optional) | C_DYN_018__C_MPPLANT | SelectionOption/Optional/ManualEntry | No | |
V_C_PROSP_0001 SF Prospect ( 'X' only prospects, <> 'X' exclude prospects) | C_DYN_024__C_PROSP | SelectionOption/Optional/ManualEntry | No | |
V_C_ZONE_0005 BFC Geo/Zone (Selection option) | C_SHTCTRY__C_ZONE | SelectionOption/Optional/ManualEntry | No |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| InfoProvider (0INFOPROV) | = DYN Reporting (CRDYN11) + APO | |
| Concerned Period (C_FLGMTH) | = 'M' | Only current values are requiered |
Key figures
All keyfigures without decimals as in Dynasys
| 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 | 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 val. | Display | DynaSys Table EXP_FORE field GH_VALUE | Ratio K_GHEUR | CTK_ZRHO3M | Available since August 2017 Dynasys only Previous to 13/11/2017 : description was "GH value" | |
Final Forecast qty | Display | DynaSys Table EXP_FORE_DR Field FF_QUANTITY | Ratio K_FFQTY | QCT_MATNR5 | Previous to 13/11/2017 : description was "FF Quantity" | |
Final Forecast val. | Display | DynaSys Table EXP_FORE_DR Field FF_VALUE | Ratio K_FCSTAMT | 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 Forecast | Display | DynaSys Table EXP_FORE_DR Field DEMAND_REVIEW_F | Ratio K_DREVT | QCT_MATNR5 | ||
| Statistical Forecast | Display | DynaSys Table EXP_FORE_DR Field STAT_FCT_QUANTIT | Ratio K_DYSTATF | QCT_MATNR5 | ||
| Customer Forecast | Display | DynaSys Table EXP_FORE_DR Field CF_QUANTITY | Ratio K_DYCUSTF | QCT_MATNR5 | ||
| CSR Forecast | Display | DynaSys Table EXP_FORE_DR Field CSRF_QUANTITY | Ratio K_DYCSRF | QCT_MATNR5 | ||
| Demand Order Book | Display | Ratio K_DOBQTY | QCT_MATNR5 | |||
| Sales Team Forecast | Display | Ratio K_DYSTF | QCT_MATNR5 | |||
| BFR03 | Display | Ratio K_DYBFR3 | QCT_MATNR5 | |||
| BFR03 value | Display | Ratio K_BFR3EUR | CTK_ZRHO3M | Available since August 2017 Dynasys only | ||
| BFR06 | Display | Ratio K_DYBFR6 | QCT_MATNR5 | |||
| BFR06 value | Display | Ratio K_BFR6EUR | CTK_ZRHO3M | Available since August 2017 Dynasys only | ||
| BFR09 | Display | Ratio K_DYBFR9 | QCT_MATNR5 | |||
| BFR09 value | Display | Ratio K_BFR9EUR | CTK_ZRHO3M | Available since August 2017 Dynasys only | ||
| Budget | Display | Ratio K_DYBUD | QCT_MATNR5 | |||
| Budget Value | Display | Ratio K_BUDEUR | CTK_ZRHO3M | Available since August 2017 Dynasys only | ||
Upside Forecast | Display | Ratio K_UPSIDE | QCT_MATNR5 | Available since 14/03/2017 | ||
| ||||||
| Constrained Forecast | Display | Ratio K_CONFOR | QCT_MATNR5 | APO only Available for DynaSys since 30/10/2017 | ||
| Sales Price | Display | Formula: Sales Price Value / Qty - 1 Kg | Available since August 2017 Dynasys only | |||
| Sales Price Value | Hidden | 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 only | ||
| DynaSys Table EXP_FORE_DR Field CONST_DEMAND_CON | ||||||
| DynaSys Table EXP_FORE_DR Field CONST_DEMAND_GRO | ||||||
| DynaSys Table EXP_FORE_DR Field FF_NET_SALES | ||||||
| Estimated Actuals (Qty) | Display | DynaSys Table EXP_FORE_DR Field EA_QTY | Ratio K_DYN_073 | Available since May 2018 Dynasys only | ||
| Estimated Actuals (Amount) | Display | DynaSys Table EXP_FORE_DR Field EA_EURO | Ratio K_DYN_074 | Available since May 2018 Dynasys only | ||
| Estimated Actuals (Amount $) | Display | DynaSys Table EXP_FORE_DR Field EA_DOLLAR | Ratio K_DYN_075 | Available since May 2018 Dynasys only | ||
| Delta Forecast | Display | DynaSys Table EXP_FORE_DR Field DELTA_FCT_QTY | Ratio K_DYN_082 | QCT_MATNR5 | Will be available soon Dynasys only | |
| Delta Forecast Amount (€) | Display | DynaSys Table EXP_FORE_DR Field DELTA_FCT_EURO | Ratio K_DYN_076 | Will be available soon Dynasys only | ||
| Delta Forecast Amount ($) | Display | DynaSys Table EXP_FORE_DR Field DELTA_FCT_USD | Ratio K_DYN_077 | Will be available soon Dynasys only | ||
| Upside Forecast Amount (€) | Display | DynaSys Table EXP_FORE_DR Field UPSIDE_FCT_EURO | Ratio K_DYN_078 | Will be available soon Dynasys only | ||
| Upside Forecast Amount ($) | Display | DynaSys Table EXP_FORE_DR Field UPSIDE_FCT_USD | Ratio K_DYN_079 | Will be available soon Dynasys only | ||
| Delta EA | Display | DynaSys Table EXP_FORE_DR Field DELTA_EA_QTY | Ratio K_DYN_083 | QCT_MATNR5 | Will be available soon Dynasys only | |
| Delta EA Amount (€) | Display | DynaSys Table EXP_FORE_DR Field DELTA_EA_EURO | Ratio K_DYN_080 | Will be available soon Dynasys only | ||
| Delta EA Amount ($) | Display | DynaSys Table EXP_FORE_DR Field DELTA_EA_USD | Ratio K_DYN_081 | Will be available soon Dynasys only |
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Column | 0CALMONTH | Calendar Year/Month | Text |
| Rows | 0LOGSYS | Source System | No display to avoid the display of the prefix for compound characteristics. |
| Rows | C_MATNR2 | Material | Key + Text |
| Rows | C_SHIPTID | SAP Ship-to | Key + Text Previously, the Ship-to was C_SHIPTO, but description were not daily loaded. Previous 30/10/2017, the description was 'Ship-to' |
| Rows | C_DYN_024 | Ship-to (including Prospects) | Will be available soon Available for DynaSys since 30/10/2017 |
| Rows | 0DISTR_CHAN | Distribution Channel | Key + Text Available for RCS only. For SOLVAY it corresponds to the 2 first characters of the BU. Also available for Logility flow, coming from Exclusion table since 01.2018 |
| 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 (APO) | Key + Text Since 30/11/2017, only for APO (new axis for Dyn). Old description 'Enterprise Customer Group' |
| Free | C_SHTCTRY | Ship-to Country | Text |
| Free | C_SOLDID | Sold-to | Key + Text Previously, the Sold-to was C_SOLDTO, but description were not daily loaded. |
| Free | C_SOLDID__C_GRCUST | Industrial Group | Text V1 = C_CUSTOMR__C_GRCUST For V2 it has been changed for C_CUSTID. The field KONZS is taken from PRS Customer. PRS seems not contains all customers (only payer?). If Customer Group (C_GRCUST) are missing, the masterdata will have to be upgraded to get missing ones. |
| Free | C_DYN_017__C_SAL_GRP | Sales Group | Sales Group = Sales Rep = Only for RCS |
| Free | C_SHTCTRY__C_GZONE | Geo Zone | No description available |
| Free | C_DYN_005__C_TACTIC2 | Tactical Material | Description are available since 08/12/2016 |
| Free | C_DYN_017__C_ZIPART | CSO | Customer Service Officer (CSO) Only filled for RCS |
| Free | C_CUSTOMR__0REGION | Ship-to Region | |
| Free | C_CUSTOMR__0CITY | Ship-to City | Since 30/10/2017, for DynaSys info it comes from C_DYN_024 to get city for both SAP Ship-to and Sales Force Prospects |
| Free | C_DYN_018__C_MPPLANT | Main Shipping Plant | |
| Free | C_MATNR2__C_MAT_GRP | Material Group | |
| Free | C_MATNR2__C_MATGR2 | Packaging Type | Previous name : Material Group 2 (Release March 2017) For Solvay PF1 only |
| Free | C_MATNR2__C_DIVISN | Division | |
| Free | C_DYN_010 | BU | |
| Free | C_DYN_018__C_MSHCOND | Main Shipping Cond. | Available since 07/02/2017 Shipping Condition of the last M3 sales order not rejected (No reason for Rejection , Item Category M3N, most recent change on date) |
| Free | C_DYN_018__C_INCOTRM | Incoterms | Available since 07/02/2017 Incoterms of the last M3 sales order not rejected (No reason for Rejection , Item Category M3N, most recent change on date) |
| Free | C_DYN_018__C_DYN_016 | Key Account (Ship-to KA) (APO) | RCS notion Text in MD C_GRCUST Available since 14/03/2017 Since 30/10/2017, For DynaSys/Logility, use Ship-to KA (GBR) (C_GBR15__C_SHIPKA) Will be removed soon. Use now the GBR one => item 480 |
| Free | C_MATNR2__C_MAGRV | Packaging Materials | Only for RCS Available since 14/03/2017 |
| Free | C_DYN_018__C_VEPART | Account Manager | PF1 notion Release April 2017 |
| Free | C_DYN_018__C_VWPART | CCS Rep | PF1 notion Release April 2017 |
| Free | C_DYN_019__C_DYN_020 | Planning Zone | DYN Only |
| Free | C_GBR14__C_GBR1 | Application | Previous to 30/10/2017, field was C_GBR5__C_GBR1 |
| Free | C_GBR14__C_GBR2 | Market | Previous to 30/10/2017, field was C_GBR5__C_GBR2 |
| Free | C_GBR14__C_GBR3 | Segment | Previous to 30/10/2017, field was C_GBR5__C_GBR3 |
| Free | C_GBR14__C_GBR4 | Corporate End Use | Previous to 30/10/2017, field was C_GBR5__C_GBR4 |
| Free | C_DYN_021__C_DYN_022 | ABC Class (auto) | DYN Only |
| Free | C_DYN_021__C_DYN_023 | ABC Class (manual) | DYN Only |
| Free | C_GBUZONE__C_ZONEH1 | GBU zone (hierarchy | Key and Text => Dyn Only |
| Free | C_GBUZONE__C_ZONEH2 | GBU zone (hier. 2) | Key and Text =>Dyn Only |
| Free | 0G_CWWE01 | IECRA | APO Only |
| Free | C_GBR18__C_GBR19 | GBU Material Group | Key and Text The notion of GBU material group exists only for WP1. Available since since 30/10/2017 |
| Free | C_GBR13__C_GBR9 | GBR Customer Sub Group | Key and Text Available since since 30/10/2017 |
| Free | C_GBR13__C_GBR6 | GBR Customer Group | Key + Text Available since since 30/10/2017, for Dyn/Log , it replaces 'Enterprise Customer Group' |
| Free | C_GBR15__C_SHIPKA | Ship-to KA (GBR) | Key and Text Available since since 30/10/2017 |
| Free | C_SHTCTRY__C_ZONE | BFC Geographie/Zone | Key and Text Available since since 30/10/2017 |
| Free | C_DYN_024__C_PROSP | Flag Prospect | Key and Text Available since since 30/10/2017
'X' Prospect
' ' Ship-to |
| Free | 0INFOPROV | InfoProvider | Key and Text Available since 30/10/2017 |
| Free | C_GBR18__C_GBR20 | GBU Material Sub-grp | Key and Text Available since 28/11/2017 |
| Free | C_MATNR2__C_LIP05 | Product line 05 | Key and Text Available since 28/11/2017 |
| Free | C_DYN_018__PRDFACT | Default Production Factory | Available since 31/05/2018 Attribut maintained only in DynaSys for RCS Material/Shipto |
| Free | C_MATNR2__C_LPROD | Product line 00 | Will be available soon |
| Free | C_MATNR2__C_LIP04 | Product Line 04 | Will be available soon |
| Free | C_MATNR2__C_FMPRD | Product Family | Will be available soon |
| Free | C_SOTCTRY | Sold-to Country | Will be available soon |
| Free | C_SOTCTRY__C_ZONE | Sold-to BFC Geographie/Zone | Will be available soon |
| Free | C_DYN_005__C_GRPPGMI | Product Group (PGMI) | Will be available soon. Available only for TS (filter on PGMI IC*) |
| Free | C_DYN_018__C_INCOTM2 | Incoterms 2 | Will be available soon. |
| Free | C_DYN_017__C_SALEMP | Sales Employee | To add |
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 | |||||