Define Condition Index (SAP Library

Define Condition Index

In this IMG activity, you specify which fields of the condition records are taken into account when creating the index. The selected fields are displayed as selection criteria in the application menu for selecting condition records. In addition to the possibility of searching for condition records using the condition type (for example, prices, surcharges, discounts) and the organizational data, you can define and use other selection criteria using the condition index.

Example

The standard system contains two indexes with which all condition records can be selected for a certain material (index 001) or a certain customer (index 002) independently of the condition type, for example.

Note

Note that the number of indexes to be updated reduces system performance when posting condition records. Take this into account when creating and activating indexes.

Default settings

Two indexes exist in the standard SAP R/3 System:

Index 001 takes the material, sales organization and distribution channel into account when creating the index.

Index 002 takes the customer, sales organization, distribution channel and division into account when creating the index.

For reasons of performance, the condition types for the condition index are not flagged in the standard system. If a condition type is to be taken into account for condition indexes, it must be activated (condition type detail screen).

Requirements

Before using condition indexes (standard and user-specific indexes), you must define overviews for condition maintenance. See the section "Overviews" for further information on the overviews for condition maintenance.

Actions if you use standard indexes

1. Check whether the condition indexes in the standard system (001 or 002) meet your requirements.

2. Activate each standard index that you want to use.

The indexes are inactive at delivery to avoid unused indexes being updated. Enter one of the two requirements for the index update.

Requirement 1: all index fields must be filled

Requirement 2: the first index field must be filled

3. In the field "Condition index" on the condition type detail screen, select every condition type to be taken into account when creating the index. The condition types are not flagged in the standard system.

4. You can change and display standard indices:

Change

Display

Actions if you create and use your own indexes

1. You can create a condition index either by copying an existing index and changing it afterwards or by carrying out the following steps.

2. Check whether the list of allowed fields meets your requirements. If you need new fields, you can include them in the field catalog for the condition index.

3. Create a condition index by entering a table between 501 and 999 and choosing the required fields from the list of the allowed fields.

The selected fields can have a maximum length of 100 characters.

Define the sequence of the fields so that the first field in the index is the field that is most frequently searched for. In addition, SAP recommends that you include the sales organization and the distribution channel.

Generate the condition index. Indexes created by you are activated automatically.

4. In the field "Condition index" on the detail screen of the respective condition type, select the condition types to be taken into account for the condition index.

Actions if you reorganize secondary indexes

You must reorganize condition indexes in the following cases:

If you created a new condition index and want to set it up for existing condition records.

If you changed an existing condition index and want to set it up with the current condition records.

Proceed as follows:

1. Enter a condition index or an interval of indexes.

2. Enter the date and the time as of which the index is to be set up.