3 Replies Latest reply: Feb 29, 2012 11:36 AM by sravanthi chilal RSS

REPORT WRITER AND REPORT PAINTER

Santosh L
Currently Being Moderated

Hi Techis,

 

Will anybody pls tell me the details workin of reort painter and report writer along with Tr code and also will u pls give me the steps to execute such type of report.

 

Rewards will be given for each reply.

 

Regards

 

Santosh L.

  • Re: REPORT WRITER AND REPORT PAINTER
    Sravan Prakash Varanasi
    Currently Being Moderated

    T.Code GRR1 (Report painter/writer)

     

    Report Painter & Report Writer is generally used for creating FI reports.The Transaction code to create report painter is GRR1 & for creating report writer it is GR31.

    Example are Trial Balance report,Consolidated Balance sheet,Profit(loss).

     

    For Report Painter Check these links

     

    http://help.sap.com/saphelp_47x200/helpdata/en/66/bc7d2543c211d182b30000e829fbfe/content.htm

     

    For Report Writer

    http://help.sap.com/saphelp_47x200/helpdata/en/66/bc7dc143c211d182b30000e829fbfe/content.htm

     

    Refer the following links :

     

    http://www.virtuosollc.com/PDF/Get_Reporter.pdf

    http://sap.ittoolbox.com/groups/technical-functional/sap-r3-other/accessing-tables-using-report-painterwriter-98766

    http://help.sap.com/saphelp_47x200/helpdata/en/da/6ada3889432f48e10000000a114084/frameset.htm

    http://help.sap.com/saphelp_bw31/helpdata/en/66/bc7d2543c211d182b30000e829fbfe/frameset.htm

     

    Reward points if useful.

  • Re: REPORT WRITER AND REPORT PAINTER
    Mahalakshmi Padmanaban
    Currently Being Moderated

    Report Writer is a tool for creating reports that meet specific business and reporting requirements.

     

    Report Writer enables you to report on data from multiple applications. Using functions such as sets, variables, formulas, cells and key figures, you can create complex reports that meet specific reporting requirements.

     

    When working with Report Writer, you can use certain functions that are not supported by Report Painter. These functions include:

     

    Multidimensional column structures

    User-defined definition of inactive row and column combinations

    Enhanced functions for using cells in column formulas.

     

     

     

    Report Painter: The Report Painter is similar to the Report Writer, but is simpler to use. Most of the functions in the Report Writer are also available in the Report Painter. The Report Painter is based on the WYSIWYG (What You See Is What You Get) principle.The main components of report painter are characterestics and basic key figure.

     

    Characteristics must be defined in your report, either as data selection criteria, report rows, or report columns. To improve processing time, you should specify all characteristics in general data selection that are not needed in the report rows or columns.

     

    The process flow for report writer/report painter is almost same and is as following.

     

    Create Set->select library->define report->Check report->Assign report to report group->Generate report->Execute report

     

    Check this thread

    Urg: Regarding Report Painter and Report Writer

     

    Also check these thread too.

    Differences Between Report Painter and Report Writer

    Reg:Report Painter

     

    Regards,

    Maha

  • Re: REPORT WRITER AND REPORT PAINTER
    sravanthi chilal
    Currently Being Moderated

    hi santosh,

     

    Where Is Report Painter/Report Writer Used?

     

    Initially, both tools were only available to the FI/CO modules. Later, with the introduction of the Logistics Information System and Flexible Analyses in Release 3.x, the functionality of these tools was further expanded. It still is not widely known that the Report Painter/Writer can be used for reporting against structures other than those delivered in FI and CO (see TechTalk on page 8-4).

     

    A common misconception in the user community is that Report Painter/Report Writer can only be used to report against a single table. However, some reporting structures do report against multiple tables. For example, CCSS (for Cost Center Accounting) refers to tables COSP, COSS and more, depending on the key figure configuration. Similarly, FI-SL (Special Purpose Ledger) reporting structures include summary and line-item tables (the key figure set determines where the data comes from).

     

    To configure other table joins, views may be created joining the necessary tables, and views can be added to the control tables, via Flexible Analyses in LIS. Report Painter/Report Writer can be used in almost any application area in R/3 to report on currencies and quantities.

     

     

    Data tables supported

     

     

    Both Report Painter and Report Writer can be used to report on the following tables and tables types:

     

    < Evaluation structures set up in the Logistics Information System (LIS). These structures normally begin with an “S” or “ZF.” Several different tables and views within the R/3 System can be added as evaluation structures.

     

    Note: You cannot add cluster tables, such as BSEG.

     

    < CCSS is used for Cost Center Accounting (CO-CCA), Internal Orders (CO-OPA), Activity Based Costing (CO-ABC) and for cost element reports in Project Systems (PS).

     

    < GLFUNCT is used for functional area reporting in cost-of-sales accounting.

     

    < GLPCT and GLPCOP are used for Profit Center Accounting (CO-PCA/EC-PCA).

     

    < FILC is used for Legal Consolidations (FI-LC).

     

    < COFIT is used for the Controlling Reconciliation Ledger (CO-CEL).

     

    < ZZ tables are created for the Special Purpose Ledger (FI-SL).

     

    < FIMC is used for consolidations in the Enterprise Controlling module (EC-LC).

     

    < GLT0 is used for Financial Accounting (General Ledger) reports by account, company, and business area (FI-GL).

     

    < KKBC, KKBE, and KKBU are used for the Controlling Product Costing module (CO-Costing).

     

    < New in Release 4.0A: RWCOOM is used for CO-CCA, CO-OPA, and CO-ABC. RWCOOM is used for special standard reports like internal order budget reports, cost center budget reports and cost component reports.

     

    Note: RPPS was used for Project Systems (PS). However, it is obsolete and will no longer be supported in Release 4.0. In Release 3.x there were only two special reports (6P70 and 6P71) using RPPS. These reports cannot be called directly, but via ABAP reports RKOPLAN0 and RKOPLAN1.

     

     

    How to Access Report Painter/Report Writer?

    To access the Report Painter you may use either of the following two methods:

     

    < Transaction FGRP

     

    < From the SAP main menu, choose Information systems ® Ad hoc reports® Report painter.

     

    Report Writer functions can be accessed from within the Report Painter. To access Report Writer, choose the following menu path from the SAP main menu:

     

    Information systems ® Ad hoc reports® Report painter® Report Writer.

     

    How Is Report Painter/Report Writer Organized?

    Report Painter/Report Writer has four main components:

     

    < Sets: Sets are logical groupings of characteristic values. For example, a cash line on a balance sheet is made up of a set of cash accounts or an energy product line on an inventory report is made up of a set of energy products. Variables can also be created which are placeholders for sets, or values within sets.

     

    < Libraries: Libraries control which characteristics and key figures from a table are available for reporting.

     

    < Reports: Reports hold a definition of the rows, columns, and overall data selection. They also include the header and footer texts and layout settings.

     

    < Report Groups: Report groups can contain one or more reports. The report group is what you execute—not the actual report. A report group is generated to create a set of ABAP programs that produce the reports.

     

    How Does Report Painter Differ from Other Reporting Tools?

    < With the exception of row titles which have text fields, Report Painter/Report Writer reports display numerical fields only (for example, dollar and quantity fields). This is not a requirement for ABAP Query and typical line item reporting tools, which can display arbitrary text columns.

     

    < While printed Report Painter/Report Writer reports appear much the same way on paper as they do on screen, the Drilldown reporting tool produces a different output format. Drilldown reporting is an online analytical tool which can be used to drill down to different levels of detail, but it is infrequently used for printing.

     

    < Report Painter/Report Writer reports are hierarchical and take advantage of configured hierarchies (for example, with cost center hierarchies). You can also execute Report Painter/Report Writer reports from each level within a hierarchy.

     

    < Report Painter/Report Writer reports can handle multiple currency/quantity units within a single column.

     

    < Report Painter/Report Writer is well suited to handle reports that require mass production. For example, Report Painter/Report Writer is a particularly effective tool for creating month-end reports.

     

    refer this link

     

    http://help.sap.com/saphelp_erp2005/helpdata/en/66/bc7d2543c211d182b30000e829fbfe/frameset.htm

    http://abaplearner.blogspot.com/2007/12/more-abap-tutorials.html

    http://www.virtuosollc.com/PDF/Get_Reporter.pdf

     

     

    regards,

    sravanthi

     

Actions