Ever heard of norm time per operation? If you did, then you don’t have to read further, for those who didn’t please continue.
Last week a business user asked me if it was possible to calculate the norm time per operation on a production order and to add this Key Performance Indicator to an existing BW report. I actually never heard of this KPI. Nonetheless the formula behind it is pretty easy.
So with this formula in mind my journey began in the SAP ECC source system. Via transaction CO03 I went to a production order and went to an individual operation. Per operation you are able to consult the standard values and the base quantity. The base quantity is straightforward and can be easily extracted via table AFVV.
Extracting standard values is a little bit more complicated, due to the fact that these are attached to a specific work center via a formula parameter. There are multiple standard values available like labor, setup & machine time. For our norm time KPI we are only interested in the machine time.