Skip to Content
avatar image
Former Member

CDS Key Problem

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 01 at 04:51 PM

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

    Add comment
    10|10000 characters needed characters exceeded