EDOCHINVINC

Transparent Table Application Table
19 Fields 1 CDS Views

eDocument Switzerland: Incoming Invoice

EDOCHINVINC is an SAP database table in S/4HANA. eDocument Switzerland: Incoming Invoice. It contains 19 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_CH_ElectronicDocIncgInvoice view_entity from BASIC Switzerland Incoming Invoice

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY edoc_guid edoc_guid eDocument GUID
biller_id edoc_ch_biller_id Biller ID
ebill_accnt_id edoc_ch_ebill_account_id Recipient ID
transaction_id edoc_ch_transaction_id Transaction ID
document_id edoc_ch_document_id Document ID
customer_id edoc_ch_customer_id Recipient Cust. ID
company_name edoc_ch_company_name Biller Company
receiver_company_name edoc_ch_receiver_company_name Recipient Cust. Name
tax_id edoc_ch_tax_id Biller Tax ID
reference_value edoc_ch_reference_value Doc. Reference
iban edoc_ch_iban Biller IBAN
creditor_reference edoc_ch_creditor_reference QR/SCOR Reference
total_amount edoc_ch_total_amount_incl_tax Total Amount
total_tax edoc_ch_total_tax Total Tax
currency edoc_ch_currency Currency
document_type edoc_ch_document_type Document Type
payment_type edoc_ch_payment_type Payment Type
reconciliation_comment edoc_ch_reconciliation_comment Reconciliation Comm.

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 Switzerland: Incoming Invoice
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDOCHINVINC (
    MANDT,                   -- Client [mandt]
    EDOC_GUID,               -- eDocument GUID [edoc_guid]
    BILLER_ID,               -- Biller ID [edoc_ch_biller_id]
    EBILL_ACCNT_ID,          -- Recipient ID [edoc_ch_ebill_account_id]
    TRANSACTION_ID,          -- Transaction ID [edoc_ch_transaction_id]
    DOCUMENT_ID,             -- Document ID [edoc_ch_document_id]
    CUSTOMER_ID,             -- Recipient Cust. ID [edoc_ch_customer_id]
    COMPANY_NAME,            -- Biller Company [edoc_ch_company_name]
    RECEIVER_COMPANY_NAME,   -- Recipient Cust. Name [edoc_ch_receiver_company_name]
    TAX_ID,                  -- Biller Tax ID [edoc_ch_tax_id]
    REFERENCE_VALUE,         -- Doc. Reference [edoc_ch_reference_value]
    IBAN,                    -- Biller IBAN [edoc_ch_iban]
    CREDITOR_REFERENCE,      -- QR/SCOR Reference [edoc_ch_creditor_reference]
    TOTAL_AMOUNT,            -- Total Amount [edoc_ch_total_amount_incl_tax]
    TOTAL_TAX,               -- Total Tax [edoc_ch_total_tax]
    CURRENCY,                -- Currency [edoc_ch_currency]
    DOCUMENT_TYPE,           -- Document Type [edoc_ch_document_type]
    PAYMENT_TYPE,            -- Payment Type [edoc_ch_payment_type]
    RECONCILIATION_COMMENT,  -- Reconciliation Comm. [edoc_ch_reconciliation_comment]
    PRIMARY KEY (MANDT, EDOC_GUID)
);

Learn More