SAP ABAP Data Element COL_SEQ (iSeries: Position of column within the key/index)

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_SEQ
Short Description	iSeries: Position of column within the key/index

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	INT4
Data Type	INT4	4-byte integer, integer number with sign
Length	10
Decimal Places	0
Output Length	10
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	Col.seq.
Medium	15	Column sequence
Long	20	Column sequence
Heading	8	Col.seq.

Documentation

Definition

Position of the column within the key constraint or index.

Example

A table is created with the following statements:
CREATE TABLE CONSTRAINT_TEST
(F1 CHAR (10) NOT NULL WITH DEFAULT,
F2 CHAR (5) NOT NULL WITH DEFAULT,
F3 CHAR (4) NOT NULL WITH DEFAULT)
ALTER TABLE CONSTRAINT_TEST
ADD CONSTRAINT CONSTRAINT_TEST_01 PRIMARY KEY (F3, F1)
The result is:

Column Name    Col.Seq.    Col.Pos.

F1    2    1

F3    1    3

History

Last changed by/on	SAP	20070813
SAP Release Created in