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

SAP Table WITH_ITEM

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

WITH_ITEM (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 WITH_ITEM to other SAP tables.

WITH_ITEM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BUKRS Company Code BUKRS T001 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 T059P CHAR 2 0
WT_WITHCD Withholding tax code WT_WITHCD T059Z CHAR 2 0
WT_QSSHH Withholding tax base amount (local currency) WT_BS CURR 15 2
WT_QSSHB Withholding tax base amount in document currency WT_BS1 CURR 15 2
WT_QSSH2 Withholding tax base amount in 2nd local currency WT_BS2 CURR 15 2
WT_QSSH3 Withholding tax base amount in 3rd local currency WT_BS3 CURR 15 2
WT_BASMAN Indicator: Withholding tax base amount entered manually WT_BASMAN CHAR 1 0
X Yes
NULL No
WT_QSSHHC Withholding tax base amount in LC for calculation WT_BSC CURR 15 2
WT_QSSHBC Withholding tax base amount in doc. currency for calculation WT_BS1C CURR 15 2
WT_QSSH2C With/tax base amount in 2nd local currency for calculation WT_BS2C CURR 15 2
WT_QSSH3C Withholding tax base amount in 3rd local currency for calc. WT_BS3C CURR 15 2
WT_QBSHH Withholding tax amount (in local currency) WT_WT CURR 15 2
WT_QBSHB Withholding tax amount in document currency WT_WT1 CURR 15 2
WT_QBSH2 Withholding tax amount in 2nd local currency WT_WT2 CURR 15 2
WT_QBSH3 Withholding tax amount in 3rd local currency WT_WT3 CURR 15 2
WT_AMNMAN Indicator: Withholding tax amount entered manually WT_AMNMAN CHAR 1 0
X Yes
NULL No
WT_QBSHHA W/tax auxiliary amount for reversal (in local currency) WT_WTA CURR 15 2
WT_QBSHHB W/tax auxiliary amount 2 in local currency for reversal WT_WTB CURR 15 2
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
WT_QSFHH Amount exempt from withholding tax in local currency WT_EXMP CURR 15 2
WT_QSFHB Amount exempt from withholding tax in document currency WT_EXMP1 CURR 15 2
WT_QSFH2 Withholding tax exempt amount in 2nd local currency WT_EXMP2 CURR 15 2
WT_QSFH3 Withholding tax exempt amount in 3rd local currency WT_EXMP3 CURR 15 2
WT_WTEXMN Exemption certificate number WT_EXNR CHAR 15 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
WT_ACCO Vendor/customer account number WT_ACNO CHAR 10 0
HKONT General Ledger Account HKONT SKA1 CHAR 10 0
HKONT_OPP General Ledger Account HKONT SKA1 CHAR 10 0
QSREC Type of recipient WT_QSREC T059C CHAR 2 0
AUGBL Document Number of the Clearing Document AUGBL CHAR 10 0
AUGDT Clearing Date AUGDT DATS 8 0
WT_QSZRT Exemption rate WT_EXRT DEC 5 2
WT_WDMBTR Withholding tax amount (in local currency) already withheld WT_AWT CURR 15 2
WT_WWRBTR Withholding tax amount already withheld in document currency WT_AWT1 CURR 15 2
WT_WDMBT2 Withholding tax amount already withheld in 2nd local curr. WT_AWT2 CURR 15 2
WT_WDMBT3 With/tax amount already withheld in 3rd local currency WT_AWT3 CURR 15 2
TEXT15 Text (15 characters) TEXT15 CHAR 15 0
WT_QBUIHH Enter withholding tax amount in local currency manually WT_QBUIHH CURR 15 2
WT_QBUIHB Enter withholding tax amount in document currency manually WT_QBUIHB CURR 15 2
WT_QBUIH2 Manually entered with/tax amount in 2nd local currency WT_QBUIH2 CURR 15 2
WT_QBUIH3 With/tax amount in 3rd local currency entered manually WT_QBUIH3 CURR 15 2
WT_ACCBS Accumulated withholding tax base amount in local currency WT_ACCBS CURR 15 2
WT_ACCWT Accumulated withholding tax amount in local currency WT_ACCWT CURR 15 2
WT_ACCWTA Accumulated auxiliary with/tax amount in local currency WT_ACCWTA CURR 15 2
WT_ACCWTHA Accumulated auxiliary with/tax amount in local currency WT_ACCWTHA CURR 15 2
WT_ACCBS1 Accumulated withholding tax base amount in local currency WT_ACCBS CURR 15 2
WT_ACCWT1 Accumulated withholding tax amount in local currency WT_ACCWT CURR 15 2
WT_ACCWTA1 Accumulated auxiliary with/tax amount in local currency WT_ACCWTA CURR 15 2
WT_ACCWTHA1 Accumulated auxiliary with/tax amount in local currency WT_ACCWTHA CURR 15 2
WT_ACCBS2 Accumulated withholding tax base amount in local currency WT_ACCBS CURR 15 2
WT_ACCWT2 Accumulated withholding tax amount in local currency WT_ACCWT CURR 15 2
WT_ACCWTA2 Accumulated auxiliary with/tax amount in local currency WT_ACCWTA CURR 15 2
WT_ACCWTHA2 Accumulated auxiliary with/tax amount in local currency WT_ACCWTHA CURR 15 2
QSATZ Withholding tax rate WT_QSATZ DEC 7 4
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_1AF_WT_REPBS Withholding tax base amount in local currency for reporting J_1AF_WT_REPBS CURR 15 2
WT_CALC Withholding Tax Already Calculated/Determined? WT_CALC CHAR 2 0
CI Enhanced WHT Calculation at Invoice Entry Has Been Run
NI Enhanced WHT Calculation at Invoice Entry Has Not Been Run
CP Enhanced WHT Calculation During Payment Posting Has Been Run
WT_LOGSYS Logical System in Which the Withholding Tax Was Calculated WT_LOGSYS CHAR 10 0
J_1BWHTCOLLCODE Official Withholding Tax Collection Code J_1BWHTCOLL T059Z_WITHCD2 CHAR 16 0
J_1BWHTRATE Tax Rate J_1BTXRATE DEC 6 2
J_1BWHT_BS Withholding Tax Base Amount from Nota Fiscal J_1BWHT_BS CURR 15 2
J_1BWHTACCBS Accumulated withholding tax real base amount(local currency) J_1BWHT_ACCRB CURR 15 2
J_1BWHTACCBS1 Accumulated withholding tax real base amount(local currency) J_1BWHT_ACCRB CURR 15 2
J_1BWHTACCBS2 Accumulated withholding tax real base amount(local currency) J_1BWHT_ACCRB CURR 15 2
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 J_1ICLRAMT CURR 13 2
J_1IREBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
J_1ISURAMT Surcharge amount J_1ISURAMT CURR 13 2

WITH_ITEM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WITH_ITEM BUKRS WITH_ITEM MANDT T001 Company Codes MANDT
WITH_ITEM BUKRS WITH_ITEM BUKRS T001 Company Codes BUKRS
WITH_ITEM HKONT WITH_ITEM MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
WITH_ITEM HKONT T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
WITH_ITEM HKONT WITH_ITEM HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
WITH_ITEM HKONT_OPP WITH_ITEM MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
WITH_ITEM HKONT_OPP T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
WITH_ITEM HKONT_OPP WITH_ITEM HKONT_OPP SKA1 G/L Account Master (Chart of Accounts) SAKNR
WITH_ITEM J_1BWHTCOLLCODE WITH_ITEM J_1BWHTCOLLCODE T059Z_WITHCD2 Entity Table: Additional Official Withholding Tax Code WITHCD2
WITH_ITEM J_1BWHTCOLLCODE WITH_ITEM MANDT T059Z_WITHCD2 Entity Table: Additional Official Withholding Tax Code MANDT
WITH_ITEM J_1BWHTCOLLCODE * T059Z_WITHCD2 Entity Table: Additional Official Withholding Tax Code LAND1
WITH_ITEM MANDT WITH_ITEM MANDT T000 Clients MANDT
WITH_ITEM QSREC WITH_ITEM WITHT T059C Types of Recipient: Vendors per Withholding Tax Type WITHT
WITH_ITEM QSREC WITH_ITEM QSREC T059C Types of Recipient: Vendors per Withholding Tax Type QSREC
WITH_ITEM QSREC WITH_ITEM MANDT T059C Types of Recipient: Vendors per Withholding Tax Type MANDT
WITH_ITEM QSREC T001 LAND1 T059C Types of Recipient: Vendors per Withholding Tax Type LAND1
WITH_ITEM WITHT WITH_ITEM MANDT T059P Withholding tax types MANDT
WITH_ITEM WITHT T001 LAND1 T059P Withholding tax types LAND1
WITH_ITEM WITHT WITH_ITEM WITHT T059P Withholding tax types WITHT
WITH_ITEM WT_WITHCD WITH_ITEM MANDT T059Z Withholding tax code (enhanced functions) MANDT
WITH_ITEM WT_WITHCD T001 LAND1 T059Z Withholding tax code (enhanced functions) LAND1
WITH_ITEM WT_WITHCD WITH_ITEM WITHT T059Z Withholding tax code (enhanced functions) WITHT
WITH_ITEM WT_WITHCD WITH_ITEM WT_WITHCD T059Z Withholding tax code (enhanced functions) WT_WITHCD