New version will be available here soon 😉 I will also have a look on the CL_ABAP_PARSER "problem" but your solution reduce the number of allowed query by 1, so i'm not sure it's a good way in this case.
Best sql editor to connect sap code#
Remove confirmation popup on display code for no select statementĪnd merge theses changes to my local new version which contain some cool features ! Refresh ddic tree when execute query, even if an error occur Adapt the default query to the limits defined for the user
I've scanned the code to find all other différences. There are nice but stay dirty trick, less robust than true dynpro, true table, so i think it's better to keep the actual version regarding this changes.įor information, the function CONVERT_TABLE_TO_STRING you used doesn't exist on my sap system I do not create "copy/paste" program anymore since i've found SAPLINK 🙂īut when i did it, i used the same tricks you used (overwrite the selection-screen, use report variant table.). Lot of things changed ! Very difficult to check the difference as you renamed all objects (variable ok, your naming rules, but why rename subroutine ?) and change order for some objects. ZAUTODOC : Automatic generation of technical BW documentation LISTCUBE replacement : a new way to display dataĪbstraction class to generate MSWORD with SAP using OLE
Best sql editor to connect sap download#
Just copy past the query in the editor and run, you will see in live the result.Īnd there is a direct download link (remember that you will need SAPLINK with table extension to install) : įinal 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) With this tool it become very easy to debug a complex query in production (with lot of join or subqueries for example). You could save your best queries, and also share it to friends.
You can access to DDIC to help you when writing query and use SAP standard help. Result is displayed in an ALV at bottom part of the screen. With ZTOAD, you can write and execute queries, in Open SQL format (the format used in ABAP program). I called it ZTOAD, in reference of a famous query builder in the SQL world.Īs 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…). I want to share with you one of the best program from my toolbox.
0 kommentar(er)
