Report Painter
目录
Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search
Support Wiki
Spaces
Help
Log in
Pages
ERP Financials
Reporting
Skip to end of banner
Go to start of banner
Report Painter
Skip to end of metadata
Created by SAI KRISHNA VALLURUPALLI on Oct 26, 2007
Go to start of metadata
1 FEATURES OF REPORT PAINTER (RP)
Relatively simple reporting creation - define rows and columns.
Use of sets (groups) for Cost Centers, Cost Elements, Funds, etc
Sets for selections - for report overall, individual column filtering and totals.
Hierarchical sets for automatic sub-totals in the rows.
Suppression of reported details in the set.
Characteristic display : choose the key (e.g. "4700") or description ("Power Fund") or both.
Authorization checks, if required, on SAP pre-defined fields - e.g. Cost Center and Cost Elements in CO Cost Center Accounting reports.
Easier than Report Writer (RW) since it is really a graphical front-end to RW. There are a few limitations in RP which RW does not have :
a characteristic can only be used in one part of the report structure - in rows or columns or in the general selection.
cannot use existing multi-dimensional sets
page break specifications
defining thresholds per section, etc
RP reports can be edited with / converted to RW and even to ABAP if required.
Column display formats can be set : e.g. scaling to 000's with one decimal place.
Headers : can include selection / drilldown variables.
Several reports can be included in the same "Report Group" and are run together, with the same general selections.
Other reports can be called up - other RW/PR reports, ABAP Queries, ABAPs and transactions (including master data display) - the selected cell's characteristics (Year, Cost Center etc) are transferred.
Report results can be stored as extracts and re-displayed instead or re-running the report.
Report definition management : use TMS (transports), or use export/import to/from PC files, or copy across clients.
2 CONSTRAINTS
RP/RW only works with reporting structures that have been pre-defined. The existing database tables are linked through a reporting structure - like "CCSS" - and then there is further RW Control tables definition. This last step is very technical and is not recommended for SAP customers or for that matter most consultants.
Also, the RW tables have the Authorization Check assigned - e.g. CCSS has E14_AUTHORITY_CHECK and filler routines for the fields. For user-defined tables there may need to be additional Authorization Check routines written and assigned to the RW table.
[See GRCT for technical set-up of a RW "table".] Also, SAP recommends using selection variants and display variants for Line Item reports. Note : only the CO line items have the Fund field, not the CO totals tables.
3 SAP HELP
See : Financials / Special Purpose Ledger / Tools
See : Financials / Controlling / Cost Center Accounting / Information System / Report Definition
4 ELEMENTS FOR REPORTING
4.1 Conventions
Each of the following aspects of defining the report will need naming conventions :
• Libraries - e.g. cannot start with a number.
• Reports
• Report Groups - e.g. cannot start with a number.
• Sets
• Variables, Set Variables and Formula Variables.
Additionally there need to be layout conventions for
• Report cover page
• Report titles
• Report headers - include run date, time, client
• Report footers
• Page numbering
• Column headings & formatting
4.2 REPORT WRITER TABLES AND LIBRARIES.
Report Writer Tables specify the data tables available for, and the reporting structure used for RW/RP reports. (These tables are defined with GRCT, and can include various ABAP routines for authorization exits, data filler and conversion routines for presentation and texts etc).
Report Writer Libraries are set up to further define the data required for reports (limit available fields or change texts). Libraries are linked to the RW tables. RW (and RP) reports which require similar data or will be developed or run but a specific group of users can share a library. Many libraries can be linked to the same RW table.
• Libraries are usually set up, delivered and supported by SAP. It is possible to set up your own, but this can be a comlex task, depending on the reporting requirements and a Logical Database, Query InfoSet or ABAP may be a quicker option.
The most often used RW Tables are :- CCSS Cost Center, Order and WBSE data.
• RWCOOM Overhead Cost Controlling (Spec. Evaluations)
• FMRBCS FM Budget Control System data
• GMIT Grants Management
• ZZSPLITT FI-Special Ledger (Fund General Ledger)
• FIMC EC-CS Consolidations Ledger
• GLPCT, GLTPC EC-PCA Profit Center Accounting
• RPPS Project System Summarization table- COFIT CO/FI Reconciliation Ledger - use standard reports.
• Sxxx Various Purchasing and SIS reporting structures
SAP RW Library Numbering : e.g.
• 0xx A few banking/GL reports
• 1xx Various different CCA reports- 1VK Most Standard Cost Center reports are in here
• 3xx Purchasing and SIS reporting
• 4xx Various - e.g. in Public Sector, 4FM (for FM reporting)
• 5xx CO/FI reconciliation ledger reports
• 6Ox Internal Order reporting
• 6P3 Project reporting - this has the "Object" field and is linked to the PS component, so the selection fields for the LDB PSJ are automatically included.
• 7xx Product Costing
• 8xx Profit Center Accounting
• 9xx Activity Based Costing
CUSTOMER RW Library Numbering : e.g.
• ZVK Copy of 1VK - with Fund field activated. In DV1.210 and 220 only.
o Note : Fund is on Line Item table, so if referenced the report will take longer to run. Use a Cost Center group by Fund instead (see section 4.4 on Sets).
• ZP2, ZP3 Copy of 6P2 and 6P3 for project reporting
• ZSL Created for the Fund Accounting Ledger (Special Ledger)
• ZFM Copy of 4FM for Funds Management
Library definition
• Characteristics for reporting : like Cost Center, Fiscal Year, Cost Element, Plan/Actual Indicator.
• Default Sets can be entered - appear on report selection screens.
• Basic Key Figures : numeric fields from the tables - e.g. costs. Behind the scenes the Key Figure is categorized as value field or a field group with period counter in field name.
• (Predefined) Key Figures : basic key figures with additional characteristics - e.g. costs for the current fiscal year or the current period. Prefix for CO Module predefined Key Figures are typically :
• I = actuals, P = planned
• Y = stat. actual, Q = stat. planned
• O = commitments (requisitions & purchase orders).
- Predefined Basic Key Figures for CCSS
See Appendix B.
4.3 REPORT GROUPS
a. A Report Group is a way to group reports with the same selection criteria. The program selects from the database only once, then each report is processed separately on the selected data.
b. The Report Group is the only way to run the report. It is the generated program based on the report code, variable definition, set definition etc.
c. Report : report group combinations
• A Report Group can have only one report.
• A Report Group can have several reports.
• A report can be in more than one report group - e.g. in a group by itself, in a monthly run group with a few other reports and in a year-end group with many other reports.
d. A Report Group can be set up to re-generate each time it is executed - all reports in it will be recompiled before executing. Or the setting can be for manual generation, which is recommended in a production system - move the report group there, generate it and it does not waste time recompiling each time it is run.
e. When a Report Group is executed (GR55), the user has the option to deselect any reports not required.
f. The Report Group (or the Library) can also identify other reports (or transactions) to call up when drilling down on a cell in the executed report. E.g.
• Transaction FB03 Display FI-GL Document
• Transaction KSB5 Display CO Document
• ABAP RKPEP004 PS WSBE Line Item Report
• Transaction KSB1 Cost Center Line item Report - Actuals
• Transaction KSBP Cost Center Line item Report - Plan
• Transaction KSB2 Cost Center Line item Report - Commitments
• Report Group ZFM1 Budget Analysis
4.4 REPORTS
4.4.1 REPORTS - General
a. A report is always created with reference to the pre-defined library.
b. A standard SAP library can be copied and amended - e.g. 1VK can be copied to ZVK and changed so the "Fund" field is made available for reporting.
c. A characteristic can be specified in only one place - column, row or general selection criteria.
d. Most standard SAP reports focus on Cost Centers, or orders or Projects. Only a few cover more than one :
• Report 1SOP-001 has CC, Internal Order & WBSE - based on the Responsible Cost Center in the Order and WBSE.
• Report 1SO1-002 + 1SO1-003 has CC and Internal Order reported separately but run together.
4.4.2 REPORTS - Define Columns
...
