SAP NetWeaver AS ABAP Release 750, ©Copyright 2016 SAP AG. All rights reserved.
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
7. Columns specified after BETWEEN
8. Subquery as data source of INSERT
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
15. Access to replacement objects
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.
Unions
From Release 7.50, the addition UNION
creates the union of the results sets of two SELECT statements.
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:
SQL Expressions Expanded
If an SQL expression can be specified, any individual literals, host variables, and host expressions can also be specified.
SQL Functions Expanded
ON Conditions Expanded
The following is possible from Release 7.50:
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 ~.
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.
Access to CDS Entities
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.
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.
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.
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.
System Classes Expanded
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.