SQL trace and code

[Former Member]

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?

[Former Member]

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

[Former Member]

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-qui...

Regards

[Former Member]

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

[anilkumar_kalkivai]

Hi Siva,

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

Regards,

Anil.

[former_member209120]

Hi Siva Kumar,

See this link it may help you...

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