ABAP Keyword Documentation →  ABAP Dictionary →  ABAP CDS in ABAP Dictionary →  ABAP CDS - Views →  ABAP CDS - DDL Statements →  ABAP CDS - DEFINE VIEW →  ABAP CDS - SELECT →  ABAP CDS - SELECT, Operands and Expressions →  ABAP CDS - cond_expr 

ABAP CDS - cond_expr, ON, Join

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

• The relational operator IS [NOT] NULL is not allowed.

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

• A field of one of the two data sources data_source of the join, a literal or a parameter can be specified for rhs.

• 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