Carrying out Drill Downs on Rollup Line Items 

Use

You have the option of carrying out a drildown to the rollup line item data in the source ledger. You do this using a Report Writer report that you define for the rollup ledger.

With larger data quantities, this function causes a huge increase in processing time. If you set the Write line items indicator, the system writes line items to the line item database.

If you do not plan to reverse the rollup or drill down to rollup line items in a report created for the rollup ledger (or if you are rolling up large quantities of data), you should leave the Write line items indicator blank to avoid unnecessary database updates and increased runtime.

Procedure

  1. Define and install rollup line item tables.
  2. Data of the source ledger is saved in special rollup line item tables. It is not currently possible to automatically install these tables using the FI-SL Define Table Group functions. You should copy the standard example tables delivered with your system (GLREFU: rollup actual line item table and GLREFV: rollup plan line item table), and modify them according to your requirements.

    For more information about installing rollup line item tables, see the Implementation Guide (IMG) for Special Purpose Ledger.

  3. Write line item records when you execute the rollup.
  4. To display the original data, line item records, which contain the original data, must be written when the rollup is executed. If no line item records are updated, the drilldown report will display incorrect data.

    To update rollup line items, set the Write line items indicator in the rollup definition (Processing optn indicator).

    For more information, see Creating Rollups.

  5. Create the rollup report and the drill-down report.

For more information, see Creating a Report Painter Report.

To carry out the drilldown, use the Call up report function. You must therefore define the drilldown report as a receiver report in the rollup report’s report group. The drilldown report is called up via the report/report interface when you select an area of data in the rollup report.

The drill-down report is similar to a standard line item report, but you can only use data set entries defined for the rollup line item tables when you create the report (for example, RBHSL-0 for rollup documents in local currency for actual data).

For more information on using the Call up report function, see Functions in the Report Output

It is not currently possible to drill down to both actual and plan data in a rollup report. You must therefore define two separate reports for displaying actual and plan rollup line items.

The rollup line items are only relevant for rollups and the Report Writer. You cannot therefore display rollup line items using the summary record and document display functions.

The reversal function can be used both with the ‘normal’ line item tables and with the special rollup line item tables. When writing line item records, the system checks if rollup line item tables are defined. If so, the line item records are written to these tables. If no rollup line item tables are defined, the line item records are written to the ‘normal’ line item tables.

Example

The accounts 101000, 102000 and 103000 are summarized into account 100000 using a rollup. A Report Writer report is defined for the rollup ledger. Data for account 100000 is output in this report after the report group is carried out.

Using the drilldown function, you can display the original posted data that makes up the total for account 100000.

If the following graphic, you can see the drill down report for account 100000. The report contains the data of the source ledger for accounts 101000, 102000, and 103000.

In the report for the rollup ledger, the data for accounts 101000, 102000 and 103000 is summarized and substituted into account 100000 and the cost center data is summarized and included in the records for the accounts.