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
To support monthly demand review and forecast follow-up compared to objectives (BFR6 / Budget) based on financial data. This report provides daily updates of forecast data, including Budget/BFR6 among different key figures : volume, value, unit price, contribution margin, gross margin (if available in Dynasys). The reference currency is €. Actual data are available such as Order Book and Invoiced history
Gross History and Invoiced History Net Sales are updated once a month (6th), whereas other forecast figures are updated 4 times a day (around 7am, 2pm, 6pm, 11pm)
If you want to be informed alerted by email when the BW load is fully done you can ask to be added to the distribution list (Service One => catalogue>Data services>Reporting and Dashboarding>Reporting Tools>Change distribution lists for BW update message)
Access to the query
Go to BW Analysis > WBP > Role DP - DiP/PP - DynaSys > 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. |
| CPFCTR1_2 | BFC Global Business Unit | Key + Text |
| C_MATNR2__0PROD_HIER | Prod. Hierarchy | Key + Text
|
| C_MATNR2__C_PROD | Commercial Product / Material Group | Key + Text Commercial Product for RCS WP1.
Material Group for SOLVAY PF1.
|
| C_SHTCTRY | Ship-to Country | Text |
| C_SOLDID | Sold-to | Key + Text |
| C_SOLDID__C_GRCUST | Industrial Group | Text
|
| C_DYN_017__C_SAL_GRP | Sales Group (SAP) | Sales Group = Sales Rep for RCS WP1 Only Source :
|
| C_SHTCTRY__C_GZONE | Geo Zone | Key & Texts Geo Zone is defined at Country level
Last update was done in 29/01/2016 from WP1 table ZWFAT114 (MAGNITUDE - COUNTRIES) field Administrative zone (MGN_ZADM) Transco 'EUR' => 'EU'; 'AMSU' => 'LA'; 'ASIA' => 'AP'; 'AMNC' => 'NA' |
| C_DYN_005__C_TACTIC2 | Tactical Material | Tactical Material for RCS PF1.
Tactical Material for RCS WP1.
|
| C_CUSTOMR__0REGION | Ship-to Region | |
| C_CUSTOMR__0CITY | Ship-to City | For both SAP Ship-to and Sales Force Prospects |
| C_DYN_018__C_MPPLANT | Main Shipping Plant | |
| C_MATNR2__C_MATGR2 | Packaging Type | For Solvay PF1 only
Not assigned in WP1 |
| C_MATNR2__C_DIVISN | Division | Key + Text |
| C_DYN_010 | BU | Key |
| C_DYN_018__C_MSHCOND | Main Shipping Cond. | Shipping Condition of the last M3 sales order not rejected (No reason for Rejection , Item Category M3N, most recent change on date)
Not assigned in WP1 |
| C_MATNR2__C_MAGRV | Packaging Materials | Only for RCS
Not assigned in PF1 |
C_DYN_021__C_DYN_020 | Planning Zone | Managed in DynaSys at DFU level
|
| C_GBR14__C_GBR1 | GBR End-Use (Application) | Previous to 30/10/2017, field was C_GBR5__C_GBR1 Important C_GBR34 end-uses for all GBUs has been created to replace
To avoid havy modification in QV queries / QV application, only mapping in MVDYN11 has been changed C_GBR14__C_GBR1 is now assigned to C_GBR34__C_GBR1 Modification done 2021/01/18 Important BFC Activity 1 (C_MAGNIT2) has to be filled only for GBU = CS (Novecare), for others, as Soda in the below example, have to remain blank
|
| C_GBR14__C_GBR2 | GBR End-Use (Market) | Previous to 30/10/2017, field was C_GBR5__C_GBR2 See important points written for C_GBR14__C_GBR1
|
| C_GBR14__C_GBR3 | GBR End-Use (Segment) | Previous to 30/10/2017, field was C_GBR5__C_GBR3
See important points written for C_GBR14__C_GBR1 |
| C_DYN_021__C_DYN_022 | ABC Class (auto) | Managed in DynaSys Is based on Estimated ICM (possibility for S&OP managers to force change) 0 = Opportunité SFDC 1 = class for which Sales Team forecast is needed 2 + 3 = mainly forecast generated by stat processus
|
| C_DYN_021__C_DYN_023 | ABC Class (manual) | Managed in DynaSys Not used by Novecare and not linked to l'ABC Class (Auto) For PF1 A Large accounts to be reviewed
For WP1
|
| C_GBUZONE__C_ZONEH1 | GBU Zone (Hier. 1) | Key and Text Ship-to's GBU Zone (Hier. 1). Updated by flat file. Defined at GBU / Country level. It is defined GBU by GBU, so an update is requested in case of GBU change. Use ZBW_GBR to update GBU Zone (Hier. 1) => WIKI
|
| C_GBUZONE__C_ZONEH2 | GBU Zone (Hier. 2) | Key and Text. Defined at GBU / Country level. same as GBU Zone (Hier. 1)
|
| 0G_CWWE01 | IECRA | For WP1 only
|
C_GBR18__C_GBR19 | GBR GBU Mat Group | Key and Text The notion of GBU material group exists only for WP1. |
| C_GBR13__C_GBR9 | GBR: Customer Sub Group | Key and Text
|
| C_GBR13__C_GBR6 | GBR GBU group (Ship-to) | Key + Text
|
| C_GBR15__C_SHIPKA | GBR Ship-to KA | Key and Text
|
| C_SHTCTRY__C_ZONE | Ship-to BFC Geographie/Zone | Key and Text Zone is defined at Country Level.
One shot upload done by flat file (Last upload 11/07/2014). |
| C_DYN_024__C_PROSP | Flag Prospect | Key and Text 'X' Prospect ' ' Ship-to
 |
| 0INFOPROV | InfoProvider | Key and Text |
| C_GBR18__C_GBR20 | GBU Material Sub-grp | Key and Text
|
| C_DYN_018__PRDFACT | Main Prod Plant | Attribute maintained only in DynaSys for RCS Material/Shipto
|
| C_MATNR2__C_LPROD | Product Line 00 | Source SAP Source SAP - function module Z_WBW_DTS_SD_PROD_AXIS ex WP1 Material 101655
|
| C_MATNR2__C_LIP04 | Product Line 04 | Key + Text
|
| C_MATNR2__C_FMPRD | Product Family Code | Key + Text
|
| C_SOTCTRY | Sold-to Country | Key + Text |
| C_SOTCTRY__C_ZONE | Sold-to BFC Geographie/Zone | Key + Text
See rule for Ship-to one |
| 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
|
| C_DYN_017__C_INCOTM2 | Incoterms 2 (RCS) | Key
|
| C_GBR23__SGINFO4 | GBR Segment Info 4 | Key RCS only (depending on IECRA) to be updated in case of IECRA / ERP BU creation/change
|
| C_GBR23__SGINFO5 | GBR Segment Info 5 | Key RCS only (depending on IECRA) to be updated in case of IECRA / ERP BU creation/change
|
| C_DYN_017__C_FLGDIST | Distributor Flag | Texts but empty (flow will be implemented later)
|
| C_MATNR2__C_LIP02 | Product Line 02 | Texts
|
| 0CALQUARTER | Cal. Year/Quarter | Key |
| 0CALMONTH2 | Calendar Month | Key |
| 0CALYEAR | Calendar Year | Key |
| 0CALQUART1 | Quarter | Key |
| 0LOC_CURRCY | Local Currency | Key |
| 0CURRENCY | Currency | Key |
| 0UNIT | Unit of Measure | Key |
| C_MATNR2__C_LIP03 | Product line 03 | Key and Text Only for RCS
|
| C_TGBRC2__C_ENTSEG3 | GBR Enterprise Segment | Key + Text
|
| CPFCTR2_2 | BFC Group of activities | Key + Text
|
| C_MAGNITU | BFC Activity 1 | Key + Text
|
| C_MATNR2_C_BISMT | Old Material Number |
|
| C_DYN_053 | Base Material PRCOM | |
| C_DYN_061 | Commercial Product | 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
|
| C_DYN_018__C_VWPART | CCS Rep (M3) | PF1 notion from M3 Sales Orders
|
| C_DYN_017__C_SALEMP | Sales Employee (SAP) | Key + Texts For PF1
For WP1
|
| C_DYN_017__C_ZIPART | ZI Partner (SAP) | Customer Service Officer (CSO) or CSR Contact Only filled for RCS, from SAP
|
| C_DYN_021__C_DYN_065 | Sales Employee DYN | Managed in DynaSys
|
| C_DYN_021__C_DYN_066 | Sales Assistant DYN | Managed in DynaSys
|
| C_DYN_018__C_DYN_062 | S&OP Planner | Used by Novecare + Special Chem From DynaSys
|
| C_DYN_021___C_DYN_063 | New Product Type | Used by PEROX From DynaSys
|
| C_DYN_024__C_DYN_064 | CRM Prospect Code | CRM Prospect before transcodification to fit max length 11 characters |
| C_DYN_021__C_DYN_034 | Active DFU (Y/N) | Key + Text ( Yes/No ) Managed in DynaSys |
C_DYN_021__C_DYN_035 | Replaced DFU (Y/N) | Key + Text ( Yes/No ) Managed in DynaSys |
| C_DYN_021__C_DYN_086 | ABC variability | Key and Text Used by SA&D, and managed in DynaSys 3 Values : X Regular / Y Normal / Z Chaotic
|
| C_SHIPTID__C_NAMECO | C/O (Ship-to) | Key
|
| C_SOLDID__C_NAMECO | C/O (Sold-to) | Key
|
| C_DYN_017__0CUST_GRP2 | Customer Group 2 'Customer Group 2' is renamed as 'GBU Segment' => It has been implemented mid-July 2023 (WO%285066) | Customer Segmentation from the SAP SOLD-TO (caution if SOLD-TO has been forced in DynaSys, customer segmentation can not be re-determined) Added 2020-01-18
|
| C_MATNR2__C_LIP05 | LIP05 | Only for WP1
|
| C_GBR4__C_MAKTCL | Market Cluster | Key and Text Market Cluster is linked to Corporate End-Use (C_GBR4 managed in GBR) Market Cluster is managed in PF1 (and soon in WP1) table ZSD_T_ENDU_MARKC Used by GBU Specialty Polymer
|
| C_MATNR2 | Material | Key + Text |
| C_MATNR2__C_MAT_GRP | Material Group | Key + Text |
| C_SHIPTID | SAP Ship-to | Key + Text |
| C_DYN_024 | SAP Ship-to (incl.Prosp) | Key + Text |
| C_GBR15__C_SHIPK2 | Ship-to KA Adjusted | Key + Text |
| C_DYN_018__C_DYN_049 | Stock Holding Strategy | Key + Test
|
| C_DYN_085__C_TEAMCL | Team Cluster | Key
Team Cluster is linked to Sold-to master. Market Cluster is managed in PF1 only, customer master, sales view, ‘extra sales area data’, tab ‘Additional Data’ Used by GBU Specialty Polymer |
C_DYN_018__0REPLENTIME C_DYN_018__C_WZEIT | Total Replenishment Lead time | Info from C_MATPNT2, 2 axis, one as a keyfigure (like original one), on as a characteristic SAP Material Master => MRP 3 view (MARC-WZEIT)
0REPLENTIME = 40 0STGE_PD_UN = TAG C_WZEIT = 40 DAYS |
| C_DYN_021_C_DYN_UA | Under allocation | X = under allocation => It has been implemented mid-July 2023 (WO%285066) Managed in DynaSys, It is added as navigational attribute of master data C_DYN_021 Value recieved 0 or 1, store N or Y in BW table
|
C_DYN_021_C_DYN_087 | Customer group final | implemented mid Nov 2023 for Novecare (WO%36101 & WO%36538) Managed in DynaSys, It is added as navigational attribute of master data C_DYN_021 |
C_DYN_021_C_DYN_088 | Opportunity ID | implemented mid Nov 2023 for Novecare (WO%36101 & WO%36538) Managed in DynaSys, It is added as navigational attribute of master data C_DYN_021 CASE SENSITIVE |
C_DYN_021_C_DYN_089 | Opportunity Number | implemented mid Nov 2023 for Novecare (WO%36101 & WO%36538) Managed in DynaSys, It is added as navigational attribute of master data C_DYN_021 Text collected in BW using tables /BIC/TC_DYN_024 (Ship-to (including Prospects)) and /BIC/TC_GRCUST (SAP Customer Corp. Group (PRS)) |
Key Figures
For more details please follow this link.
Name | Type | Unit | Description |
|---|---|---|---|
| Gross History | Hidden by default | KG | 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) Price extracted from DynaSys at DFU/Month level. To be displayed at same level in BW to get the correct price (otherwise it corresponds to the sum of prices for each line aggregated) | |
| Sales Team Net Sales | 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 Net Sales | |||
| Sales Team Forecast M-1 | Display | VKG | |
| 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 | |
| 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 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 CURR/UNIT | 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 Forecast | Display | VKG | Constrained Forecast |
| Constrained Forecast Net Sales | Display | * 1,000 EUR | Constrained Demand Net Sales |
| Constrained Forecast NetBack Sales($) | Hidden by default | * 1,000 $ | To be renammed Constrained Demand NetBack Sales (USD) |
| Constrained Forecast 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 | |
| Sales Team Forecast (REV) | Display | VKG | Invoiced History and Final Sales Team Forecast in Invoicing Date implemented mid-July 2023 (WO%285066) |
| Final Forecast (REV) | Display | VKG | Invoiced History and Final forecast in Invoicing Date implemented mid-July 2023 (WO%285066) |
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