I_RS_StRpWithholdingTaxItemC

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

CREATE VIEW I_RS_StRpWithholdingTaxItemC AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  WithholdingTaxType,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  PostingDate,
  ClearingDate,
  IsReversed,
  IsReversal,
  ReportingCurrency,
  BusinessPartner,
  BusinessPartnerCountry,
  WhldgTaxAmtInCoCodeCrcy,
  case BusinessPartnerCountry when 'RS' then WhldgTaxBaseAmtInCoCodeCrcy else cast(0 as abap.curr( 23, 2 )) end as WhldgTaxBaseAmtInCoCodeCrcy AS curr232endasWhldgTaxBaseAmtInCoCodeCrcy,
  _taxcode.WithholdingTaxPercent AS WithholdingTaxPercent,
  IsGrossingUp,
  WithholdingTaxIncomeType,
  WhldgTaxDocumentType,
  wht.SupplierRecipientType AS SupplierRecipientType,
  concat_with_space(wht._Supplier.BusinessPartnerName1,concat_with_space(wht._Supplier.BusinessPartnerName2,concat_with_space(wht._Supplier.BusinessPartnerName3,wht._Supplier.BusinessPartnerName4,1),1),1) AS SupplierFullName
FROM I_StRpWhldgTaxItem AS wht
LEFT OUTER JOIN I_Extendedwhldgtaxcode AS _taxcode ON _taxcode.Country = wht.Country AND _taxcode.WithholdingTaxType = wht.WithholdingTaxType AND _taxcode.WithholdingTaxCode = wht.WithholdingTaxCode  -- association [0..1]
LEFT OUTER JOIN I_Businesspartnerwhldgtax AS lfbw ON lfbw.CompanyCode = wht.CompanyCode AND lfbw.WithholdingTaxType = wht.WithholdingTaxType AND lfbw.Supplier = wht.Creditor  -- association [0..1]
LEFT OUTER JOIN I_WhldgTaxCountryCategory AS _revcode ON _revcode.Country = 'RS' AND _revcode.WithholdingRevenueCountry = wht.BusinessPartnerCountry  -- association [0..1]
;