SAP ABAP Data Element ORD_POS (iSeries: Ordinal position of field in the table)

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	ORD_POS
Short Description	iSeries: Ordinal position of field in the table

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	QINT4
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. no.
Medium	16	Ord. position
Long	20	Ordinal position
Heading	8	Col. no.

Documentation

Definition

Numeric place of the column in the table or view, ordered from left to right.

Example

A table is create with the statement
CREATE TABLE CUSTOMER
(CUSTOMER_ID CHAR (10) NOT NULL WITH DEFAULT,
CUSTOMER_NAME CHAR (40) NOT NULL WITH DEFAULT,
CUSTOMER_ADRESS CHAR (250) NOT NULL WITH DEFAULT,
CUSTOMER_PHONE CHAR (50) NOT NULL WITH DEFAULT)
The ordinal position of the columns is:
    CUSTOMER_ID        1
    CUSTOMER_NAME    2
    CUSTOMER_ADRESS    3
    CUSTOMER_PHONE    4

History

Last changed by/on	SAP	20070813
SAP Release Created in