Skip to Content

I am writing my first blog on SDN keeping in view financial reporting requirements of client. Report painter is an excellent reporting tool that is equipped with useful features which can help us in designing analytical reports quickly without ABAP help.Financial reporting requirement varies as per local accounting practices and GAAPS. In order to cope up with these requirements report painter let us design reports like

  1. Profit & Loss Accounts
  2. Balance Sheet
  3. Cash Flow Statements
  4. Ratio Analysis
  5. Sources & Application of Working Capital
  6. Consolidated Financial statements

In order to make the user familiar with this reporting tool i would restrict this blog to Ratio Analysis. While designing ratio analysis for ratios based on profit and loss figures and balance sheet , one thing has to kept in mind that profit and loss figures are period based and balance sheet figures are taken on To Date basis. Hence we need to handle this behavior while designing ratio analysis report in report painter. I will use start with designing the form and the setting necessary parameters for a classified report output.

Step 1: Transaction Code FGI4 (create form)


R1.jpg

In next screen you will see an unstructured form with four rows and four columns.My recommendation here is to have such a report that is meaningful at a glance & provides a comparative view of ratios for all months in the fiscal year. Here i will make 13 columns, 1st columns will be for Year to Date and rest of 12 will be for respective posting periods. Text of any row or column can be edited using shortcut key SHIFT + F1 or from menu.

R2.jpg

Now in next step you need to set the columns. Since most of the ratios are based on Balance sheet figures i will recommend to make use of key figure “Accumulated balance” KUMSL for every column you add. Following images will show the Year to date column for report.

R3.jpg

R4.jpg

R5.jpg

R7.jpg

Now the process for month columns will be a bit different than year to date column. Double click the Column 2 and then key figure with characteristics.Key figure will always be Accumulated Balance for every column. Fiscal year setting will be same as of year to date column.Do not select variable button against posting period and hard code 1 in TO to FROM . 1 will stand here as first posting period which may differ if your fiscal year is not calendar year dependent. I will take Jan to December as fiscal year. Hence here January is fist posting period as shown in the coming snap

R8.jpg

Repeat the same process for next 11 , do not forget to change the posting period for every period column i-e for February it should be 2 , for March 3 and so on..Now columns for your report have designed. You can copy the column created by selecting it pressing F9 and then F7. A new column will be added next to old the one.

R9.jpg

Step2 : Define General Data Selection

This is very important step . In this step you select parameters that will govern your report’s data . Like Financial statement version & Chart of accounts used. Ideally financial statement version for ratio analysis should be the one which is assigned to financial statements. However you can create your own using OB59.

R10.jpg

Step3: Define Rows


In this step you assign the FS items or accounts to the rows so that once report is executed their output can be displayed in the columns. I will first start with liquidity ratios which are based on balance sheet figures. First is current ratio which is current asset times current liabilities. I will first insert a blank line from Menu–edit—rows to name Liquidity ratios as shown in following snap

R11.jpg

Now i will start assigning FS nodes for current assets and current liabilities to the rows..Double click on Row 1 and select characteristics. In next screen perform the action as indicated in following snap

R12.jpg

R13.jpg

R14.jpg

You can see in the following screen shot that current assets node has been created, you need to repeat the same process for current liabilities node. Double click the next row..select characteristics and select the FS item for current liabilities by expanding hierarchy and confirm it.

R15.jpg

Next we will set formula for current ratio , follows the process as shown in the coming screen shot

R16.jpg

R17.jpg

Now your current ratio has been computed. In order to make current ratio row distinguished form other you can select color for it. Select the row and in menu go to formatting..color settings…choose any you want.

R18.jpg

Now your form is completed for one ratio, you can repeat the same process for calculating other ratios. Next we will now develop report.

Step 4: Define Report ( T code FGI1)


Our next step is to develop report based on the form we have created. You can create report from t code FGI1 as well as from form as well. In the form you can see the Report button, click it. In next screen you will see that form is automatically assigned and you can give name to your report.Press create button. In new screen characteristics tab , fetch the FS Items and assign it financial statement version.In variable tab you can set ledger 0L as default.In Output tab select classic drill down and then basic list:detail. Save and run the report. Cheers πŸ™‚

Correction:

Please note that there is a little mistake in number 6 screen shot. Variables like 1PF,1PT can be configured using FGIV not the FGIR.

Useful Tips:

  1. To hide any row or column , just click on it and go to menu …edit…rows..hide..You can display the hidden rows from the same path by selecting hidden rows and setting them display.
  2. When you try to edit name of any element , you have thee names, Short text, medium text and long text. You can set which one to display in report from menu…formatting…all rows..text length.
  3. Column width can be changed from menu..formatting..column width.
  4. You can import forms created in other client sharing the same instance number using FGIR.
  5. Forms can be deleted using FGIZ.
  6. Forms can be transported from development to live server using FGIP.
  7. Report can imported from one client to another client using FGIQ provided that client shares the same instance number.
  8. Reports can be transported to live server using FGIO.
  9. FGIX will let you delete report data.
To report this post you need to login first.

71 Comments

You must be Logged on to comment or reply to a post.

  1. Narasimhulu Konnipati

    This is the one topic among few which i am trying to get command and save user time.

    When an expert takes initiative and think about the user for a minute, one can imagine what will be the outcome. It will not only save the Users’s time, it will save a Consultant life when he is not sure on those areas.

    Wonderful document.

    But when i am downloading it, the screen shots are not coming into the PDF file.

    Could you please have a look and re-upload it if needed dear?

    Thanks a lot for your contribution.

    Hope you will be looking into SCN and assisting the users πŸ™‚

    Narasimhulu

    (0) 
    1. Atif Farooq Post author

      Hi:

          Thanks for appreciation. Actually ultimate intent of putting effort in this one was to familiarize the users with this reporting tool for making useful financial reports. As far as downloading is concerned i am having the same issue, one idea is to copy this blog and paste it into a word file, from where you can convert it into PDF. Kindly rate this article if you find it helpful .

      Regards

      (0) 
  2. Sekhar Chakraborty

    Hi Atif,

    I have gone through your blog, it is really help full to me. So far PDF is concern just press CTRL + P at Destination field of that select “Save as PDF” and then Save.

    (0) 
    1. Atif Farooq Post author

      Hi:

          Thanks for appreciation..Kindly rate the article and please note that saving in PDF is not an issue. Screen shots are not coming in PDF when saving in PDF format.

      Regards

      (0) 
        1. Ruksana Khan

          Sekhar,

          You may save the same in word file by coping the precious content posted by Atif.

          I did the same way.

          Regards

          Ruksana

          (0) 
  3. Ruksana Khan

    Hey Atif,

    It is wonderful document. Thanks to you for sharing this. I will try to create similar kind of report for learning purpose, if struck somewhere will share with you.

    Regards

    Ruksana

    (0) 
    1. Atif Farooq Post author

      Hi Ruksana:

                        I am obliged for the appreciation. Yes i will be glad to help you. Please note that ratios based on profit and loss will behave differently under the column with key figure KUMSL “Accumulated balance”. You need to set special processing for every element in row. When you get to these P &L based ratio. Should you face any ambiguity, please feel free to contact.

      Br

      (0) 
  4. Sajida Ahsan Raza

    Dear Atif,

    Really a good job done. it has been observed that this tool is merely used and most of the time company ‘s accountants used to download the data and derive Ratio analysis in Excel sheets.

    There is very rare writing on this topic on SCN/SDN

    It is fantastic style and  elaborated the things  in very easy way. good luck once again.

    i am sending you link posted in April 2011 , can you help me in this regard

    http://scn.sap.com/thread/1939209

    (0) 
    1. Atif Farooq Post author

      Hi:

            I have checked your link and since it is marked as answered so i can not reply there. I am posting reply here.

      For average collection period for debtors i assume you have already calculated debtor’s turnover ratio.Now for number of days for debtors you need to go to each element one by one for debtors turnover ratio for every month, double click it and choose “selected” . Give name to every element of debtors turnover ratio by pressing SHIFT+F1on it. Once you are done with it. Create a row with characteristics “formula”.  In formula write 31/(the row for debtor turnover ratio. Your entire row is generated for average collection period, but every row will be displaying average collection period based on 31 days and that is wrong.Leave the element of months which have 31 days. Your issue is to correct the average collection period of months with 30 days or 28 days. Go to September ‘s element , double click on it, select formula. In formula screen you will see IDs you have selected on top. Now there you can write 30/Selected ID for September month.This will do the job. Hope it helps you.

      (0) 
  5. Eli Klovski

    Hi,

    Very good work! I’m glad you are back on SCN!

    Small remark: if you are going to post some more information of this kind, please, select more proper domain and type. For example, this useful information you have published, should be posted in ‘Financial Management’ rather than in ‘Assets’. Also, the type for such an information would be ‘document’ and not ‘blog’.

    Thanks for your cooperation and keep posting!

    Eli

    (0) 
    1. Atif Farooq Post author

      Hi Eli:

                 Thanks for your suggestion and appreciation. Well you are right that this “document” should have been posted on right forum to maximize its utility. The moment i posted it i realized my mistake , i emailed  at 3rd May to SDN support team to transfer this document to the Financial forum. I did not get any reply from there. Lets see when do they consider it.

      Regards

      (0) 
          1. K P

            hello Atif,

            Thanks for this blog.

            i want financial statement by day wise & not by period wise. e.g. today is 31st march i want financial statement as on 10th Feb. How can i get FSV on perticular date? What customisation required in it? Kindly suggest me what to do in report painter.

            (0) 
            1. Atif Farooq Post author

              Hi:

              I do not see any option of day wise reporting in report painter so better ask ABAPER for it. If you get any update do update here.

              Regards

              (0) 
  6. Janet Kuck

    Atif, great job.  This is very helpful.  However, I have one question.  I have created a balance sheet form and then a report using that form.  When I run the report, a blank column is printing (or spooling) between the lead column and the key figures.  I have a hunch that the report is TRYING to print account names even though I didn’t ask for them.  I am using groups of accounts(like current assets), so I have no individual accounts showing up.  But it looks like the report is “reserving” a space for account names.  How can I turn that off so that I don’t get a blank column?  Thanks for your help.

    (0) 
  7. Mohammad Zakir Hossain

    Salam,

    This is very helpful. As an beginner in SAP I have prepared Income Statement & Balance Sheet following your tool. I’m facing problem to prepare Cash flow statement. Would you help me to form for Cash Flow Statement. Another issue, is it possible to create formula within two column?

    My email ID is zh_zakir@yahoo.com

    (0) 
  8. Gaurav Kumar

    Wonderful document Atif… I had prepared 3-4 reports on report painter last year. Now i am facing one issue.

    My one report is having Current month Vs last month comparison.

    For last month figure I have created formula variable(current month-1) and system showing always current month and last month figure for the period and year entered in the selection screen.

    Now issue is for Jan 2013 period 1 there is no prevoius month but system calulating current month-1 i.e 0 peirod and throughing error.

    Is there any way to resole that permanently ..

    (0) 
  9. Xiumei Zhang

    Wonderful document, thank you so much. But i have a question that we usually use  report painter tool with tcode start with GR* serio. they are very familar. What’s the different between them?

    Best Regards,

    Jessie

    (0) 
  10. Ranu Eugene

    Hi Atif,

    To be very frank I tried to develop report using Report painter twice but could not succeed and left it but your Documentation is superb and I tried and bingo……… πŸ™‚ .

    The way you have documented the whole process is superb and thanks for doing that.

    Please do keep posting such a good documents.

    Would love to see some more like this. πŸ˜‰

    Best of Luck. πŸ™‚

    Regards

    Eugene

    (0) 
  11. Subhadeep Das

    Hi,

    i am in the middle of developing a report on ratio analysis. My client  wants to know the sales per associate/employee for which i need to have a headcount coming from HCM tables like PA0000 etc. Pls advice how do i get that data and how to include these tables in FGI report.

    best regds

    Subha

    (0) 
  12. eric van zundert

    Hi,

    Nice overview; one question.

    If I use a FS item with a debit indicator: It still shows the debit or the credit balance.

    Does report painter not take the debit/credit filter of the FS not into account?

    kr,

    Eric

    (0) 
  13. Cercola Larry

    Hi Atif,

    Great document and very easy to follow!  Thank you!

    Have you ever created a comparative profit center report?  At a high-level, I’m trying to report on profit center amounts (one per column) across the report with the associated accounts assigned to the rows.  Any suggestions?

    Best regards,

    Larry

    (0) 
  14. Sada Bandla

    Hi Farooq ,

    Thank you very much for sharing this document  last week i got a requirement from our client Month to Month FSV (sourse Tcode :F.01), I am new to report painter when i search in SCN i found your Document which helped me alot  for creating report .soon i will present in SCN . ➕ πŸ™‚ ➕

    Regards,

    Sada Bandla

    (0) 
  15. Raj Kumar

    Very good Atif,

    The document is very very useful and its presentation is very nice, every new user can learn / create report painter using your document.

    (0) 
  16. Shuja R

    Atif,

    This document is very helpful, I was looking for this since long, but I have a problem, I want P& L report month wise comparison like 12 months on same page, how can I get that, this shows Balance Sheet Version. If I want comparison of Periods, Sale & Purchase even expenses. All P&L accounts.

    Please help.

    (0) 

Leave a Reply