Manufacturing VC query (QV_BW_QRY_CPCOPC04_0001) is one of the components to calculate the FL-ICM (Forward-Looking Integrated Contribution Margin).
The Variable Cost (VC) of a product is the sum of Raw Materials + Packaging + Tolling + Utilities costs.
We bring the detailed costs from SAP from the BOM (Bill of Material).
The BOM brings, for a given Finished Product/Plant/Month, the detailed list of components (raw material/activity type) with the corresponding quantities and costs.
In the query, we calculate the Variable Cost taking into account, for projected months, the forecasted prices for Raw Material and Energy (input by the users in specific BI-IP workbooks) and multiply them by the quantities from the BOM. If no forecast is found, then we extrapolate last Actual price to the future months.
Tool Leader + IT leader of the application: Name of project or main leader for the application + reporting coodinator
How many users? Which user category ? Is there critical period ? Which geographical perimeter? Describe in one sentence: around 50 users, worldwide or 200 users / European Site
Provide some history of the application : When was it created ? What was the initial project ? Who was the original requestor ? If possible provide link to the project information
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_M83 | Forward Looking ICM - Manufacturing | Role Menu |
| ZBI_RCS_CO_A09 | Forward Looking ICM - Manufacturing | Authorization objects |
List of authorization variables mandatory for the application.
| Authorization variables | Object |
|---|---|
| V_CPFCTR1_2_0006 | CPFCTR1_2 |
| V_C_PLANT_0012 | C_PLANT |
| V_C_AUTHMA_0001 | C_PLANT__C_AUTHMA |
Manufacturing Cost is available in Composite Provider CPCOPC04
BOM is loaded from WP1 and PF1 in different data flows.
There are 2 different BOM queries (not used directly in Pricing dashboard)
You can find the dimensions of each query here:
BOM data from both ERPs is harmonized in CV_FMCO_BOM
Forecast comes from the following ADSOs:
You can find FL-ICM overall architecture here:
Novecare (in WP1) works with Standard Cost.
So beginning of month M, we have the cost for month M.
Specialty Polymers (in PF1) works with Actual Cost.
So beginning of month M, we have the cost for month M-1 (last closed month).
In order to have a common view, for a unique Running Period, this is the way we generate data in Manufacturing Cost query.
Note that for Novecare (WP1), there is a month lag in the Forecast price for the projected months.
We can only filter a single period to read BOM data, so in each CV, Run Period is calculated differently:
CV_FMCO_MAN_COST_RCS (WP1)
RUNPER is equal to FISCPER used to extract BOM
CV_FMCO_MAN_COST (PF1)
RUNPER = FISCPER from DTP +1
For example: to generate RUNPER 03/2022
DTP from WP1 with FISCPER = 03/2022 (to extract BOM data from 03/2022)
CV will generate RUNPER 03/2022.
DTP from PF1 with FISCPER = 02/2022 (to extract BOM data from 02/2022)
CV will generate RUNPER 03/2022.
Dependencies with other application (BW, QV, Externals tools like PVelocity or Dynasis etc...
Process chain PC_COPC_10 scheduled monthly on CD7
Monthly on Day + 7
if possible, give some information on average process chain duration, amount of data loaded and total data volume example: daily process chain loaded in 30 min, weekly chain loaded in 1h15, with around 2k to 10k lines in DELTA mode for a total of 10M lines in cube. The purpose is to give a general overview of the volume of data managed y the application
| 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 |
Give details if any historisation is done, example: keep only data greater than beginning of Y-3
Manufacturing Unit Cost query : QV_BW_QRY_CPCOPC04_0001
It combines BOM (Bill of Material) data for Actuals + Raw Material Forecast.
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
| 0I_CALMO | 0CALMONTH | Interval | No | Calendar Year/Month |
| V_C_PLANT_0012 | C_PLANT | Authorization with Input | No | Plant |
| V_CPFCTR1_2_0006 | CPFCTR1_2 | Authorization with Input | No | Global business Unit |
| V_C_MATNR2_0001 | C_MATNR2 | Select Option | No | Raw Material |
| V_C_AUTHMA_0001 | C_AUTHMA | Authorization | No | Authorization Scope |
| V_0CALMONTH_0062 | C_RUNPER | Interval | No | Run Period |
Indicate if there are broadcasts and give some details on the broadcast settings.