topic CDS - Primary key in Application Development and Automation Discussions

CDS - Primary key

former_member182337 — Tue, 26 Apr 2016 05:08:44 GMT

hi,

I have created a CDS view but the problem in that is all fields defined are marked as primary key. I have defined the "key" for only the first two fields but the other four fields are set as primary as well. How to avoid it?

Regards,

Prem

Re: CDS - Primary key

thomasgauweiler — Tue, 26 Apr 2016 06:11:04 GMT

Hi Prem,

Are you talking about the display of keys in SE11 ? You should just ignore it. For CDS only your marked keys are keys!

Regards, Thomas

Re: CDS - Primary key

former_member182337 — Tue, 26 Apr 2016 06:41:58 GMT

Hi Thomas,

Thank you but it is confusing though. Isn't there any workaround to avoid it?

Re: CDS - Primary key

thomasgauweiler — Tue, 26 Apr 2016 07:23:07 GMT

Yes: do not use SE11 any more

The information visible there is missleading in several cases.

E.g. CDS views with unions will have each field twice in SE11.