EDOTREREG

Transparent Table Application Table

eDocument Turkey: Export Registration data

EDOTREREG is an SAP database table in S/4HANA. eDocument Turkey: Export Registration data. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_TR_ElectronicDocExpInvoice view_entity from BASIC eDocument TR Export Registration data

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY edoc_guid edoc_guid eDocument GUID
uuid edoc_tr_inv_uuid Turkey Invoice UUI
fit_envelope_id edoc_tr_envelope_id Envelope ID
fit_tra_id edoc_tr_tra_id Invoice ID
identifier edoc_tr_identifier Alias
vkn_tckn edoc_tr_kn VKN/TCKN
trefnum edoc_tr_trefnum GTB Ref. Number
cxdrnum edoc_tr_cxdrnum Cus.Dec.Reg.No.
reldat edoc_tr_reldat Real Exp. Date
customer kunwe Ship-to Party
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
ship_to_party_name edoc_tr_ship_to_party_name Ship-to Party 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: Export Registration data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDOTREREG (
    MANDT,               -- Client [mandt]
    EDOC_GUID,           -- eDocument GUID [edoc_guid]
    UUID,                -- Turkey Invoice UUI [edoc_tr_inv_uuid]
    FIT_ENVELOPE_ID,     -- Envelope ID [edoc_tr_envelope_id]
    FIT_TRA_ID,          -- Invoice ID [edoc_tr_tra_id]
    IDENTIFIER,          -- Alias [edoc_tr_identifier]
    VKN_TCKN,            -- VKN/TCKN [edoc_tr_kn]
    TREFNUM,             -- GTB Ref. Number [edoc_tr_trefnum]
    CXDRNUM,             -- Cus.Dec.Reg.No. [edoc_tr_cxdrnum]
    RELDAT,              -- Real Exp. Date [edoc_tr_reldat]
    CUSTOMER,            -- Ship-to Party [kunwe]
    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]
    SHIP_TO_PARTY_NAME,  -- Ship-to Party Name [edoc_tr_ship_to_party_name]
    CANCELREASON,        -- Cancel Reasn [edoc_tr_canc_reasn]
    CANCLREASNCODE,      -- Cancel Reason Code [edoc_tr_canc_reasn_cod]
    PRIMARY KEY (MANDT, EDOC_GUID)
);