ABAP CDS view - flatten structure

[Former Member]

Hi Experts

Please see the picture below. I have a table with a typical "account layout" (SAP table is BP3010). What I want do do is to flatten the two lines into one record. On the right hand side you can see the result I get now (two lines). I get two lines because I have to include GRP_TYP and GRP to the GROUP BY of the select statement. Can I use come kind of aggregation function for create just one record and not two? I tried to use MAX but that didnt work. Any suggestions on how to achieve this?

Kind regards

Erik

[Sathya_Gunasekaran]

Use INNER JOIN on same table using partner as key.