Concatenate multiple rows in one row in CDS views

[msadik]

Hi everyone;

is it possible to concatenate data in one column from multiple lines into one row in CDS views.

for example

vbak

vbeln : 1000000001

vbeln : 1000000002

vbap

vbeln : 1000000001 posnr : 000010

vbeln : 1000000001 posnr : 000020

vbeln : 1000000001 posnr : 000030

vbeln : 1000000002 posnr : 000010

view

vbeln : 1000000001 posnr : 000010 - 000020 - 000030

vbeln : 1000000002 posnr : 000010

is it possible with CDS views

thanks

[msadik]

hi everyone;

the answer is here thanks to Andrei Bohus

[former_member225688]

The link is not working can you please help ?

[former_member200447]

Hi,

I have the same issue, the link is not working.

regards

Oddmar

[san_kumar2]

https://blogs.sap.com/2019/07/16/transpose-or-merge-multiple-rows-in-one-row-cds-views/

Check this link