P_HR_StRpTaxReturnBox

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 P_HR_StRpTaxReturnBox.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_TaxIsDeferredRelevant : figen_deferred_check, P_TaxIsMossRelevant : figen_moss_check, P_TaxBoxConfiguration : figen_tdt_taxbox_config, P_FromReportingDate : fis_period_date_from, P_ToReportingDate : fis_period_date_to, P_SequenceCategory : fiisvat_hr_seq_type, P_TaxBoxStructureType : fot_atr_tax_box_struct_type

CREATE VIEW P_HR_StRpTaxReturnBox AS
SELECT
  TaxReturn.CompanyCode AS CompanyCode,
  TaxReturn.AccountingDocument AS AccountingDocument,
  TaxReturn.FiscalYear AS FiscalYear,
  TaxReturn.TaxItem AS TaxItem,
  TaxReturn.StatryRptgEntity AS StatryRptgEntity,
  TaxReturn.StatryRptCategory AS StatryRptCategory,
  TaxReturn.StatryRptRunID AS StatryRptRunID,
  TaxReturn.TransactionTypeDetermination AS TransactionTypeDetermination,
  TaxReturn.TaxCode AS TaxCode,
  TaxReturn.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  TaxReturn.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  cast( coalesce( _TaxBoxStructure.TaxRateValidityEndDate, '' ) as fot_txdat_to ) AS TaxRateValidityEndDate,
  TaxReturn.DebitCreditCode AS DebitCreditCode,
  TaxReturn.AccountingDocumentType AS AccountingDocumentType,
  TaxReturn.TaxBox AS TaxBox,
  _CustomerVendorLineItem.AccountingDocumentItem AS AccountingDocumentItem,
  TaxReturn.TaxGroup AS TaxGroup,
  TaxReturn.Country AS Country,
  TaxReturn.TaxDeclnAmountType AS TaxDeclnAmountType,
  TaxReturn.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  TaxReturn.TaxItemGrpgSupplierAcctGroup AS TaxItemGrpgSupplierAcctGroup,
  TaxReturn.TaxItemGrpgAcctgDocumentType AS TaxItemGrpgAcctgDocumentType,
  TaxReturn.TaxItemGrpgDebitCreditCode AS TaxItemGrpgDebitCreditCode,
  TaxReturn.SupplierAccountGroup AS SupplierAccountGroup,
  TaxReturn.TaxItemGrpgSpecialGLCode AS TaxItemGrpgSpecialGLCode,
  TaxReturn.TaxBoxStructureType AS TaxBoxStructureType,
  TaxReturn.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  TaxReturn.TaxType AS TaxType,
  TaxReturn.TaxNumber2 AS TaxNumber2,
  TaxReturn.TaxCalculationProcedure AS TaxCalculationProcedure,
  _TaxItemSequence( P_SAPClient : $session.client, P_TaxIsDeferredRelevant : $parameters.P_TaxIsDeferredRelevant, P_TaxIsMossRelevant : $parameters.P_TaxIsMossRelevant, P_StatryRptgEntity : $parameters.P_StatryRptgEntity , P_StatryRptCategory : $parameters.P_StatryRptCategory, P_StatryRptRunID : $parameters.P_StatryRptRunID, P_ReportingCountry : $parameters.P_ReportingCountry, P_TaxBoxConfiguration : $parameters.P_TaxBoxConfiguration, P_SequenceCategory : $parameters.P_SequenceCategory, P_TaxBoxStructureType : $parameters.P_TaxBoxStructureType ).SequenceNumber as SetLineSequenceNumber AS SequenceNumberasSetLineSequenceNumber,
  TaxReturn.TaxReportingDate AS TaxReportingDate,
  TaxReturn.DocumentDate AS DocumentDate,
  TaxReturn.PostingDate AS PostingDate,
  TaxReturn.ReportingDate AS ReportingDate,
  TaxReturn.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  TaxReturn.ReportingCountry AS ReportingCountry,
  TaxReturn.TaxCntryOrCompanyCodeCntry AS TaxCntryOrCompanyCodeCntry,
  TaxReturn.Customer AS Customer,
  TaxReturn.BusinessPartnerName AS BusinessPartnerName,
  TaxReturn.TargetTaxCode AS TargetTaxCode,
  _CustomerVendorLineItem.ClearingDate AS ClearingDate,
  cast(coalesce(_DefTaxItem.TaxCode, '') as dzmwsk ) AS SourceTaxCode,
  cast(coalesce(_DefTaxItem.TransactionTypeDetermination, '') as fac_ktosl ) AS SrceTransTypeDetermination,
  cast (TaxReturn.CustomerSupplierAddress as wlf_partner_complete_address ) AS CompletePartnerAddress,
  TaxReturn.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  TaxReturn.DocumentReferenceID AS DocumentReferenceID,
  TaxReturn.Ledger AS Ledger,
  _DefTaxItem.AccountingDocument AS SourceReferenceDocument,
  _DefTaxItem.FiscalYear AS ReferenceDocumentFiscalYear,
  _DefTaxTransfer.TaxTransferDocument AS TaxTransferDocument,
  _DefTaxTransfer.TaxTransferDocumentYear AS TaxTransferDocumentYear,
  _DefTaxTransfer.PostingDate AS TaxTransferPostingDate,
  TaxReturn.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  TaxReturn._JournalEntry.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  TaxReturn._JournalEntry.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  TaxReturn.ReportingCurrency AS ReportingCurrency,
  TaxReturn.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  TaxReturn.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  TaxReturn.AmountInReportingCurrency AS AmountInReportingCurrency,
  cast( ( TaxReturn.AmountInReportingCurrency * -1 ) as fiisvat_hr_net_amount ) AS NetAmountInReportingCurrency,
  cast( (abs(TaxReturn.AmountInReportingCurrency)) as fiisvat_hr_positive_amount ) AS OpenAmountInReportingCurrency,
  TaxReturn.TotalGrossAmount AS TotalGrossAmount,
  TaxReturn.TaxIsDeferredRelevant AS TaxIsDeferredRelevant,
  TaxReturn.GLAccount AS GLAccount,
  TaxReturn.TaxJurisdiction AS TaxJurisdiction,
  TaxReturn.TaxCountry AS TaxCountry,
  TaxReturn.TaxItemGroup AS TaxItemGroup,
  TaxReturn.CompanyCodeCountry AS CompanyCodeCountry,
  TaxReturn.TaxGroupOperation AS TaxGroupOperation,
  TaxReturn.ReferenceDocumentType AS ReferenceDocumentType,
  TaxReturn.CAReconciliationKey AS CAReconciliationKey,
  TaxReturn.StatryRptRun AS StatryRptRun
FROM I_StRpTaxReturnBoxCube
LEFT OUTER JOIN P_HR_DefTaxItem AS _DefTaxItem ON TaxReturn.CompanyCode = _DefTaxItem.CompanyCode AND TaxReturn.AccountingDocument = _DefTaxItem.TaxTransferDocument AND TaxReturn.FiscalYear = _DefTaxItem.TaxTransferDocumentYear AND _DefTaxItem.ClearingAccountingDocument is not initial AND _DefTaxItem.CAReversalDocumentNumber is initial  -- association [0..1]
LEFT OUTER JOIN P_HR_DefTaxItem AS _DefTaxTransfer ON TaxReturn.CompanyCode = _DefTaxTransfer.CompanyCode AND TaxReturn.AccountingDocument = _DefTaxTransfer.AccountingDocument AND TaxReturn.FiscalYear = _DefTaxTransfer.FiscalYear AND _DefTaxTransfer.ClearingAccountingDocument is not initial AND _DefTaxTransfer.TaxTransferDocument <> 'VIRTUAL' AND _DefTaxTransfer.TaxTransferDocument is not initial AND _DefTaxTransfer.CAReversalDocumentNumber is initial  -- association [0..1]
LEFT OUTER JOIN P_HR_CUSTOMERVENDORLINEITEM AS _CustomerVendorLineItem ON _CustomerVendorLineItem.CompanyCode = CompanyCode AND _CustomerVendorLineItem.AccountingDocument = AccountingDocument AND _CustomerVendorLineItem.FiscalYear = FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_TaxBoxStructure2 AS _TaxBoxStructure ON _TaxBoxStructure.Country = Country AND _TaxBoxStructure.TaxBoxStructureType = TaxBoxStructureType AND _TaxBoxStructure.ValidFrom = TaxBoxStrucValidityStartDate AND _TaxBoxStructure.TaxGroup = TaxGroup AND _TaxBoxStructure.TaxCode = TaxCode AND _TaxBoxStructure.TransactionTypeDetermination = TransactionTypeDetermination AND _TaxBoxStructure.TaxBox = TaxBox  -- association [0..1]
LEFT OUTER JOIN P_HR_TaxItemSequence AS _TaxItemSequence ON _TaxItemSequence.CompanyCode = CompanyCode AND _TaxItemSequence.FiscalYear = FiscalYear AND _TaxItemSequence.AccountingDocument = AccountingDocument AND _TaxItemSequence.TaxItem = TaxItem AND _TaxItemSequence.TaxCode = TaxCode AND _TaxItemSequence.TransactionTypeDetermination = TransactionTypeDetermination  -- association [0..1]
;