SAP MSQDBASES table - MS SQL server databases ( as from sysdatabases ) details in SAP

SAP MSQDBASES table summary

Object Name: MSQDBASES
Dictionary Type: Structure
Description: MS SQL server databases ( as from sysdatabases )

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

Details

MSQDBASES-DBNAME table field - The name of the database in SQL Server instance. ▼

Description: The name of the database in SQL Server instance.
Field Name: DBNAME
Data Element: MSQDBNAME
Data Type: CHAR
length (Dec): 255(0)
Check table:
Conversion Routine:
Domain Name: CHAR255
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSQDBASES-DBID table field - MS SQL Server database ID ▼

Description: MS SQL Server database ID
Field Name: DBID
Data Element: MSQDBASEID
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 DBID

MSQDBASES-SID table field - MS SQL Server - database creator user ID ▼

Description: MS SQL Server - database creator user ID
Field Name: SID
Data Element: MSQSID
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 SID

MSQDBASES-DBMODE table field - MS SQL server database lock mode ▼

Description: MS SQL server database lock mode
Field Name: DBMODE
Data Element: MSQDBMODE
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 DBMODE

MSQDBASES-STATUS table field - MS SQL server database status ▼

Description: MS SQL server database status
Field Name: STATUS
Data Element: MSQDBSTATS
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 STATUS

MSQDBASES-STATUS2 table field - MS SQL server database status ▼

Description: MS SQL server database status
Field Name: STATUS2
Data Element: MSQDBSTATS
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 STATUS2

MSQDBASES-CRDATE table field - MS SQL server database creation date. ▼

Description: MS SQL server database creation date.
Field Name: CRDATE
Data Element: MSQCREDATE
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 CRDATE

MSQDBASES-CATEGORY table field - MS SQL server database category ▼

Description: MS SQL server database category
Field Name: CATEGORY
Data Element: MSQCATEGRY
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 CATEGORY

MSQDBASES-CMPTLEVEL table field - MS SQL server Compatibility Column ▼

Description: MS SQL server Compatibility Column
Field Name: CMPTLEVEL
Data Element: MSQCMPCOLU
Data Type: INT1
length (Dec): 3(0)
Check table:
Conversion Routine:
Domain Name: INT1
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CMPTLEVEL

MSQDBASES-FILENAME table field - MS SQL server database physical file name with full path ▼

Description: MS SQL server database physical file name with full path
Field Name: FILENAME
Data Element: MSQFILNAME
Data Type: CHAR
length (Dec): 520(0)
Check table:
Conversion Routine:
Domain Name: CHAR520
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FILENAME

MSQDBASES-VERSION table field - MS SQL Server Database version ▼

Description: MS SQL Server Database version
Field Name: VERSION
Data Element: MSQVERSION
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 VERSION

View list of all SAP tables(S4H/ECC)

Select data from SAP table