SAP MSSTABCOLS table - Native SQL Server column names and types details in SAP

SAP MSSTABCOLS table summary

Object Name: MSSTABCOLS
Dictionary Type: Structure
Description: Native SQL Server column names and types

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

Details

MSSTABCOLS-NAME table field - Name of the DB field ▼

Description: Name of the DB field
Field Name: NAME
Data Element: DBFIELDNAM
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

MSSTABCOLS-TYPE table field - Database type ▼

Description: Database type
Field Name: TYPE
Data Element: DBTYPE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TYPE

MSSTABCOLS-LENGTH table field - Length of column from syscolumns ▼

Description: Length of column from syscolumns
Field Name: LENGTH
Data Element: MSSSCLEN
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LENGTH

MSSTABCOLS-PREC table field - Precision, the number of digits in a decimal number. ▼

Description: Precision, the number of digits in a decimal number.
Field Name: PREC
Data Element: MSSSCPRC
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PREC

MSSTABCOLS-SCALE table field - The number of digits to the right of the decimal point ▼

Description: The number of digits to the right of the decimal point
Field Name: SCALE
Data Element: MSSSCSCL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SCALE

MSSTABCOLS-ISNULLABLE table field - Nullable Flag ▼

Description: Nullable Flag
Field Name: ISNULLABLE
Data Element: MSSSCNLL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISNULLABLE