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.
Like the base quantity these standard values can also be found in SAP table AFVV. Column VGW01 till VGW06 represent the six different standard values which can be used in a formula parameter. The only lack this table has, is the absence of the standard value type. Without knowing the type it is pretty useless (we are only interested in the standard value of the machine).
Now the magic comes! With the use of table AFVV the determination of the type can be done by joining the following tables:
- AFRU.AUFNR with AFVV.AUFNR (AUFNR is equal to the production order)
- AFVV.AUFPL with AFVC.VGWTS
- AFVC.VGWTS with TC21.VGWTS
Then in table TC21 you will have a reference for every standard value available the given formula. In this case it is necessary to loop over every value and determine the type. Determing the type can be done by joining for e.g. TC21.PAR01 (this it the first standard value) with TC20.PARID. This last table (TC20) contains the attribute values of the formula parameter. Refer to the attached document to see the join visualized.
With all this information I was able to enhance the current BW dataflow with the KPI norm time per operation. Resulting in another happy end user!