SAP ESH_S_DBT_ADMIN Database Trigger Demon Administration Table data and field list

ESH_S_DBT_ADMIN 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 Trigger Demon Administration" 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_ADMIN TYPE ESH_S_DBT_ADMIN.

The ESH_S_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 MANDT (Client), LOGSYS (Logical system), DBT_EXTRACT_FREQ (Database Trigger Demon - Extraction Frequency), DBT_DEMON_STATUS (Database Trigger Demon - Administration-Time 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_S_DBT_ADMIN 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_ADMIN 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_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
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
LOGSYS	Logical system	LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
DBT_EXTRACT_FREQ	Database Trigger Demon - Extraction Frequency	ESH_E_DBT_EXTRACT_FREQ	INT4	10
DBT_DEMON_STATUS	Database Trigger Demon - Administration-Time Status	ESH_E_DBT_DEMON_ADM_STATUS	CHAR	1			ESH_D_DBT_DEMON_ADM_STATUS
DBT_MAX_RUNTIME	Database Trigger Demon - Maximum Runtime (secs)	ESH_E_DBT_MAX_RUNTIME	INT4	10
DBT_MAX_IDLETIME	Database Trigger Demon - Maximum Idle Time (secs)	ESH_E_DBT_MAX_IDLE_TIME	INT4	10
LAST_MOD_TSTMP	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	TIMESTAMPL	DEC	21(7)			TZNTSTMPL
LAST_MOD_USER	User Name	SYUNAME	CHAR	12			SYCHAR12

Key field

Non-key field

< ESH_S_CRT_OBJECT_DATA - Object data for indexing in push processing ESH_S_DBT_CONN - Database Trigger Consumer Registrations >

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

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

How to access SAP table ESH_S_DBT_ADMIN

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