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


SAP /SDF/MSSDBDATA610 table summary

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


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table