topic Re: CDS view group by fields in Application Development and Automation Discussions

CDS view group by fields

Rashmits — Fri, 26 May 2023 23:29:34 GMT

Hi There,

Should the number of columns/fields be same in select and 'group by' for a CDS view, getting below error when grouping by required fields. Trying to get the unique record based on STLNR and IDNRK from STPO table.

Re: CDS view group by fields

junwu — Sat, 27 May 2023 02:09:38 GMT

yes, I think that is basic sql syntax

Re: CDS view group by fields

Rashmits — Sat, 27 May 2023 02:12:28 GMT

If i have multiple joins/associations with too many columns, all of them have to be in group by clause?! even the text field?

Re: CDS view group by fields

junwu — Sat, 27 May 2023 02:17:24 GMT

you can just try, the compiler will tell u.

and yes, all needs to be there or you have to use aggregation function for those fields not presented in group by