Hovitaga OpenSQL Editor is a powerful tool for SAP consultants, ABAP developers and basis administrators that helps to work with the database of an SAP system.
- It provides an intuitive way to build ad-hoc reports and statistics with OpenSQL commands.
- The results of the queries can be easily visualized using charts and diagrams, and can be exported to MS Excel for further analysis.
- Importing data from external sources like MS Access or MS Excel can be done with a few clicks.
- Testing and code maintenance efforts can be greatly reduced, development speed and code quality can be increased, since all OpenSQL commands can be tested, evaluated and analyzed with Hovitaga OpenSQL Editor.
We have developed our OpenSQL Editor primarily for the traditional SAP Gui, but it can be used with the use of WebGUI (SAP Gui for HTML) if the ITS (Internet Transaction Server) is configured properly. Some functions cannot be used from WebGUI (creating charts for example).
Security and authorizations
Our OpenSQL Editor uses the standard SAP autohrizations for accessing database tables and also uses custom authorization objects to restrict features available for users. We provide ready-to-use roles to reduce implementation efforts.
The Query Engine
A robust OpenSQL parser is the base of our query engine that is capable of executing any valid OpenSQL statement depending on the authorizations set for the user. All syntax variants are supported except for a few ones that are not relevant ("SELECT FOR UPDATE" is not supported for example, since we have our own locking mechanism).
The Data Modification Engine
If a query fulfills certain conditions (uses one table and includes all key fields), the result set of queries is editable. Simply use the ALV grid that displays the query results to edit the result set. Changes can be saved to the database with a single click of a button. Mass update and delete commands are also supported, which is a convenient way do manipulate large sets of data.
The Data Modification Engine can be transported separately to each SAP system, so it is possible to set up a read-only version in the productive system while having a fully functional version in the development and test systems.
A strict locking concept ensures that the database remains consistent even in case of concurrent accesses to the same database record. The locking mechanism not only works between multiple instances of Hovitaga OpenSQL Editor but it protects records processed with standard SAP transactions also.
Import and export of data
The result set of any query can be exported to several formats including MS Excel, HTML or flat files (tab separated or CSV). Any data can be imported from the clipboard into the ALV grid in change mode, all records can be verified (data format, foreign key and checktable relations etc) before saving them to the database. Field mapping is quick and easy with the use of the Field Selection Wizard and/or by simply using draging and dropping the columns.