Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SQL Trace

Former Member
0 Likes
678

Hi Frendz,

i want to know how to do SQL Trace for a Particular Transaction Code, for ex xk03.

Points for sure

Thanks in Advance

Kumar

1 ACCEPTED SOLUTION
Read only

Laxmana_Appana_
Active Contributor
0 Likes
649

Hi,

Go to ST05 and select the SQL trace on and then come to the trasaction XK03 and do the necessary operations ,after completion of the work with transaction , then goto SQL trace and stop the trace and view the trace.

Regards

Appana

7 REPLIES 7
Read only

Former Member
0 Likes
649

Hi,

Goto transaction ST05. Press TRACE ON.

Execute your transaction .

Come back to this screen and click TRACE OFF.

Then check the trace details.

Best regards,

Prashant

Read only

dani_mn
Active Contributor
0 Likes
649

Hi,

GO TO 'ST05'

and click on 'TRACE ON'.

then go back to your transaction and perform the steps you are willing.

now come back to 'STO5'. and set 'trace off'. then click on 'LIST TRACE'

you have the trace for you

REgards,

Wasim Ahmed

Read only

Laxmana_Appana_
Active Contributor
0 Likes
650

Hi,

Go to ST05 and select the SQL trace on and then come to the trasaction XK03 and do the necessary operations ,after completion of the work with transaction , then goto SQL trace and stop the trace and view the trace.

Regards

Appana

Read only

0 Likes
649

Use the ST05 transaction.

click on the trace on.

then goto ur transaction and do the steps u normally do.

After that Off the trace.

and then display the trace.

There u can able to see many fields and their tables.

Now u search for ur field and which table it is getting updated.

May be the same dataelement will be as other name also.

Just check patiently...

Read only

0 Likes
649

The information http://cma.zdnet.com/book/abap/ch05/ch05.htm

It has some information on the SQL trace function, however, the first 2 people who responded seemed to get it right on the money.

Read only

Former Member
0 Likes
649

Hi,

Goto ST05 -> ACTIVATE TRACE(this will activate trace for your user id) -> then run your transaction ex xk03 -> then again to to ST05 and DEACTIVATE TRACE -> Then DISPLAY TRACE

This will give the Transaction you have run and its details.

Thanks and Regards,

Bharat Kumar Reddy.V

Read only

Former Member
0 Likes
649

Hi,

Have a look at this good link-

http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

Mark useful answers.

Regards,

Tanuja.