EKES

Transparent Table Application Table
36 Fields 17 CDS Views

Supplier Confirmations

EKES is an SAP database table in S/4HANA. Supplier Confirmations. It contains 36 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
Arun_Conf_Lines view inner Supply Assignment confirmations
arun_i_so_reqmt view left_outer Sales Order selection in Normal mode
ARUN_I_SO_REQMT_PREV view left_outer Sales Order selection from Preview table
Arun_I_Sto_Reqmt view left_outer STO selection for Normal mode
ARUN_I_STO_REQMT_PREV view left_outer STO selection from Preview table
ARUN_SSD_BG view left_outer Get supply specific SO online
ARUN_SSD_PREV view left_outer Get supply specific SO preview
ARUN_SUP_SP_SO view left_outer Get supply specific SO online
ARun_ValAddedSrvcSuplrConfBsc view from
ARUNI_CONF_LINE view inner Confirmations selection at date level
c_purdoclistflndocbase view inner CONSUMPTION Follow on Document Base
I_PurgDocSupplierConfirmation view from BASIC Purchasing Document Confirmation
I_SupDmndInboundDelivBasic view from BASIC Basic View for Confirmations
m_v_m2s_pd_fd_b view inner CDS View for follow on indicator - base
pph_e_Mdla_1 view inner
PPH_E_MDRELA_1 view inner
rrp_e_GrOc view inner RRP: Retrieve Open Order Confirmation Quantities

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ebeln ebeln Purchasing Doc.
KEY ebelp ebelp Item
KEY etens etens Sequential No.
ebtyp ebtyp Confirm. Cat.
eindt bbein Delivery Date
lpein bblpe Delivery Date
uzeit bbuze Time
erdat bberd Created on
ezeit bbeze Creation Time
menge bbmng Quantity
dabmg dabmg Qty Reduced
estkz bbest Creation Ind.
loekz bbloe Deletion Ind.
kzdis kzdis MRP-Relevant
xblnr xblnr_long Reference
vbeln vbeln_vl Delivery
vbelp posnr_vl Item
mprof mprof Mfr Part Profile
ematn ematn MPN: Material
mahnz mahnz No. Rem./Exp.
charg charg_d Batch
uecha uecha HghLevItmBatch
imwrk imwrk In Plant
vbeln_st vbeln_vl Delivery
vbelp_st posnr_vl Item
handoverdate handover_date Handover Date
handovertime handover_time Handover Time
sgt_scat sgt_scat Stock Segment
msgtstmp edi_utc_timestamp UTC Timestamp
serviceperformer serviceperformer Service Performer
expected_value commitment Expected Value
supplier_conf_no mmpur_supplierconfno Confirmation
supplier_conf_item mmpur_supplierconfitem Confirmation Item
supplier_conf_line mmpur_supplierconfline Confirmation Line
_dataaging data_temperature Data Aging

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.

-- Supplier Confirmations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EKES (
    MANDT,               -- Client [mandt]
    EBELN,               -- Purchasing Doc. [ebeln]
    EBELP,               -- Item [ebelp]
    ETENS,               -- Sequential No. [etens]
    EBTYP,               -- Confirm. Cat. [ebtyp]
    EINDT,               -- Delivery Date [bbein]
    LPEIN,               -- Delivery Date [bblpe]
    UZEIT,               -- Time [bbuze]
    ERDAT,               -- Created on [bberd]
    EZEIT,               -- Creation Time [bbeze]
    MENGE,               -- Quantity [bbmng]
    DABMG,               -- Qty Reduced [dabmg]
    ESTKZ,               -- Creation Ind. [bbest]
    LOEKZ,               -- Deletion Ind. [bbloe]
    KZDIS,               -- MRP-Relevant [kzdis]
    XBLNR,               -- Reference [xblnr_long]
    VBELN,               -- Delivery [vbeln_vl]
    VBELP,               -- Item [posnr_vl]
    MPROF,               -- Mfr Part Profile [mprof]
    EMATN,               -- MPN: Material [ematn]
    MAHNZ,               -- No. Rem./Exp. [mahnz]
    CHARG,               -- Batch [charg_d]
    UECHA,               -- HghLevItmBatch [uecha]
    IMWRK,               -- In Plant [imwrk]
    VBELN_ST,            -- Delivery [vbeln_vl]
    VBELP_ST,            -- Item [posnr_vl]
    HANDOVERDATE,        -- Handover Date [handover_date]
    HANDOVERTIME,        -- Handover Time [handover_time]
    SGT_SCAT,            -- Stock Segment [sgt_scat]
    MSGTSTMP,            -- UTC Timestamp [edi_utc_timestamp]
    SERVICEPERFORMER,    -- Service Performer [serviceperformer]
    EXPECTED_VALUE,      -- Expected Value [commitment]
    SUPPLIER_CONF_NO,    -- Confirmation [mmpur_supplierconfno]
    SUPPLIER_CONF_ITEM,  -- Confirmation Item [mmpur_supplierconfitem]
    SUPPLIER_CONF_LINE,  -- Confirmation Line [mmpur_supplierconfline]
    _DATAAGING,          -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, EBELN, EBELP, ETENS)
);

Learn More