EDOTRIC

Transparent Table Application Table
18 Fields 3 CDS Views

eDocument Turkey: Incoming Invoice Identifiers

EDOTRIC is an SAP database table in S/4HANA. eDocument Turkey: Incoming Invoice Identifiers. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_TR_ElectronicDocIncgInvoice view from BASIC eDocument Turkey incoming scenario
I_TR_IncomingInvoiceIdentifier view from BASIC Incoming eInvoices
R_TR_EDocIncgInvoiceIdentifier view_entity from BASIC eDocument TR Incoming Invoice Identifier

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY edoc_guid edoc_guid eDocument GUID
inv_uuid edoc_tr_inv_uuid Turkey Invoice UUI
fit_tra_id edoc_tr_tra_id Invoice ID
identifier edoc_tr_identifier Alias
vkn_tckn edoc_tr_kn VKN/TCKN
app_sta edoc_tr_appres_status Acceptance
app_envelope_id edoc_tr_envelope_id Envelope ID
rej_reason edoc_tr_rejtxt Rejection Reason
rec_tmstmp edoc_tr_receivedtimestamp Time Received
supplier edoc_tr_supplier Supplier
net_amount edoc_tr_net_amount Tax-Exclusive Amount
tax_amount edoc_tr_tax_amount Tax Amount
gross_amount edoc_tr_gross_amount Tax-Inclusive Amount
currency waers Currency
supplier_name edoc_tr_supplier_name Supplier Name
cancelreason edoc_tr_canc_reasn Cancel Reasn
canclreasncode edoc_tr_canc_reasn_cod Cancel Reason Code

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 Turkey: Incoming Invoice Identifiers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDOTRIC (
    MANDT,            -- Client [mandt]
    EDOC_GUID,        -- eDocument GUID [edoc_guid]
    INV_UUID,         -- Turkey Invoice UUI [edoc_tr_inv_uuid]
    FIT_TRA_ID,       -- Invoice ID [edoc_tr_tra_id]
    IDENTIFIER,       -- Alias [edoc_tr_identifier]
    VKN_TCKN,         -- VKN/TCKN [edoc_tr_kn]
    APP_STA,          -- Acceptance [edoc_tr_appres_status]
    APP_ENVELOPE_ID,  -- Envelope ID [edoc_tr_envelope_id]
    REJ_REASON,       -- Rejection Reason [edoc_tr_rejtxt]
    REC_TMSTMP,       -- Time Received [edoc_tr_receivedtimestamp]
    SUPPLIER,         -- Supplier [edoc_tr_supplier]
    NET_AMOUNT,       -- Tax-Exclusive Amount [edoc_tr_net_amount]
    TAX_AMOUNT,       -- Tax Amount [edoc_tr_tax_amount]
    GROSS_AMOUNT,     -- Tax-Inclusive Amount [edoc_tr_gross_amount]
    CURRENCY,         -- Currency [waers]
    SUPPLIER_NAME,    -- Supplier Name [edoc_tr_supplier_name]
    CANCELREASON,     -- Cancel Reasn [edoc_tr_canc_reasn]
    CANCLREASNCODE,   -- Cancel Reason Code [edoc_tr_canc_reasn_cod]
    PRIMARY KEY (MANDT, EDOC_GUID)
);

Learn More