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.
You can reach it by right click your project
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 […]