Data Element list used by SAP ABAP Table QSYSCOLUMN (iSeries: System Catalog View of Table Fields (SYSCOLUMNS))
SAP ABAP Table QSYSCOLUMN (iSeries: System Catalog View of Table Fields (SYSCOLUMNS)) is using
# Object Type Object Name Object Description Note
     
1 Data Element  CCSID iSeries: Table field CCSID
2 Data Element  CHARBYTE iSeries: Table field no. of character bytes
3 Data Element  CHARLEN iSeries: Maximum length of a character column
4 Data Element  COLTYPE iSeries: Table field data type
5 Data Element  COL_LABEL iSeries: Table field column heading
6 Data Element  COL_NAME iSeries: SQL column name
7 Data Element  DATPRC iSeries: Table fields date/time precision
8 Data Element  DFTVALUE iSeries: Table field default value
9 Data Element  HASDEFAULT iSeries: Table field has default
10 Data Element  LABELTEXT iSeries: Table field lable text
11 Data Element  LENGTH iSeries: Table field length
12 Data Element  NULLS iSeries: Table field is nullable
13 Data Element  NUM_SCALE iSeries: Table field numeric scale
14 Data Element  ORD_POS iSeries: Ordinal position of field in the table
15 Data Element  PRECISION iSeries: Table field numeric precision
16 Data Element  RADIX iSeries: Table field RADIX, precision of numeric fie
17 Data Element  REMARKS iSeries: Long comment of a table, view or table field
18 Data Element  STORAGE iSeries: Table field storage requirement
19 Data Element  SYS_CNAME iSeries: iSeries system column name
20 Data Element  SYS_DNAME iSeries: iSeries system name of table/view schema
21 Data Element  SYS_TNAME iSeries: iSeries system name of table or view
22 Data Element  TAB_SCHEMA iSeries: SQL schema name of table or view
23 Data Element  TBCREATOR iSeries: Owner of table or view
24 Data Element  TBNAME iSeries: SQL Name of Table or View
25 Data Element  UPDATES iSeries: Table field is updatable