SAP CDS PATH EXPR JOINTYPE V2
Get Example source ABAP code based on a different SAP table
• INNER ABAP_CDS_PATH_EXPR
• LEFT OUTER ABAP_CDS_PATH_EXPR
ABAP_CDS_DDL - CDS View Entity, path_expr, join_type ABAP_SYNTAX ... INNER$|${LEFT OUTER$} ...
What does it do?
Defines the join type with which the current CDS association is implemented:
INNER determines an inner join
LEFT OUTER determines a left outer join
If the join type is not specified explicitly, the type depends on the place where the path expression is used:
After FROM, it is an inner join
In all other locations, it is a left outer join
Latest notes:
In the DDL source text editor of the ADT, you can view the configuration of the join in the display of the generated SQL DDL statement.
For the last CDS association of a path expression, the specification of a join type property is not allowed. If a path expression consists of one single CDS association, then the join type cannot be specified.
BEGIN_SECTION SAP_INTERNAL_HINT
Specifying the kind of the join expression when exposing an association in a SELECT list has no effect. Specifying the kind of the join expression does only make sense in positions, where the join is instantiated.
END_SECTION SAP_INTERNAL_HINT
NON_V5_HINTS
ABAP_HINT_END
ABAP_EXAMPLE_ABEXA
Joins of CDS Associations
ABAP_EXAMPLE_END
