Skip to Content
0

CDS Key Problem

Dec 25, 2017 at 04:46 PM

168

avatar image
Former Member
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Horst Keller
Jan 01 at 04:51 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded