ABAP - Keyword Documentation →  ABAP - Release-Specific Changes →  Changes in Releases 7.5x →  Changes in Release 7.50 → 

Open SQL in Release 7.50

1. Arrangement of SELECT clauses and FROM clauses

2. Unions

3. Host expressions

4. SQL expressions expanded

5. SQL functions expanded

6. ON conditions expanded

7. Columns specified after BETWEEN

8. Subquery as data source of INSERT

9. Access to CDS entities

10. Path expressions for associations of CDS views

11. Access to global temporary tables

12. Strict mode in the syntax check

13. CDS views with input parameters

14. System classes expanded

15. Access to replacement objects

Modification 1

Arrangement of SELECT Clauses and FROM Clauses

From Release 7.50, the FROM clause of a SELECT statement can also be specified in front of the SELECT clause. In this case, the SELECT clause must be introduced using the new addition FIELDS. This arrangement supports tools such as Code Completion in ABAP Editor.

Modification 2


From Release 7.50, the addition UNION creates the union of the results sets of two SELECT statements.

Modification 3

Host Expressions

From Release 7.50, host expressions with the syntax @( expr ) can be specified in many operand positions in which host variables are possible. For expr, all ABAP expressions can calls are possible that can be specified in general expression positions.

Operand positions for host expressions in Release 7.50:

Modification 4

SQL Expressions Expanded

If an SQL expression can be specified, any individual literals, host variables, and host expressions can also be specified.

Modification 5

SQL Functions Expanded

The new function ROUND rounds numeric values.
The new functions CONCAT, LPAD, LENGTH, LTRIM, REPLACE, RIGHT, RTRIM, and SUBSTRING perform operations on strings.
The coalesce function can now have 255 arguments instead of just two and returns the value of the first argument that does not have the null value. Columns with the predefined dictionary type SSTRING can now be used as arguments.

Modification 6

ON Conditions Expanded

The following is possible from Release 7.50:

Modification 7

Columns Specified After BETWEEN

From Release 7.50, numeric columns can be specified on the right side in an interval condition using BETWEEN, providing the name of the database table or view is prefixed using ~.

Modification 8

Subquery as data source of INSERT

In the Open SQL write statement INSERT, a parenthesized subquery can now be specified as a data source after FROM. The rows of the results set of the subquery are inserted into the target table directly on the database. No data transport is required between the database and the application server.

Modification 9

Access to CDS entities

Modification 10

Path Expressions for Associations of CDS Views

From Release 7.50, path expressions can be specified in SELECT statements that access CDS views with associations published for outside use as follows.

Modification 11

Access to Global Temporary Tables

When the new global temporary tables in ABAP Dictionary are accessed using Open SQL, all temporary data stored here is guaranteed to be deleted before the next implicit database commit, If not, a runtime error occurs.

Modification 12

Strict Mode in the Syntax Check

If one the new features listed above (with the exception of dynamic join conditions) is used in an Open SQL statement, the syntax check is performed in a strict mode, which handles the statement more strictly than the regular syntax check.

Modification 13

CDS Views with Input Parameters

In Release 7.50 and higher, the input parameters of CDS views are supported by all database platforms and can be used in Open SQL. It is no longer necessary to query property VIEWS_WITH_PARAMETERS using method USE_FEATURES of class CL_ABAP_DBFEATURES. Querying this property results in a warning check from the syntax check.

Modification 14

System Classes Expanded

Modification 15

Access to Replacement Objects

From Release 7.50, it is possible to define a CDS view as a replacement object in ABAP Dictionary (transaction SE11) for a database table or a database view.

If a replacement object is defined for a database table or database view specified as a data source of a SELECT statement, the SELECT statement accesses the CDS view and not the database table or the database view.

This change was implemented using an internal tool a kernel patch after Release 7.40, SP10.