Displaying Totals Records (SAP Library

Displaying Totals Records

Use

Totals record display is also used in Profit Center Accounting (EC-PCA). See Displaying Totals Records.

Procedure

Totals record display is found under Accounting ® Financial accounting ® Special Purpose Ledger®

Planning ® Display totals

Actual posting ® Display totals

Information system ® Reports for the Special Purpose Ledger ® Totals Record Display

To display totals records, proceed as follows:

Enter the name of the ledger for which you want to display totals records.

You can define the following:

In the output list, you can display totals records with a zero value. To do so, select Display zero records.
Under Settings..., you can directly select the totals records you want displayed.

You can enter a user table to display its data.
Under Variant for list, you can select a display variant for the output list. Included in the SAP Standard System are the display variants 0F_1 and 0F_2 for cost of sales ledger 0F.

Note

If you select a display variant, the totals records in the output list are automatically summarized. This means that totals records that match each other as to the displayed key fields are summarized and displayed as one totals record. With Restore, you can display the individual totals records.

You can also summarize the totals record when you select the data. To do so, select No individual records.

Note

If you use this function, you increase the performance when generating the output list. However, you cannot display the individual totals records using the restore function.

Under Maintain user table..., you can create or change a user table.

Choose Execute.

Selection screen

Enter your selection criteria.

Enter 0 as the record type to display actual data and 1 to display plan data.

You are also able to display archived totals records.To do so, choose Extras ® Data Source and select Archive, For further information, choose the "i" button.

Choose Execute.

Output list

The totals records you selected are displayed in the output list.

The amounts and totaled amounts are displayed for all currencies kept in the ledger. The amounts are totaled for the posting periods you selected. The totaled amounts consist of the amounts from previous periods and the balance carried forward (period 0).

Example

If you select posting periods 2 to 4 in the selection screen, the totals of periods 2 to 4 are displayed as well as the total of periods 0 to 4.

In the output list, you can:

You can edit the output list by using display variants, by displaying or suppressing columns, or by forming totals. The functions of the ABAP List Viewer are available for this. You can find additional information on the functions of the ABAP List Viewer under SAP List Viewer (ALV): Classic.

If you suppress individual key fields in the output list, the summarize function is activated. This allows you to summarized the remaining totals records that have the same key fields. With Restore, the summarization is reversed.

You can display long texts for the dimensions account number, cost center, business area, profit center, and functional area.

From the output list, you can access the following information on the individual totals records:

Period breakdown: You can display period information for an individual totals record. To do so, double-click the totals record.

Line items: You can display the original document lines of a totals record if the document lines are stored in a line item table. To do so, double-click the totals record in the period screen.

Note

You can only display a document in FI-SL if the document lines are stored in the line item table or in the source application database (if the document was posted to FI-SL from another application).