Creating Totals for Line Items

Use

In the line item display, you can summarize items according to various criteria and create totals.

The criteria are defined in the system in the form of totals variants.

Prerequisites

The SAP standard system contains totals variants. You can change them or create your own.

To change a totals variant, or define a new one, proceed as follows in Customizing for Start of the navigation path Financial Accounting; General Ledger Accounting/Accounts Receivable and Payable Next navigation step G/L Accounts/Customer Accounts/Vendor Accounts Line Items Display Line Items (without ALV) Define Totals Variants End of the navigation path .

Features

You have the following options for creating totals for line items:

You can create totals for the line items according to a field that you select from the line item display (for example, document type). Place the cursor on the column required and select .

Subtotals are then created for all currency amounts that appear in the line layout.

You can create totals for the line items according to other criteria that do not appear in the line item display (for example, document type/posting key). Place the cursor outside the line item display and select .

You can select a totals variant (for example, document type/posting key), and specify whether you want to sort in descending order. To do this, select Descending .

When you select a totals variant, the system creates subtotals for the first key of the totals variant. You have the following options when displaying the totals:

Select a specific set of line items in the first list level by clicking on the required line item.

For example, if the totals variant is Document type/Posting key , place the cursor on a document type (for example, AB , general document) and then choose Start of the navigation path Goto Next navigation step Next list level End of the navigation path . The system then displays the subtotals for all documents by posting key within the document type AB .

To display both the debits and the credits that make up a subtotal, choose Settings Debit/Credit On .

If you want to see the posted documents in another currency, choose Settings Display currency.

The document currency, the local currency, and any parallel local currency defined for that company code are displayed . If you select the local or group currency as an additional local currency, the posted totals are displayed in this currency.

For more information about currencies in the line item display, see Selecting Currencies

To display valuated amounts in local currency, choose Settings Display c urrency Local currency (valuated amounts) .

Note Note

However, this is only worth doing if you have first valuated the items with the valuation program.

End of the note.

To return to a previous level, choose .

To return to the line item list from the totals display, choose Line items .
To go to a subtotals list, choose Line items and subtotals .

The system displays the line items for which a total has been created in a list in list levels according to the criteria that you specified.

The system notes these list levels and you can display them from any line item display. For more information, see Displaying List Levels .