SAP NEWS-761-ABAP SQL
Get Example source ABAP code based on a different SAP table
AB_SQL in ABAP Release 7.61 ITOC
ABAP_MODIFICATION_NN SQL Expressions From ABAP_RELEASE 7.61, other
SQL expressions can be used as operands in a cast expression and FLTP is not the only data type that can be specified.
ABAP_MODIFICATION_NN ON Conditions
From ABAP_RELEASE 7.61, it is possible to
Use SQL expressions of the left side of the ON condition of any join.
Use the expression IS $[NOT$] NULL in an ON condition of an outer join.
ABAP_MODIFICATION_NN Unions
As of ABAP_RELEASE 7.61, the set operator UNION can also be used in subqueries.
ABAP_MODIFICATION_NN Host Expressions
From ABAP_RELEASE 7.61, host expressions can also be specified as an operand n after UP TO and PACKAGE SIZE in the SELECT statement.
ABAP_MODIFICATION_NN Access to CDS Entities
From ABAP_RELEASE 7.61, the new CDS table functions can also be specified as data sources of a SELECT statement alongside CDS views .
If an input parameter of a CDS entity is annotated with the new annotation @Environment.systemField , AB_SQL can pass the system value that matches the value of the annotation implicitly. The annotation value #CLIENT even prevents an actual parameter from being passed to input parameters explicitly that are annotated in this way for client IDs.
ABAP_MODIFICATION_NN Arrangement of SELECT Clauses and FROM Clauses
From ABAP_RELEASE 7.61, 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.
ABAP_MODIFICATION_NN Strict Mode in the Syntax Check
If one the new features listed above is used in an AB-SQL statement, the syntax check is performed in a ABAP_STRICT_761 strict mode / , which handles the statement more strictly than the regular syntax check.
ABAP_MODIFICATION_NN System Classes
The class CL_ABAP_DBFEATURES can now be used to check all features of databases that can be integrated in ABAP programming but which cannot be used in all database systems.
ABAP_MODIFICATION_NN Access to Replacement Objects
From ABAP_RELEASE 7.61, it is possible to define a CDS view as a replacement object in ABAP Dictionary (transaction SE11) for a database table or a DDIC database view.
If a replacement object is defined for a database table or DDIC 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 DDIC database view.
This change was implemented using an internal tool and a kernel patch after ABAP_RELEASE 7.40, SP10.
