SQL QUERY IN ABAP

[aneel_munawar]

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

[Former Member]

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

[aneel_munawar]

Dear Sudeesh,

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

[Former Member]

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

[aneel_munawar]

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.