SAP MSSPROCINF table - MS SQL-Server: Process Information details in SAP


SAP MSSPROCINF table summary

Object Name: MSSPROCINF
Dictionary Type: Structure
Description: MS SQL-Server: Process Information


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

Details
MSSPROCINF-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

MSSPROCINF-KPID table field - Windows NT thread ID

Description: Windows NT thread ID
Field Name: KPID
Data Element: MSSKPID
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 KPID

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

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

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

MSSPROCINF-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: MSSPRGNAME
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 PROGNAME

MSSPROCINF-HOSTPROC table field - MS SQL-Server host process id (= OS work process ID)

Description: MS SQL-Server host process id (= OS work process ID)
Field Name: HOSTPROC
Data Element: MSSHOSTPID
Data Type: CHAR
length (Dec): 8(0)
Check table:
Conversion Routine:
Domain Name: WPPID
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTPROC

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

MSSPROCINF-CPUTIME table field - MS SQL Server cumulative cpu time

Description: MS SQL Server cumulative cpu time
Field Name: CPUTIME
Data Element: MSSCPUTIME
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

MSSPROCINF-PHYSIO table field - MS SQL Server cumulative physical I/O

Description: MS SQL Server cumulative physical I/O
Field Name: PHYSIO
Data Element: MSSPHYSIO
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 PHYSIO

MSSPROCINF-MEMUSAGE table field - MS SQL Server # of 2K pages used in procedure cache

Description: MS SQL Server # of 2K pages used in procedure cache
Field Name: MEMUSAGE
Data Element: MSSMEMUSE
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

MSSPROCINF-BLOCKERPID table field - MS SQL Server sp ID of blocking process

Description: MS SQL Server sp ID of blocking process
Field Name: BLOCKERPID
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 BLOCKERPID

MSSPROCINF-WAITTYPE table field - MS SQL Server wait type

Description: MS SQL Server wait type
Field Name: WAITTYPE
Data Element: MSSWAITTYP
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 WAITTYPE

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

MSSPROCINF-GROUPID table field - MS SQL Server group ID

Description: MS SQL Server group ID
Field Name: GROUPID
Data Element: MSSGROUPID
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 GROUPID

MSSPROCINF-SAPUSER table field - User Currently Served

Description: User Currently Served
Field Name: SAPUSER
Data Element: WPBNAME
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: UBNAME
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SAPUSER

MSSPROCINF-REPORTNAME table field - Report now running

Description: Report now running
Field Name: REPORTNAME
Data Element: WPREPORT
Data Type: CHAR
length (Dec): 40(0)
Check table:
Conversion Routine:
Domain Name: WPREPORT
MemoryID:
AppClass: STSK
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field REPORTNAME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table