EDOTWINV
eDocument Taiwan eInvoice
EDOTWINV is an SAP database table in S/4HANA. eDocument Taiwan eInvoice. It contains 16 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TW_EDocConsolidatedAcctgDoc | view_entity | from | BASIC | TW Edocument Consolidate Accounting Document |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | edoc_guid | EDOC_GUID | eDocument GUID | |||
| gui_number | EDOC_TW_GUI_NUMBER | GUI Number | ||||
| doc_class | DOCCLS | Doc.class | ||||
| customer | KUNNR | Customer | ||||
| tax_code | MWSKZ | Tax Code | ||||
| branch | J_1BBRANC_ | Business Place | ||||
| cancel_reason | EDOC_TW_CANCEL_REASON | Cancelation Reason | ||||
| cancel_type | EDOC_TW_CANCEL_TYPE | Cancelation Type | ||||
| return_tax_doc_no | EDOC_TW_RETURN_TAX_DOC_NO | Return Tax Doc. No. | ||||
| allowance_tp | EDOC_TW_ALLOWANCE_TYPE | Allowance Type | ||||
| random_number | EDOC_TW_RANDOM_NUMBER | Random Number | ||||
| carrier_tp | EDOC_TW_CARRIER_TYPE | Carrier Type | ||||
| carrier_id1 | EDOC_TW_CARRIER_ID | Carrier ID | ||||
| carrier_id2 | EDOC_TW_CARRIER_ID | Carrier ID | ||||
| npoban | EDOC_TW_NPOBAN | NPOBAN |
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 Taiwan eInvoice
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EDOTWINV (
MANDT, -- Client [MANDT]
EDOC_GUID, -- eDocument GUID [EDOC_GUID]
GUI_NUMBER, -- GUI Number [EDOC_TW_GUI_NUMBER]
DOC_CLASS, -- Doc.class [DOCCLS]
CUSTOMER, -- Customer [KUNNR]
TAX_CODE, -- Tax Code [MWSKZ]
BRANCH, -- Business Place [J_1BBRANC_]
CANCEL_REASON, -- Cancelation Reason [EDOC_TW_CANCEL_REASON]
CANCEL_TYPE, -- Cancelation Type [EDOC_TW_CANCEL_TYPE]
RETURN_TAX_DOC_NO, -- Return Tax Doc. No. [EDOC_TW_RETURN_TAX_DOC_NO]
ALLOWANCE_TP, -- Allowance Type [EDOC_TW_ALLOWANCE_TYPE]
RANDOM_NUMBER, -- Random Number [EDOC_TW_RANDOM_NUMBER]
CARRIER_TP, -- Carrier Type [EDOC_TW_CARRIER_TYPE]
CARRIER_ID1, -- Carrier ID [EDOC_TW_CARRIER_ID]
CARRIER_ID2, -- Carrier ID [EDOC_TW_CARRIER_ID]
NPOBAN, -- NPOBAN [EDOC_TW_NPOBAN]
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