Hovitaga

Hovitaga OpenSQL Editor Boosting software development and implementation projects One solution for multiple problems Hovitaga OpenSQL Editor is a powerful tool that helps SAP consultants, ABAP developers and basis administrators to work with the database of an SAP system. The OpenSQL Editor provides an intuitive way to build ad-hoc reports with simple OpenSQL commands. The results of the queries are displayed immediately in an ALV Grid or Tree as de- sired and can be easily visualized using charts and diagrams. The results 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, devel- opment speed and code quality can be increased, since all OpenSQL commands can be tested, evaluated and analyzed with the OpenSQL Editor. Benefits Software development time reduced - Writing programs that access the database in any form Boost business analytics – Most business users have the skill of using MS Excel for analyt- becomes much easier since all commands accessing database can be developed, tested, and ana- ics, they just simply need the data from the SAP system extracted. This is just a matter of lyzed with many user-friendly features. Using the report generation feature of the OpenSQL Editor a few clicks with the OpenSQL Editor and your business users can instantly start analyzing can spare hundreds of lines of code for a developer each time. up-to-date business data. Software testing time reduced - Testing database queries is much more simple, conve- Disposable reports eliminated - There is no need to create a new report in the Repository nient and effective with the OpenSQL Editor than to use the ABAP Debugger. each time a report or chart is required. Quick ad-hoc reports, charts - Any requirement of an ad-hoc reporting can be fulfilled Maintenance efforts reduced - Defects can be found earlier with the positive effects on in much shorter time. Many development steps are done automatically, developers don’t testing described above. Moreover, existing programs and data models can be compre- have to hassle with programming the list or tree output, the selection screen, data declara- hended quicker and easier with inspecting the OpenSQL commands and table relations in tion and creation of charts and diagrams. the OpenSQL Editor instead of the ABAP Debugger. Import of data to SAP systems simplified – For sources with a modest amount of records labor and cost savings the OpenSQL Editor offers. (typically stored in Excel sheets and Access databases) the Developer edition of the Open- SQL Editor offers a strikingly simple and intuitive way to import that into an SAP system. Improved code quality - An OpenSQL command can be thoroughly tested with minimal effort opposed to the typical awkward way of executing the given report and using the ABAP Debugger to inspect the result of the relevant commands. Quicker TTM (time to market) – Develop your products faster than your rivals due to the Job satisfaction - Providing a tool that eliminates most of the monotonic and tiring work from your employee’s day to day activities will have a good effect on team morale and gen- eral job satisfaction. Requirements and installation The OpenSQL Editor is entirely written in ABAP, so it is transparent (not a black-box devel- opment) and deeply integrated into the SAP system. No interfaces needed, no platform- dependency, no separate IT team to maintain. It does not expose the SAP system to any access from outside. Installation is a process of few minutes, since it only consists of importing one transport with the TMS (Transport Management System). The only additional effort is to set up the authorizations for the users. Due to the intuitive user interface and extensive documenta- tion no consulting or implementation project is needed. Hovitaga OpenSQL Editor runs on SAP 4.6C but some features require SAP Netweaver 7.00 (aka. 2004s) or above. Support and maintenance We provide two levels of support. Standard support makes our customers eligible to re- ceive regular support packages that contain all corrections and improvements. Customers who choose the premium support will receive every enhancement or correction immedi- ately without having to wait for the new support package to be released. The OpenSQL Editor can be purchased without any support also, if required. Conclusion Time is money. People involved in SAP development and implementation projects as well as business users spend a lot of time on inefficient and repetitive tasks that occur daily dur- ing their work. The OpenSQL Editor makes many of these tasks just a matter of minutes op- posed to hours, sparing much time for its users. Let them spend it on your business instead. To learn more about Hovitaga OpenSQL Editor, visit www.hovitaga.com or send a mail to info@hovitaga.com. Detailed whitepapers and video demonstrations are available on our website. © Copyright Hovitaga Kft. 2009. All rights reserved. SAP is a registered trademark of SAP AG. All other trademarks are the property of their respective owners. Hovitaga Kft. Address: Lajos utca 93-99 F-3-6, 1036 Budapest, Hungary Phone: +36 20 415 6721 www.hovitaga.com

Hovitaga Report Generator Boosting SAP report development processes Executive overview ABAP developers to quickly create simple reports. Only the OpenSQL query has to be built, no further ABAP programming is required. The source code of an ABAP Hovitaga Report Generator is an ABAP add-on that accelerates SAP reporting by program will be generated automatically, along with a transaction code, that significantly reducing development time. This is achieved with automatic ABAP directly executes the report. The generated report can have a selection-screen and code generation, which eliminates manual programming of code that is always it displays the data with an ALV grid or ALV tree. Thanks to the standard look and part of every report but is always different. feel every authorized user can use the report. Depending on the generation settings, 200-1000+ lines of ABAP code can be generated in a few minutes. This can save from a few hours to a day of development time depending on the complexity of the report. Reporting is critical from the perspective of the business, since all business decisions are based on some sort of report. The availability and quality of SAP reports have a great influance on the efficiency of SAP implementations. Creating custom business reports is a key area software developers and consultants spend a lot of time on. Your business can benefit from accelerated ad-hoc reporting with the use of Hovitaga Report Generator. Introduction Are you frequently requested for reports like “how many products does a customer order monthly, aggregated by product type”, “who are the top 20 customers in Bonn and which is their favorite product” or simply “how much do we spend monthly on printing costs”? If so, the Hovitaga Report Generator is the right tool for you! The Report Generator is a powerful software that helps SAP consultants and With the standard functionalities of the ALV grid the list can be easily visualized • You can select from a list which fields would you like to include in the selection using charts and diagrams, and can be exported to MS Excel for further analysis. screen as select-options or selection parameters. This export functionality provides a way to supply business users with live data • You can select which event handler methods of the ALV grid or Tree would you like to implement. from your SAP system for detailed analytics. • Choose a name and a transaction code for the report. • You can specify the package name and the transport request for the new objects with the standard dialogs. Product Highlights The Report Generator is built on the top of the Hovitaga OpenSQL Editor. You not only can generate reports, but you can also instantly test your OpenSQL queries. Any OpenSQL query can be built, checked and executed easily, the result is displayed instantly. User-friendly features help to construct the SELECT commands as comfortably as possible. ABAP reports can be generated based on the OpenSQL queries. The report is created as a standard repository object, it can be assigned to a package and added to a transport request. The entire source code of the report, the type and data declarations, the coding of the ALV display, the definition of the selection screen and the data selection query is automatically generated. This way developers can spare a lot of time when creating new reports! The generated source code is fully compliant with the SAP developer guidelines (naming conventions etc.), it is well commented and readable, allowing developers to easily modify or enhance the report by adding further coding if needed. You no longer need to manually implement the following code, since all these are Features in detail automatically generated with a few clicks: • definition of selection screens Report generation • type declaration • data declaration All you have to do for a new report is to build the OpenSQL query which reads the • programming of the UI (ALV grid or tree) data from the database. The software will guide you thru the rest of the process. • declaration of event handler class and methods • creation of a global structure in the data dictionary or a local structure in the standard SAP report can be generated based on it. The generated report will take over report the field structure of the result set. You can choose which ALV control to use:  Robustness - All syntax variations are accepted, without the use of local variables. Group • class based ALV grid (cl_gui_alv_grid) functions, subqueries (nested to any level), inner and outer joins are all supported. • class based SALV table (cl_salv_table) • class based ALV tree (cl_gui_alv_tree) Linked Query Assistant – A feature that helps to develop commands with inner and • function module based ALV grid (reuse_alv_grid_display_lvc) outer joins. The Linked Query Assistant reads the data dictionary to explore the relations between database tables. With a few clicks, a join or a subquery may be implemented Having all the options above, every developer can find the control that is the most automatically, without typing anything. comfortable for him/her, regardless of age, experience or skill level. Field Selection Wizard – An efficient feature that provides a way to select the fields Execution of OpenSQL queries - One of the most interesting features is that the SQL used in a command without manual typing. It reads the table definition from the Data statement can be executed and the result is displayed immediately. Developers can Dictionary and offers the fields with their descriptions in a list for selection. test and optimize the SQL query for rapid prototyping, and when the query is ready, a Commands can be organized into folders within the My Repository - Command properties may be set for each command (short and long description, link to Business Object or Application Component, search terms..). Commands can be searched by any of these properties. Hovitaga Report Generator runs on SAP 4.6C but some features require SAP Benefits Netweaver 7.00 (aka. 2004s) or above. The benefits of Hovitaga Report Generator are affecting both the technical people Support and maintenance and the business people. The business can benefit from a quicker ad-hoc reporting process. The average time to develop an SAP report will be drastically reduced. The We provide two levels of support. Standard support makes our customers eligible sooner the ad-hoc reports are available, the better the business runs. to receive regular support packages that contain all corrections and improvements. Customers who choose the premium support will receive every enhancement or Technical people will also benefit from using the product. ABAP developers and correction immediately without having to wait for the new support package to SAP consultants don’t have to waste time and effort on monotonous work arising be released. The Report Generator can be purchased without any support also, if every time, but can concentrate on the business logic of the reports that they develop. required. As a summary, SAP IT costs can be significantly lowered due to reduction of development time needed to create SAP reports.