SAP DB2_COLUMN_DESCRIPTION table - DB2 z/Os: Column description of a DB Table details in SAP

SAP DB2_COLUMN_DESCRIPTION table summary

Object Name: DB2_COLUMN_DESCRIPTION
Dictionary Type: Structure
Description: DB2 z/Os: Column description of a DB Table

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

Details

DB2_COLUMN_DESCRIPTION-NAME table field - DB2 column name ▼

Description: DB2 column name
Field Name: NAME
Data Element: DB2COLNAML
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NAME

DB2_COLUMN_DESCRIPTION-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

DB2_COLUMN_DESCRIPTION-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

DB2_COLUMN_DESCRIPTION-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

DB2_COLUMN_DESCRIPTION-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

DB2_COLUMN_DESCRIPTION-NULLS table field - bool type ▼

Description: bool type
Field Name: NULLS
Data Element: DB2BOOLEAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NULLS

DB2_COLUMN_DESCRIPTION-DEFAULT table field - c1 flag ▼

Description: c1 flag
Field Name: DEFAULT
Data Element: DB2FLAG
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEFAULT

DB2_COLUMN_DESCRIPTION-DFTVALUE table field - Default value for a DB column ▼

Description: Default value for a DB column
Field Name: DFTVALUE
Data Element: DEFAULT_VA
Data Type: CHAR
length (Dec): 75(0)
Check table:
Conversion Routine:
Domain Name: DEFAULT_VA
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DFTVALUE

DB2_COLUMN_DESCRIPTION-BITDATA table field - bool type ▼

Description: bool type
Field Name: BITDATA
Data Element: DB2BOOLEAN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BITDATA

DB2_COLUMN_DESCRIPTION-LENGTH2 table field - column length ▼

Description: column length
Field Name: LENGTH2
Data Element: DB2COLLEN2
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LENGTH2

View list of all SAP tables(S4H/ECC)

Select data from SAP table