SAP ESH_DBT_ADMIN Database Trigger Demon Administration Table data and field list

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

The ESH_DBT_ADMIN table consists of various fields, each holding specific information or linking keys about Database Trigger Demon Administration data available in SAP. These include LOGSYS (Logical system), DBT_EXTRACT_FREQ (Database Trigger Demon - Extraction Frequency), DBT_DEMON_STATUS (Database Trigger Demon - Administration-Time Status), DBT_MAX_RUNTIME (Database Trigger Demon - Maximum Runtime (secs))... 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_ADMIN 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_ADMIN 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_ADMIN 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
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
DBT_EXTRACT_FREQDatabase Trigger Demon - Extraction Frequency ESH_E_DBT_EXTRACT_FREQINT410
DBT_DEMON_STATUSDatabase Trigger Demon - Administration-Time Status ESH_E_DBT_DEMON_ADM_STATUSCHAR1ESH_D_DBT_DEMON_ADM_STATUS
DBT_MAX_RUNTIMEDatabase Trigger Demon - Maximum Runtime (secs) ESH_E_DBT_MAX_RUNTIMEINT410
DBT_MAX_IDLETIMEDatabase Trigger Demon - Maximum Idle Time (secs) ESH_E_DBT_MAX_IDLE_TIMEINT410
LAST_MOD_TSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
LAST_MOD_USERUser Name SYUNAMECHAR12SYCHAR12

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_DBT_ADMIN
INTO CORRESPONDING FIELDS OF WA_ESH_DBT_ADMIN
WHERE...

How to access SAP table ESH_DBT_ADMIN

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

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