Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DWB-DIC-AC (Application Component) Activation Program, Conversion Program, DB Utility, MC, SPDD⤷
SDIC (Package) ABAP Dictionary
Basic Data
| Data Element | UNIQUEFLAG |
| Short Description | Flag for UNIQUE indexes |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | AS4FLAG | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Unique |
| Medium | 15 | Unique |
| Long | 18 | Unique |
| Heading | 1 | U |
Documentation
Definition
Indicator whether or not the index on the database is created as a unique index.
For a unique index, each value combination for the index fields can be contained at most once in the table. The index fields in this case have a key attribute - that is, they already uniquely identify each record of the table.
The uniqueness of the value combinations for the index fields is checked automatically by the database system. If there is a violation (for example, in an INSERT operation) an error message (DUPLICATE RECORD) is issued. The database system thus prevents you from inserting duplicate records for the index fields of a unique index. This function requires that you always create a unique index in the database.
In the case of a non-unique index, an entry in the index can refer to several records in the table that are not different with respect to the values for the index fields.
For access speed, it makes no difference whether or not an index is defined as a unique indes. A unique index is a utility to ensure that records of a table or certain field combination are unique.
Note: A unique index for a client-specific table must contain the client field.
History
| Last changed by/on | SAP | 19970606 |
| SAP Release Created in |
