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 |
|---|---|---|---|---|
| I_TR_ElectronicDocExpInvoice | view | from | BASIC | eDocument Turkey Export Invoice |
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