Skip to Content
0

ABAP CDS view - flatten structure

Nov 27, 2017 at 11:47 AM

29

avatar image
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

question.png (143.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sathya Gunasekaran Nov 27, 2017 at 12:02 PM
0

Use INNER JOIN on same table using partner as key.

Share
10 |10000 characters needed characters left characters exceeded