Skip to Content
Former Member
Aug 13, 2015 at 12:29 PM

CDS associations - please help


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?


Untitled1.jpg (65.3 kB)
Untitled2.jpg (64.7 kB)
Untitled3.jpg (160.4 kB)