Object documentation LOCKS Locate the document in its SAP Library structure

This system table contains information about the set locks.

LOCKS

SESSION

FIXED(10)

ID of the database session

TRANSCOUNT

CHAR(20)

ID of the transaction in the database session

PROCESS

FIXED(10)

ID of the process in the database instance

USERNAME

CHAR(32)

Name of user

DATE

DATE(10)

Creation date of the lock

TIME

TIME(8)

Creation time of the lock

TERMID

CHAR(18)

ID of the user terminal

LASTWRITE

CHAR(10)

Time that has elapsed since the last SQL statement for data manipulation

LOCKMODE

CHAR(14)

Type of lock

LOCKSTATE

CHAR(10)

Status of lock

APPLPROCESS

FIXED(10)

ID of the process on the client hardware

APPLNODE

CHAR(64)

ID of the client hardware

OWNER

CHAR(32)

Table owner

TABLENAME

CHAR(32)

Name of table

TABLEID

CHAR BYTE(8)

Table ID

ROWIDLENGTH

FIXED(4)

Length of the key of the locked row

ROWIDHEX

CHAR BYTE(64)

Start of the key of the locked row in hexadecimal format

ROWID

CHAR(128)

Start of the key of the locked row

See also:

Evaluating System Tables ® LOCKS