SAP MSQSAPSULK table - MS SQL server - list of locks from sap_summary_locks details in SAP


SAP MSQSAPSULK table summary

Object Name: MSQSAPSULK
Dictionary Type: Structure
Description: MS SQL server - list of locks from sap_summary_locks


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

Details
MSQSAPSULK-DURATION table field - Time the blocking lock was hold in minutes.

Description: Time the blocking lock was hold in minutes.
Field Name: DURATION
Data Element: MSQLCKDUR
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 DURATION

MSQSAPSULK-START_DATE table field - Time stamp when the blocking situation started.

Description: Time stamp when the blocking situation started.
Field Name: START_DATE
Data Element: MSQSTDATE
Data Type: CHAR
length (Dec): 20(0)
Check table:
Conversion Routine:
Domain Name: CHAR20
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field START_DATE

MSQSAPSULK-SPID table field - SQL Server process ID

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

MSQSAPSULK-TABLENAME table field - Object name as defined in system table sysobjects.

Description: Object name as defined in system table sysobjects.
Field Name: TABLENAME
Data Element: MSQOBJNAME
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field TABLENAME

MSQSAPSULK-LCKNAME table field - Lock request mode translated from table sptvalue.

Description: Lock request mode translated from table sptvalue.
Field Name: LCKNAME
Data Element: MSQSPTNAME
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKNAME

MSQSAPSULK-KPID table field - Windows operating system thread ID

Description: Windows operating system thread ID
Field Name: KPID
Data Element: MSQTHREDID
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

MSQSAPSULK-BLOKSPID table field - SPID of blocking process.

Description: SPID of blocking process.
Field Name: BLOKSPID
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 BLOKSPID

MSQSAPSULK-LCKRSC table field - Textual description of a lock resource from syslockinfo.

Description: Textual description of a lock resource from syslockinfo.
Field Name: LCKRSC
Data Element: MSQRSCTXT
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 LCKRSC

MSQSAPSULK-LCKTYPE table field - Lock resource type as e. g. KEY or PAGE.

Description: Lock resource type as e. g. KEY or PAGE.
Field Name: LCKTYPE
Data Element: MSQLCKRSC
Data Type: CHAR
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: CHAR10
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKTYPE

MSQSAPSULK-DBASENAME table field - The name of the database in SQL Server instance.

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

MSQSAPSULK-INDNAME table field - Object name as defined in system table sysobjects.

Description: Object name as defined in system table sysobjects.
Field Name: INDNAME
Data Element: MSQOBJNAME
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field INDNAME

MSQSAPSULK-LCKSTATUS table field - Lock request mode translated from table sptvalue.

Description: Lock request mode translated from table sptvalue.
Field Name: LCKSTATUS
Data Element: MSQSPTNAME
Data Type: CHAR
length (Dec): 35(0)
Check table:
Conversion Routine:
Domain Name: CHAR35
MemoryID:
AppClass: MW
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LCKSTATUS

MSQSAPSULK-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: MSQHOSTNAM
Data Type: CHAR
length (Dec): 256(0)
Check table:
Conversion Routine:
Domain Name: CHAR256
MemoryID:
AppClass: SYST
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSQSAPSULK-CONNECTTYP table field - Name of the application program which owns the connection

Description: Name of the application program which owns the connection
Field Name: CONNECTTYP
Data Element: MSQSQLCONN
Data Type: CHAR
length (Dec): 16(0)
Check table:
Conversion Routine:
Domain Name: CHAR16
MemoryID:
AppClass: SLG
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CONNECTTYP

MSQSAPSULK-WAITTYPE table field - Wait type of waiting process, reserved field of sysprocesses

Description: Wait type of waiting process, reserved field of sysprocesses
Field Name: WAITTYPE
Data Element: MSQWAITTYP
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 WAITTYPE

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