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 | DBINDEX_D |
| Short Description | Database index |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | DBINDEX | |
| Data Type | CHAR | Character String |
| Length | 18 | |
| Decimal Places | 0 | |
| Output Length | 18 | |
| 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 | DB index |
| Medium | 15 | DB index name |
| Long | 18 | DB index name |
| Heading | 8 | DB index |
Documentation
Definition
Specifies the index name under which the database index corresponding to the index definition is created in the ABAP Dictionary. An index name must not be larger than 18 digits.
There are several options for the database index name. The reasons for this are that, on the one hand, tables can have names that are longer than 10. In addition, within an upgrade, names of indexes on the database can possibly be changed.
In this way, the database index name can be built as follows:
A 10-digit name is built from the table name and the index ID. Here, table names that are shorter than 10 position are filled up to 10 digits with underscores and the index ID is then added on to this.
In addition, the index name can be filled with underscores up to 3-digit length and afterwards an 'X' can be added on.
The index name can be built from the table name and the index ID, separated by the character ~ or ^.
In the case of a table name larger than 15, the index ID can also be appended directly without a separating character. Here, the index ID is also cut off if the length of the name would otherwise exceed a total length of 18.
&EXAMPLES"
For the table TTEST and the index with the ID A11, the corresponding index name on the database is TTEST_____A11.
History
| Last changed by/on | SAP | 19950209 |
| SAP Release Created in |
