Skip to Content

Report Painter is a very flexible reporting tool which can help the Functional Consultants to develop various reports without the help of ABAP. The advantages of the Report Painter are that defining report is very easy and flexible and you have control over the layout. The Rows and Columns are display in the definition the way they are in the report itself.

Common reports that most of the clients require are:

  • Statement of Financial Positions
  • Income Statements
  • Cash Flow Statements
  • Segmented Financial Statements
  • Aging Analysis Reports
  • Ratio Analysis

This is my first blog on SCN and I have attempted to share my knowledge in order to make the users familiar with this reporting tool and contribute a little to the SAP Community. This blog is restricted to the a simple designing of a “Vendor Aging Analysis Report”.

Step 1 – Create Form (FKI4)

1.PNG

  • Enter the Form Type as Line Item Analysis
  • Use your own naming convention to give a description to the form
  • The structure should be Two Axes (Matrix)

In the next screen (below) you will see a form of unstructured row and columns.

1.PNG

Initially, it is recommended to set General Data Selection to the form. Go to Edit-> Gen. data selection-> Gen. data selection.

1.PNG

On the next screen, enter the Company Code in the selected characteristics

1.PNG

On the next screen, double click the lead column and change the description to Vendor Aging Analysis

1.PNG

The next step is to enter the characteristics in the rows. Double click Row 1 and select characteristics, i.e. the vendor

1.PNG

On the next screen enter the following in the selected characteristics:

  • Account Type – K
  • Vendor – From “0” to “9999999”

1.PNG

The next step is to add the number of days in the columns for aging. Assuming the requirement from the client is to age the vendors based on the following days:

  • 30 Days
  • 60 Days
  • 90 Days
  • 120 Days
  • 150 Days
  • 150+ Days
  • Total

In order to achieve this, double click column 1 and select “Key Figures with Characteristics”

1.PNG

On the next screen enter the following in the selected characteristics:

  • Due date analysis – 1 (1 means analysis of line items due. You can even select it from F4)
  • Days for net due dat
    • From “0” to “30” (For aging of 30 days)
    • From “31” to “60” (For aging of 60 days)
    • From “61” to “90” (For aging of 90 days)
    • From “91” to “120” (For aging of 120 days)
    • From “121” to “150” (For aging of 150 days)
    • From “151” to “99999” (For aging of 150+ days)

1.PNG

Enter the heading of the Columns. The form (below) will eventually look like this:

1.PNG

In order to add the totals in the last column, double click the dots and select formula

1.PNG

On the next screen, enter the formula in the Formula line by using the formula components as shown in the next screen shot

1.PNG

You will be prompted to enter the description of this column. Enter “Totals” in the text box.

Always save your form after completion of every step.

That was the last step for creating a form. Eventually, the form will look like this as shown below.

1.PNG

Step 2 – Create Report (FKI1)

Upon successfully creating the form, the next step is to prepare the report for execution. Here you are required to select the report type as “Line Item Analysis”.

Enter the form as “APAGING”. This is the form that is assigned with the report. Use the same naming convention of the report as the one used for designing the form. We will enter the name as “APAGING” and “Vendor Aging” in the Long text.

1.PNG

On the next screen, the characteristic for currency will be appearing. You may enter the currency used for your reporting. I am using PKR for my purpose. Also add Vendor in the sel. Characteristics .

1.PNG

In the next tab for “Output Type”, select the output type as Classic Drill Down and Basic List: D-Down and save the report.

1.PNG

Step 3 – Report Execution (FKI0)


Go to the above T-Code and select the report APAGING in the line items tab and execute this report.

You can even asks the ABAP consultant to create a T-Code at a later stage for this report instead of going through FKI0 and add that T-Code to your Favorites.

1.PNG

In the next screen, select the open items key date and execute the report. It will appear something like the one below:

 

1.PNG

You can compare the APAGING report with the current standard report in FBL1N in order to get confidence that the report developed is accurate.

For testing purpose, I have selected Vendor No. 600015 in FBL1N Report.

1.PNG

Upon comparison of both the report, we can see that the report created by report painter is providing accurate data.

Conclusion

I wish you all Best of Luck in designing the above report for your clients/ companies and I hope that I have shared my knowledge to the extent that the users get familiar with the Report Painter tool and are able to cater multiple reporting requirements.

I will also try to share many further reports very soon!

Cheers ๐Ÿ™‚

Anss Shahid Essani (ACCA)

Certified SAP Consultant

To report this post you need to login first.

61 Comments

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

    1. Former Member

      Dear Firoz,

      CO reports with Report painter is also similar to the ones explained by Anss Shahid Essani.

      Tr- codes are GR51/52/53 Create/change/display report groups.

      GRR1/2/3 Create/change/display reports.

      There are different standard libraries available, with which only standard CO reports created by SAP. You may use the standard libraries and  also you may copy the standard libraries and create new libraries in customer naming range.

      And also you may copy the standard reports and create new reports in customer naming range and modify them to suite business requirements. And you can transport(Tr.code GCTR ) the report group(recommended).

      Most used standard libraries are

      1VK- Cost Centers: Absorption Costing ( for Cost center reporting)

      8A2        EC-PCA: Standard Reports (for Profit center reporting )

      6O1        Internal Orders (for Internal Order / PM order reporting)

      thanks & regards,

      George koshy

      Senior SAP CO Consultant

      (0) 
  1. Krali Marko

    Thanks Anss for this post, it’s really very nice report, looks perfect, but….

    I was already familiar with this kind of reports, to be honest, but I have some issue with this report,

    I suppose you could help me,

    Problem is when I have partial payment for an invoice,

    If partial payment is made before due date of invoice, system gives same due date on partial payment as invoice, but when a partial payment is made after due date of invoice, system gives posting date of partial payment as due date (F-53, F-28 for customers), (just to mention that payments from F110 always take posting date of partial payment as due date) and then in this report partial payment and invoice are coming in two different ages,

    Is there a way in sap, partial payment to take always due date of invoice, no matter when it happens or this is standard behavior of SAP.

    For that reason I use report S_ALR_87012085 and a tick Assign Items option, works fine, but it’s not very charming, looks bad, not user friendly at all, not good for export also,

    (0) 
    1. Former Member

      Hi Krali Marko,

      If i understand your requirement correctly, you want:

      • the terms of payment of the invoice should be assigned to the residual item in case of a partial payments.

      Standard SAP has a solution for acheiving this requirement.

      Please do the below mentioned steps:

      • Create a tolerance group/modify the existing tolerance group for customers/vendors(please use transaction code OBA3) and
      • In the box – Specifications for Posting Residual Items from Payment Differences, select the checkbox – Payment Term from Invoice(T043G-XKONR) and

      • In the Customer/Vendor Tolerance Group please do not maintain any Payment Terms in the field – Fixed payment term(T043G-ZTERM) and
      • Assign the tolerance group to the desired customer/vendor master(please use transaction code FD02/XD02/FK02/XK02).

      After the above steps have been carried out please enter a customer/vendor invoice and post a partial payment against the same customer/vendor.

      Please check the residual item, the terms of payment available in the invoice would be assigned to the residual item.

      Hope this helps in resolving your issue.

      (I understand your query was specifically addressed to Anss, but i just thought that the resolution is important rather than the resolution provider)

      Thanks and regards,

      G. Ajit Kumar

      (0) 
      1. Krali Marko

        Hi Kumar, thanks for your reply,

        Our company policy is not to use residual item, but strongly partial payments,

        We already have tolerance group for customers/vendor, and it work on way as you explained. Unfortunately  we cant use this functionality. I need solution for partial payments always to take net due date from original invoice.

        Thanks,

        Krali Marko

        (0) 
  2. Former Member

    Hi Anss

    this you have developed is very good and easy way to understand.

    Thanks is not sufficient word You Deserve More Than That

    but Still Thank you

    (0) 
  3. Former Member

    hi,

    nice work. very useful for functional consultant. also one thing mention to how create TCODE for this report and how to assign to report group.

    regards,

    Rakesh

    (0) 
  4. Former Member

    Hi there,

    Thank you very much. its very useful. COuld you please let us know building of Cash flow, Income statements and Funds flow statements?

    Regards, ‘MG

    (0) 
  5. Former Member

    Hi Anss,

    Thanks for sharing this wonderful exercise.However, I am facing a problem while adding the key figures 

    • Account Type – K
    • Vendor – From “0” to “9999999”

    in FKI4 create form.

    I am unable to see the fields ‘account type’ and ‘vendor’ in this screen. I tried a lot to find how I can add these characteristic to the key figure, however I coudn’t succed. Unless these fields can be added to the chart the row would not be complete.

    I would be grateful if you help me out of this.

    Regards,

    Omkar

    (0) 
  6. Former Member

    Hello Anss,

    This is a fantastic post for the people who have heard about report painter and never used like me..

    totally understand the content thanks for your hard work and keep it up.

    tc

    (0) 
    1. Anss Shahid Essani Post author

      Hi Veenu,

      Thank you for appreciating the work.

      I think that the ABAPer is the better person to assign T-Codes to report. Once you have created the report, the ABAPer may ask you the report’s program.

      When you are executing the report, you may go to “System –> Status”. There you will be able to find the program and other information that the ABAPer might require.

      Hope it helps out!  ๐Ÿ™‚

      Cheers,

      Anss

      (0) 
  7. Former Member

    Dear Anss Shahid Essani,

    Really a very good Document, Great works !!!!

    Thank you very much for sharing the document .

    Thanks and Best Regards,

    Madhukumar L

    (0) 
  8. Former Member

    Dear Mr. Shahid,

    Really a Great Explanation for Drill-Down Report Painter functionality. Much appreciated your way of helping others to understand SAP standard functionality.

    Have also attempted to create one small report for Vendor balance only with Drill-Down Report facility.

    Have one small question, When user prints the drill down report, Selection criteria comes into the printout in the starting which is quite annoying, tried to remove the tick from setting still could not get success for removing the selection criteria.

    Would you be needful to help me for removing the selection criteria from drill-down report printing.

    Many Thanks for your help.

    Kind Regards

    p

    (0) 
    1. Mukthar Ali Ahamed N

      Dear Mr.Shahid,

      Nice document. But I have a query. How can we specify the noted items i.e. down payment request will not include in vendor balances. I am struck out here. Please clarify.

      Regards,

      Mukthar

      (0) 
  9. Former Member

    Hi Anss,

    I have followed the steps mentioned above and completed customer aging report,

    When i execute the report using Tcode -FD10, i am getting only key date as input filed, i would like to add customer filed also in the input screen and how to view the aging report by transaction level. at present i am getting slab level total. how to view transactions . Many Thanks.

    Regards,

    Siddu M



    (0) 
    1. Shihab MS

      You have to add line item report in report assignment under option tab to view the line item level. Report type is RT- ABAB report and technical name is RFARRE_ITEMS

      (0) 
      1. Former Member

        Dear Shihab,

        As suggested, i have selected but i am not able to see the line items level, i can see, totals as per slabs and also can you please advise how to add customers filed in the input selection screen, at present i have only one filed that is Key date. Many thanks.

        FDI0- input selection screen shot.

        FDI0- Output screen shot.

        Regards,

        Siddu M

        (0) 
        1. Shihab MS

          HI Friend

          You have to drill down from this list into line item report select the figure and click on to execute the line item report.

          (0) 
          1. Former Member

            Hi Shihab,

            Thank you very much for your help, now i am able to see the line items, can you please let me know how can we add customer filed in the input selection screen…at present we have “Open items at key date” in Tcode- FDI0. Many thanks.

            Regards,

            Siddu M

            (0) 
  10. Former Member

    Dear Anss,

    Thanks for posting the information in details. It will help many users to understand and design aging report.

    I would like to see more details from you for other options.

    Regards,

    Waqar

    (0) 
  11. Former Member

    Hi shahid

    excellent report someone like me who new to reporting painter, it’s help me a lot to create ageing reports for my client.

    Thanks for your inputs

    Regards

    Raj

    (0) 
  12. Anss Shahid Essani Post author

    Hi Friends,

    Thank you very much for your appreciation. Hope that this document was useful initial configuration of report painter.

    I will be sharing more documents and blogs very soon.

    Thanks,

    Anss

    (0) 
  13. Former Member

    Thanks alot Anss.

    This one not only helped me to know about a scenario of aging but also about the report painter concepts.

    Regards,

    Siva Cheruvu

    (0) 
  14. Former Member

    Thanks Sir,this is so great and good as usual in short for every beginner like me this blog is not less than a great blessing.

    Allah Bless you.
    Aameen.

    Regards.
    Faisal Sheikh

     

    (1) 
  15. Former Member

    HI,

    I am looking for one more column for invoices due in next 20 days . Where days in arrears are less than to equal to -20 means due in next 20 days ?

     

    Is it possible?

     

    Many Thanks

     

    (0) 

Leave a Reply