With the format presented by the Report Painter, you can easily enter your rows, columns, and general selection criteria.The rows constitute characteristic values or groups.The columns consist of basic key figures (e.g. costs, quantities) with characteristic values for key figures.General data selections are carried out using characteristic values, which are then valid throughout the entire report.To define a report, you must determine the row and column structure and the general data selection criteria.
You can use either a combination of characteristic values or a formula to define a row.Columns contain a combination of a key figure and optional restricting characteristic values. You can also use predefined columns to display business-relevant combinations of key figures and characteristics, for example, actual costs in the current period, scheduled activity, and so on.
To define rows, you select the characteristics you want to display in these rows and enter the appropriate values. You can enter specific values, intervals of values, or a group. n In the report definition, you can use groups that were created in the master data maintenance.You can use the formula editor to define formula rows. The formulas used can refer to other rows in the same section and to cells selected in the report.
SAP delivers a number of predefined columns for the libraries in Overhead Cost Management. You can copy these predefined columns directly into your reports and change them as required.
One way to define a column is to combine a key figure with several characteristics. n To restrict the characteristics, you can enter intervals or groups as you did when defining single values for the report rows.
Using the formula editor, you can calculate additional columns within a section. The formulas used can refer to other columns in the same section or to cells selected in the report.
After you have defined the rows and columns, you can define additional criteria that are valid for the entire report. The additional criteria you select will restrict the data processed in the report. These restrictions are stored in so-called general data selections.
Before a report can be output, it must be included in a report group.A report group is a collection of reports in a library that are executed in one run. Combining several reports in a report group can be useful if the reports are intended to evaluate the same dataset. In this case, the data is only read once and then distributed among the different reports.
You cannot process reports from different libraries in the same report group.When a report group is generated, the system creates ABAP reports, which can then be run. In the first ABAP, inputs are proposed and verified with regard to output parameters, the data source, and extract parameters. In addition, values or sets are proposed for selection, if the report definition contains variables.
In the second ABAP, the data is selected from the database.The last ABAP then formats the data so that it can be output.
When using groups or several single values to define rows, you can define whether only a totals row is to be displayed, or if the complete group hierarchy with subtotals is to be exploded, or if every single value in a row is to be displayed. The system is set up in such a way that only those rows are displayed for which corresponding data exists.If you use a combination of several characteristics in a row block and this row block is exploded, you can choose the hierarchical sequence in which the characteristics are displayed.