SAP ESH_ADM_STATUS Status of Search Connectors Table data and field list

ESH_ADM_STATUS is a standard SAP Table which is used to store Status of Search Connectors data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ESH_ADM_STATUS table consists of various fields, each holding specific information or linking keys about Status of Search Connectors data available in SAP. These include SC_TYPE (Search Connector Type), SC_ID (Search Connector ID), SC_STATUS (Status of a Search Connector), TIMESTAMP (ESH: Timestamp)... 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_ADM_STATUS table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP ESH_ADM_STATUS 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_ADM_STATUS 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
SC_TYPESearch Connector Type ESH_E_IF_SEARCH_CONNECTOR_TYPECHAR10ESH_D_OM_TEMPLATE_TYPE
SC_IDSearch Connector ID ESH_E_IF_SEARCH_CONNECTOR_IDCHAR120ESH_D_IF_IDENTIFIER_LONG
SC_STATUSStatus of a Search Connector ESH_E_ADM_SC_STATUSNUMC2ESH_D_ADM_SC_STATUS
TIMESTAMPESH: Timestamp ESH_E_ADM_TIMESTAMPDEC15TZNTSTMPS
COUNTERESH: Number ESH_E_ADM_NUMBERINT410ESH_D_ADM_NUMBER
IS_SEARCHABLEFlag: Available for Search ESH_E_IF_SEARCHABLECHAR1XFELD
JOBNAMEBackground job name BTCJOBCHAR32CHAR32
JOBCOUNTJob ID BTCJOBCNTCHAR8CHAR8
INACTIVEStatus Inactive ESH_E_ADM_STATUS_INACTIVECHAR1CHAR1
IS_REPORTABLEFlag: Available for Analytics ESH_E_IF_REPORTABLECHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM ESH_ADM_STATUS
INTO CORRESPONDING FIELDS OF WA_ESH_ADM_STATUS
WHERE...

How to access SAP table ESH_ADM_STATUS

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

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