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
The best way to get IT support is to use the new
Service One Platform.