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

  


SAP MSSTABCOLS table summary

Warning: Undefined array key "id" in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 101

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: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: DBFIELDNAM
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: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: DBTYPE
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: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
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: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
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: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
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: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISNULLABLE


  

Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 234 Warning: Undefined variable $ucsaptab in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 278 Warning: Undefined variable $obj1 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj2 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj3 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj4 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj5 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj6 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj7 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj8 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj9 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj10 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279 Warning: Undefined variable $obj11 in /customers/b/9/9/trailsap.com/httpd.www/sap/index.php on line 279


View list of all SAP tables(S4H/ECC)

Select data from SAP table