Ansicht
Dokumentation

ABENNEWS-779-ABAP_SQL - NEWS-779-ABAP SQL

BAL_S_LOG - Application Log: Log header data   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.

in Release 7.79

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_clob

now supports the new type conversion function to_clob.

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.

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.

RFUMSV00 - Advance Return for Tax on Sales/Purchases   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 2451 Date: 20240424 Time: 035624     sap01-206 ( 39 ms )