Skip to Content
Author's profile photo Jerry Wang

How to import the ST05 trace file into HANA Studio and display as a graph

Some ABAPers might have already noticed this button “Graphical Explain” in tcode ST05 but do not know how to use it properly.
First you can switch on SQL trace via tcode ST05:
And execute the program you want to trace in another SAPGUI window. Once finished, deactivate the trace in ST05.
And press this button to display the trace.
Use this menu to export the execution plan of a given SQL statement into a local file (.plv ):
Then open it via HANA Studio:
Then the execution plan could be displayed in detail as a graph:
You can even paste the SQL statement you observed in ST05 into HANA Studio and execute it there:
Just open SQL Console, paste the source code and press F8 to execute:

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Lars Breddemann
      Lars Breddemann

      There is that saying that "imitation is the nicest form of flattery", so I feel flattered that you liked my blog post (Quick note on Plan Visualization in NetWeaver) from 2013 that much, that you basically re-published it.


      Author's profile photo Jerry Wang
      Jerry Wang
      Blog Post Author

      Hi  Lars,

      Oh my god! I never remembered that I had read your blog in year 2013 🙁 Recently I was assigned with a performance tuning project so I start to learn HANA Studio a little bit, and wrote what I have learned daily into this blog.

      Since there is already comment on this blog, it is not possible for me to delete it. I notice that you are community moderator, do you have enough authorization to delete this blog? If so, would you please kindly do me a favor to remove it?

      Sorry for inconvenience caused and thanks a lot for your help!

      Best regards,


      Author's profile photo Lars Breddemann
      Lars Breddemann

      Hi Jerry

      there's not a problem here! Your blog post should definitively stay online.

      It is pretty clear that you didn't mean to copy my blog and sell it as yours.

      So, all good mate! How about you share some of your experiences from the performance tuning project you mentioned?