SAP MSQSPWHO table - MS SQL server on line user status details in SAP

SAP MSQSPWHO table summary

Object Name: MSQSPWHO
Dictionary Type: Structure
Description: MS SQL server on line user status

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

Details

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

Description: MS SQL Server process ID
Field Name: SPID
Data Element: MSQSYPROID
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

MSQSPWHO-STATUS table field - SQL Server process status; ie sleeping, running etc. ▼

Description: SQL Server process status; ie sleeping, running etc.
Field Name: STATUS
Data Element: MSQPROSTAT
Data Type: CHAR
length (Dec): 60(0)
Check table:
Conversion Routine:
Domain Name: CHAR60
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field STATUS

MSQSPWHO-USERNAME table field - Database user name/ Owner of sql agent job ▼

Description: Database user name/ Owner of sql agent job
Field Name: USERNAME
Data Element: MSQUNAME
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field USERNAME

MSQSPWHO-HOSTNAME table field - MS SQL server - server name ▼

Description: MS SQL server - server name
Field Name: HOSTNAME
Data Element: MSQHOSTNA
Data Type: CHAR
length (Dec): 30(0)
Check table:
Conversion Routine:
Domain Name: CHAR30
MemoryID:
AppClass: KKEK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSQSPWHO-BLOCKID table field - SPID of blocking process. ▼

Description: SPID of blocking process.
Field Name: BLOCKID
Data Element: MSQBLOPRID
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

MSQSPWHO-DBNAME table field - The name of the database in SQL Server instance. ▼

Description: The name of the database in SQL Server instance.
Field Name: DBNAME
Data Element: MSQDBNAME
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 DBNAME

MSQSPWHO-COMMAND table field - Command currently being executed by the given process id ▼

Description: Command currently being executed by the given process id
Field Name: COMMAND
Data Element: MSQEXECMD
Data Type: CHAR
length (Dec): 32(0)
Check table:
Conversion Routine:
Domain Name: CHAR32
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