General presentation
Objective of the application
Energy Forecast prices are collected in a BW-IP workbook and then used in Manufacturing VC query to calculate the Energy cost for projected months.
Usage information
History
Roles & Access
Roles and access
List of application role + menu role and explanation if we have several applications role with specials rules.
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_M79 | Forward Looking ICM - Energy - Menu | Role Menu |
| ZBI_RCS_CO_A07 | Forward Looking ICM - Energy | Authorization objects |
Authorization variables
List of authorization variables mandatory for the application.
| Authorization variables | Object |
|---|---|
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA |
| V_C_PLANT_0012 | C_PLANT |
| V_CPFCTR1_2_0006 | CPFCTR1_2 |
Dataflow overview
Workbook "FL - Energy Forecast" is used to save Energy forecast prices entered by the users
The workbook is assigned to query BW_QRY_ALCOPC14_0001, which is built on Aggregation Level ALCOPC14.
The Composite Provider CPCOPC12 was created only to handle the authorization scope.
Energy prices are stored in DSO ABCOPC10.
The data flow starts from the BOM.
For Novecare, we get the last Actual price for each plant/activity (commodity), to use as proposed price in the workbook.
For SpP, there is no proposed price because we don't have this level of detail in the BOM in PF1 (by activity type). So we load from the BOM only the plants, then the activities (commodities) are "artificially" created in BW from this list (master data C_ENERGY)
Integrating Energy Cost in the Manufacturing CV for Novecare
In CV_FMCO_MAN_COST_RCS, for each plant/activity from the BOM, we get the forecast price from ABCOPC10 for the subsequent months.
If no forecast is found, Actual data is extrapolated for the future months (same logic as Raw Material Forecast)
Link to documents
https://app.diagrams.net/#G1RLCMm5yN06FOmvBvRN5HOSCk1xwCFtvl
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Dependencies with other applications
Data loadings
Info providers and objects loaded
Loading frequency
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |