ESH_ADM_SC_MAIN

Transparent Table Customizing Table
12 Fields 3 CDS Views

Search Connectors

ESH_ADM_SC_MAIN is an SAP database table in S/4HANA. Search Connectors. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

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

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY template_type ESH_E_OM_TEMPLATE_TYPE Template Type
KEY sc_id ESH_E_IF_SEARCH_CONNECTOR_ID Search Connector ID
template_id ESH_E_IF_TEMPLATE_ID Model ID
connection_guid ESH_E_ADM_CONNECTION_GUID Connection GUID
hash_code_sc CHAR40 Char
hash_code_templ CHAR40 Char
object_type ESH_E_OM_OBJECT_TYPE Object Type
cre_user ESH_E_CL_USER_CREATE Created By
cre_timestamp ESH_E_ADM_TIMESTAMP Timestamp
mod_user ESH_E_CL_USER_CHANGE Changed By
mod_timestamp ESH_E_ADM_TIMESTAMP Timestamp

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.

-- Search Connectors
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESH_ADM_SC_MAIN (
    MANDT,            -- Client [MANDT]
    TEMPLATE_TYPE,    -- Template Type [ESH_E_OM_TEMPLATE_TYPE]
    SC_ID,            -- Search Connector ID [ESH_E_IF_SEARCH_CONNECTOR_ID]
    TEMPLATE_ID,      -- Model ID [ESH_E_IF_TEMPLATE_ID]
    CONNECTION_GUID,  -- Connection GUID [ESH_E_ADM_CONNECTION_GUID]
    HASH_CODE_SC,     -- Char [CHAR40]
    HASH_CODE_TEMPL,  -- Char [CHAR40]
    OBJECT_TYPE,      -- Object Type [ESH_E_OM_OBJECT_TYPE]
    CRE_USER,         -- Created By [ESH_E_CL_USER_CREATE]
    CRE_TIMESTAMP,    -- Timestamp [ESH_E_ADM_TIMESTAMP]
    MOD_USER,         -- Changed By [ESH_E_CL_USER_CHANGE]
    MOD_TIMESTAMP,    -- Timestamp [ESH_E_ADM_TIMESTAMP]
    PRIMARY KEY (MANDT, TEMPLATE_TYPE, SC_ID)
);

Learn More