Entering content frame

Procedure documentation Specifying Single Values Locate the document in its SAP Library structure

Prerequisites

You want to use a list of proposed values to define a characteristic as a single value and insert it into the matrix.

Procedure

  1. Place the cursor on the cell in which you want to insert a characteristic value.
  2. In the Interactive Excel menu, choose Consolidation ® Single values 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 An example of a delimiting characteristic value is the consolidation chart of accounts, which represents a compound of the characteristic FS item. 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.
  1. Select one or more values. You can use Windows selection functions to select multiple values ( CTRL + mouse click) or blocks of values ( SHIFT + mouse click). You can also use the search function by ID values or long texts, in order to go to its position in the list. In addition to that, you can position on a value using This graphic is explained in the accompanying text .
  2. If you want to insert more than one single value, specify how you want them to be arranged on the sheet.
  3. Choose OK.

Result

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

If you select multiple values, these are inserted in the sequence in which they are listed in the database.

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

Note

You can define multiple single values in a single step.

 

 

 

 

 

 Leaving content frame