Show TOC

Grouping and Deleting GroupsLocate this document in the navigation structure

Use
Caution

The function Grouping is not available on all ALV lists. It is only available of such lists that are filled from a fast In-Memory Database. It then includes the function Forming Subtotals.

An ALV list therefore offeres either the function Groupingor a separate toolbar icon for the function Forming Subtotals.

Procedure
Simple Grouping

  1. Select one or more columns. Ensure that the columns contain elements of type Attribute as it is not possible to group according to Key Figures.

  2. Choose Group.

    In this way the list is displayed in one step grouped according to the the column (or columns).

Alternatively:

You can also introduce a grouping to the list without selecting individual columns:

  1. Choose Group.

  2. In the following dialog box, on the right-hand side you are offered all of the possible columns for a grouping. Acceopt all required columens to the selection list on the left side.

  3. Using both of the selection buttons Sort Ascending and Sort Descending you can decide here about the column display.

  4. You finally decide using the Group Column checkbox if the sorted entries are to be displayed as groups or not:

    Display as ungrouped, sorted list:

    Display as grouped list:

    The list content is still displayed as a whole sorted according to the criteria that you have defined

    The list content is summarized according to the elements of the column that you have selected for the grouping. A header row is added for all elements of the grouping colums in which the number of the list lines that are below it is specified.

    By clicking on the relevant header row you open the node and all list elements are displayed for the grouping element.

    Note

    Groupings can be nested, you can select multiple columns for the grouping in dialog box 000.

  5. Confirm the dialog box.

Grouping with Formation of Subtotals

The result of this procedure corresponds to the Formation of Subtotals.

If you want to use the function Group with the formation of subtotals, you can first form a Total for one of more columns. You can only form the total after the grouping. The whole total is then also formed and displayed for every group header row.

The procedure corresponds more exactly to the simple grouping (see above).

Note

Groupings with subtotals can be nested, you can select multiple columns for the grouping in dialog box 000. The subtotals that are assigned to a group are displayed in the header row.

Delete Grouping

  1. Open the menu Group in the toolbar.

  2. Select the Delete All Groupings entry.

Alternatively:

  1. In the list, select a column.

  2. Open the relevant context menu, click the right mouse button.

  3. Select the Delete All Groupings entry.