SAP MSQ_DBDATA table - Contains information on a database details in SAP


SAP MSQ_DBDATA table summary

Object Name: MSQ_DBDATA
Dictionary Type: Structure
Description: Contains information on a database


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

Details
MSQ_DBDATA-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

MSQ_DBDATA-CRDATE table field - Date the database was created.

Description: Date the database was created.
Field Name: CRDATE
Data Element: MSQDBCREDT
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CRDATE

MSQ_DBDATA-CMPTLEVEL table field - Compatibility level SQL Server is running on.

Description: Compatibility level SQL Server is running on.
Field Name: CMPTLEVEL
Data Element: MSQDBCMPLV
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 CMPTLEVEL

MSQ_DBDATA-AUTOSTCRE table field - AUTO_CREATE_STATISTICS: missing statistics auto. generated.

Description: AUTO_CREATE_STATISTICS: missing statistics auto. generated.
Field Name: AUTOSTCRE
Data Element: MSQDBASCRE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOSTCRE

MSQ_DBDATA-AUTOSTUPD table field - AUTO_UPDATE_STATISTICS: Out of date statistics auto. updated

Description: AUTO_UPDATE_STATISTICS: Out of date statistics auto. updated
Field Name: AUTOSTUPD
Data Element: MSQDBASUPD
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOSTUPD

MSQ_DBDATA-AUTOCLOSE table field - The database will close down when the last user logs out

Description: The database will close down when the last user logs out
Field Name: AUTOCLOSE
Data Element: MSQDBAUTCL
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOCLOSE

MSQ_DBDATA-BULKCOPY table field - SELECT INTO and fast bulk copies are allowed.

Description: SELECT INTO and fast bulk copies are allowed.
Field Name: BULKCOPY
Data Element: MSQDBULKCP
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BULKCOPY

MSQ_DBDATA-TRUCLOG table field - Trunc. log on chkpt.: checkpoint when log is 70% full.

Description: Trunc. log on chkpt.: checkpoint when log is 70% full.
Field Name: TRUCLOG
Data Element: MSQDBTRCLG
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRUCLOG

MSQ_DBDATA-TORNPGDET table field - TORN_PAGE_DETECTION: incomplete pages can be detected.

Description: TORN_PAGE_DETECTION: incomplete pages can be detected.
Field Name: TORNPGDET
Data Element: MSQDBTPDET
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TORNPGDET

MSQ_DBDATA-LOADING table field - The database is in a loading state.

Description: The database is in a loading state.
Field Name: LOADING
Data Element: MSQDBLOAD
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOADING

MSQ_DBDATA-PRERECVY table field - The database is in a prerecovering state

Description: The database is in a prerecovering state
Field Name: PRERECVY
Data Element: MSQDBPRERC
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRERECVY

MSQ_DBDATA-RECOVERY table field - Recovery of the database is underway.

Description: Recovery of the database is underway.
Field Name: RECOVERY
Data Element: MSQDBRECVR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECOVERY

MSQ_DBDATA-NOTRECVR table field - The database is not recovering

Description: The database is not recovering
Field Name: NOTRECVR
Data Element: MSQDBNOTRC
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NOTRECVR

MSQ_DBDATA-DBOFFLINE table field - The database is in status OFFLINE.

Description: The database is in status OFFLINE.
Field Name: DBOFFLINE
Data Element: MSQDBOFFLN
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBOFFLINE

MSQ_DBDATA-READONLY table field - The database is in read only mode.

Description: The database is in read only mode.
Field Name: READONLY
Data Element: MSQDBRDOLY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READONLY

MSQ_DBDATA-DBOONLY table field - RESTRICTED_USER: Only the DB owner can access the database.

Description: RESTRICTED_USER: Only the DB owner can access the database.
Field Name: DBOONLY
Data Element: MSQDBDBO
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBOONLY

MSQ_DBDATA-SINGLEUSER table field - SINGLE_USER: the database is in single user mode.

Description: SINGLE_USER: the database is in single user mode.
Field Name: SINGLEUSER
Data Element: MSQDBSNGLE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SINGLEUSER

MSQ_DBDATA-EMERGYMD table field - Database is in emergency mode.

Description: Database is in emergency mode.
Field Name: EMERGYMD
Data Element: MSQDBEMRGY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field EMERGYMD

MSQ_DBDATA-AUTOSHRINK table field - AUTO_SHRINK: when 25% of the file is unused, file is shrunk.

Description: AUTO_SHRINK: when 25% of the file is unused, file is shrunk.
Field Name: AUTOSHRINK
Data Element: MSQDBAUTSH
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOSHRINK

MSQ_DBDATA-CLNSHTDWN table field - Database was cleanly shutdown

Description: Database was cleanly shutdown
Field Name: CLNSHTDWN
Data Element: MSQDBCLNSD
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLNSHTDWN

MSQ_DBDATA-ANSINULDEF table field - ANSI_NULL_DEFAULT: NULL values allowed as default.

Description: ANSI_NULL_DEFAULT: NULL values allowed as default.
Field Name: ANSINULDEF
Data Element: MSQDBUSRAN
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANSINULDEF

MSQ_DBDATA-CCNULL table field - CONCAT_NULL_YIELDS_NULL: NULLs concatenated result in NULL.

Description: CONCAT_NULL_YIELDS_NULL: NULLs concatenated result in NULL.
Field Name: CCNULL
Data Element: MSQDBCNULL
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CCNULL

MSQ_DBDATA-RECTRIGGER table field - RECURSIVE_TRIGGERS: enables recursive firing of triggers.

Description: RECURSIVE_TRIGGERS: enables recursive firing of triggers.
Field Name: RECTRIGGER
Data Element: MSQDBRECTR
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECTRIGGER

MSQ_DBDATA-DEFLOCCUR table field - CURSOR_DEFAULT LOCAL: cursor declarations default to LOCAL

Description: CURSOR_DEFAULT LOCAL: cursor declarations default to LOCAL
Field Name: DEFLOCCUR
Data Element: MSQDBLOCDF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEFLOCCUR

MSQ_DBDATA-QUOTEDID table field - Quoted identifier: ' can be used to surround identifiers.

Description: Quoted identifier: ' can be used to surround identifiers.
Field Name: QUOTEDID
Data Element: MSQDBQUTID
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUOTEDID

MSQ_DBDATA-CCONCOMMIT table field - Cursor close on commit:any cursors open are closed on commit

Description: Cursor close on commit:any cursors open are closed on commit
Field Name: CCONCOMMIT
Data Element: MSQDBCURCM
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CCONCOMMIT

MSQ_DBDATA-ANSINULLS table field - ANSI_NULLS: any comparisons to a NULL value evaluate to NULL

Description: ANSI_NULLS: any comparisons to a NULL value evaluate to NULL
Field Name: ANSINULLS
Data Element: MSQDBNULL
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANSINULLS

MSQ_DBDATA-ANSIWARN table field - ANSI_WARNINGS: null values in aggregate fcns, or divide by 0

Description: ANSI_WARNINGS: null values in aggregate fcns, or divide by 0
Field Name: ANSIWARN
Data Element: MSQDBWARN
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANSIWARN

MSQ_DBDATA-FULLTXTEN table field - Initializes fulltext indexing or removes all fulltext catalg

Description: Initializes fulltext indexing or removes all fulltext catalg
Field Name: FULLTXTEN
Data Element: MSQDBFLTXT
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLTXTEN

MSQ_DBDATA-DBSUSPECT table field - Database is marked as suspect.

Description: Database is marked as suspect.
Field Name: DBSUSPECT
Data Element: MSQDBSUSPC
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBSUSPECT

MSQ_DBDATA-DBSHUTDOWN table field - Database encountered a problem during startup.

Description: Database encountered a problem during startup.
Field Name: DBSHUTDOWN
Data Element: MSQDBSHTDW
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBSHUTDOWN

MSQ_DBDATA-DBSTANDBY table field - Database is functioning as a standby server.

Description: Database is functioning as a standby server.
Field Name: DBSTANDBY
Data Element: MSQDBSTDBY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBSTANDBY

MSQ_DBDATA-ARITHABORT table field - ARITHABORT: Terminates on overflow or divide-by-zero error.

Description: ARITHABORT: Terminates on overflow or divide-by-zero error.
Field Name: ARITHABORT
Data Element: MSQDBARTA
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ARITHABORT

MSQ_DBDATA-NUMRNDABRT table field - NUMERIC_ROUNDABORT: error on loss of precision in expression

Description: NUMERIC_ROUNDABORT: error on loss of precision in expression
Field Name: NUMRNDABRT
Data Element: MSQDBRNDA
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMRNDABRT

MSQ_DBDATA-DBSIZE table field - Database size in MB (data files).

Description: Database size in MB (data files).
Field Name: DBSIZE
Data Element: MSQDBSIZE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBSIZE

MSQ_DBDATA-DBFREE table field - Database free space in data files in MB.

Description: Database free space in data files in MB.
Field Name: DBFREE
Data Element: MSQDBFREE
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 DBFREE

MSQ_DBDATA-DBUSED table field - Database used space in data files in MB.

Description: Database used space in data files in MB.
Field Name: DBUSED
Data Element: MSQDBUSED
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 DBUSED

MSQ_DBDATA-LOGSIZE table field - Size of the database transaction log in MB.

Description: Size of the database transaction log in MB.
Field Name: LOGSIZE
Data Element: MSQLOGSIZE
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 LOGSIZE

MSQ_DBDATA-LOGFREE table field - Free space in database transaction log in MB .

Description: Free space in database transaction log in MB .
Field Name: LOGFREE
Data Element: MSQLOGFREE
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 LOGFREE

MSQ_DBDATA-LOGUSED table field - Used space in database transaction log in MB.

Description: Used space in database transaction log in MB.
Field Name: LOGUSED
Data Element: MSQLOGUSED
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 LOGUSED

MSQ_DBDATA-DBNUMSAP table field - Number of connections to SAP database from SAP application.

Description: Number of connections to SAP database from SAP application.
Field Name: DBNUMSAP
Data Element: MSQDBSAPPC
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 DBNUMSAP

MSQ_DBDATA-DBNUMOTHER table field - Number of non-SAP processes connected to SAP database.

Description: Number of non-SAP processes connected to SAP database.
Field Name: DBNUMOTHER
Data Element: MSQDBNUMPC
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 DBNUMOTHER

MSQ_DBDATA-DBNDIFFUSE table field - Number of different users connected to SAP database

Description: Number of different users connected to SAP database
Field Name: DBNDIFFUSE
Data Element: MSQDBNDUSR
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 DBNDIFFUSE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table