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

SAP table WITH_ITEM 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 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 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 T059P WITHT
WT_WITHCD Withholding Tax Code CHAR 2 0 T059Z WT_WITHCD
WT_QSSHH Withholding Tax Base Amount (Local Currency) CURR 23 2 WT_BS
WT_QSSHB Withholding Tax Base Amount in Document Currency CURR 23 2 WT_BS1
WT_QSSH2 Withholding Tax Base Amount in Second Local Currency CURR 23 2 WT_BS2
WT_QSSH3 Withholding Tax Base Amount in Third Local Currency CURR 23 2 WT_BS3
WT_BASMAN Indicator: Withholding Tax Base Amount Entered Manually CHAR 1 0 WT_BASMAN
WT_QSSHHC Withholding Tax Base Amount in Local Crcy for Calculation CURR 23 2 WT_BSC
WT_QSSHBC Withholding Tax Base Amount in Document Crcy for Calculation CURR 23 2 WT_BS1C
WT_QSSH2C WTax Base Amount in 2nd Local Currency for Calculation CURR 23 2 WT_BS2C
WT_QSSH3C Withholding Tax Base Amount in 3rd Local Currency for Calc. CURR 23 2 WT_BS3C
WT_QBSHH Withholding Tax Amount in Local Currency CURR 23 2 WT_WT
WT_QBSHB Withholding Tax Amount in Document Currency CURR 23 2 WT_WT1
WT_QBSH2 Withholding Tax Amount in Second Local Currency CURR 23 2 WT_WT2
WT_QBSH3 Withholding Tax Amount in Third Local Currency CURR 23 2 WT_WT3
WT_AMNMAN Indicator: Withholding Tax Amount Entered Manually CHAR 1 0 WT_AMNMAN
WT_QBSHHA Withholding Tax Auxiliary Amount in Local Crcy for Reversal CURR 23 2 WT_WTA
WT_QBSHHB Withholding Tax Auxiliary Amt 2 in Local Crcy for Reversal CURR 23 2 WT_WTB
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
WT_QSFHH Amount Exempt from Withholding Tax in Local Currency CURR 23 2 WT_EXMP
WT_QSFHB Amount Exempt from Withholding Tax in Document Currency CURR 23 2 WT_EXMP1
WT_QSFH2 Amount Exempt from Withholding Tax in 2nd Local Currency CURR 23 2 WT_EXMP2
WT_QSFH3 Amount Exempt from Withholding Tax in 3rd Local Currency CURR 23 2 WT_EXMP3
WT_WTEXMN Exemption Certificate Number CHAR 25 0 WT_EXNR
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
WT_ACCO Vendor/Customer Account Number CHAR 10 0 WT_ACNO
HKONT General Ledger Account CHAR 10 0 SKA1 HKONT
HKONT_OPP General Ledger Account CHAR 10 0 SKA1 HKONT
QSREC Type of Recipient CHAR 2 0 T059C WT_QSREC
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
AUGDT Clearing Date DATS 8 0 AUGDT
WT_QSZRT Exemption Rate DEC 5 2 WT_EXRT
WT_WDMBTR Withholding Tax Amount Already Withheld in Local Currency CURR 23 2 WT_AWT
WT_WWRBTR Withholding Tax Amount Already Withheld in Document Currency CURR 23 2 WT_AWT1
WT_WDMBT2 Withholding tax amount already withheld in 2nd local curr. CURR 23 2 WT_AWT2
WT_WDMBT3 Withholding Tax Amt Already Withheld in 3rd Local Currency CURR 23 2 WT_AWT3
TEXT15 Text (15 characters) CHAR 15 0 TEXT15
WT_QBUIHH Withholding Tax Amount Entered Manually in Local Currency CURR 23 2 WT_QBUIHH
WT_QBUIHB Withholding Tax Amount Entered Manually in Document Currency CURR 23 2 WT_QBUIHB
WT_QBUIH2 Withholding Tax Amount Entered Manually in 2nd Local Curr. CURR 23 2 WT_QBUIH2
WT_QBUIH3 Withholding Tax Amount Entered Manually in 3rd Local Curr. CURR 23 2 WT_QBUIH3
WT_ACCBS Accumulated Withholding Tax Base Amount in Local Currency CURR 23 2 WT_ACCBS
WT_ACCWT Accumulated Withholding Tax Amount in Local Currency CURR 23 2 WT_ACCWT
WT_ACCWTA Accumulated Auxiliary WTax Amount in Local Currency CURR 23 2 WT_ACCWTA
WT_ACCWTHA Accumulated Auxiliary WTax Amount in Local Currency CURR 23 2 WT_ACCWTHA
WT_ACCBS1 Accumulated Withholding Tax Base Amount in Local Currency CURR 23 2 WT_ACCBS
WT_ACCWT1 Accumulated Withholding Tax Amount in Local Currency CURR 23 2 WT_ACCWT
WT_ACCWTA1 Accumulated Auxiliary WTax Amount in Local Currency CURR 23 2 WT_ACCWTA
WT_ACCWTHA1 Accumulated Auxiliary WTax Amount in Local Currency CURR 23 2 WT_ACCWTHA
WT_ACCBS2 Accumulated Withholding Tax Base Amount in Local Currency CURR 23 2 WT_ACCBS
WT_ACCWT2 Accumulated Withholding Tax Amount in Local Currency CURR 23 2 WT_ACCWT
WT_ACCWTA2 Accumulated Auxiliary WTax Amount in Local Currency CURR 23 2 WT_ACCWTA
WT_ACCWTHA2 Accumulated Auxiliary WTax Amount in Local Currency CURR 23 2 WT_ACCWTHA
QSATZ Withholding Tax Rate DEC 7 4 WT_QSATZ
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_1AF_WT_REPBS Withholding tax base amount in local currency for reporting CURR 23 2 J_1AF_WT_REPBS
WT_CALC Withholding Tax Already Calculated/Determined? CHAR 2 0 WT_CALC
CI Enhanced WHT Calculation at Invoice Entry Has Been Run
CP Enhanced WHT Calculation During Payment Posting Has Been Run
NI Enhanced WHT Calculation at Invoice Entry Has Not Been Run
WT_LOGSYS Logical System in Which the Withholding Tax Was Calculated CHAR 10 0 WT_LOGSYS
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
FIWTCO_PEN_VOL_DEDO Voluntary Pension Contribution CURR 23 2 FIWTCO_PEN_VOL_DEDO
VOL_CONTRIBUTION Volunteers' Pension Contribution CURR 23 2 VOL_CONTRIBUTION
CO_MAX_DEDUCTION Maximum Deduction CURR 23 2 CO_MAX_DEDUCTION
FIWTCO_MAND_BASE Mandatory Contributions Base CURR 13 2 FIWTCO_MAND_BASE
J_1BWHTCOLLCODE Official Withholding Tax Collection Code CHAR 16 0 T059Z_WITHCD2 J_1BWHTCOLL
J_1BWHTRATE Tax Rate DEC 6 2 J_1BTXRATE
J_1BWHT_BS Withholding Tax Base Amount from Nota Fiscal CURR 23 2 J_1BWHT_BS_FI_CS
J_1BWHTACCBS Accumulated withholding tax real base amount(local currency) CURR 23 2 J_1BWHT_ACCRB_FI_CS
J_1BWHTACCBS1 Accumulated withholding tax real base amount(local currency) CURR 23 2 J_1BWHT_ACCRB_FI_CS
J_1BWHTACCBS2 Accumulated withholding tax real base amount(local currency) CURR 23 2 J_1BWHT_ACCRB_FI_CS
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 CURR 23 2 J_1ICLRAMT
J_1IREBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
J_1ISURAMT Surcharge amount CURR 13 2 J_1ISURAMT
FIWTIN_PAR_EXEM Partial Exemption CHAR 1 0 FIWTIN_PAR_EXEM_IND
No
X Yes

WITH_ITEM foreign key relationships

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