SAP NEWS-779-ABAP SQL

Get Example source ABAP code based on a different SAP table

AB_SQL in ABAP Release 7.79
ITOC

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

ABAP_MODIFICATION_NN New Type Conversion Function to_clob

AB_SQL now supports the new type conversion function to_clob.

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 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_779 strict mode / , which handles the statement more strictly than the regular syntax check.