Ansicht
Dokumentation

ABENABAP_SQL_PATH_RESTRICTIONS - ABAP SQL PATH RESTRICTIONS

CL_GUI_FRONTEND_SERVICES - Frontend Services   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

- Restrictions for Path Expressions

In principle, the same restrictions apply to path expressions in and the CDS associations or CTE expressions used there as to using a corresponding join expression. For example, a path expression cannot be used together with the addition ORDER BY PRIMARY KEY. These restrictions are documented in the corresponding clauses. The following restrictions currently also apply:

• Requirements on the CDS entities or common table expressions

• The association targets of the associations of a path expression cannot be DDIC database tables or DDIC database views with replacement objects.

• No literals with prefixed #domain or :domain can be used in the CDS associations of the path expression to check the fixed value in the value range of a domain.

• Due to implicit client handling, no associations can be used whose ON condition accesses the client columns of their association source or association target. This cannot be bypassed using the obsolete addition CLIENT SPECIFIED either.

• Requirements on

• If a value greater than to 1 is defined for the cardinality of an association of a path expression in the FROM clause for max, the identical path expression must also be specified in the SELECT list.

• If the addition CORRESPONDING or an inline declaration @DATA$|@FINAL(...) is used in the INTO clause of a SELECT statement, columns of the SELECT list specified using a path expression must have an alias name alias defined using AS.

• A data source specified as a path expression in the FROM clause can be used in the SELECT statement only by using an alias name tabalias defined using AS in front of the column selector ~.

• The obsolete addition CLIENT SPECIFIED cannot be used together with path expressions containing CDS associations whose association target is client-dependent. In path expressions in the FROM clause, the association sources of the associations cannot be client-dependent either.

• The addition USING CLIENT and the obsolete addition CLIENT SPECIFIED cannot be combined with path expressions containing CDS associations or CTE associations that are exposed by common table expressions.

• If the alias name tabalias is specified statically using AS when the FROM clause source_syntax is specified dynamically, no path expressions can be used here.

• Path expressions cannot be used in the ON condition of a join expression.

• In SELECT statements, path expressions cannot be used together with the additions FOR ALL ENTRIES or WITH PRIVILEGED ACCESS.

Note

Fewer restrictions apply to the path expressions path_expr in the ABAP CDS CDS DDL. If CDS association reads are required that are possible in ABAP CDS but not in , they can be moved to a CDS view entity.

PERFORM Short Reference   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 6801 Date: 20240419 Time: 235033     sap01-206 ( 72 ms )