SAP MSS_CONNECTION table - sys.dm_exec_connections structure from SQL Server 9.0 details in SAP

SAP MSS_CONNECTION table summary

Object Name: MSS_CONNECTION
Dictionary Type: Structure
Description: sys.dm_exec_connections structure from SQL Server 9.0

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

Details

MSS_CONNECTION-CONNECTIONID table field - SQL Server connection id ▼

Description: SQL Server connection id
Field Name: CONNECTIONID
Data Element: MSSCONNECTIONID
Data Type: CHAR
length (Dec): 36(0)
Check table:
Conversion Routine:
Domain Name: MSSUNIQIDENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECTIONID

MSS_CONNECTION-PARENT_CONNID table field - SQL Server parent connection id ▼

Description: SQL Server parent connection id
Field Name: PARENT_CONNID
Data Element: MSSPARENTCONNID
Data Type: CHAR
length (Dec): 36(0)
Check table:
Conversion Routine:
Domain Name: MSSUNIQIDENT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PARENT_CONNID

MSS_CONNECTION-CONN_SESSIONID table field - Session ID running on connection ▼

Description: Session ID running on connection
Field Name: CONN_SESSIONID
Data Element: MSSCONNSID
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONN_SESSIONID

MSS_CONNECTION-CONNECT_TIME table field - Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS ▼

Description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
Field Name: CONNECT_TIME
Data Element: MSSCONNDATE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECT_TIME

MSS_CONNECTION-NET_TRANSPORT table field - The network transport type used by the connection ▼

Description: The network transport type used by the connection
Field Name: NET_TRANSPORT
Data Element: MSSNETRANSPORT
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 NET_TRANSPORT

MSS_CONNECTION-PROTOCOL_TYPE table field - The network transport protocol used by the connection ▼

Description: The network transport protocol used by the connection
Field Name: PROTOCOL_TYPE
Data Element: MSSPROTYPE
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 PROTOCOL_TYPE

MSS_CONNECTION-AFFINITY_NODE table field - Node Affinity from DMV connection ▼

Description: Node Affinity from DMV connection
Field Name: AFFINITY_NODE
Data Element: MSSNODEAFF
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field AFFINITY_NODE

MSS_CONNECTION-CONN_NUMREADS table field - SQL Server connection number of reads over the connection ▼

Description: SQL Server connection number of reads over the connection
Field Name: CONN_NUMREADS
Data Element: MSSCONNUMREADS
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONN_NUMREADS

MSS_CONNECTION-CONN_NUMWRITES table field - SQL Server conneciton number of writes over the connection ▼

Description: SQL Server conneciton number of writes over the connection
Field Name: CONN_NUMWRITES
Data Element: MSSCONNUMWRITES
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONN_NUMWRITES

MSS_CONNECTION-LAST_READ table field - Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS ▼

Description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
Field Name: LAST_READ
Data Element: MSSCONNLASTRD
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_READ

MSS_CONNECTION-LAST_WRITE table field - Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS ▼

Description: Character representation of datetime YYYY-MM-DD HH:MM:SS:SSS
Field Name: LAST_WRITE
Data Element: MSSCONNLASTWT
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LAST_WRITE

MSS_CONNECTION-NET_PACKET_SIZE table field - SQL Server packet size ▼

Description: SQL Server packet size
Field Name: NET_PACKET_SIZE
Data Element: MSSPACKSZ
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NET_PACKET_SIZE

MSS_CONNECTION-CLIENT_NET_ADDR table field - Connection network address ▼

Description: Connection network address
Field Name: CLIENT_NET_ADDR
Data Element: MSSCONNETADDR
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: CHAR40
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT_NET_ADDR

View list of all SAP tables(S4H/ECC)

Select data from SAP table