SAP ABAP Table J_1AWITH (Withholding transaction data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-OBS (Package) International/Globalization Development - Obsolete Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1AWITH	Table Relationship Diagram
Short Description	Withholding transaction data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	J_1AWTPKEY	☑	J_1AWTPKEY	J_1AWTPKEY	CHAR	24	0	Partial key of withholding information
4	WITHT	☑	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	T059P
5	J_1AWITHCD	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
6	J_1AQSSHH	☐	WT_BS	WERTV8	CURR	15	2	Withholding tax base amount (local currency)
7	J_1AQSSHB	☐	WT_BS1	WERTV8	CURR	15	2	Withholding tax base amount in document currency
8	J_1AQSSH2	☐	WT_BS2	WERTV8	CURR	15	2	Withholding tax base amount in 2nd local currency
9	J_1AQSSH3	☐	WT_BS3	WERTV8	CURR	15	2	Withholding tax base amount in 3rd local currency
10	J_1ABASMAN	☐	WT_BASMAN	XFELD	CHAR	1	0	Indicator: Withholding tax base amount entered manually
11	J_1AQSSHHC	☐	WT_BSC	WERTV8	CURR	15	2	Withholding tax base amount in LC for calculation
12	J_1AQSSHBC	☐	WT_BS1C	WERTV8	CURR	15	2	Withholding tax base amount in doc. currency for calculation
13	J_1AQSSH2C	☐	WT_BS2C	WERTV8	CURR	15	2	With/tax base amount in 2nd local currency for calculation
14	J_1AQSSH3C	☐	WT_BS3C	WERTV8	CURR	15	2	Withholding tax base amount in 3rd local currency for calc.
15	J_1AQBSHH	☐	WT_WT	WERTV8	CURR	15	2	Withholding tax amount (in local currency)
16	J_1AQBSHB	☐	WT_WT1	WERTV8	CURR	15	2	Withholding tax amount in document currency
17	J_1AQBSH2	☐	WT_WT2	WERTV8	CURR	15	2	Withholding tax amount in 2nd local currency
18	J_1AQBSH3	☐	WT_WT3	WERTV8	CURR	15	2	Withholding tax amount in 3rd local currency
19	J_1AAMNMAN	☐	WT_AMNMAN	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually
20	J_1AREPRT	☐	WT_SLFWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as self-withholding tax
21	J_1ASTAT	☐	WT_STAT	WT_STAT	CHAR	1	0	Line item status
22	J_1AQSFHH	☐	WT_EXMP	WERTV8	CURR	15	2	Amount exempt from withholding tax in local currency
23	J_1AQSFHB	☐	WT_EXMP1	WERTV8	CURR	15	2	Amount exempt from withholding tax in document currency
24	J_1AQSFH2	☐	WT_EXMP2	WERTV8	CURR	15	2	Withholding tax exempt amount in 2nd local currency
25	J_1AQSFH3	☐	WT_EXMP3	WERTV8	CURR	15	2	Withholding tax exempt amount in 3rd local currency
26	J_1AWTEXMN	☐	WT_EXNR	CHAR15	CHAR	15	0	Exemption certificate number
27	KOART	☐	KOART	KOART	CHAR	1	0	Account type
28	J_1AACCO	☐	J_1AACNO	CHAR10	CHAR	10	0	Account number of vendor/customer
29	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
30	QSREC	☐	WT_QSREC	WT_QSREC	CHAR	2	0	Type of recipient	*
31	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
32	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
33	J_1AQSZRT	☐	J_1AEXRT	PRZ32	DEC	5	2	Exemption rate
34	J_1AWDMBTR	☐	WT_AWT	WERTV8	CURR	15	2	Withholding tax amount (in local currency) already withheld
35	J_1AWWRBTR	☐	WT_AWT1	WERTV8	CURR	15	2	Withholding tax amount already withheld in document currency
36	J_1AWDMBT2	☐	WT_AWT2	WERTV8	CURR	15	2	Withholding tax amount already withheld in 2nd local curr.
37	J_1AWDMBT3	☐	WT_AWT3	WERTV8	CURR	15	2	With/tax amount already withheld in 3rd local currency
38	TEXT15	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
39	J_1AGWT	☐	WT_AWT	WERTV8	CURR	15	2	Withholding tax amount (in local currency) already withheld
40	J_1AGWT1	☐	WT_AWT1	WERTV8	CURR	15	2	Withholding tax amount already withheld in document currency
41	J_1AGWT2	☐	WT_AWT2	WERTV8	CURR	15	2	Withholding tax amount already withheld in 2nd local curr.
42	J_1AGWT3	☐	WT_AWT3	WERTV8	CURR	15	2	With/tax amount already withheld in 3rd local currency
43	J_1AQBUIHH	☐	WT_QBUIHH	WERTV8	CURR	15	2	Enter withholding tax amount in local currency manually
44	J_1AQBUIHB	☐	WT_QBUIHB	WERTV8	CURR	15	2	Enter withholding tax amount in document currency manually
45	J_1AQBUIH2	☐	WT_QBUIH2	WERTV8	CURR	15	2	Manually entered with/tax amount in 2nd local currency
46	J_1AQBUIH3	☐	WT_QBUIH3	WERTV8	CURR	15	2	With/tax amount in 3rd local currency entered manually
47	J_1AWTDONE	☐	WT_WTDONE	XFELD	CHAR	1	0	Indicator: Do not write this entry to the database
48	J_1AORIGBS	☐	WT_BS	WERTV8	CURR	15	2	Withholding tax base amount (local currency)
49	J_1AORIGWT	☐	WT_WT	WERTV8	CURR	15	2	Withholding tax amount (in local currency)
50	J_1ASLFWT	☐	WT_SLFWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as self-withholding tax
51	J_1AACCBS	☐	WT_ACCBS	WERTV8	CURR	15	2	Accumulated withholding tax base amount in local currency
52	J_1AACCWT	☐	WT_ACCWT	WERTV8	CURR	15	2	Accumulated withholding tax amount in local currency
53	QSATZ	☐	QPROZ	PRZ32	DEC	5	2	Percentage Subject to Withholding Tax
54	WT_GIVEN	☐	WT_GIVENPD	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually with pmnt
55	J_1ADOWNC	☐	WT_DOWNC	XFELD	CHAR	1	0	Indicator: Entry belongs to a down payment clearing item
56	J_1AFIRST	☐	WT_FIRST	XFELD	CHAR	1	0	Indicator: 1st open item cleared by the payment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1AWITH	BUKRS	T001	BUKRS		1	CN
2	J_1AWITH	HKONT	SKA1	SAKNR		1	CN
3	J_1AWITH	MANDT	T000	MANDT		1	CN
4	J_1AWITH	WITHT	T059P	WITHT	KEY	1	CN

History

Last changed by/on	SAP	19980617
SAP Release Created in