EDOTRINV
eDocument Turkey: Invoice Identifiers
EDOTRINV is an SAP database table in S/4HANA. eDocument Turkey: Invoice Identifiers. It contains 16 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TR_ElectronicDocOutgInvoice | view | from | BASIC | eDocument TR Invoice outgoing scenario |
| P_TR_ElectronicDocOutgInvoice | view | from | BASIC |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | edoc_guid | EDOC_GUID | eDocument GUID | |||
| fit_envelope_id | EDOC_TR_ENVELOPE_ID | Envelope ID | ||||
| fit_tra_id | EDOC_TR_TRA_ID | Invoice ID | ||||
| uuid | EDOC_TR_INV_UUID | Turkey Invoice UUI | ||||
| identifier | EDOC_TR_IDENTIFIER | Alias | ||||
| vkn_tckn | EDOC_TR_KN | VKN/TCKN | ||||
| fit_invoice_id | EDOC_TR_OBSOLETE | Obsolete | ||||
| business_partner | EDOC_TR_BUSINESS_PARTNER | Business Partner | ||||
| 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 | ||||
| business_partner_name | EDOC_TR_BUSINESS_PARTNER_NAME | Bus. Partner 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: Invoice Identifiers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDOTRINV (
MANDT, -- Client [MANDT]
EDOC_GUID, -- eDocument GUID [EDOC_GUID]
FIT_ENVELOPE_ID, -- Envelope ID [EDOC_TR_ENVELOPE_ID]
FIT_TRA_ID, -- Invoice ID [EDOC_TR_TRA_ID]
UUID, -- Turkey Invoice UUI [EDOC_TR_INV_UUID]
IDENTIFIER, -- Alias [EDOC_TR_IDENTIFIER]
VKN_TCKN, -- VKN/TCKN [EDOC_TR_KN]
FIT_INVOICE_ID, -- Obsolete [EDOC_TR_OBSOLETE]
BUSINESS_PARTNER, -- Business Partner [EDOC_TR_BUSINESS_PARTNER]
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]
BUSINESS_PARTNER_NAME, -- Bus. Partner Name [EDOC_TR_BUSINESS_PARTNER_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