Basic Information
| BW Server | WBP |
|---|---|
| Application | DP - Demand Planning |
| Query Name | BW - DP - Budget Review (Core Query) |
| Query Technical Name | BW_QRY_MVDYN11_0001 |
| Core/Specific Scope | Core |
| Specific Reason | If the query is not core, explanation on why it's specific (Ex : Special Tax system in India...) |
| Provider Name | Multi Provider MVDYN11 |
| Usage type | Direct execution in Analyzer / Workbook broadcast / QV / webtemplate... |
| Expected users | Ex : Site controller |
Purpose of this query
Explain the scope, purpose and history of the query. Explain if possible what is the typical use and users.
Access to the query
Go to BW Analysis > WBP > Role DP - Demand Planning
BW - DP - Budget Review (Core Query)
Variables and selection screen
- Calendar Year/Month is mandatory (MM.YYYY) as well as currency and UoM for Qty conversion
- Currency is by default "EUR" ; UoM is by default "VKG"
- Other prompts are optional
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Ex : Status of the trading partner | Ex : <> 1 | Ex : Exclude intercompanies |
Characteristics
Default layout
| Characteristic code | Characteristic Name | Explanation |
|---|---|---|
| C_MATNR2 | Material | Material |
| C_SHIPTID | Ship-to | SAP Code + Name of Customer / place where the material is shipped |
Free Characteristics
| Characteristic code | Characteristic Name | Explanation |
|---|---|---|
| 0CALMONTH | Calendar Year/Month | Text |
| 0LOGSYS | Source System | No display to avoid the display of the prefix for compound characteristics. |
| 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 |
| C_DYN_024 | DYN Ship-to (incl.Prosp) | Available for DynaSys since 30/10/2017 02.2019 Added on FA |
| 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 |
| C_MATNR2__0PROD_HIER | Prod. Hierarchy | Key + Text |
| C_MATNR2__C_PROD | Commercial Product / Material Group | Key + Text Commercial Product for RCS WP1. Example 90001465 / RHODOLINE® 581B
Material Group for SOLVAY PF1. Example Z10-11695 / SD TGT<0,15
Exception rule : for material RCS dupplicated on Solvay PF1, having Basic Material filled with Commercial Product, value is stored in C_PROD axis instead of Material Group
02.2019 Added on Segmentation |
| C_SHTCTRY | Ship-to Country | Text 02.2019 Added on Segmentation |
| C_SOLDID | Sold-to | Key + Text Previously, the Sold-to was C_SOLDTO, but description were not daily loaded. |
| 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. |
| C_DYN_017__C_SAL_GRP | Sales Group (SAP) | Sales Group = Sales Rep for RCS WP1 Only Source :
|
| C_SHTCTRY__C_GZONE | Geo Zone | No description available |
| C_DYN_005__C_TACTIC2 | Tactical Material | Description are available since 08/12/2016 |
| C_CUSTOMR__0REGION | Ship-to Region | |
| 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 |
| C_DYN_018__C_MPPLANT | Main Shipping Plant | |
| C_MATNR2__C_MAT_GRP | Material Group | |
| C_MATNR2__C_MATGR2 | Packaging Type | Previous name : Material Group 2 (Release March 2017) For Solvay PF1 only |
| C_MATNR2__C_DIVISN | Division | |
| C_DYN_010 | BU | |
| 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) |
| C_MATNR2__C_MAGRV | Packaging Materials | Only for RCS Available since 14/03/2017 |
C_DYN_021__C_DYN_020 | Planning Zone | DYN Only Changed to C_DYN_021 27/11/2018 |
| C_GBR14__C_GBR1 | GBR End-Use (Application) | Previous to 30/10/2017, field was C_GBR5__C_GBR1 |
| C_GBR14__C_GBR2 | GBR End-Use (Market) | Previous to 30/10/2017, field was C_GBR5__C_GBR2 |
| C_GBR14__C_GBR3 | GBR End-Use (Segment) | Previous to 30/10/2017, field was C_GBR5__C_GBR3 |
| C_GBR14__C_GBR4 | GBR Corporate End-Use | Previous to 30/10/2017, field was C_GBR5__C_GBR4 |
| C_DYN_021__C_DYN_022 | ABC Class (auto) | DYN Only |
| C_DYN_021__C_DYN_023 | ABC Class (manual) | DYN Only |
| C_GBUZONE__C_ZONEH1 | GBU Zone (hier. 1) | Key and Text => Dyn Only 02.2019 Added on Segmentation |
| C_GBUZONE__C_ZONEH2 | GBU zone (hier. 2) | Key and Text =>Dyn Only 02.2019 Added on Segmentation |
| 0G_CWWE01 | IECRA | APO + DYN WP1 |
| C_GBR18__C_GBR19 | GBR GBU Mat Group | Key and Text
02.2019 Added on Segmentation |
| C_GBR13__C_GBR9 | GBR: Customer Sub Group | Key and Text Available since since 30/10/2017 02.2019 Added on Segmentation |
| C_GBR13__C_GBR6 | GBR GBU group (Ship-to) | Key + Text Available since since 30/10/2017, for Dyn/Log , it replaces 'Enterprise Customer Group' 02.2019 Added on Segmentation |
| C_GBR15__C_SHIPKA | GBR Ship-to KA | Key and Text Available since since 30/10/2017 |
| C_SHTCTRY__C_ZONE | Ship-to BFC Geographie/Zone | Key and Text Available since since 30/10/2017 |
| C_DYN_024__C_PROSP | Flag Prospect | Key and Text Available since since 30/10/2017
'X' Prospect
' ' Ship-to 02.2019 Added on FA |
| 0INFOPROV | InfoProvider | Key and Text Available since 30/10/2017 |
| C_GBR18__C_GBR20 | GBU Material Sub-grp | Key and Text Available since 28/11/2017 02.2019 Added on Segmentation |
| C_DYN_018__PRDFACT | Main Prod Plant | Available since 31/05/2018 Attribut maintained only in DynaSys for RCS Material/Shipto 02.2019 Added on Segmentation 06.2019 => description change to "Main Production Plant" (Ex : Default Factory Plant) |
| C_MATNR2__C_LPROD | Product Line 00 | |
| C_MATNR2__C_LIP04 | Product Line 04 | |
| C_MATNR2__C_LIP05 | Product Line 05 | Key and Text Available since 28/11/2017 02.2019 Added on Segmentation |
| C_MATNR2__C_FMPRD | Product Family Code | |
| C_SOTCTRY | Sold-to Country | |
| C_SOTCTRY__C_ZONE | Sold-to BFC Geographie/Zone | |
| C_DYN_005__C_GRPPGMI | Product Group (PGMI) | Available only for TS (filter on PGMI IC*) |
| C_DYN_018__C_INCOTRM | Incoterms (Solvay) | Key |
| C_DYN_018__C_INCOTM2 | Incoterms 2 (Solvay) | Key |
| C_DYN_017__C_INCOTRM | Incoterms (RCS) | Key Available since 18/10/2018 |
| C_DYN_017__C_INCOTM2 | Incoterms 2 (RCS) | Key Available since 18/10/2018 |
| C_GBR23__SGINFO4 | GBR Segment Info 4 | Available 13/12/2018 RCS only (depending on IECRA) 02.2019 Added on FA/Segmentation |
| C_GBR23__SGINFO5 | GBR Segment Info 5 | Available 13/12/2018 RCS only (depending on IECRA) 02.2019 Added on FA/Segmentation |
| C_DYN_017__C_FLGDIST | Distributor Flag | Texts 02.2019 Added on DR/BR/FA/Segmentation but empty (flow will be implemented later) |
| C_MATNR2__C_LIP02 | Product Line 02 | Texts 02.2019 Added on DR/BR/FA/Segmentation |
| C_GBR15_C_SHIPK2 | GBR Ship-to KA Adjusted | Key 02.2019 Added on DR/BR/FA/Segmentation For Novecare. If Commercial Product = "GRCL000098", Ship-to is taken |
| 0CALQUARTER | Cal. Year/Quarter | Key 02.2019 Added on DR/FA |
| 0CALMONTH2 | Calendar Month | Key 02.2019 Added on DR/FA |
| 0CALYEAR | Calendar Year | Key 02.2019 Added on DR/FA |
| 0CALQUART1 | Quarter | Key 02.2019 Added on DR/FA |
| 0LOC_CURRCY | Local Currency | Key 02.2019 Added on DR |
| 0CURRENCY | Currency | Key 02.2019 Added on DR |
| 0UNIT | Unit of Measure | Key 02.2019 Added on DR/FA |
| C_PRODPLA | Manufacturing Plant | Available since 15/02/2018 for FA |
| C_SAL_OFF | Sales Office | Available since 15/05/2018 for FA |
| C_SHIPTO | Customer number | |
| C_MATNR2__C_AMTS001 | Reason for material production | |
| C_MATNR2__C_MSTAV | X-DChain status | |
| C_GBUZONE | GBU zone | |
| C_PLANT | Plant | |
| C_CUSTOMR__0COUNTRY | Cust: Country | |
| C_DYN_018__C_COMPCDE | Company code | |
| C_DOCTYP2 | Order document type | DYN for Source DynaSys APO for Source APO |
| C_MATNR2__C_LIP03 | Product line 03 | |
| 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) => to be removed quickly in last QV query (QV is not using it anymore) |
| C_TGBRC2__C_ENTSEG3 | GBR Enterprise Segment | Available since 25/06/2019 |
| CPFCTR2_2 | BFC Group of activities | BFC BU Available since 07/2019 From IECRA for WP1; from Material Plant for PF1 (C_DYN_018) Technical object is C_DYN_018__CPFCTR2_2 but taken from CPFCTR2_2 stored in cube |
| C_MAGNITU | BFC Activity 1 | Available since 07/2019 From IECRA for WP1; from Material Plant for PF1 (C_DYN_018) Technical object is 0G_CWWE01__C_MAGNITU but taken from C_MAGNITU stored in cube |
| C_MATNR2_C_BISMT | Old Material Number | Available since 04/2020 |
| C_DYN_053 | Base Material PRCOM | Available since 04/2020 |
| C_DYN_061 | Commercial Product | Available since 04/2020 Commercial product For WP1 (C_MATNR2_C_PROD) Basic Material for PF1 (C_MATNR2_BASIC_MATL) |
| C_DYN_018__C_VEPART | Account Manager (M3) | PF1 notion from M3 Sales Orders Release April 2017 |
| C_DYN_018__C_VWPART | CCS Rep (M3) | PF1 notion from M3 Sales Orders Release April 2017 |
| C_DYN_017__C_SALEMP | Sales Employee (SAP) | Key + Texts 02.2019 Added on DR/FA/Segmentation For RCS : Mix DYN (view EXP_SHIPTO_DC_SR_MANUAL) / SAP => DynaSys source to be removed |
| C_DYN_017__C_ZIPART | ZI Partner (SAP) | Customer Service Officer (CSO) or CSR Contact Only filled for RCS, from SAP Old name CSO. Changed to ZI Partner (SAP) 05.11.2020 |
| C_DYN_021__C_DYN_065 | Sales Employee DYN | 09.2020 From DynaSys view EXP_DFU_DR_BW |
| C_DYN_021__C_DYN_066 | Sales Assistant DYN | 09.2020 From DynaSys view EXP_DFU_DR_BW |
| C_DYN_018__C_DYN_062 | S&OP Planner | 09.2020 New Used by Novecare + Special Chem From DynaSys view EXP_MATSHIPTO_BW |
| C_DYN_021___C_DYN_063 | New Product Type | 09.2020 New Used by PEROX From DynaSys view EXP_DFU_DR_BW |
| C_DYN_024__C_DYN_064 | CRM Prospect | CRM Prospect before transcodification to fit max length 11 characters |
| C_DYN_021__C_DYN_034 | Active DFU | |
| C_DYN_021__C_DYN_035 | Replaced DFU |
Key Figures
For more details please follow this link.
Name | Type | Unit | Description |
|---|---|---|---|
| Gross History | Hidden by default | VKG | Gross History (Reference used for statistical forecast) Issued from Monthly snapshot (6th of each month) |
| Invoiced History Net Sales | Hidden by default | * 1,000 EUR | |
| Invoiced Hist. & Order Book to be Invoiced | Display | KG | |
| Shipped Hist. & Open Order Book [ETA] | Display | KG | |
| Shipped Hist. & Open Order Book (ETD) | Display | KG | |
| Order Book (ETA) | Hidden by default | VKG | |
| Order Book (ETD) | Display | VKG | |
| OB Price CURR/UNIT | Hidden by default | EUR / VKG | Order Book Price per Prompted Currency/Prompted Unit |
| [-] OB Price CURR/KG | Display | EUR / KG | Order Book Price per Prompted Currency/KG |
| Order Book (ETD) KG | Hidden by default | KG | |
| Invoiced Hist. & Order Book to be Invoiced Net Sales | Display | * 1,000 EUR | Order Book Net Sales = Order Book (ETD) x Order Book Price |
| Open Order Book (ETA) | Display | KG | |
| Open Order Book (ETD) | Display | KG | |
| Statistical Forecast | Hidden by default | VKG | Statistical Forecast |
| Stat. Forecast (ETD) | Display | KG | |
| Customer Forecast | Hidden by default | VKG | Customer Forecast |
| CSR Forecast | Display | VKG | CSR Forecast |
| CSR Forecast (ETD) | Display | KG | |
| Upside Forecast | Hidden by default | VKG | Export parameter in KG for Upside Forecast |
| Sales Team Forecast | Hidden by default | VKG | Forecast registered by the Sales Manager (ETA) |
| Sales Team Forecast (ETD) | Display | VKG | Sales Team Forecast estimated in ETD (based on estimated transit time in month - Offset) |
| [-] Sales Team Price LC/KG | Display | Sales Team Price (LC/KG) | |
| Sales Team Net Sales (LC) | Hidden by default | * 1,000 | |
| Sales Team Price CURR/UNIT | Hidden by default | EUR / VKG | Sales Team Price (CURR/UNIT) |
| [-] Sales Team Price CURR/KG | Display | EUR / KG | Sales Team Price (CURR/KG) |
| Sales Team Forecast ETD in KG | Hidden by default | KG | |
| Sales Team Forecast Net Sales | Display | * 1,000 EUR | Sales Team Net Sales |
| Sales Team Contribution Margin | Display | * 1,000 EUR | Estimated Constribution margin based on Final Sales Team forecast (ETD) Final Sales Team (ETD) x Estimated Unit Contribution Margin |
| Demand Review | Hidden by default | VKG | Demand Review (ETA) |
| Demand Review (ETD) | Display | VKG | Demand Review estimated in ETD (based on estimated transit time in month - Offset) |
| Demand Review Price CURR/UNIT | Display | EUR / VKG | |
| [-] Demand Review Price CURR/KG | Display | EUR / KG | |
| Demand Review (ETD) in KG | Hidden by default | KG | |
| Demand Review Net Sales | Display | * 1,000 EUR | |
| Demand Review Contribution Margin | Display | * 1,000 EUR | Demand Review Contribution Margin |
| Final STF (ETA) | Display | KG | |
| Final STF (ETD) | Display | KG | |
| Final Sales Team Forecast M-1 | Display | VKG | |
| Final Sales Team Forecast M-2 | Display | VKG | |
| Final Forecast | Hidden by default | VKG | Final Forecast = Last validated forecast (ETA) |
| Final Forecast (ETD) | Display | VKG | Final Forecast estimated in ETD (based on estimated transit time in month - Offset) |
| Final Forecast M-1 | Display | VKG | |
| Final Forecast M-2 | Display | VKG | |
| [-] Final Sales Price LC/KG | Display | Final Forecast Price LC/KG | |
| Sales Price (LC) | Hidden by default | ||
| Final Sales Price CURR/UNIT | Hidden by default | EUR / VKG | Final Forecast Price CURR/UNIT |
| [-] Final Sales Price CURR/KG | Display | EUR / KG | Final Forecast Price CURR/KG |
| Final Forecast ETD in KG | Hidden by default | KG | |
| Final Forecast Net Sales | Display | * 1,000 EUR | Final Forecast Net Sales |
| Final Forecast Net Sales (LC) | Hidden by default | * 1,000 | Final Forecast Net Sales (LC) |
| [-] Final Forecast NetBack Price CURR/UNIT | Hidden by default | EUR / VKG | Final Forecast NetBack Price CURR/UNIT |
| Final Forecast NetBack Sales | Hidden by default | * 1,000 EUR | |
| Final Forecast NetBack Sales($) | Hidden by default | * 1,000 $ | Final Forecast NetBack Sales $ |
| Final Forecast Contribution Margin | Display | * 1,000 EUR | Estimated Constribution margin based on Final forecast (= Last validated forecast (ETD) Final Forecast (ETD) x Estimated Unit Contribution Margin |
| Constrained Demand | Display | VKG | Constrained Demand |
| Constrained Demand Net Sales | Display | * 1,000 EUR | Constrained Demand Net Sales |
| Constrained Demand NetBack Sales($) | Hidden by default | * 1,000 $ | To be renammed Constrained Demand NetBack Sales (USD) |
| Constrained Demand Contribution Margin | Display | * 1,000 EUR | Constrained Demand Contribution Margin |
| Budget | Display | VKG | Budget reference in quantity |
| Budget Price CURR/UNIT | Hidden by default | VKG / EUR | Budget Price CURR/UNIT |
| [-] Budget Price CURR/KG | Display | EUR / KG | Budget Price CURR/KG |
| Budget qty in KG | Hidden by default | KG | |
| Budget Price $/UNIT | Display | $ / VKG | Budget Price $/UNIT |
| Budget Price $/KG | Display | $ / KG | Budget Price $/KG |
| Budget Net Sales | Display | * 1,000 EUR | Budget Net Sales |
| Budget Net Sales($) | Display | * 1,000 $ | Budget Net Sales ($) |
| Budget Net Sales LC | Display | ||
| [-] Budget NetBack Price CURR/UNIT | Hidden by default | EUR / VKG | Budget NetBack Price CURR/UNIT |
| Budget NetBack Sales | Hidden by default | * 1,000 EUR | |
| Budget NetBack Sales($) | Display | * 1,000 $ | Budget NetBack Sales ($) |
| Budget Contribution Margin | Display | * 1,000 EUR | Budget Contribution Margin |
| Budget Contribution Margin($) | Display | * 1,000 $ | Budget Contribution Margin ($) |
| BFR3 | Hidden by default | VKG | BFR3 reference in quantity |
| BFR6 | Hidden by default | VKG | BFR6 reference in quantity |
| BFR6 Price CURR/UNIT | Hidden by default | EUR / VKG | BFR6 Price CURR/UNIT |
| [-] BFR6 Price CURR/KG | Hidden by default | EUR / KG | BFR6 Price CURR/KG |
| BFR6 qty in KG | Hidden by default | KG | |
| BFR6 Price $/UNIT | Hidden by default | $ / VKG | BFR6 Price $/UNIT |
| BFR6 Price $/KG | Display | $ / KG | BFR6 Price $/KG |
| BFR6 Net Sales | Hidden by default | * 1,000 EUR | BFR6 Net Sales |
| BFR06 Net sales LC | Display | ||
| BFR6 Net Sales($) | Hidden by default | * 1,000 $ | BFR6 Net Sales ($) |
| [-] BFR6 NetBack Price CURR/UNIT | Hidden by default | EUR / VKG | BFR6 NetBack Price CURR/UNIT |
| BFR6 NetBack Sales | Hidden by default | * 1,000 EUR | |
| BFR6 NetBack Sales($) | Hidden by default | * 1,000 $ | BFR6 NetBack Sales ($) |
| BFR6 Contribution Margin | Hidden by default | * 1,000 EUR | BFR6 Contribution Margin |
| BFR6 Contribution Margin($) | Hidden by default | * 1,000 $ | BFR6 Contribution Margin ($) |
| BFR9 | Hidden by default | VKG | BFR9 reference in quantity |
| Estimated Actuals (Qty) | Hidden by default | VKG | Estimated Actuals = Reference for the GBU |
| Estimated Actuals (Amount) | Hidden by default | * 1,000 EUR | |
| Estimated Actuals (Amount $) | Hidden by default | * 1,000 $ | Estimated Actuals (Amount $) |
| Delta Forecast | Hidden by default | VKG | |
| Delta Forecast (Amount) | Hidden by default | * 1,000 EUR | Delta Forecast |
| Delta Forecast (Amount $) | Hidden by default | * 1,000 $ | Delta Forecast (Amount) |
| Upside Forecast (Amount) | Hidden by default | * 1,000 EUR | Updside Forecast (Amount) |
| Upside Forecast (Amount $) | Hidden by default | * 1,000 $ | Updside Forecast (Amount) |
| Delta EA | Hidden by default | VKG | Delta EA |
| Delta EA (Amount) | Hidden by default | * 1,000 EUR | Delta EA (Amount) |
| Delta EA (Amount $) | Hidden by default | * 1,000 $ | Delta EA (Amount $) |
| Sales Team Forecast vs Budget Volume | Display | VKG | Sales Team Forecast vs Budget Volume |
| Sales Team Forecast vs Budget Net Sales | Display | * 1,000 EUR | Sales Team Forecast vs Budget Net Sales |
| Sales Team Forecast vs Budget Contribution Margin | Display | * 1,000 EUR | Sales Team Forecast vs Budget Contribution Margin |
| Final Forecast vs Budget Volume | Display | VKG | Gap between Final Forecast (ETD) and Budget |
| Final Forecast vs Budget Net Sales | Display | * 1,000 EUR | Final Forecast vs Budget Net Sales |
| Final Forecast vs Budget Contribution Margin | Display | * 1,000 EUR | Final Forecast vs Budget Contribution Margin |
| Final Forecast vs Sales Team Forecast Volume | Display | VKG | Gap between Final forecast (ETD) and Sales Team Forecast (ETD) |
| Final Forecast vs Sales Team Forecast Net Sales | Display | * 1,000 EUR | Final Forecast vs Sales Team Forecast Net Sales |
| Final Forecast vs Sales Team Forecast Contribution Margin | Display | * 1,000 EUR | Gap between Final forecast Contribution Margin and Sales Team Forecast Contribution Margin |
| WIP Budget Net Sales | Display | EUR | |
| WIP Budget Net Sales ($) | Display | $ | |
| WIP Budget | Display | VKG |
Description
Text/name of the variable and explanation
Calculation rule detail
Quantity x Price
Dynamic naming of the key figure
If relevant, add the text replacement rule used for the key figure. Ex : <Fiscal Period> Quantity
Currency Conversion
- Exchange Rate Type : Ex ZRH0
The full description of each exchange rate type can be found in the Exchange rates page.
- Currency : Variable, or fixed currency used
- Time Reference : Current date / Based on infoobject X / Variable
Unit Conversion
Unit : Variable or fixed unit
The full explanation on how the quantity conversion works can be found in the Quantity Unit Conversion page.
Cells
If you have 2 structures and special cells calculations, explain here.
Conditional Formatting
See how to use in the Formatting page.
| Condition Name | Rule |
|---|---|
| Ex: Bulk Only | Ex : Only show if Gross Qty = Net Qty |
FAQ
Question : Ex : Quantity is seems incorrect when displaying the storage location in rows.
Answer to the question