P_IT_StRpWhldgTaxItemLog

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_IT_StRpWhldgTaxItemLog.
-- 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 P_IT_StRpWhldgTaxItemLog AS
SELECT
  wht.CompanyCode AS CompanyCode,
  wht.AccountingDocument AS AccountingDocument,
  wht.FiscalYear AS FiscalYear,
  wht.AccountingDocumentItem AS AccountingDocumentItem,
  wht.WithholdingTaxType AS WithholdingTaxType,
  wht.WithholdingTaxCode AS WithholdingTaxCode,
  wht.OfficialWhldgTaxCode AS OfficialWhldgTaxCode,
  wht.WhldgTaxReferenceText AS WhldgTaxReferenceText,
  wht.WithholdingTaxIncomeType AS WithholdingTaxIncomeType,
  wht.SupplierRecipientType AS SupplierRecipientType,
  wht.Country AS Country,
  wht.TaxSection AS TaxSection,
  wht.BusinessPlace AS BusinessPlace,
  wht.FinancialAccountType AS FinancialAccountType,
  wht.Debtor AS Debtor,
  wht.Creditor AS Creditor,
  wht.BusinessPartner AS BusinessPartner,
  wht.BusinessPartnerNumber AS BusinessPartnerNumber,
  wht.WhldgTaxRptgDateIsActive AS WhldgTaxRptgDateIsActive,
  wht.DefaultWhldgTxRptgDateIsActive AS DefaultWhldgTxRptgDateIsActive,
  wht.WithholdingTaxReportingDate AS WithholdingTaxReportingDate,
  wht.PostingDate AS PostingDate,
  wht.DocumentDate AS DocumentDate,
  case when WhldgTaxDocumentType = '002' or WhldgTaxDocumentType = '007' then case when wht.WhldgTaxRptgDateIsActive = 'X' then wht.WithholdingTaxReportingDate else wht.ClearingDate end else wht.PostingDate end as ClearingDate AS PostingDateendasClearingDate,
  wht.ClearingJournalEntry AS ClearingJournalEntry,
  wht.ClearingJournalEntryFiscalYear AS ClearingJournalEntryFiscalYear,
  wht.InvoiceReference AS InvoiceReference,
  wht.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  wht.IsReversed AS IsReversed,
  wht.IsReversal AS IsReversal,
  wht.ReportingCurrency AS ReportingCurrency,
  wht.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  wht.AmountInLocalCurrency AS AmountInLocalCurrency,
  wht.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  wht.WhldgTaxBaseAmtInCoCodeCrcy AS WhldgTaxBaseAmtInCoCodeCrcy,
  wht.WhldgTaxAmtInCoCodeCrcy AS WhldgTaxAmtInCoCodeCrcy,
  wht.IsSelfWhldgTax AS IsSelfWhldgTax,
  wht.IsGrossingUp AS IsGrossingUp,
  wht.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  wht.WhldgTaxCertDate AS WhldgTaxCertDate,
  wht.IN_ClrgWithholdingTaxDocument AS IN_ClrgWithholdingTaxDocument,
  wht.IN_ClrgWithholdingTaxDate AS IN_ClrgWithholdingTaxDate,
  wht.IN_WhldgTaxRecordTypeTrans AS IN_WhldgTaxRecordTypeTrans,
  wht.WhldgTaxDocumentType AS WhldgTaxDocumentType,
  wht.ItemIsReportingRelevant AS ItemIsReportingRelevant,
  wht.Name AS Name,
  wht.BusinessPartnerName AS BusinessPartnerName,
  wht.Region AS Region,
  wht.BusinessPartnerCountry AS BusinessPartnerCountry,
  wht.TaxNumber1 AS TaxNumber1,
  wht.TaxNumber2 AS TaxNumber2,
  wht.TaxNumber3 AS TaxNumber3,
  wht.TaxNumber4 AS TaxNumber4,
  wht.TaxNumber5 AS TaxNumber5,
  wht.VATRegistration AS VATRegistration,
  wht.TaxItemIsZeroRated AS TaxItemIsZeroRated,
  wht.DocumentReferenceID AS DocumentReferenceID,
  wht.IsNaturalPerson AS IsNaturalPerson,
  wht._WithholdingTaxCode AS _WithholdingTaxCode,
  wht._CompanyCode AS _CompanyCode,
  wht._Supplier AS _Supplier,
  wht._Customer AS _Customer,
  wht._ReportingCurrency AS _ReportingCurrency,
  wht._Onetime AS _Onetime,
  wht._Branch AS _Branch,
  wht._JournalEntry AS _JournalEntry,
  wht._OperationalAcctgDocItem AS _OperationalAcctgDocItem
FROM P_StRpWhldgTaxItemLog AS wht
;