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

  


SAP /SDF/MSSSTSERV_ALL 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/MSSSTSERV_ALL
Dictionary Type: Structure
Description: SQL Server: Static server data set (copy of MSS_STSERV 620)


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

Details
/SDF/MSSSTSERV_ALL-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/MSSSTSERV_ALL-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/MSSSTSERV_ALL-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/MSSSTSERV_ALL-SQLBUILDDT table field - Date the executable sqlservr.exe was created. ▼

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

/SDF/MSSSTSERV_ALL-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/MSSSTSERV_ALL-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/MSSSTSERV_ALL-NTEE table field - OS edition: A=Advanced Server, S=Server, D=Datacenter. ▼

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

/SDF/MSSSTSERV_ALL-DOMAINCTLR table field - Server is domain controller ▼

Description: Server is domain controller
Field Name: DOMAINCTLR
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 DOMAINCTLR

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


  

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