topic Re: SQL Trace in Application Development and Automation Discussions

SQL Trace

Former Member — Fri, 14 Jul 2006 05:30:07 GMT

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

Re: SQL Trace

Former Member — Fri, 14 Jul 2006 05:34:09 GMT

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

Re: SQL Trace

dani_mn — Fri, 14 Jul 2006 05:34:36 GMT

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

Re: SQL Trace

Laxmana_Appana_ — Fri, 14 Jul 2006 05:34:45 GMT

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

Re: SQL Trace

Former Member — Fri, 14 Jul 2006 05:35:46 GMT

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

Re: SQL Trace

Former Member — Fri, 14 Jul 2006 05:36:02 GMT

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

Re: SQL Trace

Former Member — Fri, 14 Jul 2006 05:40:17 GMT

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.

Re: SQL Trace

Former Member — Fri, 14 Jul 2006 06:50:44 GMT

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.