Displaying Totals Records

Use

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

Procedure

Start of the navigation path Totals record display is found under Accounting Next navigation step Financial accounting Next navigation step Special Purpose Ledger End of the navigation path

  • Start of the navigation path Planning Next navigation step Display totals End of the navigation path

  • Start of the navigation path Actual posting Next navigation step Display totals End of the navigation path

  • Start of the navigation path Information system Next navigation step Reports for the Special Purpose Ledger Next navigation step Totals Record Display End of the navigation path

To display totals records, proceed as follows:

  1. 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 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.

End of the note.

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

Note 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.

End of the note.

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

  1. Choose Execute.

Selection screen

  1. 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 Start of the navigation path Extras Next navigation step Data Source End of the navigation path and select Archive , For further information, choose the "i" button.

  1. Choose Execute.

Output list

  1. 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 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.

End of the example.

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 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).

End of the note.