You can create and use condition indices. You can use these indices to display, change and create condition records with reference. This transaction can include condition records with several condition types and tables. For example, you can use a condition index if you want to see all condition records that apply to a particular product regardless of whether the records are prices or discounts. In this case, you can use one of the standard condition indexes. Or you may want to see a list of condition records that contain a particular sales deal and a material from a user-specified list of products. To display this information, you can create your own condition index.

Creating a condition index is similar to creating a condition table. In Customizing for Sales, you select the combination of fields that you want in the index key. The system automatically proposes a list of permitted fields to choose from. The fields you specify for the key can have a maximum combined length of 100 characters. Further information on creating an index can be found in the IMG (Implementation Guide).

Reorganization means updating an index with current data. The following are examples of when this might be required.

• After you create a new index and generate it, you want to fill the index with the current data in your system. (This also applies if you choose to activate one of the standard condition indexes).
• After you specify that condition indexes should be updated for a particular condition type, you want to fill the indexes with the corresponding condition records that already exist.

The activation function displays a list of all available condition indexes and indicates which are active. The system can use a condition index only when it is activated. Before you can use the indexes that are delivered in the standard version, you must first activate them in Customizing for Sales. Some indices are activated automatically during generation. In addition, you must specify one of the following index updating requirements for each condition index:

• Requirement 1: The index is updated when the user provides data for all fields in the index
• Requirement 2: The index is updated when the user provides data for at least the first index field

You can specify for each condition type whether or not the system updates the condition indexes when you post condition records. In cases where updating condition indexes may not be necessary - for example, with freight- and tax-related condition records - you can leave the condition index indicator blank.

After you have defined a condition index and the system has updated it with current data, you can use it to search condition records.

To select condition records using an index: