I_JP_StRpWhiteRetsWhldgTxItm

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_JP_StRpWhiteRetsWhldgTxItm.
-- 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_StartDate : datum, P_EndDate : datum

CREATE VIEW I_JP_StRpWhiteRetsWhldgTxItm AS
SELECT
  I_StRpWhldgTaxItem.CompanyCode AS CompanyCode,
  I_StRpWhldgTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpWhldgTaxItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_StRpWhldgTaxItem.FiscalYear AS FiscalYear,
  I_StRpWhldgTaxItem.WithholdingTaxType AS WithholdingTaxType,
  I_StRpWhldgTaxItem.WithholdingTaxCode AS WithholdingTaxCode,
  I_StRpWhldgTaxItem.StatryRptgEntity AS StatryRptgEntity,
  I_StRpWhldgTaxItem.StatryRptCategory AS StatryRptCategory,
  I_StRpWhldgTaxItem.StatryRptRunID AS StatryRptRunID,
  I_StRpWhldgTaxItem.ClearingJournalEntry AS ClearingJournalEntry,
  I_StRpWhldgTaxItem.PostingDate AS PostingDate,
  cast(I_StRpWhldgTaxItem.BusinessPartner as /scdl/dl_partyno) AS BusinessPartner,
  I_StRpWhldgTaxItem.ReportingCurrency AS ReportingCurrency,
  I_StRpWhldgTaxItem.TransactionCurrency AS TransactionCurrency,
  cast ( I_StRpWhldgTaxItem.WhldgTaxBaseAmtInCoCodeCrcy as fis_qsshh) AS WhldgTaxBaseAmtInCoCodeCrcy,
  cast (I_StRpWhldgTaxItem.WhldgTaxAmtInCoCodeCrcy as fis_qbshh) AS WhldgTaxAmtInCoCodeCrcy,
  cast (I_StRpWhldgTaxItem.WhldgTaxAmtInTransacCrcy as fis_qbshb) AS WhldgTaxAmtInTransacCrcy,
  cast (I_StRpWhldgTaxItem.WhldgTaxBaseAmtInTransacCrcy as fis_qsshb) AS WhldgTaxBaseAmtInTransacCrcy,
  cast (I_StRpWhldgTaxItem.WhldgTxDdctdNetAmtInTransCrcy as fiwt_net_amt) AS WhldgTxDdctdNetAmtInTransCrcy,
  I_StRpWhldgTaxItem.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  cast( left( I_StRpWhldgTaxItem._WithholdingTaxCode._CodeText[1:Language = $session.system_language].WhldgTaxCodeName, 20) as abap.char(20) ) AS WhldgTaxCodeName,
  I_StRpWhldgTaxItem._Supplier.Country AS BusinessPartnerCountry,
  I_StRpWhldgTaxItem._Supplier.AddressID AS AddressID,
  cast(I_StRpWhldgTaxItem.TaxNumber1 as stcd1) AS TaxNumber1,
  cast( coalesce(_LastVndrInvcPayt._InternationalAddrVersion.BusinessPartnerName1, I_StRpWhldgTaxItem.Name) as glo_partner ) as Name AS Nameasglo_partnerasName,
  cast(I_StRpWhldgTaxItem.Name as glo_partner) AS CustomerSupplierName,
  cast(I_StRpWhldgTaxItem.OrganizationBPName1 as bu_nameor1) AS OrganizationBPName1,
  cast( I_StRpWhldgTaxItem.StreetName as glo_partner_street ) AS CustomerSupplierStreetName,
  cast(I_StRpWhldgTaxItem.PostalCode as glo_partner_pocode) AS CustomerSupplierPostalCode,
  cast(I_StRpWhldgTaxItem.CityName as glo_partner_cityname) AS CustomerSupplierCityName,
  I_StRpWhldgTaxItem._Supplier._StandardAddress._Region._RegionText[1:Language = $session.system_language].RegionName AS SupplierRegionName,
  I_StRpWhldgTaxItem._Supplier._StandardAddress.StreetSuffixName AS StreetSuffixName,
  I_StRpWhldgTaxItem.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  I_StRpWhldgTaxItem._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_StRpWhldgTaxItem._CompanyCode.Country AS Country,
  I_StRpWhldgTaxItem._CompanyCode._Address._DefaultPhoneNumber.PhoneNumber AS PhoneNumber,
  I_StRpWhldgTaxItem._Supplier.SupplierLanguage AS Language,
  I_StRpWhldgTaxItem.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  I_StRpWhldgTaxItem.PostingDate AS PaymentDate,
  I_StRpWhldgTaxItem.DocumentItemText AS DocumentItemText,
  _LastVndrInvcPayt.NumberOfDocuments AS NumberOfDocuments,
  I_StRpWhldgTaxItem.DocumentReferenceID AS DocumentReferenceID,
  I_StRpWhldgTaxItem._Supplier.IsOneTimeAccount AS IsOneTimeAccount
FROM P_JP_StRpWithholdingTaxItem AS I_StRpWhldgTaxItem
LEFT OUTER JOIN P_JP_LastVndrInvcPaytInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _ReportingCurrency ON ReportingCurrency = _ReportingCurrency.Currency  -- association [0..1]
;