I_StRpTaxReturnBoxCube

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_StRpTaxReturnBoxCube.
-- 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: ISRTAXRETURNBOXC
-- Parameters: P_TaxIsDeferredRelevant : figen_deferred_check, P_TaxIsMossRelevant : figen_moss_check, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_TaxBoxConfiguration : figen_tdt_taxbox_config

CREATE VIEW I_StRpTaxReturnBoxCube AS
SELECT
  P_StRpCalTaxReturnBox.CompanyCode AS CompanyCode,
  P_StRpCalTaxReturnBox.AccountingDocument AS AccountingDocument,
  P_StRpCalTaxReturnBox.FiscalYear AS FiscalYear,
  P_StRpCalTaxReturnBox.TaxItem AS TaxItem,
  P_StRpCalTaxReturnBox.TransactionTypeDetermination AS TransactionTypeDetermination,
  P_StRpCalTaxReturnBox.DebitCreditCode AS DebitCreditCode,
  P_StRpCalTaxReturnBox.AccountingDocumentType AS AccountingDocumentType,
  cast( P_StRpCalTaxReturnBox.SupplierAccountGroup as farp_supplier_account_group ) AS SupplierAccountGroup,
  P_StRpCalTaxReturnBox.TaxBox AS TaxBox,
  P_StRpCalTaxReturnBox.TaxDeclnAmountType AS TaxDeclnAmountType,
  P_StRpCalTaxReturnBox.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  P_StRpCalTaxReturnBox.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  P_StRpCalTaxReturnBox.TaxGroup AS TaxGroup,
  P_StRpCalTaxReturnBox.TaxItemGrpgDebitCreditCode AS TaxItemGrpgDebitCreditCode,
  cast( P_StRpCalTaxReturnBox.TaxItemGrpgAcctgDocumentType as glo_tax_item_grpg_acc_doc_type ) AS TaxItemGrpgAcctgDocumentType,
  cast( P_StRpCalTaxReturnBox.TaxItemGrpgSupplierAcctGroup as glo_tax_itm_grpg_suplr_acc_grp ) AS TaxItemGrpgSupplierAcctGroup,
  P_StRpCalTaxReturnBox.TaxItemGrpgSpecialGLCode AS TaxItemGrpgSpecialGLCode,
  P_StRpCalTaxReturnBox.StatryRptgEntity AS StatryRptgEntity,
  P_StRpCalTaxReturnBox.StatryRptCategory AS StatryRptCategory,
  P_StRpCalTaxReturnBox.StatryRptRunID AS StatryRptRunID,
  P_StRpCalTaxReturnBox.StatryRptRun AS StatryRptRun,
  P_StRpCalTaxReturnBox.ValidFrom AS ValidFrom,
  cast( P_StRpCalTaxReturnBox.Country as glo_country ) AS Country,
  P_StRpCalTaxReturnBox.TaxCode AS TaxCode,
  P_StRpCalTaxReturnBox.TaxItemGroupingVersion AS TaxItemGroupingVersion,
  P_StRpCalTaxReturnBox.TaxItemGroupingAccountNumber AS TaxItemGroupingAccountNumber,
  P_StRpCalTaxReturnBox.TaxBoxStructureType AS TaxBoxStructureType,
  ValidTo,
  TaxBoxStrucValidityEndDate,
  TaxCalculationProcedure,
  TaxRate,
  IPITaxRate,
  TaxCodeRatePointer,
  TaxRateValidityStartDate,
  Customer,
  GLAccount,
  TaxItemGroup,
  BusinessPlace,
  TaxJurisdiction,
  LowestLevelTaxJurisdiction,
  ReferenceDocumentType,
  AlternativeReferenceDocument,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  ConditionRecord,
  RoundingDecimalPlaces,
  DocumentReferenceID,
  Ledger,
  LedgerGroup,
  PostingDate,
  DocumentDate,
  TaxReportingDate,
  ReportingDate,
  TaxReportingDocumentDate,
  FiscalPeriod,
  OriginalFiscalPeriod,
  ExchangeRate,
  IsReversal,
  IsReversed,
  AccountingDocumentHeaderText,
  CompanyCodeCountry,
  cast( ReportingCountry as glo_tax_cntry_or_cocd_cntry ) AS ReportingCountry,
  TaxReturnCountry,
  CompanyCodeCurrency,
  CountryCurrency,
  DocumentCurrency,
  ReportingCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency1,
  TaxAmountInAdditionalCurrency2,
  DifferenceTaxAmtInCoCodeCrcy,
  DiffTaxBaseAmountInCoCodeCrcy,
  TotalGrossAmountInCoCodeCrcy,
  TotalGrossAmount,
  TotalGrossAmountInTransCrcy,
  TaxType,
  BPTaxNumber,
  ReportingVATRegistration,
  TaxNumber1,
  Country AS ShippingPointCountry,
  TargetTaxCode,
  TaxNumber2,
  ActiveTaxType,
  TaxNumber3,
  TaxIsDeferredRelevant,
  TaxIsMossRelevant,
  BusinessPartner,
  P_StRpCalTaxReturnBox.CAReconciliationKey AS CAReconciliationKey,
  NonDeductibleInputTaxAmount,
  DcblVATIncrdCostInRptgCrcy,
  BusinessPartnerName,
  BusinessPartnerCountry,
  TaxTypeName,
  CustomerSupplierAddress,
  TaxIsNotDeductible,
  SenderCompanyCode,
  SenderAccountingDocument,
  SenderFiscalYear,
  BalanceAmountInTransacCurrency,
  TaxBoxStructure,
  cast( TaxBoxStructureName as taxboxsname ) AS TaxBoxStructureName,
  TaxBoxName,
  TaxBoxCondition,
  TaxBoxAggregationOperation,
  TaxGroupOperation,
  ConditionType,
  IsNegativePosting,
  TaxCountry,
  TaxCntryOrCompanyCodeCntry,
  TaxGroupFreeClassification,
  _JournalEntry.TaxFulfillmentDate AS TaxFulfillmentDate,
  _JournalEntry.JrnlEntryCntrySpecificRef4 AS JrnlEntryCntrySpecificRef4,
  _JournalEntry.JrnlEntryCntrySpecificRef5 AS JrnlEntryCntrySpecificRef5
FROM P_StRpCalTaxReturnBox
;