The IMEP (Integrated Manufacturing & Energy Performance) application is under the finance domain using data from SAP CO (Controlling) to provides to business the possibility to analyze the production's target cost, actual cost, the variance for each cost item in process order, the cost collector, and to determine energy consumption and CO2 emission during production process.
For this Application the access is provided based on the BW menu "IMEP - Integrated Manufacturing & Energy Performance" and it's done via Service one.
Fill the form
https://solvay-dwp.onbmc.com/dwp/app/#/itemprofile/622
In SAP system select the "WBP - BW Business Warehouse"
In WBP - BW Business Warehouse : Select the Business Role select the "IMEP - Integrated Manufacturing & Energy Performance"
VERSION | DATE | MODIFIED BY | DESCRIPTION |
0.01 | 09.10.2023 | Inês Vilares | Initial draft |
| Data Product Type |
|
| Technologies |
|
Data Sources Note: list of all applications and various environment |
|
2.0 Business Process
Capture the business process that the application supports . This can be describe through a process diagram or a business capability model
3.0 Application Feature Overview
For this application find below all the workbooks available (the most used workboks are identified by the symbol 
):
| Reports | Definition | Prompts | BW Workbook Query | Query Technical Name |
|---|---|---|---|---|
| BW - IMEP - WP1 Manuf. Local Database (Core Workbook) | It gives a transversal and consolidated view of manufacturing costs (from sites to GBU level) for all plants managed in WP1. | Mandatory:
Optional:
| BW_WBK_CO_0019 | BW_QRY_MVCOPP01_0009 |
| BW - IMEP - PF1 Manuf. Local database (Core Workbook) | It gives a transversal and consolidated view of manufacturing costs (from sites to GBU level) for all plants managed in PF1. | BW_WBK_CO_0021 | ||
| BW - IMEP - PF1 Check of data consistency (Core Workbook) | The workbook is used to validate the quality of the data reported in imep for the sites in PF1. | BW_WBK_CO_0024 | ||
| BW - IMEP - PF1 ML synthesis (Core Workbook) | This report answers a specific need of GBUs operating in PF1 who wants to better understand the impact of the stock effects in their P&L. It can be used as the report Z1K_CONS_ESTO in PF1 but for a wider scope. | BW_WBK_CO_0026 | ||
| BW - IMEP - PF1 Prod. Cost Center Actual Postings (Core Workbook) | It is cost center report that can be used to detail the Index 1 = 9. It is mainly used to provide the detailed utilities costs that are posted in dedicated cost centers with dedicated Statistical Key figure. | BW_WBK_CO_0025 | ||
| BW - IMEP - PF1 Prod. Costs by Cost Objects (Core Workbook) | This workbook is the same as the workbook BW_WBK_CO_0021 IMEP - PF1 Manuf. Local database (Core Workbook) with a different lay-out. | BW_WBK_CO_0029 | ||
| BW - IMEP - PF1 Uploaded budget data check (Core Workbook) | This report used to control the budget that was uploaded using the transaction ZIMEP_FILE. | BW_WBK_CO_0023 |
4.0 Functional Specification
4.1 General Data/Calculations
For these reports, it’s important to understand some general concepts which are transversal to all the reports which allows the users to work with the reports.
4.2 Process Detail
4.2.1. Report/Process Definition
| Domain | Finance |
|---|---|
| Application | BW reports under IMEP - Integrated Manufacturing & energy Performance folder |
| Provider | MVCOPP01 |
SAP BW High Level View
IMEP - Characteristics
You can find below the list of all characteristics and some measures available in iMEP workbooks.
Type in your keywords in the field "Text search"
Index 1
In the application iMEP, the caracteristic Index 1 is a key element to understand to set-up an accurate report to follow production quantities and costs.
For historical reasons, the data structure is not the same in our two source systems (WP1 & PF1). It explains why some indexes only exist in one of the two ERPs.
| Code | Description | Definition | WP1 | PF1 |
|---|---|---|---|---|
| 1 | Produced material | Costs and quantities at finished product level |  | |
| 2 | Co-product | Co-product | | |
| 3 | BOM conponent | Costs and quantities issued from component consumption | | |
| 4 | Subcontracting | Subcontracting costs | | |
| 5 | Activity type | Costs and quantities issued from activity consumption at standard costs | | |
| 6 | Settlement | Process Orders variances | |  |
| 7 | Cost Collector Varia | Allocation of activity variances done by Material Ledger |
| |
| 9 | SKF/direct Posting | Detailed origin of costs consumed on production cost centers by Activities | | |
Example PF1
The aim is to have the detailed quantities and costs of production of the material 157142 in iMEP
There are 4 columns in the report:
- Finished product code:
- Index 1
- Actual quantities
- Mat. Ledger Costs = Actual costs
The detail of costs & quantities is:
| Index 1 | ||
|---|---|---|
| a | 1 - Produced material | 70 000 KG of the finished product 157142 SD are produced and the total production cost is 6 840 € |
| b | 3 - BOM conponent | 206 000 KG of Raw Materials are used for the production of the finished product with a total cost of 2 650 € |
| c | 5 - Activity type | The cost of activities used for the production is 4 440 €. It is based on the estimated costs of activities |
| d | 7 - Cost Collector Varia | It is the difference between the standard cost of activities and actual costs (=4 190 € - 4 440 €) |
| e | 9 - SKF/direct Posting | It is the detail of activity costs |
- The cost of production (a) = cost of raw materials (b) + cost of activities (standard (c) & variance(d)) = 6 840 € = 2 650 € + 4 440 € - 250 €
- Index 1 = 9 (e) is the detail of activity costs. It is equal to Index 1 = 5 (c) and Index 1 = 7 (d) => 4 440 € - 250 € = 4 190 €
Control data accuracy
The workbook BW_WBK_CO_0024 is used to perform some consistency checks.
Example WP1
The aim is to have the detailed quantities and costs of production of the material 157142 in iMEP
There are 4 columns in the report:
- Finished product code:
- Index 1
- Actual quantities
- Actual Costs
The detail of costs & quantities is:
| Index 1 | ||
|---|---|---|
| a | 1 - Produced material | 35 000 TO of the finished product 81016 SOD are produced and the total production cost is 2 700 k€ |
| b | 3 - BOM conponent | 10 500 TO of Raw Materials are used for the production of the finished product with a total cost of 2 300 k€ |
| c | 5 - Activity type | The cost of activities used for the production is 350 k€. |
| d | 6 - Settlement | It is the production variance. The amount is settled to the P&L to the value field D05/E05/F05 |
- The cost of production (a) = cost of raw materials (b) + cost of activities (c) + variance (d) = 2 700 k€ = 2 300 k€ + 350 € + 50 k€
Workbook Details
5.0 Non-functional Descriptions
5.1 Usability
5.2 Regulatory Compliance
5.3 Security
5.4 Performance
5.5 Reliability
5.6 Scalability
5.7 Compatibility
5.8 Availability
5.9 Refresh of the Data
The loads for this application it's once per daya as we can see below at 6 a.m:
