Skip to Content
avatar image
Former Member

ABAP CDS view - flatten structure

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

question.png (143.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 27, 2017 at 12:02 PM

    Use INNER JOIN on same table using partner as key.

    Add comment
    10|10000 characters needed characters exceeded