IDTW_ZEROEXP_TAX
Zero Tax for Taiwan Export
IDTW_ZEROEXP_TAX is an SAP database table in S/4HANA. Zero Tax for Taiwan Export. It contains 18 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_TW_ZeroTaxItem | view_entity | from | BASIC | Zero Tax for Taiwan Export on header level |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | belnr | BELNR_D | Document Number | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | gjahr | GJAHR | Fiscal Year | |||
| exp_type | IDTW_EXPORT_TYPE | Export Type | ||||
| cust_approach | IDTW_CUSTOM_APPROACH | Customs Clearance | ||||
| exp_mode | IDTW_EXPORT_MODE | Export Mode | ||||
| cust_doc_no | IDTW_CUSTOM_DOC | Doc. No. via Customs | ||||
| not_cust_doc | IDTW_NO_CUSTOM_DOC | Doc. not via Customs | ||||
| comments | abap.strg | |||||
| exp_date | IDTW_EXPORT_DATE | Export Date | ||||
| exchange_rate | UKURS_CURR | Exchange Rate | ||||
| export_amount | IDTW_EXPORT_AMOUNT | Declaration Amount | ||||
| idtw_ext1 | IDTW_EXT1 | Extension Field 1 | ||||
| idtw_ext2 | IDTW_EXT2 | Extension Field 2 | ||||
| idtw_ext3 | IDTW_EXT3 | Extension Field 3 | ||||
| idtw_ext4 | IDTW_EXT4 | Extension Field 4 | ||||
| idtw_ext5 | IDTW_EXT5 | Extension Field 5 |
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.
-- Zero Tax for Taiwan Export
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IDTW_ZEROEXP_TAX (
MANDT, -- Client [MANDT]
BELNR, -- Document Number [BELNR_D]
BUKRS, -- Company Code [BUKRS]
GJAHR, -- Fiscal Year [GJAHR]
EXP_TYPE, -- Export Type [IDTW_EXPORT_TYPE]
CUST_APPROACH, -- Customs Clearance [IDTW_CUSTOM_APPROACH]
EXP_MODE, -- Export Mode [IDTW_EXPORT_MODE]
CUST_DOC_NO, -- Doc. No. via Customs [IDTW_CUSTOM_DOC]
NOT_CUST_DOC, -- Doc. not via Customs [IDTW_NO_CUSTOM_DOC]
COMMENTS, -- abap.strg
EXP_DATE, -- Export Date [IDTW_EXPORT_DATE]
EXCHANGE_RATE, -- Exchange Rate [UKURS_CURR]
EXPORT_AMOUNT, -- Declaration Amount [IDTW_EXPORT_AMOUNT]
IDTW_EXT1, -- Extension Field 1 [IDTW_EXT1]
IDTW_EXT2, -- Extension Field 2 [IDTW_EXT2]
IDTW_EXT3, -- Extension Field 3 [IDTW_EXT3]
IDTW_EXT4, -- Extension Field 4 [IDTW_EXT4]
IDTW_EXT5, -- Extension Field 5 [IDTW_EXT5]
PRIMARY KEY (MANDT, BELNR, BUKRS, GJAHR)
);
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