SAP ESH_DBT_CONN Database Trigger Consumer Registrations Table data and field list

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

The ESH_DBT_CONN table consists of various fields, each holding specific information or linking keys about Database Trigger Consumer Registrations data available in SAP. These include TRIGGER_ID (Database Trigger ID), CONSUMER_ID (Database Trigger Consumer ID), CONSUMER_TYPE (Database Trigger Consumer Type), CONSUMER_STATUS (Database Trigger Consumer Status)... 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_CONN table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_DBT_CONN 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_CONN 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
CONSUMER_IDDatabase Trigger Consumer ID ESH_E_DBT_CONSUMER_IDCHAR40ESH_D_DBT_CONSUMER_ID
CONSUMER_TYPEDatabase Trigger Consumer Type ESH_E_DBT_CONSUMER_TYPECHAR1ESH_D_DBT_CONSUMER_TYPE
CONSUMER_STATUSDatabase Trigger Consumer Status ESH_E_DBT_CONSUMER_STATUSCHAR1ESH_D_DBT_CONSUMER_STATUS
CONSUMER_SEQNODatabase Trigger Consumer Sequence Number ESH_E_DBT_CONSUMER_SEQNONUMC10ESH_D_DBT_CONSUMER_SEQNO
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
OBJECT_TYPEObject Type ESH_E_OM_OBJECT_TYPECHAR20ESH_D_OM_OBJECT_TYPE
NODE_NAMENode Name ESH_E_OM_NODE_NAMECHAR20ESH_D_OM_NODE_NAME
AUTH_CHECK_BOObject Type ESH_E_OM_OBJECT_TYPECHAR20ESH_D_OM_OBJECT_TYPE
AUTH_CHECK_NODENode Name ESH_E_OM_NODE_NAMECHAR20ESH_D_OM_NODE_NAME
AUTH_CHECKAuthorization Check ESH_E_OM_AUTH_CHECKCHAR30
CONSUMER_REG_USERDatabase Trigger Consumer: Registration User ESH_E_DBT_CONSUMER_REG_USERCHAR12USERNAME
CONSUMER_REG_TSTPDatabase Trigger Consumer: Registration Timestamp ESH_E_DBT_CONSUMER_REG_TSTPDEC21(7) TZNTSTMPL
CONSUMER_UPD_USERDatabase Trigger Consumer: Last Status Update User ESH_E_DBT_CONSUMER_UPD_USERCHAR12USERNAME
CONSUMER_UPD_TSTPDatabase Trigger Consumer: Last Status Update Timestamp ESH_E_DBT_CONSUMER_UPD_TSTPDEC21(7) TZNTSTMPL

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_DBT_CONN
INTO CORRESPONDING FIELDS OF WA_ESH_DBT_CONN
WHERE...

How to access SAP table ESH_DBT_CONN

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

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