SAP table TXW_WITHITEM (Witholding tax info per W/tax type and FI line item)

SAP table TXW_WITHITEM has 6 primary key fields being MANDT,BUKRS,BELNR,GJAHR,BUZEI,WITHT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 BUKRS
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
WITHT Indicator for Withholding Tax Type CHAR 2 0 WITHT
WT_WITHCD Withholding Tax Code CHAR 2 0 WT_WITHCD
WT_QSSHH Withholding tax base amount (local currency) CHAR 31 0 TXW_WT_BS
WT_QSSHB Withholding tax base amount in document currency CHAR 31 0 TXW_WT_BS1
WT_QSSH2 Withholding tax base amount in 2nd local currency CHAR 31 0 TXW_WT_BS2
WT_QSSH3 Withholding tax base amount in 3rd local currency CHAR 31 0 TXW_WT_BS3
WT_BASMAN Indicator: Withholding Tax Base Amount Entered Manually CHAR 1 0 WT_BASMAN
WT_QBSHH Withholding tax amount (in local currency) CHAR 31 0 TXW_WT_WT
WT_QBSHB Withholding tax amount in document currency CHAR 31 0 TXW_WT_WT1
WT_QBSH2 Withholding tax amount in 2nd local currency CHAR 31 0 TXW_WT_WT2
WT_QBSH3 Withholding tax amount in 3rd local currency CHAR 31 0 TXW_WT_WT3
WT_AMNMAN Indicator: Withholding Tax Amount Entered Manually CHAR 1 0 WT_AMNMAN
WT_QSFHH Amount exempt from withholding tax in local curren CHAR 31 0 TXW_WT_EXMP
WT_QSFHB Amount exempt from withholding tax in document currency CHAR 31 0 TXW_WT_EXMP1
WT_QSFH2 Withholding tax exempt amount in 2nd local currency CHAR 31 0 TXW_WT_EXMP2
WT_QSFH3 Withholding tax exempt amount in 3rd local currency CHAR 31 0 TXW_WT_EXMP3
WT_WTEXMN Exemption Certificate Number CHAR 25 0 WT_EXNR
WT_ACCO Vendor/Customer Account Number CHAR 10 0 WT_ACNO
HKONT General Ledger Account CHAR 10 0 HKONT
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
AUGDT Clearing Date DATS 8 0 AUGDT
WT_QSZRT Exemption rate CHAR 6 0 TXW_WT_EXRT
TEXT15 Text (15 characters) CHAR 15 0 TEXT15
WT_QBUIHH Enter withholding tax amount in local currency manually CHAR 31 0 TXW_WT_QBUIHH
WT_QBUIHB Enter withholding tax amount in document currency manual CHAR 31 0 TXW_WT_QBUIHB
WT_QBUIH2 Manually entered with/tax amount in 2nd local currency CHAR 31 0 TXW_WT_QBUIH2
WT_QBUIH3 With/tax amount in 3rd local currency entered manually CHAR 31 0 TXW_WT_QBUIH3
QSATZ Withholding tax rate CHAR 9 0 TXW_WT_QSATZ
WT_QSSHHC Withholding tax base amount for calculation CHAR 31 0 TXW_WT_QSSHHC
WT_QSSHBC Enter withholding tax amount in LC calculatio CHAR 31 0 TXW_WT_QSSHBC
WT_QSSH2C Withholding base amount in 2nd local currency CHAR 31 0 TXW_WT_QSSH2C
WT_QSSH3C Withholding base amount in 3rd local currency CHAR 31 0 TXW_WT_QSSH3C
WT_QBSHHA w/tax auxiliary amount for reversal in LC CHAR 31 0 TXW_WT_QBSHHA
WT_QBSHHB w/tax auxiliary amount 2 in LC for reversal CHAR 31 0 TXW_WT_QBSHHB
WT_STAT Line Item Status CHAR 1 0 WT_STAT
D Recurring entry original document
M Sample document
S Noted items
V Parked document
X Statistical entry
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
HKONT_OPP General Ledger Account CHAR 10 0 HKONT
QSREC Vendor Recipient Type CHAR 2 0 QSREC
WT_WDMBTR withhold. tax amount in LC already withheld CHAR 31 0 TXW_WT_WDMBTR
WT_WWRBTR withholding tax amount already withheld in doc curr CHAR 31 0 TXW_WT_WWRBTR
WT_WDMBT2 withholding tax amount already withh. in 2nd loc. curr CHAR 31 0 TXW_WT_WDMBT2
WT_WDMBT3 withholding tax amount already withh. in 3rd loc. curr CHAR 31 0 TXW_WT_WDMBT3
WT_ACCBS Accumulated withholding tax base amount in local currency CHAR 31 0 TXW_WT_ACCBS
WT_ACCWT Accumulated withholding tax amount in local currency CHAR 31 0 TXW_WT_ACCWT
WT_ACCWTA Accumulated auxiliary with/tax amount in local currency CHAR 31 0 TXW_WT_ACCWTA
WT_ACCWTHA Accumulated auxiliary with/tax amount in local currency CHAR 31 0 TXW_WT_ACCWTHA
WT_ACCBS1 Accumulated withholding tax base amount in local currency CHAR 31 0 TXW_WT_ACCBS1
WT_ACCWT1 Accumulated withholding tax amount in local currency CHAR 31 0 TXW_WT_ACCWT1
WT_ACCWTA1 Accumulated auxiliary with/tax amount in local currency CHAR 31 0 TXW_WT_ACCWTA1
WT_ACCWTHA1 W/ auxiliary with/tax amount in local curr CHAR 31 0 TXW_WT_ACCWTHA1
WT_ACCBS2 Accumulated withholding tax base amount in local currency CHAR 31 0 TXW_WT_ACCBS2
WT_ACCWT2 Accumulated withholding tax amount in local currency CHAR 31 0 TXW_WT_ACCWT2
WT_ACCWTA2 Accumulated auxiliary with/tax amount in local currency CHAR 31 0 TXW_WT_ACCWTA2
WT_ACCWTHA2 wAccumulated auxiliary with/tax amount in local currency CHAR 31 0 TXW_WT_ACCWTHA2
WT_SLFWTPD Indicator: Entry Posted as Self-Withholding Tax CHAR 1 0 WT_SLFWTPD
WT_GRUWTPD Indicator: Entry Posted as "Grossing Up" CHAR 1 0 WT_GRUWTPD
WT_OPOWTPD Indicator: Entry Posted as Debit/Credit CHAR 1 0 WT_OPOWTPD
WT_GIVENPD Indicator: Withholding Tax Amount Entered Manually with Payt CHAR 1 0 WT_GIVENPD
CTNUMBER Withholding Tax Certificate Number CHAR 10 0 CTNUMBER
WT_DOWNC Indicator: Entry Belongs to a Down Payment Clearing Item CHAR 1 0 WT_DOWNC
WT_RESITEM Indicator: Entry Belongs to a Residual Item CHAR 1 0 WT_RESITEM
CTISSUEDATE Issue or Print Date of Withholding Tax Certificate DATS 8 0 CTISSUEDATE
J_1BWHTCOLLCODE Official Withholding Tax Collection Code CHAR 16 0 TXW_J_1BWHTCOLLCODE
J_1BWHTRATE Tax Rate CHAR 12 0 TXW_J_1BWHTRATE
J_1BWHT_BS Withholding Tax Base Amount from Nota Fiscal CHAR 31 0 TXW_J_1BWHT_BS
J_1BWHTACCBS Accumulated withholding tax real base amount(local currency) CHAR 31 0 TXW_J_1BWHTACCBS
J_1BWHTACCBS1 Accumulated withholding tax real base amount(local currency) CHAR 31 0 TXW_J_1BWHTACCBS
J_1BWHTACCBS2 Accumulated withholding tax real base amount(local currency) CHAR 31 0 TXW_J_1BWHTACCBS
J_1IINTCHLN Challan Number CHAR 12 0 J_1IINTCHLN
J_1IINTCHDT Challan Date DATS 8 0 J_1IINTCHDT
J_1IEWTREC Record type for EWT transactions-India CHAR 1 0 J_1IEWTREC
A Additional tax deducted from vendor
B Refund from loss account / Block certificate
C No modification / JV done
D Additional tax deducted from vendor due to base change
E Refund from tax account due to base change
F Pay from loss Account
J JV record in with item table
K Additional Tax / Pay from loss
L Refund from loss account
P Provision record
Q Provision reversal record
R Refund from tax account
U Update for original rec - Tax code / type has been changed
Y Parent Document of Partially cleared document-Customer Tax
Z Partial Clearing Document for Customer Tax Clearing
J_1IBUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
J_1ICERTDT Certificate Date DATS 8 0 J_1ICERTDT
J_1ICLRAMT Amount of EWT for which certificate is received from Custome CHAR 31 0 TXW_J_1ICLRAMT
J_1IREBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
J_1ISURAMT Surcharge amount CHAR 16 0 TXW_J_1ISURAMT
BS_BUKRS Company Code CHAR 4 0 BUKRS
BS_AUGDT Clearing Date DATS 8 0 AUGDT
BS_AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
BS_LIFNR Account Number of Supplier CHAR 10 0 LIFNR
BS_GJAHR Fiscal Year NUMC 4 0 GJAHR
BS_XZAHL Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
BS_WAERS Currency Key CUKY 5 0 WAERS