I_EDCSUPPLIERINVOICERECORDS

CDS View

EDC Supplier Invoice Records

I_EDCSUPPLIERINVOICERECORDS is a CDS View in S/4HANA. EDC Supplier Invoice Records. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EDCSupplierInvoiceTaxAuthChk view_entity from BASIC EDC Supplier Inv Against Tax Authority

Fields (17)

KeyField CDS FieldsUsed in Views
KEY EDCCommonKey EDCCommonKey 1
KEY EDCCompany EDCCompany 1
KEY EDCRecordUUID EDCRecordUUID 1
KEY EDCType EDCType 1
AccountingDocumentType AccountingDocumentType 1
BusinessArea BusinessArea 1
DocumentDate DocumentDate 1
EDCCreatedOnDateTime EDCCreatedOnDateTime 1
EDCRepresentationKey EDCRepresentationKey 1
EDCRepresentationType EDCRepresentationType 1
FiscalYear FiscalYear 1
InvoicingParty InvoicingParty 1
PostingDate PostingDate 1
ReverseDocument ReverseDocument 1
SupplierInvoice SupplierInvoice 1
SupplierInvoiceIDByInvcgParty SupplierInvoiceIDByInvcgParty 1
TaxFulfillmentDate TaxFulfillmentDate 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 Supplier Invoice Records
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EDCSUPPLIERINVOICERECORDS (
    EDCCOMMONKEY,
    EDCCOMPANY,
    EDCRECORDUUID,
    EDCTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSAREA,
    DOCUMENTDATE,
    EDCCREATEDONDATETIME,
    EDCREPRESENTATIONKEY,
    EDCREPRESENTATIONTYPE,
    FISCALYEAR,
    INVOICINGPARTY,
    POSTINGDATE,
    REVERSEDOCUMENT,
    SUPPLIERINVOICE,
    SUPPLIERINVOICEIDBYINVCGPARTY,
    TAXFULFILLMENTDATE,
    PRIMARY KEY (EDCCOMMONKEY, EDCCOMPANY, EDCRECORDUUID, EDCTYPE)
);