ABAP CDS view - flatten structure

Former Member — Mon, 27 Nov 2017 11:47:34 GMT

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

Re: ABAP CDS view - flatten structure

Sathya_Gunasekaran — Mon, 27 Nov 2017 12:02:00 GMT

Use INNER JOIN on same table using partner as key.

topic ABAP CDS view - flatten structure in Application Development and Automation Discussions

ABAP CDS view - flatten structure

Re: ABAP CDS view - flatten structure