I_Withholdingtaxitem

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_Withholdingtaxitem.
-- 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: IFIWTAXITEM

CREATE VIEW I_Withholdingtaxitem AS
SELECT
  bukrs AS CompanyCode,
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  buzei AS AccountingDocumentItem,
  witht AS WithholdingTaxType,
  wt_withcd AS WithholdingTaxCode,
  wt_qsshh AS WhldgTaxBaseAmtInCoCodeCrcy,
  wt_qsshb AS WhldgTaxBaseAmtInTransacCrcy,
  wt_qssh2 AS WhldgTaxBaseAmtInAddlCrcy2,
  wt_qssh3 AS WhldgTaxBaseAmtInAddlCrcy3,
  wt_basman AS WhldgTaxBaseIsEnteredManually,
  wt_qbshh AS WhldgTaxAmtInCoCodeCrcy,
  wt_qbshb AS WhldgTaxAmtInTransacCrcy,
  wt_qbsh2 AS WhldgTaxAmtInAddlCrcy2,
  wt_qbsh3 AS WhldgTaxAmtInAddlCrcy3,
  wt_amnman AS WhldgTaxIsEnteredManually,
  wt_stat AS WhldgTaxItemStatus,
  wt_qsfhh AS WhldgTaxExmptAmtInCoCodeCrcy,
  wt_qsfhb AS WhldgTaxExmptAmtInTransacCrcy,
  wt_qsfh2 AS WhldgTaxExmptAmtInAddlCrcy2,
  wt_qsfh3 AS WhldgTaxExmptAmtInAddlCrcy3,
  wt_wtexmn AS WhldgTaxExmptCertificate,
  koart AS FinancialAccountType,
  wt_acco AS CustomerSupplierAccount,
  hkont AS GLAccount,
  qsrec AS SupplierRecipientType,
  augbl AS ClearingAccountingDocument,
  augdt AS ClearingDate,
  wt_qszrt AS WithholdingTaxExmptPercent,
  qsatz AS WithholdingTaxPercent,
  wt_slfwtpd AS IsSelfWhldgTax,
  wt_gruwtpd AS IsGrossingUp,
  ctnumber AS WithholdingTaxCertificate,
  ctissuedate AS WhldgTaxCertDate,
  j_1iintchln AS IN_ClrgWithholdingTaxDocument,
  j_1iintchdt AS IN_ClrgWithholdingTaxDate,
  j_1irebzg AS IN_ReferenceDocumentNumber,
  wt_downc AS DownPaymentIsCleared,
  fiwtin_par_exem AS DocumentIsPartialExempted,
  j_1iewtrec AS IN_WhldgTaxRecordTypeTrans,
  _CompanyCode.Country AS Country,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  _AccountingDocument.Currency AS DocumentCurrency,
  _AccountingDocument.AdditionalCurrency1 AS AdditionalCurrency1,
  _AccountingDocument.AdditionalCurrency2 AS AdditionalCurrency2,
  j_1af_wt_repbs AS RptgWhldgTxBaseAmtInCoCodeCrcy
FROM with_item
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.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_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]
;