SAP CDS PATH EXPR JOINTYPE V1



Get Example source ABAP code based on a different SAP table
  


• INNER ABAP_CDS_PATH_EXPR_V1
• LEFT OUTER ABAP_CDS_PATH_EXPR_V1

ABAP_CDS_DDL - DDIC-Based View, 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 (INNER JOIN)
In all other locations, it is a left outer join (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.
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