SAP /SDF/MSSSTSERV620 table - SQL Server: Static server data set (copy of MSS_STSERV 620) details in SAP


SAP /SDF/MSSSTSERV620 table summary

Object Name: /SDF/MSSSTSERV620
Dictionary Type: Structure
Description: SQL Server: Static server data set (copy of MSS_STSERV 620)


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

Details
/SDF/MSSSTSERV620-HOSTNAME table field - MS SQL Server host name the wo

Description: MS SQL Server host name the wo
Field Name: HOSTNAME
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 HOSTNAME

/SDF/MSSSTSERV620-SQLVERSION table field - Version of the database management system.

Description: Version of the database management system.
Field Name: SQLVERSION
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 SQLVERSION

/SDF/MSSSTSERV620-SQLBUILDNM table field - SQL Server build number (corresponding to a Service Pack).

Description: SQL Server build number (corresponding to a Service Pack).
Field Name: SQLBUILDNM
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 SQLBUILDNM

/SDF/MSSSTSERV620-PRODLEVEL table field - Date the executable sqlservr.exe was created.

Description: Date the executable sqlservr.exe was created.
Field Name: PRODLEVEL
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 PRODLEVEL

/SDF/MSSSTSERV620-SQLSTARTTM table field - Date and time of last SQL Server start.

Description: Date and time of last SQL Server start.
Field Name: SQLSTARTTM
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 SQLSTARTTM

/SDF/MSSSTSERV620-SQLEE table field - SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use

Description: SQL Server edition: 'X' = Enterprise Ed., 'C' Cluster in use
Field Name: SQLEE
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 SQLEE

/SDF/MSSSTSERV620-NTVER table field - OS edition: A=Advanced Server, S=Server, D=Datacenter.

Description: OS edition: A=Advanced Server, S=Server, D=Datacenter.
Field Name: NTVER
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 NTVER

/SDF/MSSSTSERV620-PARAMDIFF table field - Single-character flagng SQLSer

Description: Single-character flagng SQLSer
Field Name: PARAMDIFF
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 PARAMDIFF

/SDF/MSSSTSERV620-DISKPERF table field - Single-character flagetween th

Description: Single-character flagetween th
Field Name: DISKPERF
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 DISKPERF

/SDF/MSSSTSERV620-ISCLUSTER table field - Is SQL Server clustered 'Y' or 'N'

Description: Is SQL Server clustered 'Y' or 'N'
Field Name: ISCLUSTER
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 ISCLUSTER

/SDF/MSSSTSERV620-IS3GB table field - Is SQL Server on machine with /3GB switch on 'Y' or 'N'

Description: Is SQL Server on machine with /3GB switch on 'Y' or 'N'
Field Name: IS3GB
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 IS3GB

/SDF/MSSSTSERV620-ISPAE table field - Is SQL Server on machine with PAE 'Y' or 'N'

Description: Is SQL Server on machine with PAE 'Y' or 'N'
Field Name: ISPAE
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 ISPAE

/SDF/MSSSTSERV620-ISAWE table field - Is SQL Server AWE enabled Y' or 'N'

Description: Is SQL Server AWE enabled Y' or 'N'
Field Name: ISAWE
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 ISAWE

/SDF/MSSSTSERV620-CHIP table field - Processor type being used on the host running SQL Server.

Description: Processor type being used on the host running SQL Server.
Field Name: CHIP
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 CHIP

/SDF/MSSSTSERV620-WINVER table field - Operating system version running on SQL Server host.

Description: Operating system version running on SQL Server host.
Field Name: WINVER
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 WINVER

/SDF/MSSSTSERV620-NUMCPUS table field - Number of CPUs on the host which runs SQL Server.

Description: Number of CPUs on the host which runs SQL Server.
Field Name: NUMCPUS
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 NUMCPUS

/SDF/MSSSTSERV620-SQLCPUS table field - Maximum number of CPUs SQL Server is configured to use.

Description: Maximum number of CPUs SQL Server is configured to use.
Field Name: SQLCPUS
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 SQLCPUS

/SDF/MSSSTSERV620-MASK table field - Bitmask representing the CPUs available to Windows.

Description: Bitmask representing the CPUs available to Windows.
Field Name: MASK
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 MASK

/SDF/MSSSTSERV620-PHYMEM table field - Amount of RAM on the server running SQL Server

Description: Amount of RAM on the server running SQL Server
Field Name: PHYMEM
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 PHYMEM

/SDF/MSSSTSERV620-TRACEFLAGS table field - Trace flags which are currently set for SQL Server.

Description: Trace flags which are currently set for SQL Server.
Field Name: TRACEFLAGS
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 TRACEFLAGS

/SDF/MSSSTSERV620-MEMSETTING table field - Specifies how SQL Server memory parameters have been set

Description: Specifies how SQL Server memory parameters have been set
Field Name: MEMSETTING
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 MEMSETTING

/SDF/MSSSTSERV620-AGTLOGLOC table field - UNC path to a file used by SQL Server

Description: UNC path to a file used by SQL Server
Field Name: AGTLOGLOC
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 AGTLOGLOC

/SDF/MSSSTSERV620-ERRLOGLOC table field - UNC path to a file used by SQL Server

Description: UNC path to a file used by SQL Server
Field Name: ERRLOGLOC
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 ERRLOGLOC


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table