Skip to Content
Author's profile photo JAI GUPTA

ABAP Code to find routine stastics in transformation in SAP BW

Business Scenario:

In one of my earlier document ‘How to find Top 10 routines in SAP BW system taking maximum time during data loading’ at link
http://scn.sap.com/docs/DOC-32859 I explained the strategy using which we can find the top 10 routines in BW system. Now in this document I have written an ABAP code to automate that strategy in BW.

Introduction:

In this tool, we would fetch the total run time taken during a data load and then time taken by a routine. After that, we will divide these two times and present it in the form of percentage time taken by routine as compared to total data load time.

In this output, we will have the statistics related to all the routines written in the BW system. Here we will be able to see the total run time of a data load alongside time taken by a routine and their respective percentage. Based on this data we can find the routine having maximum percentage and optimize them.

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      It's very useful

      thank u!

      regards,

      scott

      Author's profile photo Demyanov Alexey
      Demyanov Alexey

      the code is missing, please fix it

      C%3A%5CUsers%5Cq7w7e%5CPictures%5CScreenpresso%5C2021-08-10_11h17_26.png