SAP MSSPFNTOPS table - Display MSQSNAP table: Server set details in SAP


SAP MSSPFNTOPS table summary

Object Name: MSSPFNTOPS
Dictionary Type: Structure
Description: Display MSQSNAP table: Server set


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

Details
MSSPFNTOPS-DAYOW table field - Day (for Collector)

Description: Day (for Collector)
Field Name: DAYOW
Data Element: DAYOFWEEK
Data Type: CHAR
length (Dec): 7(0)
Check table:
Conversion Routine:
Domain Name: CHAR7
MemoryID:
AppClass: SDIN
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DAYOW

MSSPFNTOPS-RECORDDATE table field - Date

Description: Date
Field Name: RECORDDATE
Data Element: DATUM
Data Type: DATS
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: DATUM
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDDATE

MSSPFNTOPS-RECORDTIME table field - Time

Description: Time
Field Name: RECORDTIME
Data Element: UZEIT
Data Type: TIMS
length (Dec): 6(0)
Check table:
Conversion Routine:
Domain Name: UZEIT
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field RECORDTIME

MSSPFNTOPS-SQLVERSION table field - Version of the database management system.

Description: Version of the database management system.
Field Name: SQLVERSION
Data Element: MSQVERSN
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: CHAR50
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLVERSION

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

See all SAP tables containing field SQLBUILDNM

MSSPFNTOPS-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: MSQSSSQLEE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLEE

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

See all SAP tables containing field TRACEFLAGS

MSSPFNTOPS-PARAMDIFF table field - Configuration options set differ from current values ( ='X')

Description: Configuration options set differ from current values ( ='X')
Field Name: PARAMDIFF
Data Element: MSQSSPDIFF
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARAMDIFF

MSSPFNTOPS-HOSTNAME table field - Hostname of the application server logged into SQL Server.

Description: Hostname of the application server logged into SQL Server.
Field Name: HOSTNAME
Data Element: MSQHOSTNE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSSPFNTOPS-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: MSQDBUPTME
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLSTARTTM

MSSPFNTOPS-USERCONCTS table field - Number of user connections to the SQL Server system

Description: Number of user connections to the SQL Server system
Field Name: USERCONCTS
Data Element: MSSPSUSCON
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERCONCTS

MSSPFNTOPS-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: MSQSSWVER
Data Type: CHAR
length (Dec): 80(0)
Check table:
Conversion Routine:
Domain Name: CHAR80
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field WINVER

MSSPFNTOPS-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: MSQSSCHIP
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CHIP

MSSPFNTOPS-SQLUPTIME table field - Number of seconds SQL Server has been running.

Description: Number of seconds SQL Server has been running.
Field Name: SQLUPTIME
Data Element: MSQDSSQLSC
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: INT4
MemoryID:
AppClass: CP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SQLUPTIME

MSSPFNTOPS-PRODLEVEL table field - Date the executable sqlservr.exe was created.

Description: Date the executable sqlservr.exe was created.
Field Name: PRODLEVEL
Data Element: MSQSSBLDDT
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PRODLEVEL

MSSPFNTOPS-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: MSQSSNTEE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTVER

MSSPFNTOPS-ISCLUSTER table field - Is SQL Server clustered 'Y' or 'N'

Description: Is SQL Server clustered 'Y' or 'N'
Field Name: ISCLUSTER
Data Element: MSSISCLUSTER
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISCLUSTER

MSSPFNTOPS-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: MSSIS3GB
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field IS3GB

MSSPFNTOPS-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: MSSISPAE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISPAE

MSSPFNTOPS-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: MSSISAWE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: CHAR1
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISAWE


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table