SAP ABAP Data Element IDX_NAME (iSeries: SQL index name)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Data Element	IDX_NAME
Short Description	iSeries: SQL index name

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	Index name
Medium	15	SQL index name
Long	20	SQL index name
Heading	14	SQL index name

Documentation

Definition

SQL name of the index.
This is the name specified in the CREATE INDEX statement.
An SQL index name can be up to 128 characters long in DB2 UDB for iSeries but an iSeries object name can be only 10 characters long. If a name longer than 10 characters is specified on the CREATE statement, automatic mapping is done using the first five characters of the SQL name specified and a generated 5-digit number for the iSeries system name of the object created.

Example

For the SAP table MARA an index with ID 'L' is defined. The SQL name of this index is MARA______L which is mapped to the iSeries system name MARA_00002 (this name is not used within an SAP System).

History

Last changed by/on	SAP	20070813
SAP Release Created in