ABAP SQL in ABAP Release 7.58 - ABAP Keyword Documentation

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

ABAP SQL in ABAP Release 7.58

1. ABAP SQL Expressions on the Right Side

2. New Cardinality Syntax for Joins

3. Access to Multiple Internal Tables

4. New Addition PRIVILEGED ACCESS

Modification 1

ABAP SQL Expressions on the Right Side

ABAP SQL expressions can be defined on the right side of a condition enclosed in parentheses.

Modification 2

New Cardinality Syntax for Joins

A new syntax for specifying the cardinality of joins is available:

{MANY | ONE | {EXACT ONE}} TO {MANY | ONE | {EXACT ONE}}

This syntax allows specifying a source and a target cardinality, while the previously available numeric syntax only allowed specifying the target cardinality. The new cardinality syntax can be used to improve query performance. It can also be used in SQL path expressions and CTE associations.

Modification 3

Access to Multiple Internal Tables

It is now possible to process multiple internal tables accessed with FROM @itab within one ABAP SQL statement with the ABAP SQL engine. Currently, this is restricted to joins of internal tables where no database tables are involved.

Modification 4

New Addition PRIVILEGED ACCESS

With the new addition PRIVILEGED ACCESS, CDS access control can be disabled for a complete SELECT statement.