topic SQL statement from ST05 in Application Development and Automation Discussions

SQL statement from ST05

Former Member — Mon, 08 Feb 2010 07:31:50 GMT

Hi All,

Please let me know how to retrieve the SQL statement from ST05 output or how to know what is the field

browsed and what was the input in SE16 from ST05.

Thank you.

With Regards,

Gandhi Subramani

Re: SQL statement from ST05

Former Member — Mon, 08 Feb 2010 08:04:49 GMT

Hi,

Go to ST05.

(1)- Activate Trace.

(2)- Run the desired T-Code for which you want to do the SQl Trace.

(3)- Go to "ST05" and deactivate Trace.

(4)- Then Press Display Trace.

(5)- Then POP will come. Just press Execute.

(6)- Your SQL trace will be displayed, with the table names and the Field names and the logic which is retevering data from specific table.

Thanks

Saurabh

Re: SQL statement from ST05

Former Member — Mon, 08 Feb 2010 18:41:12 GMT

Hi Saurabh,

Thank you for your reply. I'am looking for a function module or program to retrieve the ST05 output.

With Regards,

Gandhi Subramani

Re: SQL statement from ST05

vinod_vemuru2 — Mon, 08 Feb 2010 19:44:14 GMT

Hi,

I think ST05 trace output is stored some where in application server file. Identify the path(Depends on system to system) and use OPEN DATASET, READ DATASET and CLOSE DATASET statements.

thanks,

Vinod.

Re: SQL statement from ST05

Former Member — Mon, 08 Feb 2010 20:02:10 GMT

Check the FMs in group SSQ0. One (or more) of them should get you what you need.

Rob

Re: SQL statement from ST05

Former Member — Mon, 08 Feb 2010 21:24:08 GMT

Hi Rob,

Thank you. I was using function module 'SQLT_GEN_TRACE_RECORDS_NEW' but the output was not like what we see in ST05 output. Output needs to be formatted to get a SQL statement. Whether there is any other function module which gives us a full SQL statement ?

With Regards,

Gandhi Subramani

Re: SQL statement from ST05

Former Member — Mon, 08 Feb 2010 21:47:37 GMT

As I said, the FMs in that group should help, but you may have too do a fair amount of debugging to get exactly what you need.

Rob