SAP CDS concat form different lines

[hassin]

Hallo,

I'm looking for for solution where I can put two (string) different Information from different lines in one cell.

For example we have this DB:

Column1 Column2

AAA xxx

BBB yyy

AAA zzz

Result should be:

Column1 Column2

AAA xxxzzz

BBB yyy

Thanks for your help!

[Cocquerel]

Hello,

the function STRING_AGG should do the job

see https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/a924ee1e98ab435a874efa3...

Regards,

Michael

[hassin]

Hello,

thanks for the feedback. Unfortunately this solution works only in the SQL statements and not in CDS-Views.

Regards

Hassin

[Cocquerel]

did you try in an ABAP CDS Table function that you can then call from a CDS View ?