General presentation
Objective of the application
i-MEP stands for Integrated Manufacturing & Energy Performance
The I-MEP application provides to business the possibility to analyze the production target cost / actual cost / variance for each cost item in process order / cost collector, and to determine energy consumption and CO2 emission during production process.
BI manufacturing reports will replace house solutions :
- on RCS (WP1) : programs ZWPP40A/B/C
- on Solvay (PF1) : program Z1K_MATCOST (Prix de Revient)
Tool Leader + IT leader of the application:
Usage information
History
Roles & Access
Roles and access
| Role Code | Role Description | Explanation |
|---|---|---|
| ZR_RCS_CA_Mxx | IMEP - Integrated Manufacturing & Energy Performance | Gives access to queries & workbooks IMEP (Manufacturing & Energy reports) |
| ZBI_RCS_IMEP_A01 | IMEP - Integrated Manufacturing & Energy Performance (IMEP) | Gives access to InfoArea IA_FMCO_CO_IMEP* and all authorization relevant objects except
|
Authorization objects
List of autorisation objects mandatory for the application.
| Authorization object | Explanation |
|---|---|
| GBU (C_MATPLNT-CPFCTR1_2 ) | ZR_*_CA_P05 |
| Plant (C_PLANT) | ZR_*_CA_P02 ZR_7866_CA_P02 => Plant 7866 - Chalampé (ex 7027) - (Cie ZFR9) ZR_TOUT_CA_P02 => All Plants "Solvay" |
See also file maintained by Authorization team : BW Catalog of Roles / link: https://drive.google.com/open?id=10GEfKYqrT1eeTO_uHYAheL1GX7L5y_pvH0KQU64qh5I
Dataflow overview
https://drive.google.com/open?id=18v4PEvS10Q4RmofZBDuuuTiyTqO9anDL3x-Bcxvnv2s
Functional and Technical rules on Workbench + Reporting
Rules & Explanations
Source tables
Table ZWPPMCKOST / i-MEP extraction table
This table exists on both systems PF1/WP1, but the structure is slightly different.
Following additional fields exists for PF1 table, but not for WP1 table : append ZWPPMCKOST_EXTRA
Process Chain | Code |
|---|---|
| Code établissement DSI | ETABL |
| Code édition | EDITI |
| Libellé de la ligne d'édition | LIBLI |
| Type: Fix/Var/Dep | FVD |
| Cost collector for production process PROCNR | PKOSA |
| Material Ledger Cost | MLWRT |
This table is filled via program XXX and contains only the values for the previous period (The table is emptied before each loading)
to be completed
Table ZZX_CO2_COEFFS / Energy and CO2 Emission Coeffcients
This table exists on both systems PF1/WP1, and is filled manually by Energy Carbon team
to be completed
At datasource level (PF1/WP1)
Controlling Area (0CO_AREA)
The controlling area is unique on PF1 ( value CHEF), but not on WP1 ( Z006, Z025, Z026...)
The controlling Area is not available on ECC side specific tables, but, in order to match the BI referential, this information is necessary to get referential attribut and texts (example 'Cost Center' C_COSTCTR, 'Profit Center' C_PFT_CTR)
To get the information extractor are based on specific view with follow the business rule given :
Add datasource names and view names
At business level (WBP)
Dependencies with other applications
Data loadings
Info providers and objects loaded
Main Chains
Process Chain | Code | Type | Frequency | Comments |
|---|---|---|---|---|
| MAIN |
Sub Chains
Process Chain | Code | Type | Frequency | Comments |
|---|---|---|---|---|
Other Chains
Process Chain | Code | Type | Frequency | Comments |
|---|---|---|---|---|
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 |
Record Keeping
Reporting
Queries End User Documentation
Main queries
Main functionalities
Broadcast
Maintenance
Known bugs
Recurring procedure
Planned Evolution