SAP ESH_S_DBT_TR Database Triggers Table data and field list

ESH_S_DBT_TR 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 "Database Triggers" 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_ESH_S_DBT_TR TYPE ESH_S_DBT_TR.

The ESH_S_DBT_TR table consists of various fields, each holding specific information or linking keys about Database Triggers data available in SAP. These include MANDT (Client), TRIGGER_ID (Database Trigger ID), RECORDER_ID (Recorder ID), APPLICATION_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_S_DBT_TR structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_S_DBT_TR structure 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_S_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 structure ESH_S_DBT_TR using ABAP code?

As ESH_S_DBT_TR 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 ESH_S_DBT_TR as there is no data to select.

How to access SAP table ESH_S_DBT_TR

Within an ECC or HANA version of SAP you can also view further information about ESH_S_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).