C_CH_VATTaxItemCube

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_CH_VATTaxItemCube.
-- 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: CCHVATTXITEM

CREATE VIEW C_CH_VATTaxItemCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  cast ( TaxDeclnAmountType as taxbox_ot) AS TaxDeclnAmountType,
  I_StRpTaxItemBoxCube.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  I_StRpTaxItemBoxCube.ValidFrom AS ValidFrom,
  I_StRpTaxItemBoxCube.TaxBoxStructureType AS TaxBoxStructureType,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxItemGroup,
  FiscalPeriod,
  AccountingDocumentType,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  I_StRpTaxItemBoxCube.ReportingDate AS ReportingDate,
  ExchangeRate,
  cast(right(cast( I_StRpTaxItemBoxCube.TaxRate as char20 ), 10 ) as figen_taxrateinpercentastext ) AS TaxRateInPercentAsText,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  TaxCalculationProcedure,
  BusinessPartner,
  BusinessPartnerName,
  TaxType,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxIsNotDeductible,
  MiniOneStopShopTxRptgCntry,
  I_TaxGroup.TaxGroupExternalID AS TaxGroupExternalID
FROM I_StRpTaxItemBoxCube
LEFT OUTER JOIN I_TaxGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
;