I_EDCPURCHASEORDERRECORDS

CDS View
15 Fields 1 CDS Views

EDC Relevant Purchase Order Records

I_EDCPURCHASEORDERRECORDS is a CDS View in S/4HANA. EDC Relevant Purchase Order Records. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EDCPurchaseOrderTaxAuthChk view_entity from BASIC Purchase Order Against Tax Authority Doc

Fields (15)

KeyField CDS FieldsUsed in Views
KEY EDCCommonKey EDCCommonKey 1
KEY EDCCompany EDCCompany 1
KEY EDCRecordUUID EDCRecordUUID 1
KEY EDCType EDCType 1
Customer Customer 1
EDCCreatedOnDateTime EDCCreatedOnDateTime 1
EDCRepresentationKey EDCRepresentationKey 1
EDCRepresentationType EDCRepresentationType 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderType PurchaseOrderType 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
Supplier Supplier 1
SupplyingPlant SupplyingPlant 1

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.

-- EDC Relevant Purchase Order Records
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EDCPURCHASEORDERRECORDS (
    EDCCOMMONKEY,
    EDCCOMPANY,
    EDCRECORDUUID,
    EDCTYPE,
    CUSTOMER,
    EDCCREATEDONDATETIME,
    EDCREPRESENTATIONKEY,
    EDCREPRESENTATIONTYPE,
    PURCHASEORDER,
    PURCHASEORDERDATE,
    PURCHASEORDERTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    SUPPLIER,
    SUPPLYINGPLANT,
    PRIMARY KEY (EDCCOMMONKEY, EDCCOMPANY, EDCRECORDUUID, EDCTYPE)
);

Learn More