The new Open SQL statement WITH enables
general table expressions
(CTEs) to be defined for use in the WITH statement. A general table expression generates a results set that is used in the queries of the WITH statement as a data source. The
main query of the WITH
statement has an INTO clause and transfers its results set to ABAP data objects.
The addition ORDER BY PRIMARY KEY
of the SELECT statement can now
also be specified if a column is specified multiple times in the SELECT list, without the same name being blocked by alternative names.
The components of a replacement
object must no longer be in the same order as the associated components of the replaced database table or classic view.