SET in controlling

[former_member565100]

What is the use of a SET and what is basic set?What are other different types of set?

[Former Member · Accepted solution]

Hi,

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.

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".

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.

Thanks,

Rau