SAP NEWS-755-ABAP SQL
Get Example source ABAP code based on a different SAP table
AB_SQL in ABAP Release 7.55 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 defines a subset of rows within a window, called frame. 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 ABAP 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 New Window Function NTILE
AB_SQL now supports the following new window function in window expressions:
NTILE
ABAP_MODIFICATION_NN SELECT, INTO target Modification
When using SELECT, INTO target, host variables can now be declared inline even when the FROM clause is dynamic, as long as all fields of the SELECT list are known statically. Previously, the structure of the result set, including the SELECT list, the FROM clause, and any indicators needed to be static.
ABAP_MODIFICATION_NN New Type Conversion Function to_blob
See New Type Conversion Function to_clob.
ABAP_MODIFICATION_NN New Type Conversion Function to_clob
AB_SQL now supports the new type conversion functions to_clob and to_blob.
ABAP_MODIFICATION_NN New Currency Conversion Function currency conversion
AB_SQL now supports the new currency conversion function currency_conversion.
ABAP_MODIFICATION_NN Streaming and Locators Can Now Be Used on SQL Expressions
Streaming and locators can now be used in combination with SQL expressions such as TO_CLOB, TO_BLOB, and AS_GEO_JSON.
ABAP_MODIFICATION_NN Further Data Types Allowed in Elementary SQL Expressions
Elementary SQL expressions can now also have the dictionary data types STRING and RAWSTRING.
ABAP_MODIFICATION_NN Hierarchy Load Options
The hierarchy generator HIERARCHY can now use the new addition LOAD BULK$|INCREMENTAL$|load_option to specify the load policy for a generated hierarchy.
ABAP_MODIFICATION_NN Typed Literals
Typed literals for many ABAP Dictionary types are now available in ABAP SQL.
ABAP_MODIFICATION_NN New String Functions
AB_SQL now supports the new string functions REPLACE_REGEXPR, LIKE_REGEXPR , and OCCURRENCES_REGEXPR that support regular expressions.
ABAP_MODIFICATION_NN Addition to the UPDATE FROM Clause
Set indicators can now be used as additions after the UPDATE FROM clause to indicate columns to be updated.
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.
