CDS Key Problem

Former Member — Mon, 25 Dec 2017 16:46:25 GMT

First CDS

{
t.etkno,
sum( t.menge ) as menge
}
where
(
(t.gnkod = 'ASD' and t.statu = '1')
or
(t.gnkod = 'QWE' and t.statu = '2')
)
group by t.etkno

Hi,

I have a problem with the key.

I made 2 cds;

In first cds, I used sum and group by so it will collect menge for each label.

The other cds collect many fields on many tables and menge in the first cds.

I have put menge at the end of cds but cds creates a key for all fields till menge.

How can I fix this problem?

Can someone help me?

Thanks in advace.

Re: CDS Key Problem

retired_member — Mon, 01 Jan 2018 15:15:42 GMT

Yes, in the documentation

Re: CDS Key Problem

retired_member — Mon, 01 Jan 2018 16:51:31 GMT

Open the Documentation , search for KEY, select the CDS hit, find the appropriate annotation AbapCatalog.preserveKey ...

topic Re: CDS Key Problem in Application Development and Automation Discussions

CDS Key Problem

Re: CDS Key Problem

Re: CDS Key Problem