Ansicht
Dokumentation
ABENNEWS-762-ABAP_SQL - NEWS-762-ABAP SQL
General Material Data BAL_S_LOG - Application Log: Log header dataThis documentation is copyright by SAP AG.
in Release 7.62
Subquery as Data Source of INSERT
In the write statement INSERT, a
parenthesized subquery SELECT subquery_clauses
can now be specified as a data source after FROM. The rows of the result set of the subquery
are inserted into the target table directly on the database. No data transport is required between the database and AS ABAP.
SQL Functions
- New Numeric Function
- The new function ROUND rounds numeric values.
- New String Functions
- The new functions CONCAT, LPAD, LENGTH, LTRIM, REPLACE, RIGHT, RTRIM, and SUBSTRING perform operations on strings.
- Coalesce Function Expanded
-
The coalesce function can now have 255 arguments
instead of just two and returns the value of the first argument that does not have the null value.
SQL Expressions
Columns of the built-in dictionary type SSTRING can now be used in the
SQL expressions CASE and the
coalesce function.
Host Expressions
From Release 7.62, host expressions
can be specified for the work areas wa or the internal tables itab (from which the data
is taken) in the write statements INSERT,
UPDATE, MODIFY,
and DELETE.
CDS Path Expressions
From Release 7.62, path expressions can be used as
data sources of the FROM
clause of the statement SELECT.
Access to Global Temporary Tables
When the new global
temporary tables in ABAP Dictionary are accessed using , all temporary data stored here is guaranteed to be deleted before the next implicit
database commit, If not, a runtime error occurs.
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.
ON Conditions
From Release 7.62, the full ON condition or subconditions of
joins can be specified dynamically as
(cond_syntax). This is not possible if the full FROM clause is specified dynamically as (cond_syntax).
CDS Views with Input Parameters
In Release 7.62 and higher, the input
parameters of CDS views are supported by all database platforms and can be used in . It is no longer
necessary to query property VIEWS_WITH_PARAMETERS using method USE_FEATURES of class
CL_ABAP_DBFEATURES. Querying this property results in a warning check from the syntax check.
System Classes
The new system class CL_DBI_UTILITIES contains utility methods for the database interface.
The documented method IS_LOGGING_ON can be used to verify whether logging is currently switched on for a database table.
Vendor Master (General Section) BAL_S_LOG - Application Log: Log header data
This documentation is copyright by SAP AG.
Length: 5951 Date: 20240328 Time: 220521 sap01-206 ( 88 ms )