Start of Content Area

Procedure documentation Creating Subtotals  Locate the document in its SAP Library structure

Use

You can create subtotals in one or more columns in the list that are not value columns. This function is also available for fields that are not in the list.

You can create subtotals in sequential lists for column headers but not, however, for their subordinate rows.

Example

In the order selection of Product Cost Controlling you can calculate a total of the actual costs of all manufacturing orders. You can then show the actual costs broken down into materials by forming subtotals across the material numbers.

Prerequisites

Before you can create a subtotal, you must have created a total for at least one column (see Displaying and Deleting Sums).

Procedure

Creating Subtotals for One Column

  1. Select the columns for which you require subtotals by clicking on the column header.
  2. Choose Subtotal or Edit ® Subtotal.

Creating Subtotals for More Than One Column

  1. Choose Subtotal or Edit ® Subtotal. The dialog box Define Sort Order appears.
  2. The dialog box Define Sort Order shows the fields you can create subtotals on. Fields are also available that are not shown in the list.
  3. You can limit the fields available in the list (field catalog) by choosing a field group that contains the desired fields.
  4. To select fields for subtotaling, select the relevant rows and choose Show selected fields (arrow key). The selected fields then appear in the dialog box as sorting fields.
  5. The sequence in which the selected fields are shown in the dialog box determines the sequence in which subtotals are created. To change the sequence of the fields, use the functions Cut and Paste.
  6. Specify whether the rows on which a subtotal is calculated are to be sorted ascending or descending. Also set the indicator for subtotals.
  7. Exit the dialog box with Copy.

Deleting Subtotals

You delete subtotals as follows:

  1. Choose Subtotal or Edit ® Subtotal. The dialog box Define Sort Order appears.
  2. The dialog box Define Sort Order shows the fields that were selected for subtotaling.
  3. To delete the calculation of subtotals for individual fields, select the corresponding rows in Sorting Fields in the dialog box, and choose Hide Selected Fields (arrow key). The selected fields then appear in the dialog box under Field List.
  4. Exit the dialog box with Copy.

Note

Depending on the list, the subtotals rows may contain information in addition to that of the summation level, if a number of stars ("*") are shown. The texts can only be viewed if the lead column was wide enough when it was selected in the current layout (see Changing Layouts).

There is no specific text for the first column of the list. The content of the columns that were totaled is always repeated.

 

Depending on the list, the subtotals can also be shown above the subtotaled rows. This is only possible with single-level lists.

 

The list status function gives you an overview of the fields for which subtotaling was defined.