SAP ESH_DBT_TR Database Triggers Table data and field list

ESH_DBT_TR is a standard SAP Table which is used to store Database Triggers data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_DBT_TR table consists of various fields, each holding specific information or linking keys about Database Triggers data available in SAP. These include TRIGGER_ID (Database Trigger ID), RECORDER_ID (Recorder ID), APPLICATION_TAB (Table Name), GEN_TRIGGER_TAB (Table Name)... 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. .

ESH_DBT_TR table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_DBT_TR table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ESH_DBT_TR table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
TRIGGER_IDDatabase Trigger ID ESH_E_DBT_TRIGGER_IDCHAR40ESH_D_DBT_TRIGGER_ID
RECORDER_IDRecorder ID ESH_E_DBT_RECORDER_IDCHAR32ESH_D_DBT_RECORDER_ID
APPLICATION_TABTable Name TABNAMECHAR30Assigned to domainAS4TABDTB
GEN_TRIGGER_TABTable Name TABNAMECHAR30Assigned to domainAS4TABDTB
CLIENT_DEPENDENTCharacter Field Length 1 CHAR01CHAR1CHAR1
PROCESSING_GROUPDatabase Trigger Processing Group ESH_E_DBT_PROCESSING_GROUPCHAR10ESH_D_DBT_PROCESSING_GROUP
PROCESSING_SEQNODatabase Trigger Processing Sequence Number ESH_E_DBT_PROCESSING_SEQNONUMC10ESH_D_DBT_PROCESSING_SEQNO
TRIGGER_STATUSDatabase Trigger Status ESH_E_DBT_TRIGGER_STATUSCHAR1ESH_D_DBT_TRIGGER_STATUS
CONSUMER_CNTDatabase Trigger Consumer Count ESH_E_DBT_TRIGGER_CONSUMER_CNTINT410ESH_D_DBT_TRIGGER_CONSUMER_CNT
TRIGGER_CRE_USERDatabase Trigger Creation User ESH_E_DBT_TRIGGER_CRE_USERCHAR12USERNAME
TRIGGER_CRE_TSTPDatabase Trigger Creation Timestamp ESH_E_DBT_TRIGGER_CRE_TSTPDEC15TZNTSTMPS
TRIGGER_UPD_USERDatabase Trigger Update User ESH_E_DBT_TRIGGER_UPD_USERCHAR12USERNAME
TRIGGER_UPD_TSTPDatabase Trigger Update Timestamp ESH_E_DBT_TRIGGER_UPD_TSTPDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table ESH_DBT_TR using ABAP code

The following ABAP code Example will allow you to do a basic selection on ESH_DBT_TR to SELECT all data from the table
DATA: WA_ESH_DBT_TR TYPE ESH_DBT_TR.

SELECT SINGLE *
FROM ESH_DBT_TR
INTO CORRESPONDING FIELDS OF WA_ESH_DBT_TR
WHERE...

How to access SAP table ESH_DBT_TR

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

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