SAP MSSSPWHO table - MS SQL Server: Online user status details in SAP

SAP MSSSPWHO table summary

Object Name: MSSSPWHO
Dictionary Type: Structure
Description: MS SQL Server: Online user status

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

Details

MSSSPWHO-SPID table field - MS SQL Server process ID ▼

Description: MS SQL Server process ID
Field Name: SPID
Data Element: MSSSPID
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SPID

MSSSPWHO-STATUS table field - MS SQL-Server process status ▼

Description: MS SQL-Server process status
Field Name: STATUS
Data Element: MSSSTATUS
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: TEXT10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

MSSSPWHO-USERNAME table field - MS SQL Server user name ▼

Description: MS SQL Server user name
Field Name: USERNAME
Data Element: MSSUNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

MSSSPWHO-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: MSSHOSTNM_
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSSSPWHO-BLOCKID table field - MS SQL Server sp ID of blocking process ▼

Description: MS SQL Server sp ID of blocking process
Field Name: BLOCKID
Data Element: MSSBLOCKED
Data Type: INT2
length (Dec): 5(0)
Check table:
Conversion Routine:
Domain Name: INT2
MemoryID:
AppClass: TEST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field BLOCKID

MSSSPWHO-DBNAME table field - MS SQL Server: Database name ▼

Description: MS SQL Server: Database name
Field Name: DBNAME
Data Element: MSSPDBNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: TEXT30
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field DBNAME

MSSSPWHO-COMMAND table field - MS SQL Server command ▼

Description: MS SQL Server command
Field Name: COMMAND
Data Element: MSSCOMMAND
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: TEXT16
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field COMMAND

View list of all SAP tables(S4H/ECC)

Select data from SAP table