Hierarchy

⤷

⤷

IMG Activity
ID | SIMG_CFMENUORKKFGRP | Create User-Defined Reports |
Transaction Code | S_ALR_87008095 | IMG Activity: SIMG_CFMENUORKKFGRP |
Created on | 19981222 | |
Customizing Attributes | SIMG_CFMENUORKKFGRP | Create User-Defined Reports |
Customizing Activity | SIMG_CFMENUORKKFGRP | Create User-Defined Reports |
Document
Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
Document Name | SIMG_CFMENUORKKFGRP |
Creating User-Defined Report Painter Reports
Many reporting requirements are solved by standard system reports. If, however, non-standard requirements remain unfulfilled, you can use Report Painter for simple, quick definition of user-defined reports.
You can also use standard references objects to construct your own reports: libraries, standard layouts, default columns, and row and column models, all in the standard system, and available for custom reports.
A report can consist of several "logical" pages. This is useful if you wish to construct managerial key figures, such as costs per employee. You can switch between logical pages and carry out calculations with them.
Report Painter report definition requires several Preparatory Steps, depending on the complexity of the report to be generated.
Requirements
To create reports for user-defined libraries with Report Painter, you must maintain the Libraries first.
Standard settings
The standard system includes many standard layouts and column and row models, as well as default columns for libraries 1VK, 1GK, 1AB, 1RU, and 7KK. As a rule these standard modules are sufficient for report definition.
Recommendation
Do not change a standard report because any changes will be overwritten when importing new reports from client 000 (which supplies standard reports).
- To make small changes to a standard, use the report as a model, copy it to another name, and change the copy only. Choose Report -> Copy.
You can use reports as models in one library only, but you can copy reports from other libraries.
Activities
The procedure when defining a Report Painter report depends on how far the supplied standards satisfy your requirements.
- If the libraries, layouts, row and column models, and default columns in the standard system are sufficient:
- Define report columns by using the supplied default columns and characteristics as well as formulas and standard layouts in the standard library.
- You can construct columns from characteristics, formulas, or predefined columns. Predefined columns can be changed by inserting further characteristics. You can also use variables, but only those already defined in Report Writer.
- Select a column by double-clicking.
- Choose Key figure with characteristics or Default columns for the column structure.
- If you choose Key figure with characteristics, use the dialog box to mark the key figure to be used in the report.
- In the following dialog box, choose the characteristics to be used in the column and afterwards specify the characteristic values as individual values, groups, intervals, or variables.
- To define all possible values for a chosen characteristic, enter an asterisk (*); to define an initial value, enter a pound sign (#).
- To use variables, choose Variables on/off. The SAP system automatically indicates the appropriate field and automatically adjusts the field length. Choose "Possible entries" to display all existing variables.
- If you choose Default columns, specify one of the standard default columns in the dialog box. You can then change or expand upon the suggested characteristics and characteristic values.
- To define a further report column, select the element type Formula in the dialog box. Use the formula editor to select other report columns and predefined cells to define a formula which calculates a value for the column.
- Enter a column text. Choose Copy to copy the short text to the fields Middle and Long as well.
- You can also use variables in a column text. To store a variable, enter an ampersand (&) followed by a variable name. When you activate Key as text type in the standard report layout under Column text, the report issues the current value of the variable. If you activate Name, the report issues the name of the current value.
- Define report rows by using the characteristics or row models available in the standard library.
- All steps in row definition are similar to those in column definition.
- If the libraries, layouts, and row and column models do not meet your requirements:
- If necessary, maintain the corresponding library.
- If necessary, create a new layout or change an existing one.
- If necessary, maintain the standard default columns.
- In Report Painter, choose Set maintenance -> Data set entries -> Maintenance.
- If necessary, create new row and column models.
- Proceed as described in the definition of report rows and columns.
- For further report definition proceed as described in step 1.
- Determine general selections
General selections include the characteristics according to which you select data for a report, but which are not to be identified in report rows or columns.
- Save your report.
- Insert your report into a report group.
Further Notes
Note on transport
To transport Report Painter reports, see the IMG activity Transport Report Writer Objects in the IMG for Financial Accounting under Special Purpose Ledger -> Tools -> Transport.
For more information on user-defined reports, see the SAP Library under Financials -> CO Controlling -> Cost Center Accounting -> Information System -> Defining Reports.
Creating User-Defined Report Painter Reports
You can also use the Report Writer tool to create your own reports. However, this tool is more difficult to use than the Report Painter and requires more knowledge of the system. Users who do not have this knowledge should use the Report Painter to define their reports.
The technique you use to define Report Writer reports is the same as that of the Report Painter. Just as with the Report Painter, you can use libraries, standard layouts, predefined columns, characteristics, and variables to create your reports. You can access standard modules or define your own report components.
For detailed information on the individual report components, see Preliminary steps.
Recommendation
- You generally shouldn't change the standard reports, because when you import new SAP reports from client 000 (the client in which the standard reports are delivered) your changes will be overwritten.
- If you want to make minor modifications to a standard report, you should create your report with a standard report as a template. It is also possible to copy the standard report under a new name and only change the copy. To do this, choose Report -> Copy. Although you can only use reports as a template when they are in the same library, when you copy you can use reports from other libaries.
Actions
- If the libraries, predefined columns, and sets in the standard system do not meet your requirements, proceed as follows:
- In the header of the report, define general information on the structure of the report (such as the standard layout to be used).
- You define the columns of your report by specifying column blocks. You can access key figures or predefined columns on the library, or use datasets that are available for the corresponding report table. The sequence of the entries within a column block determines how the columns appear in the report.
- You define the rows of your report by specifying a row block. This is a set that was normally created for the characteristic "cost element" and contains a variable that allows a cost element or cost element group to be entered when the report is accessed.
- If you want to have multiple sections within your report (such as the cost elements in the upper section output quantities in the lower section), you must define multiple row and column blocks accordingly. Row block 1 normally refers to column block 1, while row block 2 is combined with column block 2.
- Define general selections for your report. This is information that you have not added to the rows or columns and that refer to the report as a whole. Here you can either add a set that consists of single values (such as for all controlling areas you want to report on) or a set variable. Set variables allow you to determine the contents of the variable when you access the report (such as the fiscal year, period, or order number).
- Save your report.
- Create a report group and assign it to your report.
- If the report components supplied in the standard system do not meet your requirements, you can create your own:
- Maintain a corresponding library.
See Maintain libraries. - Create a new standard layout.
See Create layout. - Create your own sets. In the Report Writer, choose the menu option Set Maintenance.
- You can creat
Business Attributes
ASAP Roadmap ID | 207 | Establish Reporting |
Mandatory / Optional | 2 | Optional activity |
Critical / Non-Critical | 2 | Non-critical |
Country-Dependency | A | Valid for all countries |
Assigned Application Components
Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
---|---|---|---|---|
SIMG | SIMG_CFMENUORKKFGRP | 0 | HLA0009429 | Product Cost Controlling Information System |
Maintenance Objects
Maintenance object type | C | Customizing Object |
Assigned objects | ||||||
---|---|---|---|---|---|---|
Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
IMGDUMMY | D - Dummy object | GR31 | 587 | Create report | ||
IMGDUMMY | D - Dummy object | GR32 | 588 | Change report | ||
IMGDUMMY | D - Dummy object | GR33 | 589 | Display report |
History
Last changed by/on | SAP | 19981222 |
SAP Release Created in |