SAP /SDF/MSSDBDATA610 table - SQL Server: Database options (copy of MSQ_DBDATA in 6.10) details in SAP

  


SAP /SDF/MSSDBDATA610 table summary

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

Object Name: /SDF/MSSDBDATA610
Dictionary Type: Structure
Description: SQL Server: Database options (copy of MSQ_DBDATA in 6.10)


Field list for /SDF/MSSDBDATA610 table on an S/4 SAP system

Details
/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-CRDATE table field - Date the database was created. ▼

Description: Date the 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

/SDF/MSSDBDATA610-CMPTLEVEL table field - Compatibility level SQL Server is running on. ▼

Description: Compatibility level SQL Server is running on.
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

/SDF/MSSDBDATA610-AUTOSTCRE table field - AUTO_CREATE_STATISTICS: missing statistics auto. generated. ▼

Description: AUTO_CREATE_STATISTICS: missing statistics auto. generated.
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-RECOVERY table field - Recovery of the database is underway. ▼

Description: Recovery of the database is underway.
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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-DBOFFLINE table field - The database is in status OFFLINE. ▼

Description: The database is in status 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

/SDF/MSSDBDATA610-READONLY table field - The database is in read only mode. ▼

Description: The database is in read only mode.
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-RECTRIGGER table field - RECURSIVE_TRIGGERS: enables recursive firing of triggers. ▼

Description: RECURSIVE_TRIGGERS: 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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-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

/SDF/MSSDBDATA610-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

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

See all SAP tables containing field ARITHABORT

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

See all SAP tables containing field NUMRNDABRT

/SDF/MSSDBDATA610-DBSIZE table field - Database size in MB (data files). ▼

Description: Database size in MB (data files).
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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

/SDF/MSSDBDATA610-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:
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