EORD

Transparent Table Application Table
27 Fields 6 CDS Views

Purchasing Source List

EORD is an SAP database table in S/4HANA. Purchasing Source List. It contains 27 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_MPPurchasingSource view from EXTENSION Extension View for Source List Header View
E_MPPurchasingSourceItem view from EXTENSION Extension View for Source List App
I_MPPurchasingSourceItem view from BASIC Source List Item
m_v_inforecord_sos view left_outer MM-PUR: CDS View for SOS
m_v_outline_agreement_sos view left_outer MM-PUR: CDS View for SOS
M_V_Outline_Agreement_Sos_B view left_outer MM-PUR: Basic CDS View for SOS

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY matnr matnr Material
KEY werks ewerk Plant
KEY zeord dzeord Number
erdat erdat Created On
ernam ernam Created By
vdatu ordab Valid From
bdatu ordbi Valid to
lifnr elifn Supplier
flifn flifn Fixed Supplier
ebeln evrtn Agreement
ebelp evrtp Item
febel febel Fixed Agmt Item
reswk bewrk Proc. Plant
fresw fresw Fixed iss.plant
ematn ematn MPN: Material
notkz ordsp Blocked
ekorg ekorg Purchasing Org.
vrtyp bstyp Doc. Category
eortp eortp Control
autet autet MRP
meins bstme Order Unit
logsy logsystem Logical System
sobkz sobkz Special Stock
srm_contract_id srm_contract_id Central Contract
srm_contract_itm srm_contract_item Cent. Contract Item
lastchangedatetime timestampl Time Stamp

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.

-- Purchasing Source List
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EORD (
    MANDT,               -- Client [mandt]
    MATNR,               -- Material [matnr]
    WERKS,               -- Plant [ewerk]
    ZEORD,               -- Number [dzeord]
    ERDAT,               -- Created On [erdat]
    ERNAM,               -- Created By [ernam]
    VDATU,               -- Valid From [ordab]
    BDATU,               -- Valid to [ordbi]
    LIFNR,               -- Supplier [elifn]
    FLIFN,               -- Fixed Supplier [flifn]
    EBELN,               -- Agreement [evrtn]
    EBELP,               -- Item [evrtp]
    FEBEL,               -- Fixed Agmt Item [febel]
    RESWK,               -- Proc. Plant [bewrk]
    FRESW,               -- Fixed iss.plant [fresw]
    EMATN,               -- MPN: Material [ematn]
    NOTKZ,               -- Blocked [ordsp]
    EKORG,               -- Purchasing Org. [ekorg]
    VRTYP,               -- Doc. Category [bstyp]
    EORTP,               -- Control [eortp]
    AUTET,               -- MRP [autet]
    MEINS,               -- Order Unit [bstme]
    LOGSY,               -- Logical System [logsystem]
    SOBKZ,               -- Special Stock [sobkz]
    SRM_CONTRACT_ID,     -- Central Contract [srm_contract_id]
    SRM_CONTRACT_ITM,    -- Cent. Contract Item [srm_contract_item]
    LASTCHANGEDATETIME,  -- Time Stamp [timestampl]
    PRIMARY KEY (MANDT, MATNR, WERKS, ZEORD)
);

Learn More