CDS CLOUD query

[shashankagg]

Is there a way in S4 HANA CLOUD - Custom CDS views i should ignore the primary key i.e. COL2 from below screenshot from CDS and get highlighted record in green as output. Because due to COL2 i am getting 3 different rows whereas i want only single row based on COL1 and COL3.

[Tayane]

Dear Shashank,

When creating your Custom CDS View, have you tried to switch the "Key" button to off?

If your datasource allow this key field to be turned to "off", then you can simply turn it off and not use this element.

However, if it's mandatory by the datasource to have this field turned to "on" as a key, then it's not possible to not use this element.

Kind regards.