ABAP Runtime Analysis of Transformations & DTPs
We develop various ABAP Programs, Customized T-codes and Function Modules in our projects as per our requirements. To fine tune our developments, we have to check “What are the Runtimes of our ABAP Programs, Customized T-codes and Customized Function Modules?”
SAP has given us a nice t-code SE30 for this purpose. You can check the runtimes of Standard (ABAP programs, T-codes and FMs)
This blog is not to test the data volume handling through transformation and DTPs. Because data volume is not fixed, today you do some analysis by based on some amount of volume and you arrive some figures in the statistics from SE30. But the data load may increase/decrease.in future. So then today’s analysis will be invalidated. That’s exactly I have proposed to test the ABAP coding part only before loading data through transformations/DTPs.
I am going to demonstrate How to do Runtime Analysis of Transformations and DTPs.. in this blog.
Step 1: Go to the Transformation —> Extras from the top menu —> Display Generated Program, then you see the screen like below.
Step 2 : Copy the technical name(whole string) of the generated report
Step 3 : Go to SE30 t-code and paste it in Program text box and press execute like below
This will calculate Runtimes in three categories. You can check them by pressing Evaluate button in above screen shot.
Finally you can make a note of various Runtimes by observing the below screen.
Result : The above Program has spent majority of time in ABAP(Presentation), 11.5% at Database level(Datsbase Systems like MSSQL, Oracle etc) and 7.7% at System level(Application)
Similarly, you can copy the string from DTP–>Extras–>Generated Program Filter and check the runtimes by following above steps
Note : Suppose you are analyzing some FM / t-code, when you press Execute as per Step 3, you will literally get into the execution of that FM / t-code and you see the result–>Then you need to press Back button on top to reach SE30 screen –>You will see Runtime Analysis of so and so FM / t-code has been finished on the Status bar at bottom of the screen. Finally you can click on Evaluation button to see various runtimes