In CDS view How merge multiple row line data into single line?

[former_member231869]

Hi ,

Please see the attachment screen shot.

[gasparerdelyi]

I wonder if you are looking for something like this:
https://answers.sap.com/questions/12944133/concatenate-multiple-row-value-into-single-column.html

[ThorstenHoefer]

Hi panther.williams,

if you have only one value for each key, you can use the max aggregation. In open sql, it's works also for characteristic fileds. But keep in mind, what's happens if you have two values for the key material and batch? In these case, you will ignore the lower value.

select
  a~material
, a~batch
, max( b~value_1 ) as value_1
, max( b~value_2 ) as value_2
from
 table a
  left outer join on b
  where b~material = a~material
    and b~batch = a~batch
    group by a~material, a~batch
<br>