ABAP SQL in ABAP Release 7.55 - ABAP Keyword Documentation

ABAP - Keyword Documentation → ABAP - ABAP Release News → News for ABAP Release 7.5x → News for ABAP Release 7.55 →

ABAP SQL in ABAP Release 7.55

1. New Aggregate Function ALLOW_PRECISION_LOSS

2. Optional Window Frame Specification within a Window Function

3. New Window Functions FIRST_VALUE and LAST_VALUE

4. New Date/Time Conversion Functions

5. New Time Stamp Functions

6. New Date Functions

7. New Additions After the ORDER BY Clause

8. New Aggregate Functions

9. New Geometry Conversion Function as_geo_json

10. SQL Conditions Revised

11. New Window Function NTILE

12. SELECT, INTO target Modification

13. New Type Conversion Function to_blob

14. New Type Conversion Function to_clob

15. New Currency Conversion Function currency conversion

16. Streaming and Locators Can Now Be Used on SQL Expressions

17. Further Data Types Allowed in Elementary SQL Expressions

18. Hierarchy Load Options

19. Typed Literals

20. New String Functions

21. Addition to the UPDATE FROM Clause

22. Strict Mode of the Syntax Check

23. Change Regarding the CONNECTION Addition

Modification 1

New Aggregate Function ALLOW_PRECISION_LOSS

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

ALLOW_PRECISION_LOSS

Modification 2

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.

Modification 3

New Window Functions FIRST_VALUE and LAST_VALUE

ABAP SQL now supports the following new window functions in window expressions:

FIRST_VALUE and LAST_VALUE.

Modification 4

New Date/Time Conversion Functions

ABAP SQL now supports the following new date/time conversion functions:

Modification 5

New Time Stamp Functions

ABAP SQL now supports the following new time stamp functions:

UTCL_CURRENT, UTCL_ADD_SECONDS, and UTCL_SECONDS_BETWEEN.

Modification 6

New Date Functions

ABAP SQL now supports the following new date functions:

DATN_DAYS_BETWEEN, DATN_ADD_DAYS, and DATN_ADD_MONTHS.

Modification 7

New Additions After the ORDER BY Clause

ABAP SQL now supports the following additions after the ORDER BY clause:

NULLS FIRST and NULLS LAST.

Modification 8

New Aggregate Functions

ABAP SQL now supports the following new aggregate functions:

MEDIAN, STDDEV, VAR, CORR, and CORR_SPEARMAN.

Modification 9

New Geometry Conversion Function as_geo_json

ABAP SQL now supports the following new geometry conversion function:

as_geo_json

Modification 10

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.

Modification 11

New Window Function NTILE

ABAP SQL now supports the following new window function in window expressions:

NTILE

Modification 12

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.

Modification 13

New Type Conversion Function to_blob

See New Type Conversion Function to_clob.

Modification 14

New Type Conversion Function to_clob

ABAP SQL now supports the new type conversion functions to_clob and to_blob.

Modification 15

New Currency Conversion Function currency conversion

ABAP SQL now supports the new currency conversion function currency_conversion.

Modification 16

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.

Modification 17

Further Data Types Allowed in Elementary SQL Expressions

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

Modification 18

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.

Modification 19

Typed Literals

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

Modification 20

New String Functions

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

Modification 21

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.

Modification 22

Strict Mode of the Syntax Check

If one the new features listed above is used in an ABAP SQL statement, the syntax check is performed in a strict mode, which handles the statement more strictly than the regular syntax check.

Modification 23

Change Regarding the CONNECTION Addition

The addition CONNECTION is supported by the ABAP SQL engine for the standard connection as well as for service connections. Only secondary connections from table DBCON cannot be processed by the ABAP SQL engine.