SE11 Aggregation

[Former Member]

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

654 XYZ

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

[ThomasZloch]

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

[Former Member]

thats pretty cool!

how can i display hte subtotals only?

[ThomasZloch]

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

[matteo_montalto]

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.