Ansicht
Dokumentation

ABENNEWS-755-ABAP_SQL - NEWS-755-ABAP SQL

Vendor Master (General Section)   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

in Release 7.55

New Aggregate Function ALLOW_PRECISION_LOSS

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

• ALLOW_PRECISION_LOSS
  
  
  
  

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.

New Window Functions FIRST_VALUE and LAST_VALUE

now supports the following new window functions in window expressions:

• FIRST_VALUE and LAST_VALUE.
  
  
  
  

New Date/Time Conversion Functions

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
  
  
  
  

New Time Stamp Functions

now supports the following new time stamp functions:

• UTCL_CURRENT, UTCL_ADD_SECONDS, and UTCL_SECONDS_BETWEEN.
  
  
  
  

New Date Functions

now supports the following new date functions:

• DATN_DAYS_BETWEEN, DATN_ADD_DAYS, and DATN_ADD_MONTHS.
  
  
  
  

New Additions After the ORDER BY Clause

now supports the following additions after the ORDER BY clause:

• NULLS FIRST and NULLS LAST.
  
  
  
  

New Aggregate Functions

now supports the following new aggregate functions:

• MEDIAN, STDDEV, VAR, CORR, and CORR_SPEARMAN.
  
  
  
  

New Geometry Conversion Function as_geo_json

now supports the following new geometry conversion function:

• as_geo_json
  
  
  
  

SQL Conditions 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.
  
  
  
  

New Window Function NTILE

now supports the following new window function in window expressions:

• NTILE
  
  
  
  

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 SELECT list, FROM clause, and any indicators needed to be static.

New Type Conversion Function to_blob

New Type Conversion Function to_clob

now supports the new type conversion functions to_clob and to_blob.

New Currency Conversion Function currency conversion

now supports the new currency conversion function currency_conversion.

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.

Further Data Types Allowed in Elementary SQL Expressions

Elementary SQL expressions can now also have the dictionary data types STRING and RAWSTRING.

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.

Typed Literals

Typed literals for many ABAP Dictionary types are now available in ABAP SQL.

New String Functions

now supports the new string functions REPLACE_REGEXPR, LIKE_REGEXPR, and OCCURRENCES_REGEXPR that support regular expressions.

Addition to the UPDATE FROM Clause

Set indicators can now be used as addition after the UPDATE FROM-clause to indicate columns for update.

Strict Mode of 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.

Change Regarding the CONNECTION Addition

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

RFUMSV00 - Advance Return for Tax on Sales/Purchases   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.

Length: 10258 Date: 20240426 Time: 071210     sap01-206 ( 106 ms )