Show TOC

Procedure documentationSpecifying a Value/Value Reference for Characteristics Locate this document in the navigation structure

Prerequisites

You have not yet specified a characteristic value or the cell reference of a characteristic value, for example, if you manually inserted a characteristic into your matrix.

Procedure

Using the Data Matrix tab

  1. On the Data Matrix tab, click Change.

    The Change data matrix dialog box opens.

  2. In the Change data matrix dialog box, on the Optional characteristics tab, select a characteristic.

  3. In the Value/Value reference field, enter one of the following:

    • A single value

      If the ID of the single value is identical to a possible cell coordinate, for example a transaction type with the ID B10, you need to enter the value preceded by an apostrophe ('), for example, ‘B10.

    • A cell reference, for example, B3

    • A cell reference, by clicking the button to the right of the entry field

    A dialog box opens. When you drag the cursor over the appropriate matrix area on the worksheet, its coordinates appear in the dialog box field. Use the function button next to the coordinate field to confirm your entry.

  4. Click Confirm to complete your selection.

  5. After you have specified all values and value references click Save.

    If you have not yet defined a required characteristic, a warning message appears. In this case, click   Data Matrix   Change   and define the appropriate characteristics on the Req. char. tab; then click OK.

Using the Context Menu

  1. Select one or more fields by marking it/them, for example, the FS item, and then right-click.

  2. Click   SAP Interactive Excel   Allocate/Allocate globally   and select the item or a characteristic that you have chosen instead.

Result

Cell Reference

An assignment is created between a characteristic on the worksheet and a characteristic preset in SAP Interactive Excel. The cell reference of a characteristic is automatically adjusted if you move the characteristic to a different location on the worksheet.

Single Value

The characteristic is invisible on the worksheet, as is the case for all constants.