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.
Access the workbook
The workbook to be used is BW_WBK_CO_0026 - BW - IMEP - PF1 ML synthesis (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_0026 - BW - IMEP - PF1 ML synthesis (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 GBU (5), a company code (6) or a plant code (9)
It is also possible to enter:
- a target currency (3) to have all values converted with the same currency
- a Unit of Measure for the quantity conversion (ex: TO for Tons) (4)
- a Cost object (7)
- a material code (8)
Click "OK"
The report
The report is displayed with the list of raw materials and the detail of stock movements
There are 20 columns in the report for amounts (blue) and quantities (green)
- Inventory at the beginning of the period entered in the prompt
- Production of the material during the period
- Other receipts such as purchases
- Consumption of the material in production
- Sales
- Other consumption such as transfer to another plant
- Other movements of inventory
- Ending inventory
- Delta is the difference between the beginning and the ending inventory
- Control that the difference between the beginning inventory and the ending inventory corresponds to the sum of all inventory movements. It should be equal to zero.
This detail corresponds to the detail available in the transaction CKM3 - Material Price Analysis in PF1 by material code
- IMEP - Characteristics — List of Characteristics & Measures available in the BW application iMEP with the link to more detailed documentation when it exists.
- IMEP - 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.
- IMEP - PF1 Manuf. Local database — This workbook gives a transversal and consolidated view of manufacturing costs (from sites to GBU level) for all plants managed in PF1.
- IMEP - WP1 Manuf. Local database — This workbook gives a transversal and consolidated view of manufacturing costs (from sites to GBU level) for all plants managed in WP1.
- IMEP - PF1 Check of data consistency — The aim of this workbook is to validate the quality of the data reported in imep for the sites in PF1.
- IMEP - PF1 ML synthesis — 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.
The best way to get IT support is to use the new
Service One Platform.