ABAP SQL in ABAP Release 7.57 - ABAP Keyword Documentation

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

ABAP SQL in ABAP Release 7.57

1. Support for ORDER BY in the ABAP SQL Engine

2. String Functions Processed by the ABAP SQL Engine

3. Table Buffering for Decimal Floating Point Calculations

Modification 1

Support for ORDER BY in the ABAP SQL Engine

The ABAP SQL engine fully supports the ORDER BY clause now:

ORDER BY does not bypass table buffering any more. Before, it bypassed table buffering in cases where single columns were specified as sort keys and these columns were not a left-aligned subset of the primary key in the correct order or if the addition DESCENDING was specified for a column.
ORDER BY can now be used with SELECT FROM @itab without transporting the internal table to the database. This allows looping over an internal table in a sequence defined by ORDER BY and sorting internal tables by expressions.

Modification 2

String Functions Processed by the ABAP SQL Engine

The string functions LEFT, LOWER, RIGHT, UPPER and SUBSTRING can be processed by the ABAP SQL engine now. They do not bypass table buffering any more and do not cause the transport of an internal table accessed by FROM @itab to the database. While LEFT, LOWER, RIGHT, UPPER where not supported at all, SUBSTRING was supported under certain conditions.

Modification 3

Table Buffering for Decimal Floating Point Calculations

Calculations for built-in types DECFLOAT16 and DF16_DEC do not bypass the table buffering any more. The calculation in the table buffer is done with the respective decimal floating point arithmetic. The following differences to ABAP and to the database must be considered:

In ABAP, the calculation type for decfloat16 is decfloat34.
On the database, built-in type DF16_DEC is handled as a packed number.

Both can lead to different results.