OpenSQL query testing tool

[Former Member]

Hi,

I am looking for a simple tool that I can type in a sql query and then run the query. It would be nice if it can be like MS Access that you can switch between design view and SQL view - using design view to contruct the query and switch to SQL view so you can copy the SQL statement to the ABAP program.

So far the only thing I found is SQL Query Tool (t-code SQ01), but it's more a reporting tool than a query testing tool.

Please advise. Thanks,

Jack

[Former Member]

Actually...You can do your own tool...Check this blog -:) It will give you a couple of ideas -;)

[Dynamic Inner Join Function Module|https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/5262] [original link is broken] [original link is broken] [original link is broken];

Greetings,

Blag.