Jetzt SAP S/4HANA® Integration optimieren und beschleunigen!
You’ve never been so close to your data
With the ABAP® Open SQL Editor you can use all the possibilities of ABAP® Open SQL for formulating SELECT statements. Individual SQL queries or extensive series of SQL commands are entered in the SQL statement window.
ABAP® Open SQL Editor
- Syntax check
- Pretty Printer
- Forward navigation to the ABAP® Dictionary
- Code Completion
- and many more…
Unlimited possibilities combined in just one tool
Get the SQL Cockpit as a fully functional ABAP® Open SQL Editor! Various functions await you, including an unlimited number of queries or the direct input of (complex) SQL statements. In addition to a sophisticated authorization concept, the SQL Editor enables audit-proof database changes.
Standard Edition
- Save and compare lists
- Compare lists with historical data
- Unlimited number of queries
- Report Generator
- Variant maintenance, definition of favorites
- Results immediately visible in the ALV grid
- Direct input of (complex) SQL statements
- Support of all (modern) SQL functions incl. 7.51
- Queries in the background, periodically
- OData Generator
Premium Edition
- all standard features
- Atlassian JIRA® as ticket system
- Comprehensive authorization concept
- Logged database changes
Data security is important to us!
YES – We enable secure data manipulation!
With our SQL Cockpit for SAP® Systems, you get
an ABAP Open SQL Editor with a unique authorization concept.
Audit-proof confirmed by Ernst & Young!
Compatible for all ABAP® SQL SELECT operations
Our solution supports almost the entire range of SQL SELECT queries, including advanced features like SQL expressions, CDS views, and unions. Additionally, special options such as database hints and the DESTINATION addition are fully compatible.
SQL functions
- JOINS (Inner, Outer, Cross)
- Aggregations
- Subqueries
- Secondary Database connections
- Database hints
- UNION (ALL/DISTINCT)
SQL Expressions
- Numerical functions
- String, date &
conversion functions - Coalesce function
- Arithmetic
- Case distinctions
CDS Views/Entities
- Views with parameters
- Associations
- Path Expressions
- Display of the DDL definition
directly in the ABAP SQL Cockpit
for SAP® Systems - ADT Integration
Strict Mode
- SELECT queries in
modern, strict mode
formulate - SELECT queries in the
old-fashioned style
formulate
- SELECT queries in
Features in detail: The focus is on usability
An easy-to-use application was and is one of our most important goals. That is why we attach great importance to outstanding usability.
Easy
All features are just 1 click away, evaluations can be made in just a few seconds!
Intuitive
The design aims to enable & support intuitive use!
Efficient
Find data faster in the SAP system & complete tasks more effectively!
Customizable
The SQL Cockpit supports all individual user needs and requirements!
Compare tables with each other – and not just during the runtime
The table comparison is also possible with saved lists. Old data can be compared with new data with just one click. The results are displayed in a clear overview so that any differences can be quickly identified!
Easily save & execute SELECT statements as templates
With SQL Cockpit for SAP® Systems, you have full control over your SQL queries. You can store any number of statements, organize them clearly, and execute them again at any time. Thanks to the intuitive toolbars, you can quickly create your own SQL templates, significantly reducing repetitive tasks and day-to-day effort.
In addition, SQL Cockpit allows you to define variants of your queries — either privately for personal use or publicly so that colleagues can access them as well. This encourages team collaboration, avoids duplicate work, and ensures that proven queries are always available when needed.
Various options for lists & reports
Display an unlimited number of lists – only the screen size or the main memory limit the display! In addition, the results of the SELECT statements executed are not only displayed. They can also be saved, shared, exported and compared!
Filter / sort columns
Form (intermediate) sums
Saved Lists
Comparison with other lists
Export (Excel, CSV, HTML,…)
Charts via ALV Graph
Display with Crystal Reports
Sharing lists with colleagues
Build SQL queries faster and more efficiently
Don’t remember the column names for your SQL statement? No problem! Simply hover your mouse over the table name to access the element information. Here, you’ll find all the important details, including column names and short descriptions. Additionally, you can easily drag and drop the column names into the editor area.
Report Generator & OData Wizard – Work even without ABAP Open SQL knowledge
Independent ABAP reports can be generated from the SQL database queries with a single click. By clicking on the generation button, the wizard opens and helps you step-by-step with the individual steps! OData is a REST-based, open format for exchanging data. With the SQL Cockpit for SAP Systems, OData Gateway Services can be generated on the basis of query specifications. All common query options of version 2.0 are supported!
Logged database changes
Audit-proof modification of data is possible with the SQL Cockpit: This feature offers the unbeatable possibility of modifying data from database tables! The basis is a sophisticated authorization concept. As security is a major issue here, the SQL Cockpit supports extensive logging of changes. From classic logging to system logging and e-mail notifications. Integration with JIRA and the Solution Manager system – if available – is also included!
Ask our experts
As an SAP® partner, we offer comprehensive consulting services and SAP®-certified add-ons that integrate seamlessly into your system landscape. Our team combines cutting-edge technological know-how with certified SAP® expertise — delivering solutions that work in practice.
