SAP ABAP Data Element COL_NAME (iSeries: SQL column 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	COL_NAME
Short Description	iSeries: SQL column name

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	FDNAME
Data Type	CHAR	Character String
Length	30
Decimal Places	0
Output Length	30
Value Table	DD03L

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	SQLColName
Medium	15	SQL column name
Long	15	SQL column name
Heading	10	SQLColName

Documentation

Definition

SQL name of a table or view column.
This is the name of the column specified in the CREATE TABLE or VIEW statement and can be up to 30 characters long.

The iSeries system name of a column has a maximum of 10 characters. If a column name longer than 10 characters is specified in the CREATE statement, automatic mapping is done using the first 5 characters of the SQL column name and a generated 5 digit number.

Example

The statement
        CREATE TABLE ORDER
            (ORDER_NUMBER CHAR (10) NOT NULL WITH DEFAULT)
creates a table ORDER with one column. The SQL name of the column is ORDER_NUMBER which exceeds the length of 10 characters. The iSeries system name of this column is ORDER00001.

History

Last changed by/on	SAP	20070813
SAP Release Created in