Indices (ttadv4521m000)

Use this session to list, find or maintain the indices which are defined in a table.

Field Information

Table

The code of the package for which the table is defined.

Table

The module code of the table.

Table

The identification code of the table, for which the index has been defined.

A table is uniquely identified by this code in combination with the package and module codes.

VRC

The version of the package for which the table is defined.

VRC

The release of the package for which the table is defined.

VRC

The customer extension of the package for which the table is defined.

Index Number

The number of the index, which is a unique number within the table.

Note: The primary key always has index number 1.
Dupl

Yes Different records can have the same values in the index parts. These are called duplicate records.

No Duplicate records are not allowed.

The primary index (index number 1) may not have duplicates.

For example : An item table has two indices :

Index no. Part(s) Duplicates
1 Item code no
2 Item group yes

Each record in the item table must have a unique item code. The combination of item group and description is not unique, so it is possible that two items in the item table have the same item group and description.

Note: Indices allowing duplicate values can slow down delete actions on the table they refer to. You must make an index unique by adding the primary key at the end.

Acti

This field indicates whether the index is active or not.

Note: 
  • The primary index (index number 1) is always active.
  • This information is not used in the data dictionary or the database layer.