P_HR_StRpTaxItem

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_StRpTaxItem.
-- 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_FromReportingDate : fis_period_date_from, P_ToReportingDate : fis_period_date_to

CREATE VIEW P_HR_StRpTaxItem AS
SELECT
  Item.CompanyCode AS CompanyCode,
  Item.AccountingDocument AS AccountingDocument,
  Item.FiscalYear AS FiscalYear,
  Item.TaxItem AS TaxItem,
  Item.TaxItemUUID AS TaxItemUUID,
  Item.TaxCode AS TaxCode,
  case when RefTaxCode.TargetTaxCode = '' then Item.ReportingDate when RefTaxCode.TargetTaxCode <> '' and _DefTaxItem.PostingDate is not initial and _DefTaxItem.PostingDate is not null then case when $parameters.P_FromReportingDate >= _DefTaxItem.PostingDate and $parameters.P_ToReportingDate <= _DefTaxItem.PostingDate then '00000000' else Item.ReportingDate end when RefTaxCode.TargetTaxCode <> '' and (_DefTaxItem.PostingDate is initial or _DefTaxItem.PostingDate is null ) then Item.ReportingDate end as ReportingDate AS ReportingDateendasReportingDate,
  RefTaxCode.TargetTaxCode AS TargetTaxCode,
  Item.TargetTaxCode AS ItemTargetTaxCode,
  Item.ReportingDate AS ItemReportingDate,
  Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  Item.DebitCreditCode AS DebitCreditCode,
  Item.DebitCreditCodeIsChanged AS DebitCreditCodeIsChanged,
  Item.TaxRate AS TaxRate,
  Item.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  Item.GLAccount AS GLAccount,
  Item.TaxItemGroup AS TaxItemGroup,
  Item.BusinessPlace AS BusinessPlace,
  Item.TaxJurisdiction AS TaxJurisdiction,
  Item.LowestLevelTaxJurisdiction AS LowestLevelTaxJurisdiction,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.ReferenceDocumentType AS ReferenceDocumentType,
  Item.AlternativeReferenceDocument AS AlternativeReferenceDocument,
  Item.ReverseDocument AS ReverseDocument,
  Item.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  Item.DocumentReferenceID AS DocumentReferenceID,
  Item.ConditionType AS ConditionType,
  Item.Ledger AS Ledger,
  Item.LedgerGroup AS LedgerGroup,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item.TaxReportingDate AS TaxReportingDate,
  Item.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  Item.TaxFulfillmentDate AS TaxFulfillmentDate,
  Item.FiscalPeriod AS FiscalPeriod,
  Item.ExchangeRate AS ExchangeRate,
  Item.IsReversal AS IsReversal,
  Item.IsReversed AS IsReversed,
  Item.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  Item.CompanyCodeCountry AS CompanyCodeCountry,
  Item.ReportingCountry AS ReportingCountry,
  Item.TaxReturnCountry AS TaxReturnCountry,
  Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.CountryCurrency AS CountryCurrency,
  Item.DocumentCurrency AS DocumentCurrency,
  Item.ClearingAccountingDocument AS ClearingAccountingDocument,
  Item.TaxType AS TaxType,
  Item.TaxCalculationProcedure AS TaxCalculationProcedure,
  Item.EUTaxClassification AS EUTaxClassification,
  Item.TaxCodeReturnCountry AS TaxCodeReturnCountry,
  Item.TaxNumber1 AS TaxNumber1,
  Item.TaxNumber2 AS TaxNumber2,
  Item.TaxNumber3 AS TaxNumber3,
  Item.TaxNumber4 AS TaxNumber4,
  Item.BusinessPartner AS BusinessPartner,
  Item.BusinessPartnerCountry AS BusinessPartnerCountry,
  Item.BusinessPartnerName AS BusinessPartnerName,
  Item.CustomerSupplierAddress AS CustomerSupplierAddress,
  Item.CustomerSupplierVATRegn AS CustomerSupplierVATRegn,
  Item.TaxIsNotDeductible AS TaxIsNotDeductible,
  Item.Supplier AS Supplier,
  Item.Customer AS Customer,
  Item.InterestDocFinAccountType AS InterestDocFinAccountType,
  Item.IsNegativePosting AS IsNegativePosting,
  Item.SupplierAccountGroup AS SupplierAccountGroup,
  Item.OriginalReferenceDocument AS OriginalReferenceDocument,
  Item.SenderLogicalSystem AS SenderLogicalSystem,
  Item.CAReconciliationKey AS CAReconciliationKey,
  Item.MiniOneStopShopTxRptgCntry AS MiniOneStopShopTxRptgCntry,
  Item.SenderCompanyCode AS SenderCompanyCode,
  Item.SenderAccountingDocument AS SenderAccountingDocument,
  Item.SenderFiscalYear AS SenderFiscalYear,
  Item.TaxCountry AS TaxCountry,
  Item.AccountingDocumentCategory AS AccountingDocumentCategory,
  Item.TaxDataSource AS TaxDataSource
FROM I_StRpTaxItem AS Item
INNER JOIN I_TaxCode AS RefTaxCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_HR_DefTaxItem AS _DefTaxItem ON Item.CompanyCode = _DefTaxItem.CompanyCode AND Item.AccountingDocument = _DefTaxItem.AccountingDocument AND Item.FiscalYear = _DefTaxItem.FiscalYear AND _DefTaxItem.ClearingAccountingDocument is not initial  -- association [0..1]
;