C_TW_TaxItemQuery

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 C_TW_TaxItemQuery.
-- 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.
-- SQL view name: CTWTAXITEMQUERY
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_StatryRptRunType : srf_report_run_type

CREATE VIEW C_TW_TaxItemQuery AS
SELECT
  Cube.CompanyCode AS CompanyCode,
  Cube.BusinessPlace AS BusinessPlace,
  cast(Cube.AccountingDocumentClass as idtw_formatcode) AS AccountingDocumentClass,
  Cube.AccountingDocument AS AccountingDocument,
  Cube.TaxCode AS TaxCode,
  cast(Cube.TaiwaneseCalendarYear as idtw_year) AS TaiwaneseCalendarYear,
  Cube.DebitCreditCode AS DebitCreditCode,
  add the key TaxGroup as I_STRPTAXITEMBOXCUBE add it as key to improve performance (avoid to use DISTINCT) Cube.ReferenceDocumentType AS ReferenceDocumentType,
  Cube.AssignmentReference AS AssignmentReference,
  Cube.JrnlEntryCntrySpecificRef1 AS JrnlEntryCntrySpecificRef1,
  Cube.JrnlEntryCntrySpecificRef2 AS JrnlEntryCntrySpecificRef2,
  Cube.JrnlEntryCntrySpecificRef3 AS JrnlEntryCntrySpecificRef3,
  Cube.ReportingDate AS ReportingDate,
  Cube.DocumentDate AS DocumentDate,
  cast(Cube.SourceReferenceDocument as idtw_xblnr) AS SourceReferenceDocument,
  Cube.PostingDate AS PostingDate,
  Cube.Supplier AS Supplier,
  Cube.SupplierCountry AS SupplierCountry,
  Cube.Customer AS Customer,
  Cube.CustomerCountry AS CustomerCountry,
  Cube.FiscalYear AS FiscalYear,
  Cube.BusinessPartner AS BusinessPartner,
  cast(Cube.DocumentReferenceID as fis_xblnr) AS DocumentReferenceID,
  's Logic Serial Number' Cube.SupplierTaxID2 AS SupplierTaxID2,
  cast(Cube.SequenceNumber as idtw_numbering) AS SequenceNumber,
  cast(Cube.FiscalPeriod as idtw_month) AS FiscalPeriod,
  cast(Cube.CustomerTaxID1 as idtw_buyerguid) AS CustomerTaxID1,
  cast(Cube.SupplierTaxID1 as idtw_sellergui) AS SupplierTaxID1,
  Cube.TaxRate AS TaxRate,
  Cube.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  Cube.TaxType AS TaxType,
  Cube.ControllingObjectType AS ControllingObjectType,
  cast(Cube.NmbrOfPages as idtw_numpg) AS NmbrOfPages,
  Cube.DeductionType AS DeductionType,
  Cube.IndustrialTaxRateCategory AS IndustrialTaxRateCategory,
  cast(Cube.MultipleInvoiceType as idtw_remark) AS MultipleInvoiceType,
  Cube.GoodsAreCleared AS GoodsAreCleared,
  cast(Cube.IsMarkedForDeletion as idtw_mark_deleted) AS IsMarkedForDeletion,
  Cube.ReverseDocument AS ReverseDocument,
  Cube.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  cast(Cube.TaxBaseAmountInCoCodeCrcy as idtw_tax_base_amount) AS TaxBaseAmountInCoCodeCrcy,
  cast(Cube.GrossTaxAmount as idtw_gross_amount ) AS GrossTaxAmount,
  Cube.TW_EDocGvmntUniformInvcNumber AS TW_EDocGvmntUniformInvcNumber,
  Cube.CompanyCodeCurrency AS CompanyCodeCurrency
FROM I_TW_TaxItemCube
;