CDS view group by fields

[Rashmits]

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.

[junwu]

yes, I think that is basic sql syntax

[Rashmits]

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

[junwu]

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