Ansicht
Dokumentation
ABENNEWS-765-ABAP_SQL - NEWS-765-ABAP SQL
Fill RESBD Structure from EBP Component Structure Addresses (Business Address Services)This documentation is copyright by SAP AG.
in Release 7.65
Common Table Expressions
The new statement WITH enables
common
table expressions (CTEs) to be defined for use in the WITH statement. A common table expression creates a result set that is used in the queries of the WITH statement as a data source. The
main query of the WITH statement has an INTO clause and transfers its result set to ABAP data objects.
Cross Join
As well as an inner and outer join, it is now possible to use a
cross join in a SELECT statement.
Inline Declaration for OPEN CURSOR
An inline declaration with the
declaration
operator DATA can now also be
specified at the operand position for dbcur of the OPEN CURSOR statement.
SQL Functions
- The new numeric function DIVISION enables divisions with decimal places.
- The new date functions DATS_IS_VALID, DATS_DAYS_BETWEEN, DATS_ADD_DAYS and DATS_ADD_MONTHS execute operations with date fields.
- An addition AS dtype can now
be specified in the aggregate function AVG to define the data type of the result.
Extended Result
The new addition EXTENDED RESULT
of an INTO clause can be used to provide an extended result for an object of the class
CL_OSQL_EXTENDED_RESULT, which can be queried using methods of the class.
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.
Access to Cached Views of the SAP HANA Database
Under certain conditions, a query can read data from the cache when accessing a
cached view of the
SAP HANA database.
This can be checked using the addition EXTENDED
RESULT of an INTO clause.
Session Variables in the SAP HANA Database
A new ABAP-specific session variable
CDS_CLIENT for the client ID is modified in reads by addition USING CLIENT. The
CDS session variable
client is now linked to this HANA session variable.
Restrictions Removed
- The addition ORDER BY PRIMARY KEY of the SELECT statement can now also be specified if a column is specified multiple times in the SELECT list, without the same name being blocked by alternative names.
- When accessing CDS
views that use session variables, addition USING CLIENT can now be used. When accessing
CDS views that do not use the
session variable
client, the addition CLIENT SPECIFIED can now be used.
rdisp/max_wprun_time - Maximum work process run time rdisp/max_wprun_time - Maximum work process run time
This documentation is copyright by SAP AG.
Length: 6350 Date: 20240424 Time: 051446 sap01-206 ( 55 ms )