The aim of this workbook is to validate the quality of the data reported in imep for the sites in PF1.

It can be used when you start working with iMEP queries and confirm that there is no specificity in your production site / GBU that is not taken into account in the imep program.




Access the workbook

The workbook to be used is BW_WBK_CO_0024 - BW - IMEP - PF1 Check of data consistency (Core Workbook) 

=> Go to Analysis for Office in excel 

=> Click "Open Data Source"




Go to the tab "Role" and open the folder IMEP - Integrated Manufacturing & Energy Performance => Manufacturing 

Double-click on the workbook BW_WBK_CO_0024 - BW - IMEP - PF1 Check of data consistency (Core Workbook) to open it



Open the workbook

It is mandatory to enter the period (2) : MMM.YYYY

It is also recommended to enter at least a company code (6) or a plant code (11)

It is also possible to enter:

  • a target currency (3) however it is recommended to perform the test with the local currency
  • a Unit of Measure for the quantity conversion (ex: TO for Tons) (4)
  • a GBU (5)
  • a Cost object (8)
  • an Index 1 (9) 
  • a material code (10)

Click "OK" 



The workbook in detail

There are 7 sheets in the workbook: 



1. DS_6

The aim of the report iMEP is to provide a detail of actual production costs by material/plant. In PF1, the actual production costs by material is calculated with Material Ledger and the total by material/plant can be displayed with the transaction CKM3 - Material Price Analysis.

The purpose of the control (DS_6) is to compare the calculation done by Material Ledger (3) and the one done in iMEP (2) material code by material code (1)

Ex: The actual production costs calculated with Material Ledger (3) gives the same result as iMEP (2). It confirms that the report iMEP is accurate.

(2) = (3)

=> In case of discrepancies, a ticket should be created to get the support of the IS team



2. DS_2

Produced quantity (2) should be equal to Actual quantity (3) 

(1) = (2) - (3)

=> In case of discrepancies, a ticket should be created to get the support of the IS team



3. DS_1

The aim of this control is to ensure that the total productions costs (2) calculated by iMEP is equal to variable costs (3) + fixed costs (4) + depreciation (5).

(1) = (2) - ((3) + (4) + (5))

=> In case of discrepancies, a ticket should be created to get the support of the IS team



4. DS_3

The aim of this control is to ensure that the total productions costs (Index 1 = 1 & 2) (2)(3) calculated by iMEP is equal to the sum of Raw materials (Index 1 = 3) (4) and activities (Index 1 = 5 & 7) (5)(6) costs.

(1) = (2) - ((3) + (4) + (5) + (6))

=> In case of discrepancies, a ticket should be created to get the support of the IS team



5. DS_4

The aim of this control is to ensure that the total activities costs (Index 1 = 5 & 7) (1)(2) calculated by iMEP is equal to the production costs recorded in a cost center  (Index 1 = 9) (4) 

(3) = ((1) + (2)) - (4) 

=> The control is only true when a production cost center is dedicated to the production of a single material.
In the case of multi-materials cost centers, it is not possible to report the index 1 = 9 per material and therefore the control does not work.



6. DS_5



7. Data loading

In this sheet you can find some information regarding the loading of data in iMEP