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 | |
| Provider Name | Multi Provider MVDYN11 |
| Usage type | |
| Expected users |
Purpose of this query
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 "Euro" ; UoM is by default "TO"
- Other prompts are optional
Filters
| Object | Filter Value | Explanation |
|---|---|---|
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
Calculation rule detail
Dynamic naming of the key figure
Currency Conversion
- Exchange Rate Type :
The full description of each exchange rate type can be found in the Exchange rates page.
- Currency :
- Time Reference :
Unit Conversion
Unit :
The full explanation on how the quantity conversion works can be found in the Quantity Unit Conversion page.
Cells
Conditional Formatting
See how to use in the Formatting page.
| Condition Name | Rule |
|---|---|
FAQ
Question :
The best way to get IT support is to use the new
Service One Platform.