I_TW_FixedAssetTaxCube

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_FixedAssetTaxCube.
-- 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: ITWFATAXCUBE
-- 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 I_TW_FixedAssetTaxCube AS
SELECT
  taxItem.AccountingDocument AS AccountingDocument,
  taxItem.CompanyCode AS CompanyCode,
  taxItem.FiscalYear AS FiscalYear,
  taxItem.TaxItemGroup AS TaxItemGroup,
  taxItem.AccountingDocumentItem AS AccountingDocumentItem,
  taxItem.TaxGroup AS TaxGroup,
  taxItem.TaiwaneseCalendarYear AS TaiwaneseCalendarYear,
  taxItem.FiscalPeriod AS FiscalPeriod,
  left(BusPlace.DistrictTaxOffice, 1) AS DistrictTaxOffice,
  left(BusPlace.TaxNumber1, 8) AS SupplierTaxID1,
  left(BusPlace.TaxNumber2, 9) AS SupplierTaxID2,
  taxItem.DocumentDate AS DocumentDate,
  taxItem.PostingDate AS PostingDate,
  taxItem.ReportingDate AS ReportingDate,
  left(taxItem.DocumentReferenceID, 14) AS DocumentReferenceID,
  taxItem.FixedAssetDescription AS FixedAssetDescription,
  cast(cast(taxItem.Quantity as abap.quan( 12, 0 )) as sstring) AS Quantity,
  taxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(taxItem.AmountInCompanyCodeCurrency as sstring) AS AmountInCompanyCodeCurrency,
  cast( cast( taxItem.AmountInCompanyCodeCurrency*TaxRate*(fltp_to_dec(0.01 as abap.dec(3,2))) as abap.curr(8, 3) ) as sstring) AS TaxAmountInCoCodeCrcy,
  taxItem.AssetAdditionalDescription AS AssetAdditionalDescription,
  taxItem.TaxAmount AS TaxAmount,
  taxItem.BusinessPlace AS BusinessPlace,
  taxItem.Supplier AS Supplier,
  taxItem.Customer AS Customer,
  taxItem.CustomerCountry AS CustomerCountry,
  taxItem.SupplierCountry AS SupplierCountry,
  taxItem.AccountingDocumentClass AS AccountingDocumentClass,
  taxItem.TaxCode AS TaxCode,
  taxItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  taxItem.TaxRate AS TaxRate
FROM I_FixedAssetTaxItem
INNER JOIN I_TW_TaxCode AS taxCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Branch AS BusPlace ON /* join condition not captured in parsed metadata */
;