I_SG_StRpTaxItemCube

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_SG_StRpTaxItemCube.
-- 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: ISGSRTAXITEMCUBE
-- Parameters: P_RelevantAmountPosition : relevantamountposition, P_Language : sylangu

CREATE VIEW I_SG_StRpTaxItemCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  I_StRpTaxItemBoxCube.TaxItem AS TaxItem,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  I_StRpTaxItemBoxCube._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  ValidFrom,
  TaxBoxStructureType,
  TaxGroup,
  ReportingDate,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxItemGroup,
  FiscalPeriod,
  AccountingDocumentType,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  BusinessPartnerCountry,
  ExchangeRate,
  cast( TaxRate as btaux ) AS TaxRate,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  I_StRpTaxItemBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  cast(TaxNumber1 as stcd1) AS TaxNumber1,
  cast(TaxNumber2 as stcd2) AS TaxNumber2,
  cast(TaxNumber3 as stcd3) AS TaxNumber3,
  cast(BusinessPartner as abi_bprtnr) AS BusinessPartner,
  cast(BusinessPartnerName as glo_partner) AS BusinessPartnerName,
  CustomerSupplierAddress,
  TaxType,
  CompanyCodeCurrency,
  I_StRpTaxItemBoxCube.CountryCurrency AS CountryCurrency,
  DocumentCurrency,
  case $parameters.P_RelevantAmountPosition when '2' then AdditionalCurrency1 when '3' then AdditionalCurrency2 when 'C' then I_StRpTaxItemBoxCube.CountryCurrency else I_StRpTaxItemBoxCube.ReportingCurrency end as ReportingCurrency AS ReportingCurrencyendasReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  cast( AmountInTransactionCurrency as fis_wsl) AS AmountInTransactionCurrency,
  cast ( TaxBaseAmountInCoCodeCrcy as hwbas_bses ) AS TaxBaseAmountInCoCodeCrcy,
  cast ( TaxAmountInCoCodeCrcy as hwste) AS TaxAmountInCoCodeCrcy,
  cast( TaxBaseAmountInTransCrcy as fwbas_bses ) AS TaxBaseAmountInTransCrcy,
  cast( TaxAmount as fwste ) AS TaxAmount,
  cast( TaxBaseAmountInRptgCrcy as glo_taxbase_amount_rptg_crcy) AS TaxBaseAmountInRptgCrcy,
  cast( TaxAmountInRptgCrcy as glo_tax_amount_rptg_crcy ) AS TaxAmountInRptgCrcy,
  cast (AmountInAdditionalCurrency1 as dmbe2_farp ) AS AmountInAdditionalCurrency1,
  cast(AmountInAdditionalCurrency2 as dmbe3_farp) AS AmountInAdditionalCurrency2,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  ' ' AS DocumentItemText,
  I_StRpTaxItemBoxCube._TaxCalculationProcedure AS _TaxCalculationProcedure
FROM I_StRpTaxItemBoxCube
LEFT OUTER JOIN I_Country ON /* join condition not captured in parsed metadata */
;