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

Overview

WITH_ITEM is a standard SAP S/4HANA table that stores Witholding tax info per W/tax type and FI line item data. There are total 88 fields in the WITH_ITEM table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WITH_ITEM belongs to Withholding Tax (Calculation) (FI-AP-AP-Q) module and is located in the package Infrastructure for withholding tax (FQST).

In addition, following links provide an overview of foreign key relationships, if any, that link WITH_ITEM to other SAP tables and standard CDS views available based on WITH_ITEM table in S/4HANA 2020.

Techincal Settings of WITH_ITEM

Below are technical details of the table WITH_ITEM

Buffering not allowed
No buffering
Storage type is Column Store

List of WITH_ITEM Fields

The following table gives you an overview of the fields available in WITH_ITEM

Field	Description	Data Element	Check Table	Data Type	Length
MANDT	Client	MANDT	T000	CLNT	3
BUKRS	Company Code	BUKRS	T001	CHAR	4
BELNR	Accounting Document Number	BELNR_D		CHAR	10
GJAHR	Fiscal Year	GJAHR		NUMC	4
BUZEI	Number of Line Item Within Accounting Document	BUZEI		NUMC	3
WITHT	Indicator for Withholding Tax Type	WITHT	T059P	CHAR	2
WT_WITHCD	Withholding Tax Code	WT_WITHCD	T059Z	CHAR	2
WT_QSSHH	Withholding Tax Base Amount (Local Currency)	WT_BS		CURR	23
WT_QSSHB	Withholding Tax Base Amount in Document Currency	WT_BS1		CURR	23
WT_QSSH2	Withholding Tax Base Amount in Second Local Currency	WT_BS2		CURR	23
WT_QSSH3	Withholding Tax Base Amount in Third Local Currency	WT_BS3		CURR	23
WT_BASMAN	Indicator: Withholding Tax Base Amount Entered Manually	WT_BASMAN		CHAR	1
WT_QSSHHC	Withholding Tax Base Amount in Local Crcy for Calculation	WT_BSC		CURR	23
WT_QSSHBC	Withholding Tax Base Amount in Document Crcy for Calculation	WT_BS1C		CURR	23
WT_QSSH2C	WTax Base Amount in 2nd Local Currency for Calculation	WT_BS2C		CURR	23
WT_QSSH3C	Withholding Tax Base Amount in 3rd Local Currency for Calc.	WT_BS3C		CURR	23
WT_QBSHH	Withholding Tax Amount in Local Currency	WT_WT		CURR	23
WT_QBSHB	Withholding Tax Amount in Document Currency	WT_WT1		CURR	23
WT_QBSH2	Withholding Tax Amount in Second Local Currency	WT_WT2		CURR	23
WT_QBSH3	Withholding Tax Amount in Third Local Currency	WT_WT3		CURR	23
WT_AMNMAN	Indicator: Withholding Tax Amount Entered Manually	WT_AMNMAN		CHAR	1
WT_QBSHHA	Withholding Tax Auxiliary Amount in Local Crcy for Reversal	WT_WTA		CURR	23
WT_QBSHHB	Withholding Tax Auxiliary Amt 2 in Local Crcy for Reversal	WT_WTB		CURR	23
WT_STAT	Line Item Status	WT_STAT		CHAR	1
WT_QSFHH	Amount Exempt from Withholding Tax in Local Currency	WT_EXMP		CURR	23
WT_QSFHB	Amount Exempt from Withholding Tax in Document Currency	WT_EXMP1		CURR	23
WT_QSFH2	Amount Exempt from Withholding Tax in 2nd Local Currency	WT_EXMP2		CURR	23
WT_QSFH3	Amount Exempt from Withholding Tax in 3rd Local Currency	WT_EXMP3		CURR	23
WT_WTEXMN	Exemption Certificate Number	WT_EXNR		CHAR	25
KOART	Account type	KOART		CHAR	1
WT_ACCO	Vendor/Customer Account Number	WT_ACNO		CHAR	10
HKONT	General Ledger Account	HKONT	SKA1	CHAR	10
HKONT_OPP	General Ledger Account	HKONT	SKA1	CHAR	10
QSREC	Type of Recipient	WT_QSREC	T059C	CHAR	2
AUGBL	Document Number of the Clearing Document	AUGBL		CHAR	10
AUGDT	Clearing Date	AUGDT		DATS	8
WT_QSZRT	Exemption Rate	WT_EXRT		DEC	5
WT_WDMBTR	Withholding Tax Amount Already Withheld in Local Currency	WT_AWT		CURR	23
WT_WWRBTR	Withholding Tax Amount Already Withheld in Document Currency	WT_AWT1		CURR	23
WT_WDMBT2	Withholding tax amount already withheld in 2nd local curr.	WT_AWT2		CURR	23
WT_WDMBT3	Withholding Tax Amt Already Withheld in 3rd Local Currency	WT_AWT3		CURR	23
TEXT15	Text (15 characters)	TEXT15		CHAR	15
WT_QBUIHH	Withholding Tax Amount Entered Manually in Local Currency	WT_QBUIHH		CURR	23
WT_QBUIHB	Withholding Tax Amount Entered Manually in Document Currency	WT_QBUIHB		CURR	23
WT_QBUIH2	Withholding Tax Amount Entered Manually in 2nd Local Curr.	WT_QBUIH2		CURR	23
WT_QBUIH3	Withholding Tax Amount Entered Manually in 3rd Local Curr.	WT_QBUIH3		CURR	23
WT_ACCBS	Accumulated Withholding Tax Base Amount in Local Currency	WT_ACCBS		CURR	23
WT_ACCWT	Accumulated Withholding Tax Amount in Local Currency	WT_ACCWT		CURR	23
WT_ACCWTA	Accumulated Auxiliary WTax Amount in Local Currency	WT_ACCWTA		CURR	23
WT_ACCWTHA	Accumulated Auxiliary WTax Amount in Local Currency	WT_ACCWTHA		CURR	23
WT_ACCBS1	Accumulated Withholding Tax Base Amount in Local Currency	WT_ACCBS		CURR	23
WT_ACCWT1	Accumulated Withholding Tax Amount in Local Currency	WT_ACCWT		CURR	23
WT_ACCWTA1	Accumulated Auxiliary WTax Amount in Local Currency	WT_ACCWTA		CURR	23
WT_ACCWTHA1	Accumulated Auxiliary WTax Amount in Local Currency	WT_ACCWTHA		CURR	23
WT_ACCBS2	Accumulated Withholding Tax Base Amount in Local Currency	WT_ACCBS		CURR	23
WT_ACCWT2	Accumulated Withholding Tax Amount in Local Currency	WT_ACCWT		CURR	23
WT_ACCWTA2	Accumulated Auxiliary WTax Amount in Local Currency	WT_ACCWTA		CURR	23
WT_ACCWTHA2	Accumulated Auxiliary WTax Amount in Local Currency	WT_ACCWTHA		CURR	23
QSATZ	Withholding Tax Rate	WT_QSATZ		DEC	7
WT_SLFWTPD	Indicator: Entry Posted as Self-Withholding Tax	WT_SLFWTPD		CHAR	1
WT_OPOWTPD	Indicator: Entry Posted as Debit/Credit	WT_OPOWTPD		CHAR	1
WT_GIVENPD	Indicator: Withholding Tax Amount Entered Manually with Payt	WT_GIVENPD		CHAR	1
CTNUMBER	Withholding Tax Certificate Number	CTNUMBER		CHAR	10
WT_DOWNC	Indicator: Entry Belongs to a Down Payment Clearing Item	WT_DOWNC		CHAR	1
WT_RESITEM	Indicator: Entry Belongs to a Residual Item	WT_RESITEM		CHAR	1
CTISSUEDATE	Issue or Print Date of Withholding Tax Certificate	CTISSUEDATE		DATS	8
J_1AF_WT_REPBS	Withholding tax base amount in local currency for reporting	J_1AF_WT_REPBS		CURR	23
WT_CALC	Withholding Tax Already Calculated/Determined?	WT_CALC		CHAR	2
WT_LOGSYS	Logical System in Which the Withholding Tax Was Calculated	WT_LOGSYS		CHAR	10
_DATAAGING	Data Filter Value for Data Aging	DATA_TEMPERATURE		DATS	8
FIWTCO_PEN_VOL_DEDO	Voluntary Pension Contribution	FIWTCO_PEN_VOL_DEDO		CURR	23
VOL_CONTRIBUTION	Volunteers' Pension Contribution	VOL_CONTRIBUTION		CURR	23
CO_MAX_DEDUCTION	Maximum Deduction	CO_MAX_DEDUCTION		CURR	23
FIWTCO_MAND_BASE	Mandatory Contributions Base	FIWTCO_MAND_BASE		CURR	13
J_1BWHTCOLLCODE	Official Withholding Tax Collection Code	J_1BWHTCOLL	T059Z_WITHCD2	CHAR	16
J_1BWHTRATE	Tax Rate	J_1BTXRATE		DEC	6
J_1BWHT_BS	Withholding Tax Base Amount from Nota Fiscal	J_1BWHT_BS_FI_CS		CURR	23
J_1BWHTACCBS	Accumulated withholding tax real base amount(local currency)	J_1BWHT_ACCRB_FI_CS		CURR	23
J_1BWHTACCBS1	Accumulated withholding tax real base amount(local currency)	J_1BWHT_ACCRB_FI_CS		CURR	23
J_1BWHTACCBS2	Accumulated withholding tax real base amount(local currency)	J_1BWHT_ACCRB_FI_CS		CURR	23
J_1IINTCHLN	Challan Number	J_1IINTCHLN		CHAR	12
J_1IEWTREC	Record type for EWT transactions-India	J_1IEWTREC		CHAR	1
J_1IBUZEI	Number of Line Item Within Accounting Document	BUZEI		NUMC	3
J_1ICERTDT	Certificate Date	J_1ICERTDT		DATS	8
J_1ICLRAMT	Amount of EWT for which certificate is received from Custome	J_1ICLRAMT		CURR	23
J_1IREBZG	Document No. of the Invoice to Which the Transaction Belongs	REBZG		CHAR	10
J_1ISURAMT	Surcharge amount	J_1ISURAMT		CURR	13
FIWTIN_PAR_EXEM	Partial Exemption	FIWTIN_PAR_EXEM_IND		CHAR	1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WITH_ITEM

Table Name	Field	Cardinality	Check Table
WITH_ITEM	BUKRS	1: CN	T001
WITH_ITEM	HKONT	1: CN	SKA1
WITH_ITEM	HKONT_OPP	1: CN	SKA1
WITH_ITEM	J_1BWHTCOLLCODE	C: CN	T059Z_WITHCD2
WITH_ITEM	MANDT	1: CN	T000
WITH_ITEM	QSREC	1: CN	T059C
WITH_ITEM	WITHT	1: CN	T059P
WITH_ITEM	WT_WITHCD	1: CN	T059Z

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

Overview

Techincal Settings of WITH_ITEM

List of WITH_ITEM Fields

Foreign Key Relationships

Other References