SAP MSS_SESSION table - /sys.dm_exec_sessions structure from SQL Server 9.0 details in SAP

SAP MSS_SESSION table summary

Object Name: MSS_SESSION
Dictionary Type: Structure
Description: /sys.dm_exec_sessions structure from SQL Server 9.0

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

Details

MSS_SESSION-SESSIONID table field - Session ID for SQL Server ▼

Description: Session ID for SQL Server
Field Name: SESSIONID
Data Element: MSSSESSIONID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MSSINT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESSIONID

MSS_SESSION-LOGINTIME table field - The time at which client process logged into SQL Server. ▼

Description: The time at which client process logged into SQL Server.
Field Name: LOGINTIME
Data Element: MSQPRLGTME
Data Type: CHAR
length (Dec): 24(0)
Check table:
Conversion Routine:
Domain Name: CHAR24
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOGINTIME

MSS_SESSION-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

MSS_SESSION-PROGNAME table field - Name of the application program which owns the connection. ▼

Description: Name of the application program which owns the connection.
Field Name: PROGNAME
Data Element: MSQAPPPROG
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGNAME

MSS_SESSION-HOSTPID table field - Process ID on app. server ▼

Description: Process ID on app. server
Field Name: HOSTPID
Data Element: MSSHPID
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: MSSINT4
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTPID

MSS_SESSION-CLIENTINFVER table field - MSS Session client interface name ▼

Description: MSS Session client interface name
Field Name: CLIENTINFVER
Data Element: MSSSESSINTFVER
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENTINFVER

MSS_SESSION-CLIENTINFNAME table field - MSS Session client interface name ▼

Description: MSS Session client interface name
Field Name: CLIENTINFNAME
Data Element: MSSSESSINTFNAME
Data Type: CHAR
length (Dec): 64(0)
Check table:
Conversion Routine:
Domain Name: CHAR64
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENTINFNAME

MSS_SESSION-LOGINNAME table field - The user name used to log into the SQL Server database ▼

Description: The user name used to log into the SQL Server database
Field Name: LOGINNAME
Data Element: MSQUSRNAME
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 LOGINNAME

MSS_SESSION-NTDOMAIN table field - NT domain for the client connected to SQL Server. ▼

Description: NT domain for the client connected to SQL Server.
Field Name: NTDOMAIN
Data Element: MSQNTDOMA
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTDOMAIN

MSS_SESSION-NTUNAME table field - Windows NT user name for the process connected to SQL Server ▼

Description: Windows NT user name for the process connected to SQL Server
Field Name: NTUNAME
Data Element: MSQNTUNAME
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NTUNAME

MSS_SESSION-CPUTIME table field - CPU time for a SQL session (ms) ▼

Description: CPU time for a SQL session (ms)
Field Name: CPUTIME
Data Element: MSSSESCPUTIME
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 CPUTIME

MSS_SESSION-MEMUSAGE table field - The pages allocated by the SQL process in procedure cache. ▼

Description: The pages allocated by the SQL process in procedure cache.
Field Name: MEMUSAGE
Data Element: MSQPRMEMUS
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 MEMUSAGE

MSS_SESSION-TTLSCHEDTIME table field - SQL Server session scheduled time ▼

Description: SQL Server session scheduled time
Field Name: TTLSCHEDTIME
Data Element: MSSESSCHTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTLSCHEDTIME

MSS_SESSION-TTLELAPSEDTIME table field - SQL Server session elapsed time ▼

Description: SQL Server session elapsed time
Field Name: TTLELAPSEDTIME
Data Element: MSSESSELPTIME
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TTLELAPSEDTIME

MSS_SESSION-SESS_NUMREADS table field - number of reads performed in a session ▼

Description: number of reads performed in a session
Field Name: SESS_NUMREADS
Data Element: MSSSESNUMREADS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMREADS

MSS_SESSION-SESS_NUMWRITES table field - Number of writes performed in a session ▼

Description: Number of writes performed in a session
Field Name: SESS_NUMWRITES
Data Element: MSSSESNUMWRITES
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMWRITES

MSS_SESSION-SESS_NUMLOGICALREADS table field - number of reads performed by a session ▼

Description: number of reads performed by a session
Field Name: SESS_NUMLOGICALREADS
Data Element: MSSSESNUMLOGRDS
Data Type: DEC
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: MSQBIGINT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SESS_NUMLOGICALREADS

MSS_SESSION-TRXISOLEVEL table field - MSS Transaction Isolation level ▼

Description: MSS Transaction Isolation level
Field Name: TRXISOLEVEL
Data Element: MSSTRXISOLEVEL
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TRXISOLEVEL

MSS_SESSION-ORIGLOGINNAME table field - Original name used to login to SQL Server ▼

Description: Original name used to login to SQL Server
Field Name: ORIGLOGINNAME
Data Element: MSSORIGUSRNAME
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 ORIGLOGINNAME

View list of all SAP tables(S4H/ECC)

Select data from SAP table