ESH_ADM_STATUS

Transparent Table Customizing Table
13 Fields 2 CDS Views

Status of Search Connectors

ESH_ADM_STATUS is an SAP database table in S/4HANA. Status of Search Connectors. It contains 13 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_EntSrchRuntimeBufferDetails view left_outer BASIC Enterprise Search CDS Models Runtime Buffer Details
P_ESHSEARCHVIEW view left_outer BASIC

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sc_type ESH_E_IF_SEARCH_CONNECTOR_TYPE Connector Type
KEY sc_id ESH_E_IF_SEARCH_CONNECTOR_ID Search Connector ID
sc_status ESH_E_ADM_SC_STATUS Status
timestamp ESH_E_ADM_TIMESTAMP Timestamp
counter ESH_E_ADM_NUMBER Number
is_searchable ESH_E_IF_SEARCHABLE Search
jobname BTCJOB Job Name
jobcount BTCJOBCNT Job No.
applog_handle BALLOGHNDL Handle
applog_client SYMANDT Client ID
inactive ESH_E_ADM_STATUS_INACTIVE Inactive
is_reportable ESH_E_IF_REPORTABLE Analytics

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Status of Search Connectors
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESH_ADM_STATUS (
    MANDT,          -- Client [MANDT]
    SC_TYPE,        -- Connector Type [ESH_E_IF_SEARCH_CONNECTOR_TYPE]
    SC_ID,          -- Search Connector ID [ESH_E_IF_SEARCH_CONNECTOR_ID]
    SC_STATUS,      -- Status [ESH_E_ADM_SC_STATUS]
    TIMESTAMP,      -- Timestamp [ESH_E_ADM_TIMESTAMP]
    COUNTER,        -- Number [ESH_E_ADM_NUMBER]
    IS_SEARCHABLE,  -- Search [ESH_E_IF_SEARCHABLE]
    JOBNAME,        -- Job Name [BTCJOB]
    JOBCOUNT,       -- Job No. [BTCJOBCNT]
    APPLOG_HANDLE,  -- Handle [BALLOGHNDL]
    APPLOG_CLIENT,  -- Client ID [SYMANDT]
    INACTIVE,       -- Inactive [ESH_E_ADM_STATUS_INACTIVE]
    IS_REPORTABLE,  -- Analytics [ESH_E_IF_REPORTABLE]
    PRIMARY KEY (MANDT, SC_TYPE, SC_ID)
);

Learn More