2023 May 27 12:29 AM
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.
2023 May 27 3:09 AM
2023 May 27 3:12 AM
If i have multiple joins/associations with too many columns, all of them have to be in group by clause?! even the text field?
2023 May 27 3:17 AM
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