Drilldown Reports

[msshihab1987]

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