test your SQL statement before using it in your ABAP program

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.

SQL Console
You can reach it by right click your project

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

You may also like