Application Development Blog Posts
Learn and share on deeper, cross technology development topics such as integration and connectivity, automation, cloud extensibility, developing at scale, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member217925
Active Participant
29,652


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.

http://quelquepart.biz/data/images/ztoad/ztoad.png

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.

And there is a direct download link (remember that you will need SAPLINK with table extension to install) :

Download link : https://www.mediafire.com/folder/if3ljcnesme7y/ABAP

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 :smile:




My others blogpost :

ZAL11 : a replacement for AL11

LISTCUBE replacement : a new way to display data

Abstraction class to generate MSWORD with SAP using OLE

Generate DOCX file in ABAP

ZAUTODOC : Automatic generation of technical BW documentation

119 Comments
Labels in this area