I_TW_ZeroTaxItem

DDL: I_TW_ZEROTAXITEM Type: view_entity BASIC Package: GLO_FIN_IS_VAT_TW
18 Fields 1 Data Sources

Zero Tax for Taiwan Export on header level

I_TW_ZeroTaxItem is a Basic CDS View that provides data about "Zero Tax for Taiwan Export on header level" in SAP S/4HANA. It reads from 1 data source (idtw_zeroexp_tax) and exposes 18 fields with key fields AccountingDocument, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_VAT_TW.

Data Sources (1)

SourceAliasJoin Type
idtw_zeroexp_tax idtw_zeroexp_tax from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Zero Tax for Taiwan Export on header level view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument belnr SD Document
KEY CompanyCode bukrs Value
KEY FiscalYear gjahr Settlement Year
ZeroTaxRateDeclarationType exp_type Travel Exp.Type
GoodsAreCleared cust_approach Customs Clearance
ExportType exp_mode Export Mode
CustomsDocument cust_doc_no Doc. No. via Customs
TW_ExternalDocumentNumber not_cust_doc Doc. not via Customs
TW_ZeroTaxComment comments User Notes
ExportDate exp_date Export Date
ExportAmountInCompanyCodeCrcy Declaration Amount
Currency
TW_ZeroTaxExtensionField1 idtw_ext1 Extension Field 1
TW_ZeroTaxExtensionField2 idtw_ext2 Extension Field 2
TW_ZeroTaxExtensionField3 idtw_ext3 Extension Field 3
TW_ZeroTaxExtensionField4 idtw_ext4 Extension Field 4
TW_ZeroTaxExtensionField5 idtw_ext5 Extension Field 5
ZeroTaxIsAtItemLevel is_item_level Truth Value

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_TW_ZeroTaxItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_TW_ZeroTaxItem AS
SELECT
  belnr AS AccountingDocument,
  bukrs AS CompanyCode,
  gjahr AS FiscalYear,
  exp_type AS ZeroTaxRateDeclarationType,
  cust_approach AS GoodsAreCleared,
  exp_mode AS ExportType,
  cust_doc_no AS CustomsDocument,
  not_cust_doc AS TW_ExternalDocumentNumber,
  comments AS TW_ZeroTaxComment,
  exp_date AS ExportDate,
  cast( export_amount as abap.dec(12,0)) AS ExportAmountInCompanyCodeCrcy,
  cast('' as waers) AS Currency,
  idtw_ext1 AS TW_ZeroTaxExtensionField1,
  idtw_ext2 AS TW_ZeroTaxExtensionField2,
  idtw_ext3 AS TW_ZeroTaxExtensionField3,
  idtw_ext4 AS TW_ZeroTaxExtensionField4,
  idtw_ext5 AS TW_ZeroTaxExtensionField5,
  is_item_level AS ZeroTaxIsAtItemLevel
FROM idtw_zeroexp_tax
;

Learn More