Add Flexibility to Report Writer and Report Painter Tables for Your Critical Business Reports

  • by Soorian Ethirajulu, Global Business Systems Analyst
  • April 12, 2012
Report Painter and Report Writer are two comprehensive reporting tools provided by SAP. You can use only reporting tables that are defined in the system in these tools to create reports. Learn how to enhance the functionality to use multiple tables to increase their capabilities.
Key Concept

Report Writer and Report Painter are SAP reporting tools with which you can define reports using standard reporting objects such as libraries, standard layouts, and row and column models. Standard reports delivered by SAP can meet most of the reporting requirements. However, if your reporting requirements are not fulfilled by SAP’s standard reports, you can also define complex reports using these tools.

Report Writer and Report Painter are flexible reporting tools available in the SAP system for developing reports for all kinds of evaluation without ABAP development. In finance, many standard reports developed with Report Writer and Report Painter are available in managerial accounting (CO) and the Special Purpose Ledger. With SAP ERP Central Component (SAP ECC), Report Painter and Report Writer became available in SAP General Ledger (the new general ledger).

The limitation is that not all database tables can be used to develop these reports — only those tables configured as reporting tables. Most of them are preconfigured and delivered by SAP or configured in applications such as the Special Purpose Ledger. Most of these tables are single tables with transaction data. You can develop these reports using the Report Writer and Report Painter only with those characteristics that exist in the respective table.

I’ll discuss how to combine more than one table that can be configured as the reporting table and then create reports using characteristics from multiple tables. In this example, I’m using the SAP General Ledger total reporting table FAGLFLEXT with the general ledger master data table SKA1. Reports created from this view can use the group account from the master data table instead of the general ledger account from the standard reporting table. The article is appropriate for business super users who can create ad hoc reports, analysts who design the reports, and technical staff who support the enhancement.

You need to follow a six-step process:

  • Step 1. Create a database view
  • Step 2. Include the view in data declaration
  • Step 3. Perform the technical setup of the Report Writer table
  • Step 4. Maintain the table directory
  • Step 5. Maintain the integrated master data
  • Step 6. Generate the FI programs using report RGZZGLUX

Soorian Ethirajulu

Soorian Ethirajulu is a business systems analyst at a leading global medical technology company. He has a master’s degree and professional certifications in accounting and finance. He is also an SAP-certified solution consultant in FI and CO. He has about 13 years of SAP experience in FI and CO, including more than seven years as a consultant. He is currently involved in a global implementation of SAP ERP Central Component (SAP ECC) 6.0.

If you would like to submit an idea for an article for SAP Professional Journal, contact managing editor Scott Priest.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.