SAP WITH_ITEM Witholding tax info per W/tax type and FI line item Table data and field list

WITH_ITEM is a standard SAP Table which is used to store Witholding tax info per W/tax type and FI line item data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The WITH_ITEM table consists of various fields, each holding specific information or linking keys about Witholding tax info per W/tax type and FI line item data available in SAP. These include BUKRS (Company Code), BELNR (Accounting Document Number), GJAHR (Fiscal Year), BUZEI (Number of Line Item Within Accounting Document)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

WITH_ITEM table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP WITH_ITEM table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the WITH_ITEM table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
BELNR	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
BUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
WITHT	Indicator for withholding tax type	WITHT	CHAR	2	T059P		WITHT
WT_WITHCD	Withholding tax code	WT_WITHCD	CHAR	2	T059Z		WT_WITHCD
WT_QSSHH	Withholding tax base amount (local currency)	WT_BS	CURR	15(2)			WERTV8
WT_QSSHB	Withholding tax base amount in document currency	WT_BS1	CURR	15(2)			WERTV8
WT_QSSH2	Withholding tax base amount in 2nd local currency	WT_BS2	CURR	15(2)			WERTV8
WT_QSSH3	Withholding tax base amount in 3rd local currency	WT_BS3	CURR	15(2)			WERTV8
WT_BASMAN	Indicator: Withholding tax base amount entered manually	WT_BASMAN	CHAR	1			XFELD
WT_QSSHHC	Withholding tax base amount in LC for calculation	WT_BSC	CURR	15(2)			WERTV8
WT_QSSHBC	Withholding tax base amount in doc. currency for calculation	WT_BS1C	CURR	15(2)			WERTV8
WT_QSSH2C	With/tax base amount in 2nd local currency for calculation	WT_BS2C	CURR	15(2)			WERTV8
WT_QSSH3C	Withholding tax base amount in 3rd local currency for calc.	WT_BS3C	CURR	15(2)			WERTV8
WT_QBSHH	Withholding tax amount (in local currency)	WT_WT	CURR	15(2)			WERTV8
WT_QBSHB	Withholding tax amount in document currency	WT_WT1	CURR	15(2)			WERTV8
WT_QBSH2	Withholding tax amount in 2nd local currency	WT_WT2	CURR	15(2)			WERTV8
WT_QBSH3	Withholding tax amount in 3rd local currency	WT_WT3	CURR	15(2)			WERTV8
WT_AMNMAN	Indicator: Withholding tax amount entered manually	WT_AMNMAN	CHAR	1			XFELD
WT_QBSHHA	W/tax auxiliary amount for reversal (in local currency)	WT_WTA	CURR	15(2)			WERTV8
WT_QBSHHB	W/tax auxiliary amount 2 in local currency for reversal	WT_WTB	CURR	15(2)			WERTV8
WT_STAT	Line item status	WT_STAT	CHAR	1			WT_STAT
WT_QSFHH	Amount exempt from withholding tax in local currency	WT_EXMP	CURR	15(2)			WERTV8
WT_QSFHB	Amount exempt from withholding tax in document currency	WT_EXMP1	CURR	15(2)			WERTV8
WT_QSFH2	Withholding tax exempt amount in 2nd local currency	WT_EXMP2	CURR	15(2)			WERTV8
WT_QSFH3	Withholding tax exempt amount in 3rd local currency	WT_EXMP3	CURR	15(2)			WERTV8
WT_WTEXMN	Exemption certificate number	WT_EXNR	CHAR	15			CHAR15
KOART	Account Type	KOART	CHAR	1			KOART
WT_ACCO	Vendor/customer account number	WT_ACNO	CHAR	10			CHAR10
HKONT	General Ledger Account	HKONT	CHAR	10	SKA1	ALPHA	SAKNR
HKONT_OPP	General Ledger Account	HKONT	CHAR	10	SKA1	ALPHA	SAKNR
QSREC	Type of recipient	WT_QSREC	CHAR	2	T059C		WT_QSREC
AUGBL	Document Number of the Clearing Document	AUGBL	CHAR	10		ALPHA	BELNR
AUGDT	Clearing Date	AUGDT	DATS	8			DATUM
WT_QSZRT	Exemption rate	WT_EXRT	DEC	5(2)			PRZ32
WT_WDMBTR	Withholding tax amount (in local currency) already withheld	WT_AWT	CURR	15(2)			WERTV8
WT_WWRBTR	Withholding tax amount already withheld in document currency	WT_AWT1	CURR	15(2)			WERTV8
WT_WDMBT2	Withholding tax amount already withheld in 2nd local curr.	WT_AWT2	CURR	15(2)			WERTV8
WT_WDMBT3	With/tax amount already withheld in 3rd local currency	WT_AWT3	CURR	15(2)			WERTV8
TEXT15	Text (15 characters)	TEXT15	CHAR	15			TEXT15
WT_QBUIHH	Enter withholding tax amount in local currency manually	WT_QBUIHH	CURR	15(2)			WERTV8
WT_QBUIHB	Enter withholding tax amount in document currency manually	WT_QBUIHB	CURR	15(2)			WERTV8
WT_QBUIH2	Manually entered with/tax amount in 2nd local currency	WT_QBUIH2	CURR	15(2)			WERTV8
WT_QBUIH3	With/tax amount in 3rd local currency entered manually	WT_QBUIH3	CURR	15(2)			WERTV8
WT_ACCBS	Accumulated withholding tax base amount in local currency	WT_ACCBS	CURR	15(2)			WERTV8
WT_ACCWT	Accumulated withholding tax amount in local currency	WT_ACCWT	CURR	15(2)			WERTV8
WT_ACCWTA	Accumulated auxiliary with/tax amount in local currency	WT_ACCWTA	CURR	15(2)			WERTV8
WT_ACCWTHA	Accumulated auxiliary with/tax amount in local currency	WT_ACCWTHA	CURR	15(2)			WERTV8
WT_ACCBS1	Accumulated withholding tax base amount in local currency	WT_ACCBS	CURR	15(2)			WERTV8
WT_ACCWT1	Accumulated withholding tax amount in local currency	WT_ACCWT	CURR	15(2)			WERTV8
WT_ACCWTA1	Accumulated auxiliary with/tax amount in local currency	WT_ACCWTA	CURR	15(2)			WERTV8
WT_ACCWTHA1	Accumulated auxiliary with/tax amount in local currency	WT_ACCWTHA	CURR	15(2)			WERTV8
WT_ACCBS2	Accumulated withholding tax base amount in local currency	WT_ACCBS	CURR	15(2)			WERTV8
WT_ACCWT2	Accumulated withholding tax amount in local currency	WT_ACCWT	CURR	15(2)			WERTV8
WT_ACCWTA2	Accumulated auxiliary with/tax amount in local currency	WT_ACCWTA	CURR	15(2)			WERTV8
WT_ACCWTHA2	Accumulated auxiliary with/tax amount in local currency	WT_ACCWTHA	CURR	15(2)			WERTV8
QSATZ	Withholding tax rate	WT_QSATZ	DEC	7(4)			PRZ34
WT_SLFWTPD	Indicator: Entry posted as self-withholding tax	WT_SLFWTPD	CHAR	1			XFELD
WT_GRUWTPD	Indicator: Entry posted as 'Grossing up'	WT_GRUWTPD	CHAR	1			XFELD
WT_OPOWTPD	Indicator: Entry posted as a debit/credit	WT_OPOWTPD	CHAR	1			XFELD
WT_GIVENPD	Indicator: Withholding tax amount entered manually with pmnt	WT_GIVENPD	CHAR	1			XFELD
CTNUMBER	Withholding Tax Certificate Number	CTNUMBER	CHAR	10			CHAR10
WT_DOWNC	Indicator: Entry belongs to a down payment clearing item	WT_DOWNC	CHAR	1			XFELD
WT_RESITEM	Indicator: Entry belongs to a residual item	WT_RESITEM	CHAR	1			XFELD
CTISSUEDATE	Issue or Print Date of Withholding Tax Certificate	CTISSUEDATE	DATS	8			DATUM
J_1AF_WT_REPBS	Withholding tax base amount in local currency for reporting	J_1AF_WT_REPBS	CURR	15(2)			WERTV8
WT_CALC	Withholding Tax Already Calculated/Determined?	WT_CALC	CHAR	2			WT_CALC
WT_LOGSYS	Logical System in Which the Withholding Tax Was Calculated	WT_LOGSYS	CHAR	10	Assigned to domain	ALPHA	LOGSYS
.INCLU--AP				0
J_1BWHTCOLLCODE	Official Withholding Tax Collection Code	J_1BWHTCOLL	CHAR	16	T059Z_WITHCD2		WITHCD2
J_1BWHTRATE	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
J_1BWHT_BS	Withholding Tax Base Amount from Nota Fiscal	J_1BWHT_BS	CURR	15(2)			WERTV8
J_1BWHTACCBS	Accumulated withholding tax real base amount(local currency)	J_1BWHT_ACCRB	CURR	15(2)			WERTV8
J_1BWHTACCBS1	Accumulated withholding tax real base amount(local currency)	J_1BWHT_ACCRB	CURR	15(2)			WERTV8
J_1BWHTACCBS2	Accumulated withholding tax real base amount(local currency)	J_1BWHT_ACCRB	CURR	15(2)			WERTV8
.INCLU--AP				0
J_1IINTCHLN	Challan Number	J_1IINTCHLN	CHAR	12			J_1IINTCHLN
J_1IINTCHDT	Challan Date	J_1IINTCHDT	DATS	8
J_1IEWTREC	Record type for EWT transactions-India	J_1IEWTREC	CHAR	1			J_1IEWTREC
J_1IBUZEI	Number of Line Item Within Accounting Document	BUZEI	NUMC	3			BUZEI	BUZ
J_1ICERTDT	Certificate Date	J_1ICERTDT	DATS	8			CK_DATUM	ABTME
J_1ICLRAMT	Amount of EWT for which certificate is received from Custome	J_1ICLRAMT	CURR	13(2)			WERT7
J_1IREBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
J_1ISURAMT	Surcharge amount	J_1ISURAMT	CURR	13(2)			WERTV7

Key field

Non-key field

< WITH_EXCL_WITHT - Assignment to Withholding Tax Type WITH_ITEMX - Auxiliary structure for table WITH_ITEM >

How do I retrieve data from SAP table WITH_ITEM using ABAP code

The following ABAP code Example will allow you to do a basic selection on WITH_ITEM to SELECT all data from the table
DATA: WA_WITH_ITEM TYPE WITH_ITEM.

SELECT SINGLE *
FROM WITH_ITEM
INTO CORRESPONDING FIELDS OF WA_WITH_ITEM
WHERE...

How to access SAP table WITH_ITEM

Within an ECC or HANA version of SAP you can also view further information about WITH_ITEM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to WITH_ITEM

    KNA1 - General Data in Customer Master
        ADDR1_VAL - Address Data
    KNC3 - Customer Master (Special G/L Transaction Figures)
    BSID - Accounting: Secondary Index for Customers
        ADMI_FILES - Archive Files
        BSIDEXT - Secondary Index & Additions Section (bsega)
        BKPF - Accounting Document Header
            BSEG - Accounting Document Segment
                WITH_ITEM - Witholding Tax Info.per W/Tax Type and FI Line Itm
                GSEG - Offsetting Items for B-Segment in Reporting
        KNAS - Customer Master (VAT Registration Nos Gen. Sel.)
        KNKA - Customer Master Credit Management: Central Data
        KNKK - Credit Management Cust. Mstr: Control Area Data
        KNBK - Customer Master (Bank Details)
        KNB1 - Customer Master (Company Code)
            KNB4 - Customer Payment History
            KNB5 - Customer Master (Dunning Data)
            KNC1 - Customer Master (Transaction Figures)

    LFA1 - Vendor Master (General Section)
        ADDR1_VAL - Address Data
    BSIKEXT - Secondary Index & Additions Section (BSEGA)
    BKPF - Accounting Document Header
        BSEG - Accounting Document Segment
            WITH_ITEM - Witholding Tax Info.per W/Tax Type and FI Line Itm
            GSEG - Offsetting Items for B-Segment in Reporting
        LFAS - Vendor Master (General Part EU Tax Number)
        LFBK - Vendor Master (Bank Details)
        LFB1 - Vendor Master (Company Code)
            LFB5 - Vendor Master (Dunning Data)
            LFC1 - Vendor Master (Transaction Figures)
            LFC3 - Vendor Master (Transaction Figures) Special Ledger
            BSIK - Accounting: Secondary Index for Vendors
                ADMI_FILES - Archive Files