topic Re: SE11 Aggregation in Application Development and Automation Discussions

SE11 Aggregation

Former Member — Thu, 02 Sep 2010 14:45:50 GMT

Hi,

in SE11 Table view I see 4 rows. in layout i changed the view so that i can see only partner and adress:

PARTNER ADRESS

654 XYZ

653 XXX

Is there a possibility to build an aggreagt over them? Or to hide the dublicates?

I want to see only:

PARTNER ADRESS

654 XYZ

653 XXX

Edited by: Ezachiael leaihcaze on Sep 2, 2010 4:49 PM

Re: SE11 Aggregation

ThomasZloch — Thu, 02 Sep 2010 14:58:11 GMT

If there is a an additional column holding an amount or number field, you could try a workaround by displaying a sum over the amount field, sort by partner and address then build subtotals over partner and address, finally display the subtotal records only.

You will probably need to switch to ALV Grid layout in the user parameters.

Thomas

Re: SE11 Aggregation

Former Member — Thu, 02 Sep 2010 15:31:13 GMT

thats pretty cool!

how can i display hte subtotals only?

Re: SE11 Aggregation

matteo_montalto — Thu, 02 Sep 2010 15:36:24 GMT

hello,

try to switch from SE16 standard view mode to ALV grid, selecting just the field you'd like to use (Settings-> user parameters -> ALV grid display). Then select the heading columns you need to aggregate (CTRL+ left click on each table column heading) and press a SORT button (ascending or descending, it's the same) This will aggregate same data for both fields you selected.

Re: SE11 Aggregation

ThomasZloch — Thu, 02 Sep 2010 15:48:20 GMT

The values in the sort columns have some handle on the right for expand/collapse, try clicking these. You can collapse everything by clicking in the very last total line, then you should expand again up to the partner column.

Thomas