Wednesday 19 September 2018

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.

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning


First you can switch on SQL trace via tcode ST05:
SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

And execute the program you want to trace in another SAPGUI window. Once finished, deactivate the trace in ST05.

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

And press this button to display the trace.

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

Use this menu to export the execution plan of a given SQL statement into a local file (.plv ):

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning
SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

Then open it via HANA Studio:

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

Then the execution plan could be displayed in detail as a graph:

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

You can even paste the SQL statement you observed in ST05 into HANA Studio and execute it there:

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

Just open SQL Console, paste the source code and press F8 to execute:

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

No comments:

Post a Comment