Skip to Content
0
Former Member
Nov 27, 2017 at 11:47 AM

ABAP CDS view - flatten structure

295 Views

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

Attachments

question.png (143.9 kB)