Specifying Sets (SAP Library - Consolidation (EC-CS))

Specifying Sets

Prerequisites

You want to use a list of proposed values to define a characteristic as a set and insert it into the matrix. Sets with the following characteristics are offered: consolidation unit, FS item, transaction currency.

Procedure

Place the cursor on the cell in which you want to insert the first entry in the set.

In the Interactive Excel menu, choose Consolidation ® Sets and the characteristic you require.

A dialog box appears with a list of values for the characteristic. Depending on the characteristic that you are defining, values for other characteristics that you have already specified, and on which the values in the proposal list are dependent, may appear in fields at the top of the box.

Note

You may want to specify a value for a characteristic that is dependent on the values of characteristics that you have not yet specified. In order to generate a list of valid proposals, you need to specify these delimiting characteristic values. Only after you have made this specification is a value list displayed.

Note

If a list is very long, first a condensed form of the list is displayed, which you can selectively expand as desired.

Select one or more sets. You can use Windows selection functions to select multiple values ( CTRL + mouse click) or blocks of values ( SHIFT + mouse click). You can enter a value ID (in the form of the field name) in order to go to its position in the list. You can also use the search function by ID values or long texts to go to their position in the list. In addition to that, you can position on a value using .

4. Determine the following:

How the set entries should be arranged on the sheet (in the case of a set list or multiple set aggregations)
Whether the ID and/or short text and/or long text of the characteristic should be displayed
Whether the set is a list set or a set aggregation

5. Choose OK.

Result

Set list

The relevant set entries are inserted at the cursor position, either beside or beneath each another (depending on the alignment selected).

Set entries are inserted in the sequence in which they are entered in the set.

Set aggregation

Only one entry is inserted into the worksheet. This entry represents the sum of all entries in the set.

Sets can be formatted, moved, deleted or changed after insertion into a worksheet.