Three types of reports can be executed using drilldown reporting. These include financial statements, key figure reports and balance display reports. Financial statements use the financial statement versions for determining structure and layout. Key figure reports provide total credit or total debit amounts. Balance display reports display balances by general ledger, customer, vendor or asset account.
SAP Drilldown reporting uses characteristics and key figures. Characteristics are non monetary variables like company code, vendor, and business area. Key figures are monetary variables like total debit amount, total credit amount and accumulated amount.
Execute SAP Drilldown Reporting
To execute SAP drilldown reporting use transaction code FGI0. You will see a screen like the below:
Click on report type 002 to expand the folder and select the standard G/L account balance display report as shown below:
Place your cursor on the report and click the execute icon
- Ledger
- Fiscal year that you want to report on
- From/to period that you want to report on
Execute the report
The report is displayed. Double click the row to see drilldown details. For instance, in the below report the user can use the navigation column to see balances according to company code, cost centers, segments or profit centers:
Create SAP Drilldown Reporting
When creating a drilldown report, you must first create the form and then the report. The form is then assigned to the report and the report will be ready for use. The report form contains the report and output formats. The report defines the selection criteria.
Create Report Form
Use report painter to create report forms via transaction code FGI4. Enter the following information:
- Select form type Reporting for Table FAGLFLEXT to create an FI report
- Enter a form name and description
- Choose the radial button for the number of axes you want in the structure (for this tutorial, we will use a matrix structure with two axes)
Click create
The resulting matrix is where you will enter the characteristics and key figures you want the report to display. Report painter creates a report form template as shown below:
Double click on each row under Lead column to add characteristics. On the resulting screen, select the Characteristics radial button and click the green check
Select from the available characteristics on the right pane and move them to the left side. The report will display results in rows according to these characteristics. You may have to identify accompanying characteristics and values as well. For example, we have selected account number as a characteristic below, but also had to select chart of accounts to identify which set of account numbers we want to use. We have also entered the range of accounts to include in the report:
Click check
Now that we have a characteristic, let’s add our first key figure. Double click on Column 1. Select the radial button Key figure with characteristic and press enter.
Select the key figure that you want this column to display. For instance, if we want to report on debit balances and credit balances, we select debit balance postings for Column 1. To add another column with credit balance double click on Column 2, selecting credit balance postings, and so on. You will see a system message confirming your key figure selection was successful as below:
We have now defined two key figure columns as shown below:
Click save
Create Report
Now that we have created a form, it’s time to create a report. From the saved form screen, click on Report
Enter the following information:
- Select form type Reporting for Table FAGLFLEXT to create an FI report
- Specify a logical name and description for the report
- Assign the form you just created to the report
Click create
On the Characteristics tab, select from the available characteristics on the right pane and move them to the left side. You may select any number of characteristics such as currency, company code, cost center, etc. The report will provide drilldown functionality in terms of these characteristics.
Click on the OutputType tab. Select the radial button of the output type that you want to use. For our example, we will use Classic drilldown output. Click save
A system message will confirm that the report has been saved:
Execute New Report
Now let’s execute our report using the process we described previously. Execute transaction code FGI0. Now you can see the new report. Place your cursor on the report and click the execute icon
Enter selection criteria or execute wide open. Execute the report
The results are shown and you can use full drilldown features as described in the Execute SAP Drilldown Reporting section:
—
Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP FI tutorials.
Navigation Links
Go to next lesson:
Go to previous lesson: SAP Financial Statement Version
Go to overview of the course: SAP FI Training
View Comments (1)
thank you. your article save my life