SAP DB2TBCOLS table - DB2/390: Column Definition of a Database Table details in SAP

  


SAP DB2TBCOLS table summary

Object Name: DB2TBCOLS
Dictionary Type: Structure
Description: DB2/390: Column Definition of a Database Table


Field list for DB2TBCOLS table on an S/4 SAP system

Details
DB2TBCOLS-NAME table field - Column name ▼

Description: Column name
Field Name: NAME
Data Element: DB2COLNAME
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: CHAR18
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

DB2TBCOLS-TBNAME table field - DB2 table name ▼

Description: DB2 table name
Field Name: TBNAME
Data Element: DB2TABNAME
Data Type: CHAR
length (Dec): 18(0)
Check table:
Conversion Routine:
Domain Name: CHAR18
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBNAME

DB2TBCOLS-TBCREATOR table field - DB2 creator name ▼

Description: DB2 creator name
Field Name: TBCREATOR
Data Element: DB2CREATOR
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: CHAR8
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TBCREATOR

DB2TBCOLS-COLNO table field - Numeric position of the column in the table or view ▼

Description: Numeric position of the column in the table or view
Field Name: COLNO
Data Element: DB2COLNO
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLNO

DB2TBCOLS-COLTYPE table field - Column type specified in the column definition ▼

Description: Column type specified in the column definition
Field Name: COLTYPE
Data Element: DB2COLTYPE
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DB2COLTYPE
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COLTYPE

DB2TBCOLS-LENGTH table field - Length attribute of the column ▼

Description: Length attribute of the column
Field Name: LENGTH
Data Element: DB2COLLEN
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LENGTH

DB2TBCOLS-SCALE table field - Scale of decimal data ▼

Description: Scale of decimal data
Field Name: SCALE
Data Element: DB2SCALE
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: DB2SINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCALE

DB2TBCOLS-NULLS table field - Whether the column can contain null values ▼

Description: Whether the column can contain null values
Field Name: NULLS
Data Element: DB2NULLS
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: DB2YNFLAG
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NULLS


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table