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
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 the SQL Cockpit for SAP® Systems, you can store, organize and repeatedly execute any number of your statements. Ideal SQL templates can be defined in conjunction with the symbols. In addition, private or public variants can be created to which other users can also have access. Collaboration can be that easy!
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 a member of the SAP® PartnerEdge® open ecosystem, we offer a comprehensive range of consulting services and SAP®-certified, compatible add-ons. Our employees are always up to date with the latest technology and have the relevant SAP® certificates.
