Drilldown Reporting  

Use

You can use the drilldown reporting tool to evaluate summary tables. You can define and print reports.

Integration

You can process data from various SAP components.

Prerequisites

To be able to evaluate a summary table using drilldown reporting, you need to have activated it for drilldown reporting. To do this, go to Customizing for the Special Purpose Ledger and choose Information System → Drilldown Reports → Use Drilldown Reporting → Activate Drilldown Reporting for FI-SL Tables.

Features

You can create the following reports:

·        Account balances

·        Financial statement reports

·        Line item reports called up from the totals report

·        Flexible reports on the SAP account assignments and the customer-specific additional account assignments.

·        Average balance reports (reports for displaying average balances)

To create reports for average balances, you have to run a day ledger (a summary table with 366 periods that contains the original general ledger postings) and activate it for drilldown reporting. SAP delivers two example reports for average balances: The drilldown reports ADBREPORT-1 and ADBREPORT-2. For more information, see SAP note 599692.

However, the evaluation of summary tables with drilldown reporting is restricted as follows:

·        You can only evaluate one ledger.

·        You can only report using the second or third currency (usually the local or group currency) and one quantity (no additional quantity).

·        You can only display one currency in the report.

You have the following options for defining drilldown forms and reports:

·        From the SAP Easy Access screen under Accounting → Financial Accounting → Special Purpose Ledger→ Tools → Drilldown Reporting

·        In Customizing for Financial Accounting under General Ledger Accounting → Information System → Drilldown Reports (G/L Accounts) → Form or Report

For more detailed information about drilldown reporting, see the SAP Library under Cross-Application Components → CA - Drilldown Reporting Ledger.