SAP Table J_1AWITH

Withholding transaction data

The table J_1AWITH (Withholding transaction data) is a standard table in SAP ERP. It belongs to the package J1AF.

Technical Information

Table	J_1AWITH
Short Text	Withholding transaction data
Package	J1AF
Table Type	Transparent Table

Fields for Table J_1AWITH

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
BUKRS	✔	Company Code	BUKRS	CHAR	4	T001
J_1AWTPKEY	✔	Partial key of withholding information	J_1AWTPKEY	CHAR	24
WITHT	✔	Indicator for withholding tax type	WITHT	CHAR	2	T059P
J_1AWITHCD		Withholding tax code	WT_WITHCD	CHAR	2	*
J_1AQSSHH		Withholding tax base amount (local currency)	WT_BS	CURR	15
J_1AQSSHB		Withholding tax base amount in document currency	WT_BS1	CURR	15
J_1AQSSH2		Withholding tax base amount in 2nd local currency	WT_BS2	CURR	15
J_1AQSSH3		Withholding tax base amount in 3rd local currency	WT_BS3	CURR	15
J_1ABASMAN		Indicator: Withholding tax base amount entered manually	WT_BASMAN	CHAR	1
J_1AQSSHHC		Withholding tax base amount in LC for calculation	WT_BSC	CURR	15
J_1AQSSHBC		Withholding tax base amount in doc. currency for calculation	WT_BS1C	CURR	15
J_1AQSSH2C		With/tax base amount in 2nd local currency for calculation	WT_BS2C	CURR	15
J_1AQSSH3C		Withholding tax base amount in 3rd local currency for calc.	WT_BS3C	CURR	15
J_1AQBSHH		Withholding tax amount (in local currency)	WT_WT	CURR	15
J_1AQBSHB		Withholding tax amount in document currency	WT_WT1	CURR	15
J_1AQBSH2		Withholding tax amount in 2nd local currency	WT_WT2	CURR	15
J_1AQBSH3		Withholding tax amount in 3rd local currency	WT_WT3	CURR	15
J_1AAMNMAN		Indicator: Withholding tax amount entered manually	WT_AMNMAN	CHAR	1
J_1AREPRT		Indicator: Entry posted as self-withholding tax	WT_SLFWTPD	CHAR	1
J_1ASTAT		Line item status	WT_STAT	CHAR	1
J_1AQSFHH		Amount exempt from withholding tax in local currency	WT_EXMP	CURR	15
J_1AQSFHB		Amount exempt from withholding tax in document currency	WT_EXMP1	CURR	15
J_1AQSFH2		Withholding tax exempt amount in 2nd local currency	WT_EXMP2	CURR	15
J_1AQSFH3		Withholding tax exempt amount in 3rd local currency	WT_EXMP3	CURR	15
J_1AWTEXMN		Exemption certificate number	WT_EXNR	CHAR	15
KOART		Account Type	KOART	CHAR	1
J_1AACCO		Account number of vendor/customer	J_1AACNO	CHAR	10
HKONT		General Ledger Account	HKONT	CHAR	10	SKA1
QSREC		Type of recipient	WT_QSREC	CHAR	2	*
AUGBL		Document Number of the Clearing Document	AUGBL	CHAR	10
AUGDT		Clearing Date	AUGDT	DATS	8
J_1AQSZRT		Exemption rate	J_1AEXRT	DEC	5
J_1AWDMBTR		Withholding tax amount (in local currency) already withheld	WT_AWT	CURR	15
J_1AWWRBTR		Withholding tax amount already withheld in document currency	WT_AWT1	CURR	15
J_1AWDMBT2		Withholding tax amount already withheld in 2nd local curr.	WT_AWT2	CURR	15
J_1AWDMBT3		With/tax amount already withheld in 3rd local currency	WT_AWT3	CURR	15
TEXT15		Text (15 characters)	TEXT15	CHAR	15
J_1AGWT		Withholding tax amount (in local currency) already withheld	WT_AWT	CURR	15
J_1AGWT1		Withholding tax amount already withheld in document currency	WT_AWT1	CURR	15
J_1AGWT2		Withholding tax amount already withheld in 2nd local curr.	WT_AWT2	CURR	15
J_1AGWT3		With/tax amount already withheld in 3rd local currency	WT_AWT3	CURR	15
J_1AQBUIHH		Enter withholding tax amount in local currency manually	WT_QBUIHH	CURR	15
J_1AQBUIHB		Enter withholding tax amount in document currency manually	WT_QBUIHB	CURR	15
J_1AQBUIH2		Manually entered with/tax amount in 2nd local currency	WT_QBUIH2	CURR	15
J_1AQBUIH3		With/tax amount in 3rd local currency entered manually	WT_QBUIH3	CURR	15
J_1AWTDONE		Indicator: Do not write this entry to the database	WT_WTDONE	CHAR	1
J_1AORIGBS		Withholding tax base amount (local currency)	WT_BS	CURR	15
J_1AORIGWT		Withholding tax amount (in local currency)	WT_WT	CURR	15
J_1ASLFWT		Indicator: Entry posted as self-withholding tax	WT_SLFWTPD	CHAR	1
J_1AACCBS		Accumulated withholding tax base amount in local currency	WT_ACCBS	CURR	15
J_1AACCWT		Accumulated withholding tax amount in local currency	WT_ACCWT	CURR	15
QSATZ		Percentage Subject to Withholding Tax	QPROZ	DEC	5
WT_GIVEN		Indicator: Withholding tax amount entered manually with pmnt	WT_GIVENPD	CHAR	1
J_1ADOWNC		Indicator: Entry belongs to a down payment clearing item	WT_DOWNC	CHAR	1
J_1AFIRST		Indicator: 1st open item cleared by the payment	WT_FIRST	CHAR	1