I_SG_StRpTaxReturnCube

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_StRpTaxReturnCube.
-- 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: ISGSRTAXRETURNC
-- Parameters: P_RelevantAmountPosition : relevantamountposition, P_Language : sylangu, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1

CREATE VIEW I_SG_StRpTaxReturnCube AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxItem,
  I_StRpTaxReturnBoxCube.TaxCode AS TaxCode,
  I_StRpTaxReturnBoxCube.TaxCalculationProcedure AS TaxCalculationProcedure,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxItemGroupingVersion,
  TaxBoxStrucValidityStartDate AS ValidityStartDate,
  TaxBoxStructureType,
  TaxGroup,
  AccountingDocumentType,
  ReportingDate,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  TaxItemGroup,
  FiscalPeriod,
  CAReconciliationKey,
  ReferenceDocumentType,
  StatryRptRun,
  AccountingDocumentHeaderText,
  DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  BusinessPartnerCountry,
  ExchangeRate,
  cast( TaxRate as btaux ) AS TaxRate,
  TaxRateValidityStartDate,
  GLAccount,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  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_StRpTaxReturnBoxCube.CountryCurrency AS CountryCurrency,
  DocumentCurrency,
  case $parameters.P_RelevantAmountPosition when '2' then AdditionalCurrency1 when '3' then AdditionalCurrency2 when 'C' then I_StRpTaxReturnBoxCube.CountryCurrency else I_StRpTaxReturnBoxCube.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
FROM I_StRpTaxReturnBoxCube
;