SAP NEWS-762-ABAP SQL



Get Example source ABAP code based on a different SAP table
  



AB_SQL in ABAP Release 7.62
ITOC

ABAP_MODIFICATION_NN Subquery as Data Source of INSERT

In the AB-SQL 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.

ABAP_MODIFICATION_NN SQL Functions

The following changes have been made:
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.

ABAP_MODIFICATION_NN SQL Expressions

Columns of the built-in dictionary type SSTRING can now be used in the SQL expressions CASE and the coalesce function.

ABAP_MODIFICATION_NN Host Expressions

From ABAP_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.

ABAP_MODIFICATION_NN CDS Path Expressions

From ABAP_RELEASE 7.62, path expressions can be used as data sources of the FROM clause of the statement SELECT.

ABAP_MODIFICATION_NN Access to Global Temporary Tables

When the new global temporary tables in ABAP Dictionary are accessed using AB_SQL , all temporary data stored here is guaranteed to be deleted before the next implicit database commit , If not, a runtime error occurs.

ABAP_MODIFICATION_NN Strict Mode in the Syntax Check

If one the new features listed above is used in an AB-SQL statement, the syntax check is performed in a ABAP_STRICT_762 strict mode / , which handles the statement more strictly than the regular syntax check.

ABAP_MODIFICATION_NN ON Conditions

From ABAP_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).

ABAP_MODIFICATION_NN CDS Views with Input Parameters

In ABAP_RELEASE 7.62 and higher, the input parameters of CDS views are supported by all database platforms and can be used in AB_SQL . 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.

ABAP_MODIFICATION_NN 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.