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


SAP MSD_DBDATA table summary

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

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


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

Details
MSD_DBDATA-DBNAME table field - MS SQL server Database name

Description: MS SQL server Database name
Field Name: DBNAME
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSD_DBDATA-CRDATE table field - Date the SQLSever database was created

Description: Date the SQLSever database was created
Field Name: CRDATE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CRDATE

MSD_DBDATA-CMPTLEVEL table field - SQLServer release level that the DB is compatible to

Description: SQLServer release level that the DB is compatible to
Field Name: CMPTLEVEL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CMPTLEVEL

MSD_DBDATA-AUTOSTCRE table field - Missing statistics auto. built for query during optimization

Description: Missing statistics auto. built for query during optimization
Field Name: AUTOSTCRE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOSTCRE

MSD_DBDATA-AUTOSTUPD table field - Out of date Statistics built for query during optimization

Description: Out of date Statistics built for query during optimization
Field Name: AUTOSTUPD
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOSTUPD

MSD_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:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOCLOSE

MSD_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:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BULKCOPY

MSD_DBDATA-TRUCLOG table field - The db is checkpointed when log is 70% full

Description: The db is checkpointed when log is 70% full
Field Name: TRUCLOG
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRUCLOG

MSD_DBDATA-TORNPGDET table field - Incomplete pages can be detected

Description: Incomplete pages can be detected
Field Name: TORNPGDET
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TORNPGDET

MSD_DBDATA-LOADING table field - The database is in a loading state

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

See all SAP tables containing field LOADING

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

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

See all SAP tables containing field PRERECVY

MSD_DBDATA-RECOVERY table field - The database is in a recovering state

Description: The database is in a recovering state
Field Name: RECOVERY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECOVERY

MSD_DBDATA-NOTRECVR table field - The database is not recovering

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

See all SAP tables containing field NOTRECVR

MSD_DBDATA-DBOFFLINE table field - The database is offline

Description: The database is offline
Field Name: DBOFFLINE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBOFFLINE

MSD_DBDATA-READONLY table field - The database is read only

Description: The database is read only
Field Name: READONLY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field READONLY

MSD_DBDATA-DBOONLY table field - Only the database owner can access the database

Description: Only the database owner can access the database
Field Name: DBOONLY
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBOONLY

MSD_DBDATA-SINGLEUSER table field - The database is in single user mode

Description: The database is in single user mode
Field Name: SINGLEUSER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SINGLEUSER

MSD_DBDATA-EMERGYMD table field - Database is in emergency mode

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

See all SAP tables containing field EMERGYMD

MSD_DBDATA-AUTOSHRINK table field - When 25% or more of the file is unused, file is auto. shrunk

Description: When 25% or more of the file is unused, file is auto. shrunk
Field Name: AUTOSHRINK
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AUTOSHRINK

MSD_DBDATA-CLNSHTDWN table field - Database was cleanly shutdown

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

See all SAP tables containing field CLNSHTDWN

MSD_DBDATA-ANSINULDEF table field - Allows the user to control the database default nullability

Description: Allows the user to control the database default nullability
Field Name: ANSINULDEF
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANSINULDEF

MSD_DBDATA-CCNULL table field - Null operands result in a Null if concatenated

Description: Null operands result in a Null if concatenated
Field Name: CCNULL
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CCNULL

MSD_DBDATA-RECTRIGGER table field - Enables recursive firing of triggers

Description: Enables recursive firing of triggers
Field Name: RECTRIGGER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECTRIGGER

MSD_DBDATA-DEFLOCCUR table field - Cursor declarations default to LOCAL

Description: Cursor declarations default to LOCAL
Field Name: DEFLOCCUR
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DEFLOCCUR

MSD_DBDATA-QUOTEDID table field - ' can be used to surround delimited identifiers

Description: ' can be used to surround delimited identifiers
Field Name: QUOTEDID
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field QUOTEDID

MSD_DBDATA-CCONCOMMIT table field - Any cursors open are closed on commit or roll back

Description: Any cursors open are closed on commit or roll back
Field Name: CCONCOMMIT
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CCONCOMMIT

MSD_DBDATA-ANSINULLS table field - Any comparisons to a null value evaluate to NULL

Description: Any comparisons to a null value evaluate to NULL
Field Name: ANSINULLS
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANSINULLS

MSD_DBDATA-ANSIWARN table field - Null values in aggregate fcns, or divide by 0, cause warning

Description: Null values in aggregate fcns, or divide by 0, cause warning
Field Name: ANSIWARN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ANSIWARN

MSD_DBDATA-FULLTXTEN table field - Initailizes fulltext indexing or removes all full-text catlg

Description: Initailizes fulltext indexing or removes all full-text catlg
Field Name: FULLTXTEN
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field FULLTXTEN

MSD_DBDATA-DBSUSPECT table field - Database is marked as suspect

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

See all SAP tables containing field DBSUSPECT

MSD_DBDATA-DBSHUTDOWN table field - Database encountered a problem during startup

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

See all SAP tables containing field DBSHUTDOWN

MSD_DBDATA-DBSTANDBY table field - Database is functioning as a standby server

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

See all SAP tables containing field DBSTANDBY

MSD_DBDATA-DBSIZE table field - MS SQL server database size

Description: MS SQL server database size
Field Name: DBSIZE
Data Element:
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

MSD_DBDATA-DBFREE table field - MSQ server database free size

Description: MSQ server database free size
Field Name: DBFREE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBFREE

MSD_DBDATA-DBUSED table field - MSQ server database used size

Description: MSQ server database used size
Field Name: DBUSED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBUSED

MSD_DBDATA-LOGSIZE table field - MS SQL server - size of the log file

Description: MS SQL server - size of the log file
Field Name: LOGSIZE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGSIZE

MSD_DBDATA-LOGFREE table field - MS SQL server - free log size

Description: MS SQL server - free log size
Field Name: LOGFREE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGFREE

MSD_DBDATA-LOGUSED table field - MS SQL server - used log size

Description: MS SQL server - used log size
Field Name: LOGUSED
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGUSED

MSD_DBDATA-DBNUMSAP table field - Number of SAP processes connected to the database

Description: Number of SAP processes connected to the database
Field Name: DBNUMSAP
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNUMSAP

MSD_DBDATA-DBNUMOTHER table field - Number of non-SAP processes connected to the database

Description: Number of non-SAP processes connected to the database
Field Name: DBNUMOTHER
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNUMOTHER

MSD_DBDATA-DBNDIFFUSE table field - Number of different users connected to the database

Description: Number of different users connected to the database
Field Name: DBNDIFFUSE
Data Element:
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNDIFFUSE


  

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