Ansicht
Dokumentation

ABENNEWS-762-ABAP_SQL - NEWS-762-ABAP SQL

ABENNEWS-762-ABAP_SQL - NEWS-762-ABAP SQL

General Material Data   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

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 )