I_WithholdingTaxTrace

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_WithholdingTaxTrace.
-- 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: IEWHTTRACE

CREATE VIEW I_WithholdingTaxTrace AS
SELECT
  wt.CompanyCode AS CompanyCode,
  wt.AccountingDocument AS AccountingDocument,
  wt.FiscalYear AS FiscalYear,
  wt.AccountingDocumentItem AS AccountingDocumentItem,
  wt.WithholdingTaxType AS WithholdingTaxType,
  wt.WithholdingTaxCode AS WithholdingTaxCode,
  abs(wt.WhldgTaxBaseAmtInCoCodeCrcy) AS WhldgTaxBaseAmtInCoCodeCrcy,
  abs(wt.WhldgTaxBaseAmtInTransacCrcy) AS WhldgTaxBaseAmtInTransacCrcy,
  abs(wt.WhldgTaxBaseAmtInAddlCrcy2) AS WhldgTaxBaseAmtInAddlCrcy2,
  abs(wt.WhldgTaxBaseAmtInAddlCrcy3) AS WhldgTaxBaseAmtInAddlCrcy3,
  wt.WhldgTaxBaseIsEnteredManually AS WhldgTaxBaseIsEnteredManually,
  abs(wt.WhldgTaxAmtInCoCodeCrcy) AS WhldgTaxAmtInCoCodeCrcy,
  abs(wt.WhldgTaxAmtInTransacCrcy) AS WhldgTaxAmtInTransacCrcy,
  abs(wt.WhldgTaxAmtInAddlCrcy2) AS WhldgTaxAmtInAddlCrcy2,
  abs(wt.WhldgTaxAmtInAddlCrcy3) AS WhldgTaxAmtInAddlCrcy3,
  wt.WhldgTaxIsEnteredManually AS WhldgTaxIsEnteredManually,
  wt.WhldgTaxItemStatus AS WhldgTaxItemStatus,
  abs(wt.WhldgTaxExmptAmtInCoCodeCrcy) AS WhldgTaxExmptAmtInCoCodeCrcy,
  abs(wt.WhldgTaxExmptAmtInTransacCrcy) AS WhldgTaxExmptAmtInTransacCrcy,
  abs(wt.WhldgTaxExmptAmtInAddlCrcy2) AS WhldgTaxExmptAmtInAddlCrcy2,
  abs(wt.WhldgTaxExmptAmtInAddlCrcy3) AS WhldgTaxExmptAmtInAddlCrcy3,
  wt.WhldgTaxExmptCertificate AS WhldgTaxExmptCertificate,
  wt.FinancialAccountType AS FinancialAccountType,
  wt.CustomerSupplierAccount AS CustomerSupplierAccount,
  wt.GLAccount AS GLAccount,
  wt.SupplierRecipientType AS SupplierRecipientType,
  wt.ClearingAccountingDocument AS ClearingAccountingDocument,
  wt.ClearingDate AS ClearingDate,
  wt.WithholdingTaxExmptPercent AS WithholdingTaxExmptPercent,
  wt.WithholdingTaxPercent AS WithholdingTaxPercent,
  wt.IsSelfWhldgTax AS IsSelfWhldgTax,
  wt.IsGrossingUp AS IsGrossingUp,
  wt.WithholdingTaxCertificate AS WithholdingTaxCertificate,
  wt.WhldgTaxCertDate AS WhldgTaxCertDate,
  wt.IN_ClrgWithholdingTaxDocument AS IN_ClrgWithholdingTaxDocument,
  wt.IN_ClrgWithholdingTaxDate AS IN_ClrgWithholdingTaxDate,
  wt.IN_ReferenceDocumentNumber AS IN_ReferenceDocumentNumber,
  wt.DownPaymentIsCleared AS DownPaymentIsCleared,
  wt.DocumentIsPartialExempted AS DocumentIsPartialExempted,
  wt.IN_WhldgTaxRecordTypeTrans AS IN_WhldgTaxRecordTypeTrans,
  bkpf.PostingDate AS PostingDate,
  bkpf.IsReversed AS IsReversed,
  abs(trace.sknto) AS DiscountAmtInCoCodeCrcy,
  cast(trace.wt_postm as fis_wtpostm) AS WhldgTaxPostingTimePoint,
  t001.land1 AS Country,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  _AccountingDocument.Currency AS DocumentCurrency,
  _AccountingDocument.AdditionalCurrency1 AS AdditionalCurrency1,
  _AccountingDocument.AdditionalCurrency2 AS AdditionalCurrency2,
  abs(wt.RptgWhldgTxBaseAmtInCoCodeCrcy) AS RptgWhldgTxBaseAmtInCoCodeCrcy,
  trace.wt_dopost AS WhgdTaxPostingIsRequired,
  trace.xzahl AS IsUsedInPaymentTransaction,
  trace.wt_agtdf AS RequiredStartDate,
  trace.wt_agtdt AS RequiredEndDate,
  trace.wt_valid AS WithholdingTaxValidFromDate,
  trace.validityenddate AS ValidityEndDate,
  trace.wt_exdf AS ExemptionDateBegin,
  trace.wt_exdt AS ExemptionDateEnd,
  trace.qproz AS WhldgTaxRelevantPercent,
  trace.nowhtreason AS NoWhldgTaxReasonCode,
  trace.wt_redbas AS WhgdTxBaseAmtIsReduced,
  trace.ih_witht AS ReferentialWhldgTaxType,
  trace.stjah AS ReversalJournalEntryFiscalYear,
  _CompanyCodeWithholdingTaxType._Text[1:Language = $session.system_language].WithholdingTaxTypeName AS WithholdingTaxTypeName,
  _WithholdingTaxCode._CodeText[1:Language = $session.system_language].WhldgTaxCodeName AS WhldgTaxCodeName,
  _Country._Text[1:Language = $session.system_language].CountryName AS CountryName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM I_Withholdingtaxitem AS wt
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeStdVH AS _CompanyCodeVH ON CompanyCode = _CompanyCodeVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocument ON CompanyCode = _AccountingDocument.CompanyCode AND AccountingDocument = _AccountingDocument.AccountingDocument AND FiscalYear = _AccountingDocument.FiscalYear  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CoCodeWithholdingTaxType AS _CompanyCodeWithholdingTaxType ON CompanyCode = _CompanyCodeWithholdingTaxType.CompanyCode AND WithholdingTaxType = _CompanyCodeWithholdingTaxType.WithholdingTaxType  -- association [0..1]
LEFT OUTER JOIN I_Extendedwhldgtaxcode AS _WithholdingTaxCode ON Country = _WithholdingTaxCode.Country AND WithholdingTaxType = _WithholdingTaxCode.WithholdingTaxType AND WithholdingTaxCode = _WithholdingTaxCode.WithholdingTaxCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
;