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
- VRC
- 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.