SAP NEWS-778-ABAP SQL

Get Example source ABAP code based on a different SAP table

AB_SQL in ABAP Release 7.78
ITOC

ABAP_MODIFICATION_NN New Aggregate Function ALLOW_PRECISION_LOSS

AB_SQL now supports the following new aggregate function in combination with the aggregate expression SUM:

ALLOW_PRECISION_LOSS

ABAP_MODIFICATION_NN Optional Window Frame Specification within a Window Function

The optional window frame specification allows a subset of rows within a window, called a frame, to be defined. Frames are determined with respect to the current row, which enables the frame to move within a window.

ABAP_MODIFICATION_NN New Window Functions FIRST_VALUE and LAST_VALUE

AB_SQL now supports the following new window functions in window expressions:

FIRST_VALUE and LAST_VALUE.

ABAP_MODIFICATION_NN New Date/Time Conversion Functions

AB_SQL now supports the following new date/time conversion functions:

TSTMPL_TO_UTCL and TSTMPL_FROM_UTCL

DATS_TO_DATN and DATS_FROM_DATN

TIMS_TO_TIMN and TIMS_FROM_TIMN

ABAP_MODIFICATION_NN New Time Stamp Functions

AB_SQL now supports the following new time stamp functions:

UTCL_CURRENT, UTCL_ADD_SECONDS, and UTCL_SECONDS_BETWEEN.

ABAP_MODIFICATION_NN New Date Functions

AB_SQL now supports the following new date functions:

DATN_DAYS_BETWEEN, DATN_ADD_DAYS, and DATN_ADD_MONTHS.

ABAP_MODIFICATION_NN New Additions After the ORDER BY Clause

AB_SQL now supports the following additions after the ORDER BY clause:

NULLS FIRST and NULLS LAST.

ABAP_MODIFICATION_NN New Aggregate Functions

AB_SQL now supports the following new aggregate functions:

MEDIAN, Standard SAP Help forDEV, VAR, CORR, and CORR_SPEARMAN.

ABAP_MODIFICATION_NN New Geometry Conversion Function as_geo_json

AB_SQL now supports the following new geometry conversion function:

as_geo_json

ABAP_MODIFICATION_NN SQL Conditions Revised

The following SQL conditions were revised:

The operator IN can now be used with a subquery that returns value tuples .

SQL functions and cast expressions can now be used as operands on the right side of comparison operators.

ABAP_MODIFICATION_NN Strict Mode of 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_778 strict mode / , which handles the statement more strictly than the regular syntax check.

ABAP_MODIFICATION_NN Change Regarding the CONNECTION Addition

The addition CONNECTION only bypasses table buffering in case of real remote connections that are available in table DBCON.