P_KZ_StRpWhldgTaxRepCorrItem

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_KZ_StRpWhldgTaxRepCorrItem.
-- 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

CREATE VIEW P_KZ_StRpWhldgTaxRepCorrItem AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wht.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  _StRpRptdJournalEntry.StatryRptRunStatus AS Runstatus,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  wht.Country AS Country,
  wht.BusinessPartner AS BusinessPartner,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.TransactionCurrency AS TransactionCurrency,
  wht.WithholdingTaxPercent AS WithholdingTaxPercent,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  wht.Name AS Name,
  wht.PostingDate AS PostingDate,
  wht.ClearingDate AS ClearingDate,
  case when ( wht.WhldgTaxDocumentType = '002' or wht.WhldgTaxDocumentType = '007' ) and _WHTRptDateActive.WhldgTaxRptgDateIsActive = '' then wht.ClearingDate when ( wht.WhldgTaxDocumentType = '002' or wht.WhldgTaxDocumentType = '007' ) and _WHTRptDateActive.WhldgTaxRptgDateIsActive = 'X' then wht.WithholdingTaxReportingDate when ( wht.WhldgTaxDocumentType = '004' or wht.WhldgTaxDocumentType = '005' or wht.WhldgTaxDocumentType = '006' or wht.WhldgTaxDocumentType = '008' ) and _WHTRptDateActive.WhldgTaxRptgDateIsActive = '' then wht.PostingDate when ( wht.WhldgTaxDocumentType = '004' or wht.WhldgTaxDocumentType = '005' or wht.WhldgTaxDocumentType = '006' or wht.WhldgTaxDocumentType = '008' ) and _WHTRptDateActive.WhldgTaxRptgDateIsActive = 'X' then wht.WithholdingTaxReportingDate else wht.PostingDate end as ReportingDate AS PostingDateendasReportingDate,
  _WHTRptDateActive.WhldgTaxRptgDateIsActive AS MwtiIsActive,
  case when _WHTRptDateActive.WhldgTaxRptgDateIsActive = 'X' and wht.WithholdingTaxReportingDate is not initial then cast( substring(wht.WithholdingTaxReportingDate, 5, 2) as fins_fiscalperiod ) else wht.FiscalPeriod end as FiscalPeriod AS FiscalPeriodendasFiscalPeriod,
  wht.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  wht.ClearingJournalEntry AS ClearingJournalEntry,
  wht.ClearingItem AS ClearingItem,
  wht.WhldgTaxExmptCertificate AS WhldgTaxExmptCertificate,
  wht.WithholdingTaxExmptPercent AS WithholdingTaxExmptPercent,
  wht._OperationalAcctgDocItem.AssignmentReference AS AssignmentReference,
  wht.IsReversal AS IsReversal,
  wht.IsReversed AS IsReversed,
  wht.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  wht.FinancialAccountType AS FinancialAccountType,
  wht.InvoiceReference AS InvoiceReference,
  bp.type AS BusinessPartnerType,
  _WithholdingTaxCode.WithholdingTaxPercent AS Extendedwtaxrate,
  wtax.WithholdingTaxExmptPercent AS Wtax_exempercent
FROM P_StRpWhldgTaxItem AS wht
LEFT OUTER JOIN P_StRpWhldgTaxItem AS invdoc ON invdoc.CompanyCode = wht.CompanyCode AND invdoc.AccountingDocument = wht.InvoiceReference AND invdoc.FiscalYear = wht.InvoiceReferenceFiscalYear AND invdoc.AccountingDocumentItem = wht.InvoiceItemReference AND invdoc.WithholdingTaxType = wht.WithholdingTaxType  -- association [0..1]
LEFT OUTER JOIN P_StRpWhldgTaxItem AS paydoc ON paydoc.CompanyCode = wht.CompanyCode AND paydoc.AccountingDocument = wht.ClearingJournalEntry AND paydoc.FiscalYear = wht.ClearingJournalEntryFiscalYear AND paydoc.ClearingItem = wht.ClearingItem AND paydoc.WithholdingTaxType = wht.WithholdingTaxType  -- association [0..1]
LEFT OUTER JOIN I_WithholdingTaxReportingDate AS _WHTRptDateActive ON _WHTRptDateActive.CompanyCode = wht.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Extendedwhldgtaxcode AS _WithholdingTaxCode ON wht.Country = _WithholdingTaxCode.Country AND wht.WithholdingTaxType = _WithholdingTaxCode.WithholdingTaxType AND wht.WithholdingTaxCode = _WithholdingTaxCode.WithholdingTaxCode  -- association [0..1]
LEFT OUTER JOIN P_Withholdingtxtype AS _TaxType ON _TaxType.land1 = wht.Country AND _TaxType.witht = wht.WithholdingTaxType  -- association [0..1]
LEFT OUTER JOIN I_SupplierWithHoldingTax AS wtax ON wht.BusinessPartner = wtax.Supplier AND wht.CompanyCode = wtax.CompanyCode AND wht.WithholdingTaxType = wtax.WithholdingTaxType  -- association [0..1]
;