Drilldown Reports for FI-SL Tables


Starting in Release 4.0A, you can evaluate any FI-SL summary table with the drilldown reporting tool.

The following functions are valid:

At the moment there are also the following restrictions:


1. Activating Drilldown Reporting for an FI-SL Table
This is where the drilldown reporting structure for the summary table is generated (compare T800A-GFISTABLE) and the drilldown reporting field catalog (table TKAFA, TKAF, TKAFD, TKCKT) is updated for the new fields in the summary table.
Before you activate drilldown reporting for an FI-SL table, you have to maintain the integrated master data for all fields relevant to the FI-SL summary table (transaction GCS1, table T800D), because drilldown reports use this master data. You will have to be especially careful to enter the higher-level fields such as the company code correctly so that the drilldown report can find the texts to each field in the report display.
Activate drilldown reporting for FI-SL tables

You use transaction GCRE2 to deactivate drilldown reporting for FI-SL tables. This removes entries from the field catalog.
Deactivate drilldown reporting for FI-SL tables
1. Defining Forms and Reports
To define forms and reports, go to the G/L Information System in General Ledger Accounting in Customizing.

If you need to call up a line item report from a summary report for a journal entry statement, you first have to generate the line item report with program RGRGENSI for the summary table, and then assign the generated line item report to the summary report.
Assigning the report is part of the 'Change drilldown report' function, which you reach by activating the characteristic selection field and then Extras -> Report assignment.
In the dialog box that appears, choose the 'Other report type' function and insert the line item report generated earlier, as an ABAP report.
1. Executing the Drilldown Report
You execute the drilldown report with transaction FSI0.
In the dialog box that appears, choose your table (reporting for table xx) and then start the report you need.
Execute drilldown report

Examples for Drilldown Reports

1) Balance Sheet Report

First execute transaction FSI4 to create a form. Select your summary table from the dialog box (reporting for table xx) and choose 'One coordinate with key figure' as report type.

Choose the 'Ledger' and 'Record type' characteristics in the 'General selections' function on the 'Report Painter: Create form' detail screen and enter the values.

Then choose the 'Define element' function and activate the 'Key figure with characteristics' function in the dialog box that follows.

In the next dialog box, choose the 'Balance sheet value' key figure and then the 'Fiscal year' characteristic. It is advisable to use a variable for the fiscal year that can be entered during report execution.

To perform a yearly comparison, another element can be defined for the previous year and then a formula with the variance between the first two elements.

Save your entries.

To create the report, execute transaction FSI1.

Enter the report name and the form name and then choose 'Create.'

On the following 'Characteristic selection' screen, choose the 'Balance sheet/Income statement item' characteristic (mandatory for balance sheet reports) as well as other characteristics - such as account number - that will also be displayed in your report. Next, choose the 'Sort characteristics' function to define the display order of individual characteristics.

Choose 'Extras' -> 'Hierarchy selection' and enter a balance sheet and income statement structure in the dialog box that appears or activate the 'Entry with execution' indicator. You can then enter the balance sheet and income statement structure when the report is executed.

Save your entries.

Execute your report with transaction FSI0.

2) Balance Lists

Execute the 'Create form' function as described above. Define three elements, each time selecting 'Key figure with characteristics' as element type:

Save your entries.

Then create a report as described above.

Select 'Account number,' 'Business area', Function area', and 'Cost center' as characteristics.

Save and execute the report.

You can display other examples of forms and reports with report type '2 coordinates (matrix)' under the 'Balance sheet analysis from cost of sales' report type. The forms and reports delivered by SAP start with '0SAP'.