ABAP Keyword Documentation → ABAP - Release-Specific Changes → Changes in Releases 7.5x → Changes in Release 7.54
ABAP SQL in Release 7.54
1. Client handling
INTO clause revised
3. Definition of associations
4. New aggregate function
5. New built-in functions
DISTINCT optional in aggregate function
7. Window expressions
8. SQL conditions revised
9. Temporal hierarchies
10. New hierarchy navigators
11. Aggregate expressions in SQL expressions
CAST matrix revised
13. Strict mode in the syntax check
14. Syntax check for literals and host constants
7.31 | 7.40 | 7.54
The new additions
USING [ALL] CLIENTS [IN]in queries
USING [ALL] CLIENTS [IN]in write statements
make it possible to switch implicit client handling from the current default client to multiple clients.
This makes the addition
obsolete in queries and
obsolete in the write statements
UPDATE SET and
Extensions of the INTO Clause
INTO clause has been extended as follows:
The new addition
NEWcan be used to implicitly create anonymous data objects as target areas. The addition
NEWnow also makes inline declarations possible when using dynamic tokens and after the statement
The new addition
INDICATORScan be used to specify a null indicator.
Definition of Associations
When associations of a
common table expression are published using the addition
WITH ASSOCIATIONS, new
associations can be defined by specifying
JOIN TO ONE|MANY. These CTE associations can be used in the subsequent queries of the current
WITH statement, either in
path expressions or as
hierarchy associations in the
Definitions of associations require strict mode from Release 7.54.
New Aggregate Function STRING_AGG
The new aggregate function
can be used to chain character-like results of the rows of the results set of a query or of the current group as a string.
New Built-In Functions
ABAP SQL Now supports the following new built-in functions:
Addition DISTINCT Optional in Aggregate Function COUNT
The aggregate function COUNT( sql_exp
) can now be used without the addition
DISTINCT. In this case, it counts all rows in which the value of the argument is not the
Window expressions defined using
can now be used in the
SELECT list of a query. Window expressions define windows as a subset of the results set and apply
window functions to them.
SQL Conditions Revised
The SQL conditions were revised as follows:
Unlike in all other relational expressions in ABAP SQL, the relational expression
IS [NOT] NULLcan now be used to check LOBs and geodata types.
A new variant of the operator
INcan be used to compare multiple operands with a list of value tuples.
The hierarchy generator
HIERARCHY can now use the new addition
PERIOD FROM TO VALID FROM TO to create
temporal hierarchies in which the hierarchy nodes are limited by time intervals.
New Hierarchy Navigators
The new hierarchy navigators
HIERARCHY_ANCESTORS_AGGREGATE can be used to calculate
aggregate functions for
descendant nodes and
ancestor nodes. The latter
also supports the new aggregate function
Aggregate Expressions in SQL Expressions
From Release 7.54, aggregate expressions can be specified as operands of SQL expressions.
CAST Matrix Revised
The matrix of types that can be converted to each other with a
CAST expression has been expanded. In particular, the
new data types of the ABAP Dictionary are taken into
account. The new types DECFLOAT16 and DECFLOAT34 can also be specified after the addition
AS of the aggregate function
Strict Mode in 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.
Syntax Check for Literals and Host Constants
The fact that conversions of host variables in read positions need to be lossless is checked for literals and host constants in the strict syntax check modes from Release 7.50 and Release 7.51 and hence can produce syntax errors. From Release 7.54, a syntax check warning is produced when this rule is broken outside of the strict mode too.