Skip to Content
Author's profile photo Shihab MS

Drilldown Reports

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

Assigned Tags

      55 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Krali Marko
      Krali Marko

      Am I the only one who can not see the print screens ?

      Author's profile photo Former Member
      Former Member

      Some images can be seen, but some are not.. 🙂

      Author's profile photo Krali Marko
      Krali Marko

      Maybe these are Pay-per-view images 🙂

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      HI Friends

      Actually i wanted to hide some details in those images, that is y i first copied  it into paint and after making some changes attached these images in to the sites from Paint , that is the reason some images are seems blurred.

      Author's profile photo Krali Marko
      Krali Marko

      Hi shihab,

      Thanks for ur reply,

      First I was looking such document (Drilldown) for long time,

      I don't know how u can see the images in this document, but on my computer (I tried on all browsers) images are not blurred but completely blank,  i see only the framework of the image.

      I can see only 6 images,

      - First image of 2 Edit Form

      - First image of 4 Reversal Sign

      - And the last four images of (C) Assigning Sub reports in to main report

      I would really appreciate if I send this document by email or re-upload images.

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      HI Friend

      I have checked in my ID it is working fine, anyway i have updated the images again . Please check once again and please let me know the result

      Author's profile photo Krali Marko
      Krali Marko

      Perfect, now i can see all images, thanks.

      Author's profile photo pranav kumar
      pranav kumar

      Thanku so Much Shihab,

      I will configure accordingly screen shot. a lot of thanks.

      Mr. Shihab, 

      Right now i facing Foreign Currency calcuation...

      i will send u the settings n all.

      Please let me ...

      Plzze yr quick action will be highly apprecited..

      regards

      Pranav

      SAP FICO Consultant.

      Author's profile photo Former Member
      Former Member

      Hi guys

      I am having a challenge here . i want to change the despricption of the form title but after changing it is not showing the header in full it seems like it is picking the short text and not long text.e.g the HEADER for the existing form is ZDCO financial statement version after changing instead of showing NGSC finamcial statement version it shows NGSC FIN.

      Regards Rejoice

      Author's profile photo Eli Klovski
      Eli Klovski

      Nice outlook

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      Thanks

      Author's profile photo Former Member
      Former Member

      Hi  Shihab

      I am trying to design a Cashflow report.Can you educate me on how to come up with a formulate which calculate increase or decrease in inventory,trade receivables,paybles etc.

      I understand it sgould be current yr -previous year in this form trade receivablesl /FY;&1FY. I dont know where you get these parameters .Please help am stuck.

      Apart from this on the increase in cash and cash equivalents.....BALANce at the beginning of the year which figuream i supposed to pick then Balance at end of year how is it computed.

      Regards

      Rejoice

      Author's profile photo pranav kumar
      pranav kumar

      Thanks

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      You can use two hidden column for a current period and previous period, and formula can be used for calculating the changes in inventory

      Author's profile photo pranav kumar
      pranav kumar

      HI Shihab Sir,

      Very good morning sir,

      sir,

      based on that we have prepared Report painter for P&L account but FS item not display, plzze plzze help me in this regard, its urgent... User wants for MIS report

      purpose P&L report.

      Like

      Expenes

             Manufacturing

                    COGM

                    POWER

              ADMINISTRATIVE

                     SALARIES

                     EMPLOYEE BENEFITS

                     OTHER EXP

      we have configred through FSI4 and FSI1 , value coming after execute FSI0, but FS ITEM not showing as per client requirement,

      see the screen shot i have made to meet requirement for client but still problm ..

      Author's profile photo pranav kumar
      pranav kumar

      Dear Sir,

      See the below format, client want accordingly below format , we have made but still not meet requirement from customer kindly tell me where i ve assign add FS item in KSI4 , KSI1 report..

      Budget Main  Head
      Sales 311100 SALES EXP-FG( MACHIN
      311200 SALES EXP-FG(FORGING
      311300 SALES EXP-FG(ASSY)
      311400 SALES EXP- Deemed
      312100 SALES DOM-FG(MACHINE
      312200 SALES DOM-FG(FORGING
      312300 SALES DOM-FG(ASSY)
      312400 SALE OF WIP
      460026 PROV FOR CUST DEDN
      Sales Total
      Scrap Sale 321130 SALE OF MFG.SCRAP
      321140 SALE OF SCRA FORGING
      Scrap Sale Total
      Other Operating Income Total
      Mat Cost 411010
      444555
      440022
      441122
      441021
      443254
      447845
      445578
      Mat Cost Total
      Man Power
      Man Power Total
      Power & Diesel
      Power & Diesel Total
      Fuel & Oil
      Fuel & Oil Total
      Stores & Consumables
      Operation Support
      Stores & Consumables Total
      Oth Mfg Exp & Maint Exp
      Operation Support
      Operation Support
      Oth Mfg Exp & Maint Exp Total
      Maintenace Expenses
      Maintenace Expenses Total
      Admin Exp

      Its urgent sir

      Author's profile photo Ranu Eugene
      Ranu Eugene

      Hi Shihab,

      Nice Document and thanks for sharing. 🙂

      Keep up the good work.

      Best of Luck. 🙂

      Regards

      Eugene

      Author's profile photo Nishu Shah
      Nishu Shah

      Hi,

      Appreciate your effort ! Thanks

      I have a query, we have a situation where a single gl is used for operating exp and non operating exp. It is generally bifurcated by CO Account assignment i.e. of it is operating then it is assigned to CS Order and if it is non operating, then it is assigned to Cost center

      How to make bifurcation of cost element on CO account assignment level in report painted

      Thank You

      Nishu

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      Hi all.

      It is better to use FGI0, FGI1 for repor creation and FGI4 for form creation instead of using the  oldest method FSI1 and FSI4.

      Author's profile photo pranav kumar
      pranav kumar

      Thanks for quick reply..

      we have already prepared but when i go for Execute FGI0 getting Error

      The drilldown report must be selected using one ledger

      Message no. GH113

      Diagnosis

      Drilldown reports must be selected using precisely one ledger. Here, the drilldown report called up has no ledger selections or more than one ledger has been used for selection.

      System Response

      Execution of the report is terminated.

      Procedure

      Maintain the form accordingly.

      Message No.

      Message no. GH113

      Note : Sir,

      Kindly Send me Screen shot for the same like FSI4 and FSI1 , i m new one but as per business scenario i have configured as per your an idea.

      see the config settings below

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      hI,

      Use Report Type 002 ie FAGLFLEXT ,

      there will be some standard reports are available, if u wanted to created ur own , either you can copy or use FGI4 to create form and then use FGI1 to create report with this form

      Author's profile photo pranav kumar
      pranav kumar

      Thanks sir,

      sir, but FAGLFLEXT for new GL or ECC6 EHP4, coz still New GL not activated,, kindly confirm sir.

      Thanks a lot for quick reply...

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      When you activate new General Ledger Accounting, the totals records in General Ledger Accounting are updated in the standard totals table FAGLFLEXT. This totals table is deployed in functions such as planning and reporting.

      Author's profile photo pranav kumar
      pranav kumar

      Thanks a lot sir...

      Sir finally , i have made as you given advice to go for FSI4 and FSI1 ... sir , kindly i requested to you see the screen shot below, i have one issues after executing april'13, may june data flow but i dont know july'13 , Aug and Sept'13 no data found showing in exist report i have seen in FS10N report in all sales account till septeber;13 data was there, kindly correct me where i have done mistake to config... all most out of 100   99.9% covered.. but from July no data

      flow...

      in this regard , we have activate COPA report .. for your information might be from July.13.. that's why not showing or somthing wrong config... kindly correct me as soon as possible... i am still stuck till now since morning.... plzzze.

      Your action will be highly appreciated...

      note : See the report below

      Kind regards

      Pranav kr Gupta

      SAP FICO Consultant.

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      Hi,

      Please check the characteristic you have defined for the July period

      Author's profile photo pranav kumar
      pranav kumar

      Hi, Shihab,

      Good Evening,

      Thanks a lot....

      yes u are right, actually what happened, Period April is 1, but FSI4 format Following calender year, thats why... showing in July..instead of April... finally... resolved the issues...

      thanku so much... for helping..

      upto marks out of 100 100.. from side...

      Note : one more issues in Copa... plzze help me in this regard

      in KE30 Report Material Cost not updated... only COGS GL updated and showing in KE30... coz condition type in KE4I VPRS... based on Material Master data system calculate Material Cost... but we want actual material cost n fetch in KE30 report... tell me step with screen shot... its urgent... pllzzze...

      Kind regards

      Pranav Kr.Gupta

      SAP FICO Consultant

      Author's profile photo pranav kumar
      pranav kumar

      Hi Shihab,

      We have made Drill Down Report in KE30... but when i select the component Like sales, or any other and go to Line Item from Menu Bar... Line Item Button is not active... Customer want to see Line item as well in KE30 Report.

      Kindly Help me ... in KE30 for Line Item Wise..

      Kind ragards

      Pranav Kr. Gupta

      SAP FICO Consultant

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      Hi Friend

      You have to assign the report in Option> Report Assignment.

      Thease are the available report Type. You have to choose the report type and enter report program

      BB    Report Portfolio

      BW    BW Query

      QU    SAP Query

      RE    Drilldown Reporting

      RT    ABAP Report Program

      RW    Report Writer

      TR    Transaction

      Author's profile photo pranav kumar
      pranav kumar

      Hi Shihab

      Thanks for Quick Reply...

      But where we have to configuration ... for the same ..kindly send me the step-step details... actually, today we want to close this issues ASAP.. Kindly help so .. we can give the report to Customer as well.

      Plz help Shihab.

      Kind regards

      Pranav

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      Hi Friend

      You have to assign the Report in KE32 in"Options" tab.under Extras >Report Assignment.

      There you have to choose Insert Row(F6). Other Report Type. There you have to choose the report type. If we select Transaction you have to enter T Code KE24 for Line item display.

      Author's profile photo pranav kumar
      pranav kumar

      Thanku sir...

      Thanks a lott...

      Right Now i am configuring assignment .. once complete we will let you know...

      sir, in Report assignment which one we have to select for Line Item Display..

      like as you said report name : i.e RE - Drilldown report... RW- For Report Painter  so every report which showing in system or either one of them.. and application : EC Profit Center Accounting...

      Kindly Guide me we are very alomost achieve the Issues resolve ... i think...

      Plzze Shihab..

      Kind regards

      Pranav

      Author's profile photo pranav kumar
      pranav kumar

      Hi Shihab,

      But we have made KE80 Report...

      to create KE84 then KE81.

      to Execute KE80..

      i have seen same thing is there...

      i am waiting for your reply sir.

      Thanks

      pranav.

      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      Hi Friend

      Whether in KE32, KE82, FSI2 or in FGI2 assignment of Report is same

      Author's profile photo pranav kumar
      pranav kumar

      Hi Shihab,

      Good Afternoon ,

      SIr, all most we achieve  as you given advice to do but in Option Tab. Report Assignment m stuk.. if possible or free kindly send me the step by step.. m trying four five times.. but Line Item Button still showing inactive.

      see the sreen shot.

      Kind regards

      Pranav Kr. Gupta

      Author's profile photo pranav kumar
      pranav kumar

      Hi Shihab,

      For yr Information.

      We have ECC6.. but we didnt activate NEW GL Document Splitting..kindly tell me.. we can do in Classic GL As well.. kindly confirm.

      Kind regards

      Pranav Kr.Gupta

      Author's profile photo Sri P
      Sri P
      Detailed steps and thanks for sharing
      Author's profile photo Shihab MS
      Shihab MS
      Blog Post Author

      Thanks sridevi

      Author's profile photo narin kamuni
      narin kamuni

      Nice Document - Thanks for Sharing...

      Regards,

      Narin  Kamuni

      Author's profile photo Subhadeep Das
      Subhadeep Das

      very good. It helped me a lot. thank you.

      best regds

      Subha

      Author's profile photo Sudeep A
      Sudeep A

      Good information. Thank you.

      Regards,

      Sudeep

      Author's profile photo Erwin Leitner
      Erwin Leitner

      Hello,

      Thank you very much. 🙂

      ➕ ➕ ➕

      all the best

      Erwin

      Author's profile photo Rahul Malhotra
      Rahul Malhotra

      Good value addition...thanks!!! 🙂

      Author's profile photo Shanid MP
      Shanid MP

      Hi Shihab,

      Very good document, it helped a lot and request you to advise on below.

      I have created a cash flow report (direct) copy from SAPRATION-04, in 2 column given the characeriitcs as Fiscal year, From per & To period, second column variable was created with other name, but fields are same.

      Now for Balance sheet items I would need to put the formula to avoid including PY & previous period balance. To calculate the same I need to add PY columns, I am not able to create a column with variable as 1FY-1, if I would add this additionally, then it is coming in selection screen of report.

      Kindly help.

      Regards

      Shanid

      Author's profile photo Syed Zia Abbas
      Syed Zia Abbas

      Dear Shanid

      You need to define two sets of variables, 1) Reporting FY, Reporting Period From and Reporting Period To and 2) Comparison Year, CY Period from and CY Period To.

      When you define previous period as 1FY-1, you will be getting option to enter as 1FY only (system will calculate 1FY-1 on its own) which will be either you RY or CY. So do not bother and proceed the way you are doing.

      Regards

      Author's profile photo Shanid MP
      Shanid MP

      Dear Syed,

      Thanks for the immediate reply, hope you can solve my issue.

      Yes you are right, I have only 1FY to add here, after adding it is still 1FY, not iFY-1.
      what you mean 'system will calculate 1FY-1 on its own'?

      Following are the steps I have done.

      -----------------------------------------------------------------

      Following columns are created.

      1) Reporting year

      Variables used - &1FY (GJAHR), &1PF (PERDE) and &1PT (PERDE)

      2) Comparison year

      Created new variables same as above but name changed.

      &Z1FY (GJAHR), &Z1PF (PERDE) and &Z1PT (PERDE)

      Till here, I am getting the fields 'RY, per from & to, CY per from & to' in report selecton.

      Now I would need to create following additional columns (hidden) to put the formula only for Balance Sheet items.

      1) Reporting year - copied same as first column.
      2) Previous year for RY - Here I am getting only &1FY, &2FY etc as variable. &1FY-1 is not there.

      Now if I put &1FY-1 as local variable, this fields is displayed in report selection.

      3) Comparison year - copied same as second column
      4) Previous year for CY - Same issue mentioned in point 2.

      Kindly advise.

      Regards
      Shanid

      Author's profile photo Syed Zia Abbas
      Syed Zia Abbas

      Dear Shanid

      You need to mention the year as &1FY-1. Please see below screen. Hope you are able to understand now;

      /wp-content/uploads/2014/12/27_607983.png

      Regards

      Syed

      Author's profile photo Shanid MP
      Shanid MP

      Dear Syed,

      You said right, thanks a lot, appreciated.

      I do not know why did miss to check that.

      Now I am able to add PY and add the formula for B/S accounts.

      However, I need to put the formula for period also for B/S accounts as the report will be executed in period wise and when I am executing for only 1 period (except period 1), B/S values are displayed all the values till the period.

      For eg: If I execute with 2014, 3 to 3, then balance displayed from 1 to 3.

      Can you please let me know how can I put the formula for period to display the exact figure of the period.

      Regards

      Shanid

      Author's profile photo Syed Zia Abbas
      Syed Zia Abbas

      Dear Shanid

      You need to create two separate period variables for each FY. It will be &PF (Period Form) and &PT (Period To). So when you run the report, you need to input both the periods. In your column, you need to select both the period variables,as shown in my screenshot in my earlier post.

      Let me know if you need more inputs?

      Regards

      Author's profile photo Shanid MP
      Shanid MP

      Dear Syed,

      Thanks for the prompt reply.

      I have already created the period variables for RY and CY and selected the same in each column. (including formula column) as below and it is coming in selection screen.

      But the issue is that I had mentioned that period wise balance are not displayed for B/S items.

      For eg: If I execute with selection 2014, 3 to 3, then balance are displayed from 1 to 3.

      I think I need to put formula for this, in order to display ony for specific periods.

      Hope above calrifies my issue.

      Test.png

      Test2.png

      Regards

      Shanid

      Author's profile photo Syed Zia Abbas
      Syed Zia Abbas

      Dear Shanid

      Your settings looks ok. Even then if you are not getting values as expected, then you need to check your entire report. and run for period 1 to 1 and then 1 to 2. And then analyze the difference.

      For better analysis, I would recommend you to rename your variables as below;

      Reporting Year

      Reporting Pd  : From

      Reporting Pd  :To

      and

      Comparison Year

      Comparison Pd: From

      Comparison Pd: To

      Regards

      Author's profile photo Shanid MP
      Shanid MP

      Dear Syed,

      As I observed that, for Year we have already given FY-1 as PY, and formula maintained as FY minus FY-1.

      For the period we had not given anything, it is just PF & PT, I think we would need to create a variable with formula option (FSIV).

      Kindly suggest.

      Regards

      Shanid

      Author's profile photo Syed Zia Abbas
      Syed Zia Abbas

      Dear Shanid

      Even in FSIV, you do not mention the values. Please check whether your variable is created with the option shown below (and not by the balance);

      /wp-content/uploads/2014/12/28_609529.png

      Let me know if this is helpful for you?

      Regards

      Author's profile photo Shanid MP
      Shanid MP

      Dear Syed,

      It is maintained in 'Financial Statement key figures'.

      I was referring something like creating the formula mentoined in below link.

      Please let me know if you get something out of below.

      http://help.sap.com/saphelp_470/helpdata/en/5b/d22ea043c611d182b30000e829fbfe/content.htm

      Regards

      Shanid

      Author's profile photo Syed Zia Abbas
      Syed Zia Abbas

      Dear Shanid

      I have created Cash Flow Statement and Equity Statement using the same procedure as I have mentioned to you, but no where I have used the formula for identifying the periods.

      Please check your settings thoroughly, else you can catch me on gmail.

      Regards

      Author's profile photo martina das
      martina das

      Hi syed,

      I am trying to create cash flow statement  And stuck in a point when I need to show changes in equity in two consecutive year.  I find in those existing form there are predefined formula are there with z005 - z004 to get those value  .  My question is how we can create those formula charecter or else if there is any other way to capture the changes in equity/ inventory / payables etc

      Regards

      Martina