1. Home
  2. Resources
  3. SAP Tables
  4. TXW_WITHITEM - Witholding tax info per W/tax type and FI line item

SAP Table TXW_WITHITEM

Witholding tax info per W/tax type and FI line item

TXW_WITHITEM (Witholding tax info per W/tax type and FI line item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TXW_WITHITEM to other SAP tables.

TXW_WITHITEM table fields

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