CDS associations - please help

[Former Member]

What is the purpose of the new 1: addition before a filter condition?

For illustration purposes, i've created a 1 to many association between Articles and Units of Measure.  (Tables MARA & MARM).  Then, I created another view to 'consume' the association.  No problem, but I get the following warning:  Association uoms can influence the cardinality of the resulting set.  (see exclamation marks in yellow triangles):

OK, fix that using the 1: addition, and the warning goes away:

My expectation now is a 1 to 1 association between Article and Units of Measure, but the result set is still 1 to many.  What then does the  1: addition mean?  

[Former Member]

What is the purpose of the new 1: addition before a filter condition?

For illustration purposes, i've created a 1 to many association between Articles and Units of Measure.  (Tables MARA & MARM).  Then, I created another view to 'consume' the association.  No problem, but I get the following warning:  Association uoms can influence the cardinality of the resulting set.  (see exclamation marks in yellow triangles):

OK, fix that using the 1: addition, and the warning goes away:

My expectation now is a 1 to 1 association between Article and Units of Measure, but the result set is still 1 to many.  What then does the  1: addition mean?  

[pfefferf]

Hello Eric,

with "1:" you can define that the association is monovalent because of the filter (to avoid syntax errors). But during runtime it is not checked that it is really monovalent.

For more information have a look to the online documentation ABAP CDS - 1:.

Best Regards,

Florian