I_EDCRELATION

CDS View

eDocument Consistency Relation Record

I_EDCRELATION is a CDS View in S/4HANA. eDocument Consistency Relation Record. It contains 7 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
I_EDCAccountingDocRelation view_entity from BASIC EDC Accounting Document Relation
I_EDCBillingDocumentRelation view_entity from BASIC EDC Billing Document Relation
I_EDCPurchaseDocumentRelation view_entity from BASIC EDC Purchase Document Relation
I_EDCSalesDocumentRelation view_entity from BASIC EDC Sales Order Doc Relation
I_EDCSupplierInvoiceRelation view_entity from BASIC EDC Supplier Invoice Relation
I_EDCTaxAuthDocRecords view_entity from BASIC EDC Tax Authority Document Records
I_ES_EDCElectronicDocRelation view_entity from COMPOSITE Spain eDoc and Source Doc Relationship
I_IN_EDocRets2Rltn view_entity from COMPOSITE GSTR2 EDocument Relation
I_IN_GSTR2BTaxAuthorityStatus view_entity from COMPOSITE Tax Authority 2B
I_IN_GSTRetsSalesRegRelation view_entity from COMPOSITE India GSTR Sales Register Relation
I_IN_Rets2EDocHdrRltn view_entity from COMPOSITE eDocument GSTR2 Header Relation
I_IN_Rets2TaxAuthDocHdrRltn view_entity from COMPOSITE Tax Auth Doc GSTR2 Header Relation
I_IN_TaxAuthDocEInvcHdrItmRltn view_entity from COMPOSITE Tax Auth Doc eInvc Header Item Relation
I_IN_TaxAuthDocEInvcHdrRltn view_entity from COMPOSITE Tax Auth Doc eInvoice Header Relation
I_IN_TxAuthRets2Rltn view_entity from COMPOSITE Relation tax authority hdr item aggrgn
I_KR_EDCTotOfIncgTxAuthTxItm view_entity from COMPOSITE KFC Aggrg of Incoming Tax Authority Tax Items
I_KR_EDCTotOfOutgTxAuthTxItm view_entity from COMPOSITE KFC Aggrg of Outgoing Tax Authority Tax Items
R_ES_EDCTaxAuthSIIExempt view_entity from COMPOSITE Spain SII Consistency Tax Authority Exempt items
R_ES_EDCTaxAuthSIINonTax view_entity from COMPOSITE Spain SII Tax Authority Non Taxable items
R_ES_EDCTaxAuthSIITaxable view_entity from COMPOSITE Spain SII Tax Auth Item for Taxable

Fields (7)

KeyField CDS FieldsUsed in Views
KEY EDCCompany CompanyCode,EDCCompany 17
KEY EDCRepresentationKey EDCRepresentationKey 17
KEY EDCRepresentationType EDCRepresentationType 20
KEY EDCType EDCType 19
EDCCommonKey EDCCommonKey 16
EDCCreatedOnDateTime EDCCreatedOnDateTime 10
EDCRecordUUID EDCRecordUUID 20

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.

-- eDocument Consistency Relation Record
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EDCRELATION (
    EDCCOMPANY,
    EDCREPRESENTATIONKEY,
    EDCREPRESENTATIONTYPE,
    EDCTYPE,
    EDCCOMMONKEY,
    EDCCREATEDONDATETIME,
    EDCRECORDUUID,
    PRIMARY KEY (EDCCOMPANY, EDCREPRESENTATIONKEY, EDCREPRESENTATIONTYPE, EDCTYPE)
);