I_Withholdingtaxitem

Withholding Tax Item | view: IFIWTAXITEM | TRAN | Extraction: Full only | Component: Information System
Tables used: BKPFWITH_ITEMT001TKA02
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
WithholdingTaxType FK Indicator for Withholding Tax Type
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
WhldgTaxBaseAmtInCoCodeCrcy Withholding Tax Base Amount (Local Currency)
WhldgTaxAmtInCoCodeCrcy Withholding Tax Amount in Local Currency
WhldgTaxExmptAmtInCoCodeCrcy Amount Exempt from Withholding Tax in Local Currency
💲 Currency Key (DocumentCurrency):
WhldgTaxBaseAmtInTransacCrcy Withholding Tax Base Amount in Document Currency
WhldgTaxAmtInTransacCrcy Withholding Tax Amount in Document Currency
WhldgTaxExmptAmtInTransacCrcy Amount Exempt from Withholding Tax in Document Currency
💲 Additional Currency 1 (AdditionalCurrency1):
WhldgTaxBaseAmtInAddlCrcy2 Withholding Tax Base Amount in Second Local Currency
WhldgTaxAmtInAddlCrcy2 Withholding Tax Amount in Second Local Currency
WhldgTaxExmptAmtInAddlCrcy2 Amount Exempt from Withholding Tax in 2nd Local Currency
💲 Additional Currency 2 (AdditionalCurrency2):
WhldgTaxBaseAmtInAddlCrcy3 Withholding Tax Base Amount in Third Local Currency
WhldgTaxAmtInAddlCrcy3 Withholding Tax Amount in Third Local Currency
WhldgTaxExmptAmtInAddlCrcy3 Amount Exempt from Withholding Tax in 3rd Local Currency
Column Name Description
Column Name Description
ClearingDate Clearing Date
WhldgTaxCertDate Issue or Print Date of Withholding Tax Certificate
Column Name Description
WhldgTaxBaseIsEnteredManually Indicator: Withholding Tax Base Amount Entered Manually Show values
WhldgTaxIsEnteredManually Indicator: Withholding Tax Amount Entered Manually Show values
WhldgTaxItemStatus Line Item Status Show values
FinancialAccountType Account type Show values
IsSelfWhldgTax Indicator: Entry Posted as Self-Withholding Tax Show values
IsGrossingUp Indicator: Entry Posted as "Grossing Up" Show values
Column Name Description Domain name
WhldgTaxExmptCertificate Exemption Certificate Number CHAR25
CustomerSupplierAccount Vendor/Customer Account Number CHAR10
ClearingAccountingDocument Document Number of the Clearing Document BELNR
WithholdingTaxExmptPercent Exemption Rate PRZ32
WithholdingTaxPercent Withholding Tax Rate PRZ34
WithholdingTaxCertificate Withholding Tax Certificate Number CHAR10
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_WITHHOLDINGTAXITEM.COMPANYCODE == T001.BUKRS
  • I_WITHHOLDINGTAXITEM.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_WITHHOLDINGTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_WITHHOLDINGTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • I_WITHHOLDINGTAXITEM.MANDT == TCURC.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_WITHHOLDINGTAXITEM.COUNTRY == T005.LAND1
  • I_WITHHOLDINGTAXITEM.MANDT == T005.MANDT
Currency Key
  • Currency Key
  • Currency Key
  • Client
  • I_WITHHOLDINGTAXITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • I_WITHHOLDINGTAXITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • I_WITHHOLDINGTAXITEM.MANDT == TCURC.MANDT
General Ledger Account
  • ?
  • General Ledger Account
  • Client
  • I_WITHHOLDINGTAXITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • I_WITHHOLDINGTAXITEM.GLACCOUNT == SKA1.SAKNR
  • I_WITHHOLDINGTAXITEM.MANDT == SKA1.MANDT
Type of Recipient
  • Type of Recipient
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • I_WITHHOLDINGTAXITEM.SUPPLIERRECIPIENTTYPE == T059C.QSREC
  • I_WITHHOLDINGTAXITEM.COUNTRY == T059C.LAND1
  • I_WITHHOLDINGTAXITEM.WITHHOLDINGTAXTYPE == T059C.WITHT
  • I_WITHHOLDINGTAXITEM.MANDT == T059C.MANDT
Withholding Tax Code
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • Withholding Tax Code
  • I_WITHHOLDINGTAXITEM.COUNTRY == T059Z.LAND1
  • I_WITHHOLDINGTAXITEM.WITHHOLDINGTAXTYPE == T059Z.WITHT
  • I_WITHHOLDINGTAXITEM.MANDT == T059Z.MANDT
  • I_WITHHOLDINGTAXITEM.WITHHOLDINGTAXCODE == T059Z.WT_WITHCD
Indicator for Withholding Tax Type
  • Country/Region Key
  • Indicator for Withholding Tax Type
  • Client
  • I_WITHHOLDINGTAXITEM.COUNTRY == T059P.LAND1
  • I_WITHHOLDINGTAXITEM.WITHHOLDINGTAXTYPE == T059P.WITHT
  • I_WITHHOLDINGTAXITEM.MANDT == T059P.MANDT