Rollup 

Purpose

A rollup is used to determine how data is "rolled up" (i.e. summarized) from several source ledgers into a single rollup ledger. Since you can use several different ledgers in FI-SL, you can have different levels of detail and/or different dimensions. Some ledgers may contain too much detailed information or irrelevant dimensions for some cumulative reports; you can summarize this information in a rollup ledger.

Implementation Considerations

If you only want to run a report once, it is more efficient for the Report Writer to summarize the data. However, if you must select the same data for your report more than once, the report data should be summarized in a rollup ledger. You can use rollup ledgers to improve system performance when you are creating reports.

Integration

With the rollup, you can process data both from other SAP application components as well as from external systems. A rollup ledger is the summarization of information from one or more ledgers (source ledgers) into a single ledger. The following graphic shows the data from several source ledgers being summarized in one rollup ledger.

To summarize data in a rollup ledger, you have to define a rollup. Before you can create a rollup, you must first define a ledger as a rollup ledger. In Customizing for Special Purpose Ledger, you activate the Rollup allowed indicator in the ledger definition to define whether you can rollup data into the ledger. For more information about defining ledgers and ledger classes, see the Implementation Guide (IMG) under Special Ledger ® Basic Settings ® Master Data ® Maintain Ledger.

Features

You can use sets in rollups.

With field movement, you can define which fields are to be transferred from a sender table to an FI-SL receiver table.

You can also define whether a rollup should update the line item database.

By defining the rollup type, you define how the data is to be summarized.

You can use user exits to call up other programs.

Using Application Link Enabling (ALE) and IDoc, you can transfer FI-SL ledger data across separate SAP systems.

You can drill down to data in rollup line items in the source ledger.

When you create a rollup (rollup header and rollup sequence), you define how data is to be selected from the sender table, summarized in the rollup and posted to the receiver table. For more information, see:

You can check, document, display, change and reverse and execute the rollup. You can also execute a rollup in the background.

Example

If you want to create a report that only uses account data from a source ledger containing 100 different accounts and 100 different cost centers for each account, the system has to read at least 10,000 totals records (100 accounts * 100 cost centers). This report would take an extremely long time to process. To improve system performance, you can summarize the account data from the source ledger(s) into a rollup ledger that contains only 100 totals records (one totals record for each account). The rollup summarizes the cost center values for each account into one totals record for all cost centers.

 

To roll up data into FI-LC, the companies into which data is rolled must have the data transfer indicator O (rollup from FI-SL; you set this indicator in FI-LC Customizing). For more information about setting these parameters in Customizing, see the Implementation Guide for Special Purpose Ledger.