Show TOC

 Sets Locate this document in the navigation structure

Use

The definition of reports using report writer is based on the set concept. You can build set hierarchies by linking sets. On the basis of these set hierarchies, Report Writer can build totals. The row/column structure and the general data selection criteria in a Report Writer report are all defined with sets.

Integration

In various places, the CO information system uses the master data groups created in the application component menus, such as cost center groups or cost element groups. These groups can be entered at the time the report is started. Basic or single dimension sets are generated for the master data characteristics in the group maintenance records for the master data. You can also use selection variants for these groups. As a general rule, however, other sets are needed for report definition purposes that cannot be created in the master data group maintenance records. This requires you to edit these sets in Report Writer using the set maintenance function.

Example Example

Master data group maintenance only creates sets that refer to a single characteristic. By contrast, the multi-dimensional set 1-L-IP-SH-01 contains the characteristics "CO debit/credit indicator" and "Cost element".

End of the example.

Features

The following set types are available:

  • Basic sets

A basic set contains individual values or value intervals for a given characteristic. Basic sets can also contain value and formula variables as well as formulas.

  • Single dimension sets

These contain single values, value intervals, basic sets or single dimension sets that use the same characteristic. You can therefore use single dimension sets to define hierarchies consisting of basic sets or of other single dimension sets for the same characteristic.

  • Predefined column

A predefined column contains enhanced predefined columns and formulas. You can use enhanced predefined columns to access the value and quantity fields in the Controlling application component databases.

  • Multi-dimensional sets

These can contain basic sets, single dimension sets, and predefined columns with different characteristics. Each characteristic, however, may appear only once in a multi-dimensional set. You can also use set variables with these sets to change the construction of the report.

For more information on sets, see the SAP Library , under   FI - Financials   FI Special Ledger   Sets