Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

CDS Views : how to delete the duplicates entries

former_member1059510
Explorer

‎2022 May 18 5:35 PM

0 Kudos
1,229

Hello everyone,

I have created a CDS-View joining 4 tables. I amunfortunately getting duplicate-keys entries. I tried to use a grou by on the key fields but I am getting a compilation Error saying that I need to use all the fields in the Groupby, I find this, not ogical. Should I do so (use all the 25 fields in the Group by)in order to delete the dplicate-Keys entries ?

Kind Regards,

Hatem.

1 REPLY 1

Sandra_Rossi
Active Contributor

‎2022 May 18 6:41 PM

0 Kudos
718

For information, concerning GROUP BY, you need to indicate all non-aggregated selected columns, it's SQL basics and it has been like that forever.

You may search the forum/SAP Web site with your favorite Web search engine. I see many answers for search below. Based on the results, if it still doesn't solve, you may anyway refine your query/provide more information. 

CDS view delete duplicates site:sap.com

I can find very interesting solutions.