Drilldown Reports
Copy form
You can copy an existing for form for creating a form for drilldown reports . Use T code FSI4 for creating Forms
Edit Form
Use T code FSI5 for editing the Form we have created
Select the Column and Double click on that , You can add different characteristics values in that table. You can also add new columns to current form , point the cursor and insert element , either you can add a characteristics value or you can define a formula ie for calculating Variants like that
Tick the Variable box then you will get a screen , there you can select the variable such as "Fiscal year, Fiscal year (6 mo.) etc.
Enter the text in the following format to separate the text in to two lines , in this case the year will display in the second line
Insert Row
Point the curser in the row for inserting an Element in the row
You can either enter a formula or select Characteristics value from the Financial Statement Version
Use Reversal sign option to specify Credit item in the Profit and loss A/C and Balance sheet(Incomes, Liabilities etc,)
Dividing Lines
You can create a dividing line to separate each line items
Column Width
you can adjust the width of the Colum
Hide Colum or Row
Hiding is a good tool to Hide those rows or column that you don’t want to show in the report , but you wanted the values of the Column/row for some calculation Purpose
Here we have an option to enter a formula for a particular item in the report ,. Fist you have to select those line items that you wanted to include in the Formula
Double Click on the item there you have different options.
Report Creation
Create the report with the form that you created , you can specify the name for the Report . Use Tcode FSI1 for report Creation
You can make the selection of characteristics values for the Reports . Drag those items wanted to include in the report
Select the Classical Drilldown for report out put type. If you wanted to include any Header for |Footer in the report that you can mention in the Layout.
You can edit the report from Tcode FSI2 and also you can execute report
The main important feature of this drilldown report is that we can drill down the report in to line item level
Here in the main report we can add many sub report . These Sub report will help the user to drilldown in to Line item level.
Create Sub Report
You have to create a separate form and a report this purpose as main report . You can use the same tools that we used in the Main report. The important difference between main report and the sub report is the Report type , Here we are using separate ABAP report for line item display
You can create elements for the report in this way
Report Creation
Create sub reports using FSI1
Select those characteristics you wish to include in the report
Select the classical Drilldown report as output Type , you can create header/footers or copy from the existing header created for the main report
Here in the option tab we can mention the report Type used , Select the REPORT ASSIGNMENT ' push button and select Other Report Type
You can select the ABAP Report from the list available and Enter the Report Program" RFGLRE_ITEMS"
Assigning Sub reports in to main reports
select the report that you wanted to assign the sub reports
Select the Report assignment Push Button and add new report and select the report from the report list .
Area Menu Creation
You can create Area Menu for easy access to the report. These reports are created to meet the requirement of Top Management most of the time , so the wanted to access easily to the report . To fulfill this requirement we can crate a Area Manu
Use T code SE43- Area Menu Creation
Create area menu with a Name Starting with Z and add new entry to the list . You have to select the Report to add a report to the area menu
Select the Drilldown Report in the screen and select the Balance sheet key Figure in the selection. There u will have option to select the report you have already created
I hope now you can able to view the report in the area menu and able to execute the report
Comments