Process Chain Run-time Analysis
Hello BW experts,
I'm a BW guy and I am tasked to make a program that will compute the average run time of every active process chain. Active I mean still being used and running on a regular basis. After computing for the average run time, it will be stored into a 'Z' table together with the other details of the chain. Then another program will be scheduled to run periodically to check if the chains are not running too long compared to the computed average run time of the first program.
But first things first, I want to know the best way to compute for the average run time of every active chain on our system. I've read about the RSPCPROCESSLOG table and found out that I could get the start and end timestamp there for every chain variant. It seems simple in theory because you would just subtract those timestamps and add all the results for the variants and then you could get the runtime of that specific run. But I am looking for an API that could actually do that for me.
Could you suggest some APIs that are actually intended to do this kind of job? Or is there any other approach that you know for doing this?
Any suggestion would be much appreciated. I'm willing to study everything that I need to just to finish this because again, I'm a BW guy and have a little knowledge on ABAP.