EDOTRIC
eDocument Turkey: Incoming Invoice Identifiers
EDOTRIC is an SAP database table in S/4HANA. eDocument Turkey: Incoming Invoice Identifiers. It contains 18 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TR_ElectronicDocIncgInvoice | view | from | BASIC | eDocument Turkey incoming scenario |
| I_TR_IncomingInvoiceIdentifier | view | from | BASIC | Incoming eInvoices |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- 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