General presentation
Objective of the application
Manufacturing Unit Cost query (QV_BW_QRY_CPCOPC04_0001) is one of the components to calculate the FL ICM.
It combines BOM (Bill of Material) data for Actuals + Raw Material Forecast.
The BOM brings the breakdown of the Variable Cost (Raw Materials, Packaging, Tolling and Utilities).
For projected months, if forecast prices are not found for a raw material, the query extrapolates the costs from Actuals.
Tool Leader + IT leader of the application:
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 |
|---|---|---|
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
Dataflow overview
BOM is loaded from WP1 and PF1 in different data flows.
There are 2 different queries:
- QV_BW_QRY_CPCOBOM1_0001 - for WP1 GBUs (eg Novecare)
- QV_BW_QRY_CPCOBOM2_0001 - for PF1 GBUs (eg Specialty Polymers)
WP1 data flow is a replication of the solution already used by Novecare.
PF1 data flow is totally new and relies on a custom table (ZCO_PRICE_RM) populated in PF1
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 |