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, P_StatryRptRefNmbrPrefixValue : idtw_ref_num_prefix

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,
  Cube.TaxItem AS TaxItem,
  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) key Cube.TaxBox AS TaxBox,
  add the key TaxBox as I_STRPTAXITEMBOXCUBE add it as key to improve performance (avoid to use DISTINCT) key Cube.TaxDeclnAmountType AS TaxDeclnAmountType,
  add the key TaxDeclnAmountType as I_STRPTAXITEMBOXCUBE add it as key to improve performance (avoid to use DISTINCT) key Cube.TransactionTypeDetermination AS TransactionTypeDetermination,
  add the key TransactionTypeDetermination as I_STRPTAXITEMBOXCUBE add it as key to improve performance (avoid to use DISTINCT) Cube.ReferenceDocumentType AS ReferenceDocumentType,
  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
;