SAP MSQSAPLCKS table - MS SQL server sap locks (as from sap_locks) details in SAP

  


SAP MSQSAPLCKS table summary

Object Name: MSQSAPLCKS
Dictionary Type: Structure
Description: MS SQL server sap locks (as from sap_locks)


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

Details
MSQSAPLCKS-CURDATE table field - MS SQL server - usa style date format ▼

Description: MS SQL server - usa style date format
Field Name: CURDATE
Data Element: MSQUSADATE
Data Type: CHAR
length (Dec): 12(0)
Check table:
Conversion Routine:
Domain Name: CHAR12
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CURDATE

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

MSQSAPLCKS-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: MSQHOSTNE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field HOSTNAME

MSQSAPLCKS-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: MSQPRONE
Data Type: CHAR
length (Dec): 128(0)
Check table:
Conversion Routine:
Domain Name: CHAR128
MemoryID:
AppClass: SPO
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field PROGNAME

MSQSAPLCKS-CMD table field - Command currently being executed by the given process id ▼

Description: Command currently being executed by the given process id
Field Name: CMD
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 CMD

MSQSAPLCKS-LOCKNAME table field - Lock request mode translated from table sptvalue. ▼

Description: Lock request mode translated from table sptvalue.
Field Name: LOCKNAME
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 LOCKNAME

MSQSAPLCKS-OBJNAME table field - Object name as defined in system table sysobjects. ▼

Description: Object name as defined in system table sysobjects.
Field Name: OBJNAME
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 OBJNAME


  



View list of all SAP tables(S4H/ECC)

Select data from SAP table