topic Re: Checking of SQL Query Result in Application Development and Automation Discussions

Checking of SQL Query Result

Former Member — Thu, 30 Nov 2006 15:04:10 GMT

Hi All,

How can i view result of SQL query in SAP-ABAP. Actually I want to see result of following query :

select * from ZMSTKCALC where werks_d <> werks_main.

I am new to SAP territory.

Thanks in advance for your help.

Re: Checking of SQL Query Result

Former Member — Thu, 30 Nov 2006 15:06:32 GMT

Hi,

Put a Break point there, or write a statment before that query BREAK-POINT, and execute that, you will go into the Debugging mode, there double click that tabel ZMSTKCALC , you will see the result

Regards

Sudheer

Re: Checking of SQL Query Result

Former Member — Thu, 30 Nov 2006 15:06:51 GMT

hi yogesh ,

welcome to SDN.

for this

data : begin of itab occurs 0,

include structure ZMSTKCALC .

end of itab.

select * from ZMSTKCALC into table itab where werks_d <> werks_main.

loop at itab.

write:/ itab. "--for outout

endloop.

collect the data into itab .

regards,

vijay

Re: Checking of SQL Query Result

venkata_ramisetti — Thu, 30 Nov 2006 15:08:06 GMT

Hi Yogesh,

Welcome to the SDN world!!!

You have to use WRITE statement to see the result of the SQL query.

The result of the SQL query need to be stored in a work area.

For example:

data: T_ZMSTKCALC LIKE ZMSTKCALC occurs 0 with header line.

select * from ZMSTKCALC into table T_ZMSTKCALC where werks <> werks_main.

loop at T_ZMSTKCALC.

write:/ T_ZMSTKCALC-FIELD1,

T_ZMSTKCALC-FIELD2.

endloop.

Thanks

Ramakrishna

Re: Checking of SQL Query Result

Former Member — Thu, 30 Nov 2006 15:10:49 GMT

Thanks Sudhir for Reply...

Is there any other way? I mean the way one can execute Query on ORACLE - SQL Prompt.

Using Transaction - SQ01 or SQvi or zx02.

Thanks

Re: Checking of SQL Query Result

Former Member — Thu, 30 Nov 2006 15:12:33 GMT

Thanks for Reply...

Is there any other way? I mean the way one can execute Query on ORACLE - SQL Prompt.

Using Transaction - SQ01 or SQvi or zx02.

Please note that i can not write program in Production environment. I mean not alllowed.

Thanks