EDOTREREG
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_TR_ElectronicDocExpInvoice | view_entity | from | BASIC | eDocument TR Export Registration data |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA