P_TH_StRpWhldgTaxItem

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_TH_StRpWhldgTaxItem.
-- 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.
-- SQL view name: PSRTHWHLDGTXITM

CREATE VIEW P_TH_StRpWhldgTaxItem AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wht.StatryRptgEntity AS StatryRptgEntity,
  wht.StatryRptCategory AS StatryRptCategory,
  wht.StatryRptRunID AS StatryRptRunID,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht.Country AS Country,
  wht.BusinessPlace AS BusinessPlace,
  wht.BranchCode AS BranchCode,
  wht.FinancialAccountType AS FinancialAccountType,
  wht.Debtor AS Debtor,
  wht.Creditor AS Creditor,
  wht.BusinessPartner AS BusinessPartner,
  wht.AddressID AS AddressID,
  wht.SupplierCountry AS SupplierCountry,
  wht.SupplierRegion AS SupplierRegion,
  wht.PostingDate AS PostingDate,
  wht.DocumentDate AS DocumentDate,
  wht.InvoiceReference AS InvoiceReference,
  wht.IsReversed AS IsReversed,
  wht.IsReversal AS IsReversal,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.TransactionCurrency AS TransactionCurrency,
  wht.BusinessPartnerAddressID AS BusinessPartnerAddressID,
  wht.PersonNumber AS PersonNumber,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  wht.TaxNumber1 AS TaxNumber1,
  wht.Language AS Language,
  wht.TransactionCode AS TransactionCode,
  wht.DocumentReferenceID AS DocumentReferenceID,
  wht._WithholdingTaxCode AS _WithholdingTaxCode,
  wht._CompanyCode AS _CompanyCode,
  wht._Supplier AS _Supplier,
  wht._Customer AS _Customer,
  wht._Onetime AS _Onetime,
  wht._Branch AS _Branch,
  wht._Supplier.Supplier AS Supplier,
  wht._OperationalAcctgDocItem AS _OperationalAcctgDocItem
FROM P_TH_StRpWhldgTaxItemOneCycle AS wht
LEFT OUTER JOIN P_TH_StRpWhldgTaxItemOneCycle AS wht_dependent ON wht.CompanyCode = wht_dependent.CompanyCode AND wht.AccountingDocument = wht_dependent.AccountingDocument AND wht.FiscalYear = wht_dependent.FiscalYear AND wht.AccountingDocumentItem = wht_dependent.AccountingDocumentItem AND wht.WithholdingTaxType <> wht_dependent.WithholdingTaxType AND ( wht.StatryRptgEntity is null AND wht_dependent.StatryRptgEntity is null OR wht.StatryRptgEntity = wht_dependent.StatryRptgEntity ) AND ( wht.StatryRptCategory is null AND wht_dependent.StatryRptCategory is null OR wht.StatryRptCategory = wht_dependent.StatryRptCategory ) AND ( wht.StatryRptRunID is null AND wht_dependent.StatryRptRunID is null OR wht.StatryRptRunID = wht_dependent.StatryRptRunID ) AND wht.Withholdingtaxpostingrule = '3' AND wht_dependent.Withholdingtaxpostingrule = '1' AND wht.WithholdingTaxIncomeType = wht_dependent.WithholdingTaxIncomeType AND wht.SqntlNmbrOfWhldgTaxType = wht_dependent.DependencyNmbrOfWhldgTaxType  -- association [0..1]
;