Ansicht
Dokumentation
ABENNEWS-761-ABAP_SQL - NEWS-761-ABAP SQL
CL_GUI_FRONTEND_SERVICES - Frontend Services BAL Application Log DocumentationThis documentation is copyright by SAP AG.
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
- 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.
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 )