ESERVICE
Point of delivery service
ESERVICE is an SAP database table in S/4HANA. Point of delivery service. It contains 22 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /UCOM/I_MCM_POD_SERVICE_DETAIL | view_entity | inner | COMPOSITE | MCM PoD Service Details |
| I_UtilsPoDService | view_entity | from | BASIC | Utilities Point Of Delivery Service |
Fields (22)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | vertrag | SERVICE_KEY | PoD service | |||
| int_ui | INT_UI | PoD | ||||
| service_start | SERVICE_START | Start date PoDS | ||||
| service_end | SERVICE_END | End date PoDS | ||||
| service | SERCODE | Service Type | ||||
| serviceid | SERVICE_PROV | Serv. Provider | ||||
| srvprvref | SRVPRVREF | SP reference no | ||||
| servprov_pay | SERVPROV_PAY | Payment Class | ||||
| sparte | SPARTE | Division | ||||
| startobjtype | SWO_OBJTYP | Object Type | ||||
| startobjkey | DOCUMENTKEY | Document number | ||||
| endobjtype | SWO_OBJTYP | Object Type | ||||
| endobjkey | DOCUMENTKEY | Document number | ||||
| erdat | ERDAT | Created On | ||||
| ernam | ERNAM | Created By | ||||
| aedat | AEDAT | Changed On | ||||
| aenam | AENAM | Changed By | ||||
| begru | BEGRU | AuthorizGroup | ||||
| loevm | LOEVM | Delete | ||||
| prev_serv_start | SERVICE_START | Start date PoDS | ||||
| prev_serv_end | SERVICE_END | End date PoDS |
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.
-- Point of delivery service
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ESERVICE (
MANDT, -- Client [MANDT]
VERTRAG, -- PoD service [SERVICE_KEY]
INT_UI, -- PoD [INT_UI]
SERVICE_START, -- Start date PoDS [SERVICE_START]
SERVICE_END, -- End date PoDS [SERVICE_END]
SERVICE, -- Service Type [SERCODE]
SERVICEID, -- Serv. Provider [SERVICE_PROV]
SRVPRVREF, -- SP reference no [SRVPRVREF]
SERVPROV_PAY, -- Payment Class [SERVPROV_PAY]
SPARTE, -- Division [SPARTE]
STARTOBJTYPE, -- Object Type [SWO_OBJTYP]
STARTOBJKEY, -- Document number [DOCUMENTKEY]
ENDOBJTYPE, -- Object Type [SWO_OBJTYP]
ENDOBJKEY, -- Document number [DOCUMENTKEY]
ERDAT, -- Created On [ERDAT]
ERNAM, -- Created By [ERNAM]
AEDAT, -- Changed On [AEDAT]
AENAM, -- Changed By [AENAM]
BEGRU, -- AuthorizGroup [BEGRU]
LOEVM, -- Delete [LOEVM]
PREV_SERV_START, -- Start date PoDS [SERVICE_START]
PREV_SERV_END, -- End date PoDS [SERVICE_END]
PRIMARY KEY (MANDT, VERTRAG)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA