ABAP Keyword Documentation →  ABAP - Dictionary →  ABAP CDS in ABAP Dictionary →  ABAP CDS - Data Definitions →  ABAP CDS - DDL for Data Definitions →  ABAP CDS - DEFINE VIEW →  ABAP CDS - SELECT →  ABAP CDS - SELECT, Operands and Expressions →  ABAP CDS - cond_expr →  ABAP CDS - cond_expr, Operands 

ABAP CDS - cond_expr, ON, Join

Rules for conditions cond_exp in an ON condition of a join of a CDS view:

• All relational operators are allowed.

• lhs expects a field of the data source data_source that represents the left side of the join.

• A field of both data sources data_source of the join, a literal with optional domain prefix, a parameter, a session variable, or a built-in function can be specified for rhs (with the exception of the operator LIKE).

• At least one comparison for equality between a field of the left data source and a field of the right data source of the join must be performed.

• No path expressions or other expressions or function calls can be specified.

Other versions: 7.31 | 7.40 | 7.54