I_PH_TaxReturnItemGroupCube

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_PH_TaxReturnItemGroupCube.
-- 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: IPHSPTAXITEMTDT
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_Language : sylangu

CREATE VIEW I_PH_TaxReturnItemGroupCube AS
SELECT
  TaxItemBox.CompanyCode AS CompanyCode,
  AccountingDocument,
  FiscalYear,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxItemBox.TaxCode AS TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxDeclnAmountType,
  TaxBoxStructureType,
  TaxGroup,
  DebitCreditCode,
  AccountingDocumentType,
  SupplierAccountGroup,
  TaxBoxStrucValidityStartDate,
  UnifiedTaxBoxStructureType,
  TaxItemGrpgDebitCreditCode,
  TaxItemGrpgAcctgDocumentType,
  TaxItemGrpgSupplierAcctGroup,
  TaxItemGrpgSpecialGLCode,
  TaxBoxStrucValidityEndDate,
  TaxRateValidityStartDate,
  TaxItemBox.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  FiscalPeriod,
  TaxItemBox.ReportingDate AS ReportingDate,
  DocumentReferenceID,
  CompanyCodeCountry,
  ReportingCountry,
  TaxReturnCountry,
  BusinessPartnerCountry,
  ExchangeRate,
  cast( TaxRate as btaux ) AS TaxRate,
  GLAccount,
  AccountingDocumentHeaderText,
  TaxItemBox.BusinessPlace AS 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,
  cast(CustomerSupplierAddress as business_partner_address) AS CustomerSupplierAddress,
  TaxType,
  TargetTaxCode,
  ReportingCurrency,
  cast(AmountInReportingCurrency as glo_amount_rptg_crcy ) AS AmountInReportingCurrency,
  cast( TaxBaseAmountInRptgCrcy as glo_taxbase_amount_rptg_crcy ) AS TaxBaseAmountInRptgCrcy,
  cast( TaxAmountInRptgCrcy as glo_tax_amount_rptg_crcy) AS TaxAmountInRptgCrcy,
  I_PH_TaxBalanceGroupByIndustry.AlphanumericTaxCode AS AlphanumericTaxCode,
  I_PH_TaxBalanceGroupByIndustry._AlphanumericTxCodeText[1:Language = $parameters.P_Language].IndustryKeyText AS IndustryKeyText
FROM I_StRpTaxReturnBoxCube
;