Showing results for 
Search instead for 
Did you mean: 

creation of report with the help of report painter

Former Member
0 Kudos

Dear Experts,

I need report painter material, if any body have pls farward to me.

my intension to create controlling report with the help of report painter.

I am ready to award full points.

Thanks in advance



Moderator - Please read this:

/thread/931177 [original link is broken]

Thread locked

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Chinasammy,

Report Painter allows you to create reports using data from SAP application components, which you can adapt to meet your individual requirements.

Many of your reporting requirements can already be met by using the standard reports provided by various SAP application components. If these SAP standard reports do not meet your reporting needs, Report Painter enables you to define your specific reports quickly and easily.

When executing a Report Painter report, it is displayed by the system in Report Writer format. You thus have access to the same functions as for Report Writer reports defined in the same way, and can combine Report Painter and Report Writer reports together in a report group.

Report Painter uses a graphical report structure, which forms the basis for your report definition and displays the rows and columns as they appear in the final report output.

To facilitate report definition, you can use many of the standard reporting objects provided by SAP (such as libraries, row/column models, and standard layouts) in your own specific reports. When you define a Report Painter report you can use groups (sets). You can also enter characteristic values directly.

Advantages of Report Painter include:

Flexible and simple report definition

Report definition without using sets

Direct layout control: The rows and columns are displayed in the report definition as they appear in the final report output, making test runs unnecessary.


Below mentioned is the process for creating reports using Report Painter as a tool.

Selecting and maintaining a library for your report: As the transfer structure to Report Painter you use a report table, which is defaulted by SAP and can not be maintained. This table contains characteristics, key figures and predefined columns. In a library, you collect the characteristics, key figures, and predefined columns from the report table, which you need for your Report Painter reports.

When you define a Report Painter report, you assign it to a library. Reports assigned to one library can only use the characteristics, key figures, and predefined columns selected for that library.

When you create or maintain a library, the Position field determines the sequence in which the characteristics, key figures or (predefined) key figures appear in the Report Painter selection lists when you define a report. This allows you to position the objects that you use regularly in your reports at the beginning of the selection lists. If you do not make an entry in the Position field, you will not be able to use this object in Report Painter reports.

You can use either the standard SAP libraries for your reports or define your own.

(ii) Selecting or maintaining a standard layout for your report: Standard layouts determine report layout features and the format of your report data.If the SAP standard layouts do not meet your reporting requirements, you can create a new standard layout or change an existing one.

(iii) Defining row and column models: A model is a one-dimensional, predefined reporting structure that you can insert in either the rows or columns of your report.If you often use the same or similar row or column definitions in your reports, it is recommended that you create row or column models.

You must define the row and/or column models that you want to include in your report definition before you define the report.

You can also use the standard column models supplied by SAP.

(iv) Defining the report: Defining a Report Painter report involves the following steps.

(a) Define the report columns: You define the report columns using the characteristics, key figures, and predefined columns selected for the library that the report uses. Alternatively, you can use a column model for column definition. Column models are predefined column structures which you insert into your entire column definition, instead of defining each individual column.

(b) Define the report rows: You define the report rows using the characteristics selected for the library selected for the report.

Alternatively, you can use a row model for your row definition. Row models serve the same purpose as column models, but are used to define a report row.

Edit and format the report rows and columns in line with your requirements. (For example, you can hide rows or columns, define the column width or define colors for your report rows).

(iii)Define general data selection criteria for the selection of your report data: Selection criteria are the characteristics used to select data for the entire report. You cannot enter characteristics as data selection criteria if they are already being used in the report rows or columns.

(iv) Assigning the report to a report group: Once you have defined a report, you must assign it to a report group. A report group can contain one or more reports from the same library. However, reports that share the same data will select data more quickly and improve processing time.

Hopw this helps you. Please let me know if you need anything more and assign points.



Former Member
0 Kudos

Hi Manish,

Thanks for ur immediate reply. I assign points to u.Still i am not getting clear idea, if u have any sample report, could u farward to me.