Precise SAP Table/Function Module for Process Chain Runtime Analysis?

[Former Member]

Hello Experts,

My Requirement needs an ABAP Code to read Process Chain runtimes automatically.

So, i m looking for a SAP table or a Function Module which can provide this information.

Please Note, I have already tried the table RSPCPROCESSLOG and Function Module - RSPC_RUNTIME_ANALYSIS where if we pass the PC log ID, we can get the Start and End Time Stamps. But, these are hard to read and my ABAP code would need additional coding to read this.

Also, in the FM - RSPC_RUNTIME_ANALYSIS, we have a column "Duration" that can provide the runtime in Seconds, but when i add up all the individual "duration" for each process to get the final runtime, it doesnt match with the Runtime, that we see in SA38/ST13, Process Chain Runtime Analysis.

So, Is there any other table or Function module that can give the accurate runtime as seen in SA38 or ST13?

Thanks in Advance.

Cheers

Shiva

[former_member197660]

Hello Shiva

This can be achieved by installing and using BI content delivered by SAP for data load statistics.

Technical content provides you the options to analyse following data:

1) Process Chain Statistics ie. data flow for Multiprovider: 0TCT_MC21

2) DTP Statistics ie. data flow for Multiprovider: 0TCT_MC22

3) Infopackage Statistics ie. data flow for Multiprovider: 0TCT_MC22

It does provide a big range of characteristics to analyse the statistical data in required meaningful manner.

After activating the content automate the data load using process chains and set the queries over broadcaster to get automated periodic update for your data load status.

Regards

Ashish 

[MGrob]

Hi

Have you checked RSPCM?

hope that helps

Martin

[Former Member]

Hi Martin,

Yes, I checked RSPCM too. RSPCM is similar to transaction ST13 and does not have Process Chain End Date or End Time or Runtime details. So, i m still looking for a table which has this information, other than RSPCPROCESSLOG because, RSPCPROCESSLOG only has this info in the form of time stamps which need additional ABAP conversion.

Cheers

Shiva

[RamanKorrapati]

Hi,

there is no best table other than RSPCPROCESSLOG. Even this table also will have the start and end dates/time of particular process step wise only not whole process chain wise.

Other than table or FM, There are standard info cube which holds process chain stastics - 0TCT_C22.

Thanks

[MGrob]

7.31 provides you with a lot more detail in RSPCM, runtime statistics, average runtime deviation, end times and delayed start times. It might also be introduced in lower bw version with a support package

[Former Member]

Thanks Again.

But, RSPCM is a transaction where i will be able to check the details manually.

Is there a way, i can get this information read by an ABAP Code?, like from any SAP Table or SAP Function Module ?

Cheers

Shiva

[RamanKorrapati]

Hi Shiva,

This is the backend program for RSPCM, program - RSPC_MONITOR.

if your familiar with abap, check that program. might be useful to know the tables.

Thanks

[Former Member]

You can use the FM RSPC_GET_DEVIATION to get the runtime stats.

Br, H

[Former Member]

Hi Harish,

It says,

Function module RSPC_GET_DEVIATION does not exist

Message no. FL046

Cheers

Shiva

[Former Member]

which version of BW you're in?

Mine is 7.4 and I can get the details using the above FM.

Br, H

[former_member215240]

Hi Shiva,

Did u find sloution for it. I have the same requiremnt.

Thanks

Santhosh

[Former Member]

Hi Santhosh,

I wasn't able to find a better table or Function Module than Table - RSPCPROCESSLOG or Function Module - RSPC_RUNTIME_ANALYSIS in BW versions below 7.4.

I had to use the RSPCPROCESSLOG for my ABAP program to read the Start and End Time stamps for each process and add them up to get the Total Runtime of Process Chain.

Note, this total value can differ from the values in SA38/ST13 Runtime Analysis, but this difference did not affect my development/output much.

Cheers

Shiva

[former_member209728]

Hi Shiva,

Hope you remember 🙂

I could see the FM RSPC_GET_DEVIATION in my system under the function group RSPC_BACKEND but it's attributes says that it is Not Released. This means SAP may change it or even remove it without any warning.

However the code in this FM is fairly simple and it just gives you deviations from the average run times for a process chain based on the rspcprocesslog table. You can achieve this with your ABAP code as well.

Thanks,

Kush

[Former Member]

Hello Kush,

Ha Ha, Yeah, I remember. How are you?

Yes, it seems, the availability of this Function Module depends on the BW Version and Service Pack. I was able to find the Function Group in SE80, but, it doesn't have the mentioned FM in my system version.

But, Anyway, thanks for your reply. I was able to use the RSPCPROCESSLOG table to derive a logic for the code.

Cheers

Shiva

[Former Member]

Hi Shiva,

     You can also debug program /SSA/BWT. It will help you to understand what ST13 does internally so that you can write your approach same way.

[Former Member]

Hi Yogesh,

Thanks for your reply.

Yes, i tried to debug the /SSA/BWT program to check which tables it refers to and it seems, it refers to RSPCPROCESSLOG which, i had mentioned earlier in my question.

So, i guess, i have no other option, other than, use the same table and write ABAP code to read the Start and End Time Stamps.

But, Thanks again for your reply.

Cheers

Shiva