topic Re: SQL trace and code in Application Development and Automation Discussions

SQL trace and code

Former Member — Tue, 16 Jul 2013 03:53:04 GMT

hi, in ST05, I can find the SQL statement, may I know how to know the corresponding line of code in the original program in SE38?

Re: SQL trace and code

Former Member — Tue, 16 Jul 2013 04:05:56 GMT

Hi Siva,

There is a button by the name Display Call positions in ABAP Programs (F5) in the toolbar. Place the cursor on a SELECT statement, click on that button and it will take you to the ABAP program where the query has been written.

Hope this helps,

~Athreya

Re: SQL trace and code

Former Member — Tue, 16 Jul 2013 04:06:27 GMT

Hi Siva,

When you go in the detail list it shows you the name of the program you can find it from there with CTRL + F in the program.

For more details on ST05.

http://scn.sap.com/community/abap/testing-and-troubleshooting/blog/2007/09/05/the-sql-trace-st05-quick-and-easy

Regards

Re: SQL trace and code

Former Member — Tue, 16 Jul 2013 04:16:02 GMT

Hi Siva,

Follow the below mentioned steps :

Go to ST05 & Click "Display Trace".
Execute the "Display Performance Trace" Report with your selection criteria.
Trace will be shown in ALV & third column indicates the "Program Name".

Either you can sort the "Program name" column or filter the column by your respective program name.

So we can see corresponding line of code related to DB statements in the original program.

PFA for you refernece.

Regards,

Prasanna

Re: SQL trace and code

anilkumar_kalkivai — Tue, 16 Jul 2013 06:32:31 GMT

Hi Siva,

If you want analyze the program performance better try in SE30 Tcode.

Regards,

Anil.

Re: SQL trace and code

former_member209120 — Tue, 16 Jul 2013 06:47:28 GMT

Hi Siva Kumar,

See this link it may help you...

http://help.sap.com/saphelp_erp60_sp/helpdata/EN/17/358df9c9fee2469105731e10756921/content.htm