test your SQL statement before using it in your ABAP program

test your SQL statement before using it in your ABAP program
Rate this post

For a long time i thought that there is a missing SQL console feature integrated in SAP functionality. With ABAP 7.4 and usage of Eclipse as IDE, SAP succeded to fulfill this gap with new Eclipse SQL Console. Actually before this feature, there was a similar feature that we could use for the same aim. Therefore i wanted to write down both options so that you can pick one of the suitable one for you.

The advantage of SQL Console is you can write complex sql statements including inner join,left outer join, subqueries etc.

Eclipse
SQL Console
You can reach it by right click your project


SAP GUI
SQL Command Editor
DBACOKCPIT transaction -> Performance tab -> Additional Functions -> SQL Command Editor

You may also like