Ansicht
Dokumentation

ABENNEWS-761-ABAP_SQL - NEWS-761-ABAP SQL

ABENNEWS-761-ABAP_SQL - NEWS-761-ABAP SQL

CL_GUI_FRONTEND_SERVICES - Frontend Services   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

in Release 7.61





SQL Expressions

From 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.



ON Conditions

From Release 7.61, it is possible to

Unions

As of Release 7.61, the language element UNION can also be used in subqueries.



Host Expressions

From Release 7.61, host expressions can also be specified as an operand n after UP TO and PACKAGE SIZE in the SELECT statement.



Access to CDS Entities

From 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, 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.



Arrangement of SELECT Clauses and FROM Clauses

From 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.



Strict Mode in the Syntax Check

If one the new features listed above is used in an statement, the syntax check is performed in a strict mode, which handles the statement more strictly than the regular syntax check.



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.



Access to Replacement Objects

From 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 Release 7.40, SP10.






ABAP Short Reference   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 5490 Date: 20240328 Time: 183400     sap01-206 ( 74 ms )