SAP NEWS-760-ABAP SQL
Get Example source ABAP code based on a different SAP table
AB_SQL in ABAP Release 7.60 ITOC
ABAP_MODIFICATION_NN Unions From ABAP_RELEASE 7.60, the set operator
UNION creates the union of the result sets of two SELECT statements.
ABAP_MODIFICATION_NN SQL Expressions
From ABAP_RELEASE 7.60, SQL expressions can be specified in the following operand positions (except in the SELECT list):
Left side of any WHERE condition
Left side of a HAVING condition
Left side of a complex case distinction
If an SQL expression can be specified, any individual literals, host variables, and host expressions can also be specified.
ABAP_MODIFICATION_NN Host Expressions
From ABAP_RELEASE 7.60, 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 ABAP_RELEASE 7.60:
Arguments of SQL expressions and hence all operand positions in which these are possible.
Right sides of WHERE, ON, or HAVING conditions, except for LIKE and IN.
Actual parameters for input parameters of CDS views.
Right side of a SET expression in UPDATE.
ABAP_MODIFICATION_NN Columns Specified After BETWEEN
From ABAP_RELEASE 7.60, 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 ~.
ABAP_MODIFICATION_NN Access to CDS Entities
Until ABAP_RELEASE 7.60, a CDS entity could only be used together with database tables and DDIC views in a SELECT statement if addressed using its ABAP_CDS_MNG_VIEW . This restriction now no longer applies. From ABAP_RELEASE 7.60, CDS views can be addressed using the name of their CDS entity , even if linked with database tables or DDIC views using joins or subqueries. Accessing a CDS view by specifying the ABAP_CDS_MNG_VIEW is obsolete.
ABAP_MODIFICATION_NN CDS Path Expressions
From ABAP_RELEASE 7.60, path expressions closed with an element can be specified for columns specified in SELECT statements that access CDS views with CDS associations exposed for outside use.
ABAP_MODIFICATION_NN Strict Mode in the Syntax Check
If one the new features listed here is used in an AB-SQL statement, the syntax check is performed in a ABAP_STRICT_760 strict mode / , which handles the statement more strictly than the regular syntax check.
