ESERVPROV

Transparent Table Application Table
15 Fields 3 CDS Views

Service Providers

ESERVPROV is an SAP database table in S/4HANA. Service Providers. It contains 15 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/UCOM/I_MCM_ESERVPROV view_entity from BASIC Basic View
/UCOM/I_SERVPROV view from BASIC Service Provider
I_UtilitiesServiceProvider view from BASIC Utilities Service Provider

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY serviceid SERVICE_PROV Serv. Provider
prov_bukrs BUKRS_PR CoCode ServPr.
service SERCODE Service Type
externalid DUNSNR External Number
own_log_sys OWN_LOG_SYS SP in Own Sys.
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete
sec_ext_id E_EDMIDEEXTNUM Second Ext. No.
sec_ext_idtyp E_EDMIDEEXTNUMTYP Ext. No. Cat.
externalidtyp E_EDMIDEEXTNUMTYP Ext. No. Cat.

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.

-- Service Providers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESERVPROV (
    MANDT,          -- Client [MANDT]
    SERVICEID,      -- Serv. Provider [SERVICE_PROV]
    PROV_BUKRS,     -- CoCode ServPr. [BUKRS_PR]
    SERVICE,        -- Service Type [SERCODE]
    EXTERNALID,     -- External Number [DUNSNR]
    OWN_LOG_SYS,    -- SP in Own Sys. [OWN_LOG_SYS]
    ERDAT,          -- Created On [ERDAT]
    ERNAM,          -- Created By [ERNAM]
    AEDAT,          -- Changed On [AEDAT]
    AENAM,          -- Changed By [AENAM]
    BEGRU,          -- AuthorizGroup [BEGRU]
    LOEVM,          -- Delete [LOEVM]
    SEC_EXT_ID,     -- Second Ext. No. [E_EDMIDEEXTNUM]
    SEC_EXT_IDTYP,  -- Ext. No. Cat. [E_EDMIDEEXTNUMTYP]
    EXTERNALIDTYP,  -- Ext. No. Cat. [E_EDMIDEEXTNUMTYP]
    PRIMARY KEY (MANDT, SERVICEID)
);

Learn More