Skip to Content
author's profile photo
Former Member

Report Painter


can any one provide me with step by step guide to report painter.

as I have requirement to create a report using a painter.

Thanx in advance


Sriram Pattapurati.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 09:27 AM

    Hello Sriram,

    You should be able to meet most of your reporting requirements using the standard reports in your R/3 application components. However, if these reports do not entirely meet your needs, you can define your own reports quickly and easily using the Report Painter.

    With the Report Painter, you can define reports which allow you to present complex data analyses in a structure. To do so, you set various characteristics and key figures when defining the report.

    Characteristics are non-numeric fields. They represent the criteria according to which you can select data records. Examples of characteristics are "Controlling area", "Fiscal year" and "Profit center". Characteristic values are the instances of these characteristics, such as fiscal year 1998, 1997, and so on.

    Key figures are numerical fields that you can analyze in your reports. Examples of key figures are costs and revenues or balance sheet balances in a certain currency or activity quantities.

    Procedure for Creating a Report Painter Report:

    From the relevant application, choose Tools-> Report Painter->Report->Create.

    The Report Painter: Create Report screen appears.

    You can also create Report Painter reports from any Report Writer screen. To do so, choose Report Writer->Report Painter->Create report.

    Enter the name of the library the report is to use, and a name and description for the report. The report name can be a maximum of eight characters long.

    If you want to create your report using an existing Report Painter report as a basis, enter the name of the report that you want to copy under Copy from. Both reports must use the same library.

    Choose Create.

    The next screen displays an empty report containing four rows and four columns (this is the basic structure for a report). You define your report on this screen.

    Enter or change the description for the report by double-clicking the report description field.A dialog box appears in which you can enter a short, medium, and long text for the report description.

    Define the rows of your report.

    Rows contain a combination of characteristic values or formulas. Note the lead column at the first position of the rows. The Report Painter uses the lead column to access the rows. You can replace the description Lead column with a different term.

    Define the columns of your report.

    Columns contain a combination of a basic key figure and optional restricting characteristic values. You can also use predefined key figures to present key figures and characteristics that make business sense. For example, a number of predefined key figures are delivered for the libraries in Overhead Cost Controlling that can be copied directly into the reports, where they can be modified as required.

    Define general data selection criteria.

    The general data selection criteria restrict data selection for the report.

    Choose Save and then Execute to create the report. Assign the report to a report group.

    You have to display the report before you execute it, so that you can later change the report layout directly from the report list.

    Once you have defined a report, you can display and print out a table of contents with Extras->Overview.

    The overview contains the characteristics and characteristic values used in the individual sections, column blocks, and general data selection criteria. It also provides general information such as the user who last changed the report, the report name, and the standard layout assigned to the report, as well as details on the report formats.

    If you double-click an individual characteristic, you can see where this characteristic is used in the report definition.

    Hope I had been able to help you. please assign points and let me know if you need anything more.

    How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member


      Thanx for the reply, well have a query, how do i select/add table whihc is not there in the drop down list when creating a report.

      thanx in advance.



  • author's profile photo
    Former Member
    Posted on Aug 21, 2007 at 08:10 PM


    Please check out the following link:

    Hope this helps.

    Please assign points as a way to say thanks.


    Add comment
    10|10000 characters needed characters exceeded