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 | Possible values | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
WT_GRUWTPD
Indicator: Entry posted as "Grossing up"
|
WT_GRUWTPD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
WT_OPOWTPD
Indicator: Entry posted as a debit/credit
|
WT_OPOWTPD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
WT_GIVENPD
Indicator: Withholding tax amount entered manually with pmnt
|
WT_GIVENPD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
WT_RESITEM
Indicator: Entry belongs to a residual item
|
WT_RESITEM |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
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 | ||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||
|
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 |