This website is not affiliated with, sponsored by, or approved by SAP AG.

ZTOAD - Open SQL editor

Development (ABAP Development WorkBench, ABAP/4 programming)

Moderators: Snowy, thx4allthefish, YuriT, Gothmog

ZTOAD - Open SQL editor

Postby quelquepart » Mon Aug 03, 2015 8:17 am

Hi everybody,

I want to share with you one of the best program from my toolbox. I called it ZTOAD, in reference of a famous query builder in the SQL world.

As you know, SAP don't give to developper tools to execute query (there is a crappy tool for admin, and some function modules for devs, but not so usable...).

So i took my keeboard and made my own...

With ZTOAD, you can write and execute queries, in Open SQL format (the format used in ABAP program). Result is displayed in an ALV at bottom part of the screen. You can access to DDIC to help you when writing query and use SAP standard help.

You could save your best queries, and also share it to friends.

Image

With this tool it become very easy to debug a complex query in production (with lot of join or subqueries for example). Just copy past the query in the editor and run, you will see in live the result.

French presentation can be found here : http://quelquepart.biz/article7/ztoad-requeteur-open-sql

And there is a direct download link (remember that you will need SAPLINK with table extension to install) : http://quelquepart.biz/telechargements&file=L2RhdGEvZG9jdW1lbnRzL3p0b2FkLnppcCozZThiNjE,&source=sapfans-ZTOAD

Final bonus: If ZSPRO is also installed, ZTOAD will get tables listed in ZSPRO repository and display it in a tree under DDIC tree (to help you to create queries)

Feel free to comment here :)
http://quelquepart.biz
quelquepart
 
Posts: 18
Joined: Wed Feb 22, 2012 6:02 am
Location: France

Return to ABAP

Who is online

Users browsing this forum: No registered users and 14 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.