LOCK_W_SDB SAP (SAP DB Lock Waits) Structure details

Dictionary Type: Structure
Description: SAP DB Lock Waits




ABAP Code to SELECT data from LOCK_W_SDB
Related tables to LOCK_W_SDB
Access table LOCK_W_SDB




Structure field list including key, data, relationships and ABAP select examples

LOCK_W_SDB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SAP DB Lock Waits" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_LOCK_W_SDB TYPE LOCK_W_SDB.

The LOCK_W_SDB table consists of various fields, each holding specific information or linking keys about SAP DB Lock Waits data available in SAP. These include TABLEID (Table ID), H_TERMID (Terminal ID), H_PROCESS (SAP DB: Process ID), H_APPLPROC (SAP DB: Process ID).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP LOCK_W_SDB structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TABLENAMESDB Table Name ADATABNAMECHAR30CHAR30
TABLEIDTable ID SADA_TABIDCHAR16CHAR16
H_TERMIDTerminal ID SADATERMIDCHAR18CHAR18
H_PROCESSSAP DB: Process ID SADA_PIDCHAR10CHR10
H_APPLPROCSAP DB: Process ID SADA_PIDCHAR10CHR10
H_APPLNODESDB Node Name SADA_NODECHAR64CHR64
H_ROWIDTable row ID SADAROWIDCHAR256CHAR256
H_LOCKMODESDB Locking Mode SADA_MODECHAR14CHAR14
H_DATESDB Date SADA_DATECHAR10CHR10
H_TIMESDB Time SADA_TIMECHAR8CHAR8
H_LOCKTOUTSDB Timeout SADA_TOUTCHAR10CHR10
R_TERMIDTerminal ID SADATERMIDCHAR18CHAR18
R_PROCESSSAP DB: Process ID SADA_PIDCHAR10CHR10
R_APPLPROCSAP DB: Process ID SADA_PIDCHAR10CHR10
R_APPLNODESDB Node Name SADA_NODECHAR64CHR64
R_ROWIDTable row ID SADAROWIDCHAR256CHAR256
R_REQMODESDB Locking Mode SADA_MODECHAR14CHAR14
R_DATESDB Date SADA_DATECHAR10CHR10
R_TIMESDB Time SADA_TIMECHAR8CHAR8
R_REQTOUTSDB Timeout SADA_TOUTCHAR10CHR10

Key field Non-key field



How do I retrieve data from SAP structure LOCK_W_SDB using ABAP code?

As LOCK_W_SDB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on LOCK_W_SDB as there is no data to select.

How to access SAP table LOCK_W_SDB

Within an ECC or HANA version of SAP you can also view further information about LOCK_W_SDB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!