Starting in Release 4.0A, you can evaluate any FI-SL summary
table with the drilldown reporting tool.
The following functions are valid:
Balance sheet and income statement reports
Flexible reports using SAP account assignments and freely
defined additional account assignments
Calling a line item report from the summary report
At the moment there are also the following restrictions:
You can only evaluate summary tables
You can evaluate one ledger only
You can only report on the second or third currencies (usually
local or group currency) and one quantity (no additional
You can only display one currency in a report
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
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
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
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
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:
Key figure 'Total of debit postings' with fiscal year
Key figure 'Total of credit postings' with fiscal year
Key figure 'Cumulative balance' with fiscal year
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'.