...
The first one ("FL - Energy Forecast") is common for Novecare and SpP and is used to save Energy price typed by the users. This is done by plant/activitiy (ELEC, GAS, STEAM, etc)
Energy unit price is stored in DSO ABCOPC10.
For
GBU Novecare
We , we get the latest Actual price (current month M) from the BOM, for each plant/activity, to use as proposed price in the workbook for future (M+12) months. Then the user can change the prices and save.
...
A change was requested to improve the process for Novecare (and potential other WP1 GBUs from WP1, like TS and PA).
As the prices sent by Corporate are not reflecting the same process used by plant controllers, it has been decided to implement a % increase to standard cost instead.
A formula will automatically calculate the % trend based on the corporate data of the unit price between each month in the workbook.
Example of the calculation:
https://docs.google.com/spreadsheets/d/1F8YPA5tVAw-hieDyODLhQwQNnKJOt-vxsoe3ezu4gGU/edit#gid=0
So the prices saved by Corporate in the workbook are stored in ABCOPC10.
And a new DSO ABCOPC19 is loaded from ABCOPC10, and the % increase calculation is applied in TRF below
Then ABCOPC19 is integrated in CV_FMCO_MAN_COST_RCS.
No more lag is applied, meaning the Forecast for month M takes directly the price from month M, Forecast for M+1 takes the price from M+1, etc.
GBU SP
There For SpP, there is no proposed price because we don't have this level of detail (by activity type) in the BOM in PF1. So we load from the BOM only the plants, then the activities are "artificially" created in BW from the values in master data C_ENERGY, and then the user can input the prices..
Currently the only activities loaded in the Unit price workbook for GBU SP are ELEC, GAS, STEAM.
This is filtered in CV_FMCO_ENERGY_SP_FORE_UF into AACOPC06 (used as lookup in TRSF: APCOPC06 -> ADSO ABCOPC11)
As for SpP, there is no detail coming from SAP for "Utilities" (just an aggregated cost), there is this For SpP, there is a specific process covered by the second workbook ("FL - Energy Forecast - SPP Usage Factor) where the users save the usage factor by plant/H4/product hierarchy.
...