Path Expression and Filters in ABAP CDS

[former_member594288]

Hi,

I am new to cds, can anyone please give me some explanation for Path Expressions and Filters in Associations and i have gone through some posts but it's not clearing my doubts like Filters are like where conditions, if it is like where condition then why we need path expression.

[maheshpalavalli]

You can do that with filter as well, but one specific advantage I think of is, using one single association and reusing it multiple times inside the select clause, which is not possible when you pass as a filter,

for e.g.,

... _assoc{
...
_assoc[ filter1 ].as test1,
_assoc[ filter2 ].as test2,
...
}

If you are not using path expressions, then you have to define two associations on the same table/view.

[Sandra_Rossi]

Did you read the documentation?

[maheshpalavalli]

sandra.rossi, thanks for the link.. I was searching for that and all I could find was abap select on cds path expressions..