SAP ABAP IMG Activity SIMG_CFMENUORKKFGRP (Create User-Defined Reports)
Hierarchy
SAP_FIN (Software Component) SAP_FIN
   CO-PC-OBJ (Application Component) Cost Object Controlling
     KK0C (Package) Customizing for Cost Object Controlling
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.

  1. If the libraries, layouts, row and column models, and default columns in the standard system are sufficient:
    1. Define report columns by using the supplied default columns and characteristics as well as formulas and standard layouts in the standard library.
    2. 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.
    3. Define report rows by using the characteristics or row models available in the standard library.
    4. All steps in row definition are similar to those in column definition.
  2. If the libraries, layouts, and row and column models do not meet your requirements:
    1. If necessary, maintain the corresponding library.
    2. If necessary, create a new layout or change an existing one.
    3. If necessary, maintain the standard default columns.
    4. In Report Painter, choose Set maintenance -> Data set entries -> Maintenance.
    5. If necessary, create new row and column models.
    6. Proceed as described in the definition of report rows and columns.
    7. For further report definition proceed as described in step 1.
  3. 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.

  4. Save your report.
  5. 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

  1. If the libraries, predefined columns, and sets in the standard system do not meet your requirements, proceed as follows:
    1. In the header of the report, define general information on the structure of the report (such as the standard layout to be used).
    2. 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.
    3. 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.
    4. 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.
    5. 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).
    6. Save your report.
    7. Create a report group and assign it to your report.
  2. 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