SAP MSSLOCKINF table - MS SQL-Server: Lock Information details in SAP

SAP MSSLOCKINF table summary

Object Name: MSSLOCKINF
Dictionary Type: Structure
Description: MS SQL-Server: Lock Information

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

Details

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

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

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

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

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

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

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

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

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

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

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

Description: MS SQL Server: Database name
Field Name: DBNAME
Data Element: MSSLDBNAME
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

MSSLOCKINF-LOCKID table field - MS SQL-Server lock ID ▼

Description: MS SQL-Server lock ID
Field Name: LOCKID
Data Element: MSSLOCKID
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 LOCKID

MSSLOCKINF-LOCKEDPAGE table field - MS SQL Server locked page number ▼

Description: MS SQL Server locked page number
Field Name: LOCKEDPAGE
Data Element: MSSLOCKPG
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 LOCKEDPAGE

MSSLOCKINF-LOCKTYPE table field - MS SQL Server lock type number ▼

Description: MS SQL Server lock type number
Field Name: LOCKTYPE
Data Element: MSSLOCKTYP
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 LOCKTYPE

MSSLOCKINF-LOCKTEXT table field - MS SQL Server lock description text ▼

Description: MS SQL Server lock description text
Field Name: LOCKTEXT
Data Element: MSSLOCKTXT
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: TEXT35
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LOCKTEXT

MSSLOCKINF-OBJECTNAME table field - MS SQL Server object name ▼

Description: MS SQL Server object name
Field Name: OBJECTNAME
Data Element: MSSOBJNAME
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 OBJECTNAME

MSSLOCKINF-OBJECTTYPE table field - Object type ▼

Description: Object type
Field Name: OBJECTTYPE
Data Element: MSSOBJTYPE
Data Type:
length (Dec): 0(0)
Check table:
Conversion Routine:
Domain Name:
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field OBJECTTYPE

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

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

MSSLOCKINF-NESTLEVEL table field - Nesting level for lock waiters ▼

Description: Nesting level for lock waiters
Field Name: NESTLEVEL
Data Element: NESTLEVEL
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 NESTLEVEL

View list of all SAP tables(S4H/ECC)

Select data from SAP table