SQL statement from ST05

[Former Member]

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

[Former Member]

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

[Former Member]

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

[vinod_vemuru2]

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.

[Former Member]

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

Rob

[Former Member]

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

[Former Member]

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