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

  • create dynamic table (0)
    Field symbols is hard to understand for beginners in ABAP. But when you get used to it , it is very handy and easy to use. You can create an internal table as a dynamic dictionary […]
  • add large number of requests to another system queue (0)
    As you may know if you have configured SAP system routes in STMS correctly and requests are given the correct target system (either Target system or Target group), then each released […]
  • rerun ABAP report with auto generated SM37 variant (0)
    After i have analyzed a background job's attributes in SM37, i discovered that there is ABAP report and variant of the report in step data.