topic Re: SQL QUERY IN ABAP in Application Development and Automation Discussions

SQL QUERY IN ABAP

aneel_munawar — Sat, 24 May 2014 12:44:53 GMT

Dear ABAP Experts,

Is there any possibility to see the SQL statement for the query which are designed by the SQVI queries.?

Like SQL Server, we design the query in query designer and sql statements are also shown in it .

Regards,

Aneel

Re: SQL QUERY IN ABAP

Former Member — Sat, 24 May 2014 17:57:29 GMT

Hi Aneel,

You have option to generate SQVI query program.

Quickview -> Additional functions -> Generate Program

View the generated program to see SQL Statement.

Regards,

Sudeesh Soni

Re: SQL QUERY IN ABAP

aneel_munawar — Sun, 25 May 2014 05:01:56 GMT

Dear Sudeesh,

Is there any tool which can be used to design the queries like sql server query designer.?

Re: SQL QUERY IN ABAP

Former Member — Sun, 25 May 2014 06:44:46 GMT

Hi Aneel,

Sorry, i am unable to understand what you want to achieve. It will be helpful if you explain the requirement completely.

You can use SQVI query to design queries like SQL Server query.

Regards,

Sudeesh Soni

Re: SQL QUERY IN ABAP

aneel_munawar — Sun, 25 May 2014 15:17:12 GMT

Yes we can design but to get the sql query we have to generate the report and then get the sql statement from that report.

But I want to get only sql statement immediately. If you have used the MS sql server , It gives sql statements under the query designer in the same window. I mean you can design the quuery and as well as write the sql statements in the same window.