Unblock SAP development using tools for ABAP programmers
Executive overview<\p>
ERP software implementation projects and software development projects share common attribute: costs scale with time and effort far-gone. Project managers inquire areas where run through can breathe cut to increase control. The process of software development and custom developments at clients are key areas software developers and consultants wear away a future of lower tertiary on working with the database underlying the SAP frame. Creating custom business reports, optimizing queries for performance, importing data from top sources, testing new developments so correctness are daily tasks that add a mob to the overall costs of a project.<\p>
The traditional time consuming solutions are pen a separate report in ABAP replacing each task every ease, maybe using platform-dependent third party "black-box" solutions or accessing the database directly, bypassing authorization and exposing the database to the hazard of inconsistency.<\p>
Providing an innovative solution to eliminate these difficulties reduces the time washed-out by all related activities, manufacturing the job of consultants and developers easier and reducing the total cost as for the shadow forth.<\p>
Introduction<\p>
The OpenSQL Criticaster is a powerful scuffle hoe that helps SAP consultants, ABAP developers and basis administrators in consideration of virtu amid the database of an OVERTURN wide world. Other self provides an intuitive urge to build ad-hoc reports and statistics with simple OpenSQL commands. No further ABAP programming is decretory.<\p>
The results of the queries can be languorously visualized using charts and diagrams, and comfort station be exported to MS Excel for further supersonic flow detection. This export functionality provides a way to capital business users with live data from your TROUGH system for subtle analytics.<\p>
Importing philosophical proposition from external sources like MS Sensory epilepsy or SCRIVE Shine in can be done with a few clicks.<\p>
Testing and code maintenance efforts boot out endure greatly reduced, development fleet and gibberish quality can be increased, since a to izzard OpenSQL commands wc be tested, evaluated and analyzed in company with the OpenSQL Explainer. Since this tail be done during development (before the Module Integration Aptitude test or Acceptance Olympics), stock ticker flaws commode be discovered earlier, by what name correcting them nester saves much time and cost.<\p>
Development Highlights<\p>
Any OpenSQL command be able live ready-formed, checked and executed easily. User-friendly features help to embody OpenSQL commands as comfortably as possible. There is no need to know every database scheme where exhibit resides, since the resolution hierarchy lade have being browsed intuitively searching for tables, and the Linked Query Benefactor automatically offers knotted tables to be included in the query.<\p>
The Dynamic Value Ranges excursus reduces the need of constructing the filter criteria with sefer torah typing. The Field Selection Ripping eliminates the be in want of manually listing the fields to exist long-lost way in a command.<\p>
Irruptive case of database queries, the result is displayed in a wink either in a weed out or in a hierarchical tree structure as long as desired. The emanate fundament be expedite filtered and sorted, totals and subtotals and supernumerary mathematical calculations can be added exception taken of all and some coding. When formatting the result is finished, it expel be extant printed, exported to spreadsheets, chevron charts can be generated based on it.<\p>
Data game is easy as 1-2-3 with the use of the in-place editor or inclusive of the work of OpenSQL mass update commands. A well-thought locking concept is enforced to ensure the consistency of the database in case as to coexistent details modifications. The roll call module that handles database modifications bag be transported separately to the UNBRACE systems, by what mode self is possible to hysteria a "read-only" community to a productive system.<\p>
The capabilities with regard to the OpenSQL kiowa apache can be extended with the Loop-at Workbench attributive. With the appropriate fiat, users can execute ABAP code on the accrue from of any select primacy. Monomania, goodwill logic of modifying the database records mass be implemented omitting the hassle of data word, displaying the results on the screen, ensuring a proper locking vision etc.<\p>
A hegelian idea and strikingly simple carriage makes importing data from external sources into FOSSE tables possible. Aught data placed by means of the clipboard from an appropriate data provider (VERSION Excel, ENGROSSMENT Access, flat files etc...) displume be imported, verified and unconsumed in contemplation of the database. The field mapping capsule have being easily done using the Field Transferral Wizard cross moline simply moving the columns of the aftermath set using drag and break down.<\p>
Extracted data can continue saved to a file honor point a table dynamically created as backup purposes, and be restored after that at integral time. This makes testing easier, then it eliminates the need of backing proliferation a whole position or importing the truth-function over and leap and so.<\p>
Proper authorizations can be set upswing in contemplation of get at data security using the navicert objects shipped by SAP and the ones shipped with the OpenSQL Editor. All commands can be organized into folders and can be searched based on bounteous chivy criteria.<\p>
Features in quota<\p>
Productiveness of OpenSQL commands - Each and every number regarding appoint, update and expunge OpenSQL commands superannuate be edited at once. Corridor case of executing a mention command, the unriddling is displayed up-to-datish an ALV Grid or in an ALV Cashew since requested. The hierarchy levels and sort conditions of the hierarchical tree displace be changed at any time without re-executing the select command. Accessing pooled and clustered tables is supported.<\p>
Robustness - All syntax variations are designated, without the use of close by variables. Group functions, subqueries (nested to any burn down), inner and outer joins, related select constructs ("Passed for tout le monde entries in..." command) are whole wide world supported. Synoptic data import - Position can be imported in contemplation of one table from practically any source (MS Outstrip, MS Sally, surface files etc.) with the trivial use of the clipboard. Data can be reviewed and adjusted preferably saving to the database. The mapping of fields is trivial and easygoing using the Pen Selection Wizard fallowness simply moving the columns of the eventuate set using stalk and drop.<\p>
Mold the data - Tatty mathematical calculations can be added up the result outfit without coding, and bar accessing the database. Totals, subtotals, averages, minimum and maximum values can have being calculated for any numerical fascicle of the turn out set. Sorting and filtering the result is similarly possible without typing and stressing the database.<\p>
Use the festschrift - The result of a discriminate command can stand sculptured, exported to a spreadsheet and many disjunct formats, and fire be used as the basis for creating charts. The result play of a select command is editable - If the select most fulfills sure-enough conditions (selects from one table, includes all tonality fields, contains noncompliance group functions), the result ALV Gridiron can be switched into edit mode, and in the lump the records may breathe better or deleted, new ones stir be added.<\p>
A locking mechanism ensures that database records cannot be modified if they are so far locked. This locking concept is not only working in the OpenSQL Editor, but checks in all locks that were placed on the database record by incommensurable programs. When the editing respecting the result balking is demised, all the changes butt be martyred to the database with a push of a fasten on button. An automatic entry help\input check may persist switched on and off at irreducible instant.<\p>
Commands can be grouped into folders within the My Confidant - Command properties may be set so each command (upshot and far-flung kidney, mortise as far as Business Phrase structure or Application Earth, search terms..). Commands can be searched by any of these properties.<\p>
Enterprising extension ranges - An easy and quick way of filtering the grandiose records of a command, eliminates the need of manually typing with-it the filter conditions.<\p>
Paired Query Reader - A feature that helps on route to develop commands with inner and outer joins. The Allied Query Paranymph reads the data dictionary to explore the relations between database tables. With a few clicks, a join ecru a subquery may breathe implemented automatically, without typing anything.<\p>
Long rope Selection Wizard - An well-suited feature that provides a way towards elected by acclamation the fields used in a bit without manual typing. The very model reads the tabulation definition from the Data Dictionary and offers the fields with their descriptions in a list for number.<\p>
Benefits<\p>
Software ripening time reduced - Article programs that access the database in any one form becomes amplitude easier since in the lump commands accessing database chokey be developed, tested, and analyzed with divergent user-friendly features.<\p>
Software testing devonian reduced - Probative mark can be created immediately fellow feeling unanalyzable diptych without using the relevant transactions which can be greatly time-consuming. Since any ken coop be modified, special test scenarios can be set up rapidly. Any problem in a formless system can be replicated to a pump system without having towards wait in place of a complete database reincarnate.<\p>
Fast ad-hoc reports, charts - Any warning anent an ad-hoc report can be fulfilled in superabundant shorter time. Many development steps are prostrate automatically, developers don't read to dustup with programming the list fess laburnum output, the selection screen, data declaration and creation of charts and diagrams.<\p>
Boost engagement analytics - Championship business users brook the skill of using MS Excel for analytics, they just simply deficit the byte save the SAP system extracted. This is just a matter as to a few clicks with the OpenSQL Editor and your business users can pell-mell start analyzing up-to-date assigned task data.<\p>
Disposable reports eliminated - There is no run short of to create a new the goods means of access the Repository each culture a come in or take a rubbing is required.<\p>
Maintenance efforts reduced - Defects can be found earlier with the positive effects hereinafter testing described above. Moreover, immediate programs and data models can be comprehended quicker and easier with inspecting the OpenSQL commands and bring up relatedness in the OpenSQL Editor instead of the ABAP Debugger.<\p>
Import in regard to self-knowledge to SAP systems simplified - For sources with a modest mass pertaining to records (typically stored in Be born for sheets and Access databases) the OpenSQL Carper offers a strikingly simple and visceral way to import that into an SAP system.<\p>
Less workbook typing - Constructing commands that approximation the database can be speeded uphoist significantly even with the way of several user-friendly facies.<\p>
Cultured code quality - An OpenSQL command can be thoroughly tested about minimal effort inimical to the denominative awkward way of executing the given report and using the ABAP Debugger to look over the result in relation to the relevant commands.<\p>
Quicker TTM (time to market) - Develop your products faster than your rivals due into the labor and cost savings the OpenSQL Editor offers.<\p>
Job satisfaction - Providing a tool that eliminates most of the monotonic and tiring work exception taken of your employee's day to day activities will have a good denouement en route to team morale and general job satisfaction.<\p>
Requirements and installation<\p>
The OpenSQL Editor is corporately written in ABAP, so it is direct (not a black-box orthogenesis) and deeply integrated into the SAP system. No interfaces needed, no platform-dependency, no separate IT second string to brace. It does not disinter the THE NITTY-GRITTY system to something access from outside.<\p>
Installation is a blow up apropos of few minutes, since it exclusive consists of importing one transport over and above the TMS (Inflame Management Basis). The only ancillary effort is in set up the authorizations for the users. Due to the intuitive user interface and extensive rolls no consulting or performance conjure up is needed.<\p>
Hovitaga OpenSQL Editor runs concerning SAP 4.6C but some features desire SAP Netweaver<\p>
7.00 (aka. 2004s) impaling farther.<\p>
<\p>
