Drill-Down to Rollup Line Items as of Release 3.0 (SAP Library

Drill-Down to Rollup Line Items as of Release 3.0

Description

With Release 3.0, you can use the drill-down function to display the source (unsummarized) data in a Report Writer report which reports on (summarized) rollup data.

Example:

The accounts 101000, 102000 and 103000 are summarized to account 100000 using a rollup. After that a report for the rollup ledger is defined, which (after the rollup has been executed) displays the data for account 100.000. Using the drill-down function, it is now possible for you to display how the data originated for account 100.000. The drill-down report would in this case list the data for accounts 101000, 102000 and 103000.

This example serves as an illustration. You can of course display the original data of several substituted or completely summarized fields.

Rollup-Summary Report Drill-Down-Report (100.000)
--------------------------- ---------------------------------
!Account 100.000 ! 100.- ! -----> !*Account 100.000 ! 100.- !
!Account 200.000 ! 200.- ! ! Orig. Accnt 101.000 ! 50.- !
!Account 300.000 ! 300.- ! ! Orig. Accnt 102.000 ! 30.- !
--------------------------- ! Orig. Accnt 103.000 ! 20.- !
---------------------------------

Prerequisites for the drill-down function

1. Defining and installing rollup line item tables
During the rollup execution, the original information (that is, the information on how the rollup record originated) is transferred to the allotted original fields in the rollup line item tables (see below for a detailed description). For this reason, these special rollup line item tables must be installed in the Special Purpose Ledger system. (SL Configuration menu -> Environment -> Tables -> Installation -> With object table).

It is not yet possible to automatically define rollup line item tables definition using the Special Purpose Ledger table definition. For this reason, it is recommended that you copy the delivered table examples GLREFU (rollup line item table) and GLREFV (rollup plan line item table) and adapt them according to your requirements.
The original fields of the rollup line item tables are automatically filled according to the following logic when the rollup is executed:
All fields beginning with the letter 'R' in the summary table to be rolled up, are transferred to the respective original field which begins with the letter 'U' (for example, RACCT -> UACCT, RLDNR -> ULDNR). All fields beginning with the letter 'S' are transferred to the respective original field, which begins with 'V' (for example SACCT -> VACCT, SCNTR -> VCNTR). All remaining fields, provided that their names are less than 10 characters long, get a 'U' placed in front (for example DRCRK -> UDRCRK). If the field names are 10 characters long, the first letter is replaced with a 'U' (for example ZZKUNGROUP -> UZKUNGROUP).
You must take this logic into consideration when defining tables for the field movement to the special original fields fo the rollup line item tables, otherwise you cannot perform the required drill-down.

1. Writing line items in the rollup execution
When executing a rollup, line items must always be written. If line items are not written, the drill-down report will inevitably produce inaccurate results. For this reason, it is advisable that you activate the indicator 'Write line items' ('Processing optn' button) directly in the rollup definition.

2. Defining the rollup report and the drill-down report
If you want more information regarding the steps involved for defining these reports, refer to the relevant Report Writer documentation. The following only refers to drill-down-specific points.
You must enter a valid report set for the report/report interface when defining the report group of the 'normal' rollup report. This set is used to call up the corresponding drill-down report after you have selected a section of the report in the rollup report. The corresponding original information will be displayed.
When defining the drill-down report (which corresponds to a 'normal' line item report), you must make sure that only the valid data set entries for the rollup line item tables are used (for example, RBHSL-0 for rollup-document-local currency-actual). These data set entries are automatically created during the installation of the rollup line item tables.

Further notes

Drill down to actual and planning data
For technical reasons it is not possible to simultaneously execute a drill-down to both actual data and planning data. That is why two different reports need to be defined in order to display the actual line items and plan line items.

Displaying the rollup line items using the summary record or document display
Rollup line items are only relevant for rollups and Report Writer and cannot be displayed using the above mentioned functions.

Reversing rollup line items
Rollup executions, that have written line items to the rollup line item tables can be reversed, analogue to the usage of the conventional line items.

When writing line items you must pay attention that the conventional line item tables and the rollup line item tables do not get mixed up because when you activate one type of table, you can no longer access the other type of table.