Skip to Content
0

ABAP CDS view Association in HANA - Cardinality

Mar 11 at 05:02 AM

167

avatar image

Hi I am trying to get a better understanding of using Cardinality syntax during an association while creating the CDS view.

In this process, I would like to know, how the view is going to provide the out put differently for the below cardinality definition. My tables to be used in this association are CSKS (attributes- Cost Center) and CSKT (Text - Cost Center).

[0..1]

[0..*]

[1..1]

Please provide me with an example, that would help a lot. I have gone through sap help documentation, but still not clarified.

https://help.sap.com/doc/abapdocu_740_index_htm/7.40/en-US/index.htm?file=abencds_path_expression_attr.htm

Thanks

Sreekanth

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Horst Keller
Mar 11 at 03:55 PM
0
Share
10 |10000 characters needed characters left characters exceeded
Sreekanth Surampally Mar 13 at 03:44 AM
0

Thanks Horst, now I understood that, cardinality [0..1] or [1..1] are Left outer joins to the Target table. With this specification, if no field from right table is selection in the view definition, join does not occur. With the other cardinality [0..*] or [1..*] the join will definitely occur though i did not select any fields from right table and also I can't use target object columns in where condition is my understanding correct?

if my association is formed as Inner join, because of overriding option with attribute, the above cardinality rules still work as same as in above right?

Thanks

Sreekanth

Share
10 |10000 characters needed characters left characters exceeded