Ansicht
Dokumentation
ABENNEWS-751-ABAP_SQL - NEWS-751-ABAP SQL
BAL_S_LOG - Application Log: Log header data PERFORM Short ReferenceThis documentation is copyright by SAP AG.
in Release 7.51
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 results 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 results 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.
New Addition OFFSET in SELECT
In the additions named under additional_options
in the statement SELECT, an addition
OFFSET can now be specified to specify the first row of the results set.
SQL Functions
- The new numeric function DIVISION enables divisions with decimal places.
- The new string functions LEFT, CONCAT_WITH_SPACE, INSTR, and RPAD perform operations on strings.
- In the string functions LPAD, LTRIM, and RTRIM, arguments passed as constants or literals can now contain special characters.
- 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.
New Additions in DELETE dbtab
In the variant DELETE FROM target of the statement DELETE,
the additions ORDER BY, OFFSET,
and UP TO can now be specified to restrict the number of rows to delete.
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.
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 by the addition USING CLIENT in reads. 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.
- The components of a replacement object must no longer be in the same order as the associated components of the replaced database table or classic view.
- When accessing CDS views that use
session variables, the 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.
Fill RESBD Structure from EBP Component Structure CPI1466 during Backup
This documentation is copyright by SAP AG.
Length: 8530 Date: 20240329 Time: 054823 sap01-206 ( 116 ms )