topic is there a tool to view SQL statement execution result? in Application Development and Automation Discussions

is there a tool to view SQL statement execution result?

Former Member — Fri, 21 Mar 2008 08:24:45 GMT

hi experts,

is there a tool to view SQL statement execution result? suppose i type 'select * into wa_bseg from bseg up to 10',and the tool will return the result to me.

hunger for ur advice and thanks a lot!

Re: is there a tool to view SQL statement execution result?

Former Member — Fri, 21 Mar 2008 08:26:56 GMT

hi ,

goto the tcode st05...

this will give the performance over the select statements..

regards,

venkat.

Re: is there a tool to view SQL statement execution result?

Former Member — Fri, 21 Mar 2008 08:28:53 GMT

Hi liu,

You can check that at runtime while debugging

all you have to do is provide a breakpoint at your select statement and then provide the table name in your debugging tool.

you will get all the data.

Regards,

Abhinay

Re: is there a tool to view SQL statement execution result?

Former Member — Fri, 21 Mar 2008 08:40:46 GMT

Hi Liu.

Sure you can by usisg ABAP Debuger to view your SQL statement execution result.

REPORT ztest.

data: it_bseg type TABLE OF bseg WITH HEADER LINE.

start-OF-SELECTION.

BREAK-POINT. "it will be switched to debug mode

SELECT * into TABLE it_bseg

FROM bseg UP TO 10 ROWS.

LOOP at it_bseg.

write:/1 it_bseg-belnr.

ENDLOOP.

After you execute program it will be switched to debug mode and you can view your your SQL statement execution result.

Hope it help.

Sayan.