Chapters:
0:00 Intro Association with multiple tables
13:26 Path Expression basic
23:40 Path Expression filter condition
28:18 Multiple joins from the same association
32:56 Path Expression Inner/left outer join
35:32 Path Expression Cardinality
38:17 Summarisation
***********************************************************
SQL path expression Definition :
A path expression of the CDS DDL is a sequence of CDS associations
separated by periods (.)
Source._assoc1(p1,p2)._assoc2(attribute).field
Attribute :-
Cardinality [1:filter condition/join]
The addition 1: or *: cannot be specified as the only addition in square
brackets.
It must always be combined with a filter condition.
Addition 1: prevents a syntax error if a path specified with filter conditions
Join type implemented when used
INNER determines an inner join
LEFT OUTER determines a left outer join
◾Filter conditions
If the join type is explicitly defined with INNER|{LEFT OUTER},
the addition WHERE must be specified explicitly
Code
saptechnomaniac.blogspot.com/...
Негізгі бет Ғылым және технология Path Expression in CDS association PART 12 ABAP on HANA Course
Пікірлер: 16