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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ FI-AP-AP (Application Component) Basic Functions
     ⤷ FQST (Package) Infrastructure for withholding tax

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	WITH_ITEM	Table Relationship Diagram
Short Description	Witholding tax info per W/tax type and FI line item

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	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
4	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
6	WITHT	☑	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	T059P
7	WT_WITHCD	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	T059Z
8	WT_QSSHH	☐	WT_BS	WERTV8	CURR	15	2	Withholding tax base amount (local currency)
9	WT_QSSHB	☐	WT_BS1	WERTV8	CURR	15	2	Withholding tax base amount in document currency
10	WT_QSSH2	☐	WT_BS2	WERTV8	CURR	15	2	Withholding tax base amount in 2nd local currency
11	WT_QSSH3	☐	WT_BS3	WERTV8	CURR	15	2	Withholding tax base amount in 3rd local currency
12	WT_BASMAN	☐	WT_BASMAN	XFELD	CHAR	1	0	Indicator: Withholding tax base amount entered manually
13	WT_QSSHHC	☐	WT_BSC	WERTV8	CURR	15	2	Withholding tax base amount in LC for calculation
14	WT_QSSHBC	☐	WT_BS1C	WERTV8	CURR	15	2	Withholding tax base amount in doc. currency for calculation
15	WT_QSSH2C	☐	WT_BS2C	WERTV8	CURR	15	2	With/tax base amount in 2nd local currency for calculation
16	WT_QSSH3C	☐	WT_BS3C	WERTV8	CURR	15	2	Withholding tax base amount in 3rd local currency for calc.
17	WT_QBSHH	☐	WT_WT	WERTV8	CURR	15	2	Withholding tax amount (in local currency)
18	WT_QBSHB	☐	WT_WT1	WERTV8	CURR	15	2	Withholding tax amount in document currency
19	WT_QBSH2	☐	WT_WT2	WERTV8	CURR	15	2	Withholding tax amount in 2nd local currency
20	WT_QBSH3	☐	WT_WT3	WERTV8	CURR	15	2	Withholding tax amount in 3rd local currency
21	WT_AMNMAN	☐	WT_AMNMAN	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually
22	WT_QBSHHA	☐	WT_WTA	WERTV8	CURR	15	2	W/tax auxiliary amount for reversal (in local currency)
23	WT_QBSHHB	☐	WT_WTB	WERTV8	CURR	15	2	W/tax auxiliary amount 2 in local currency for reversal
24	WT_STAT	☐	WT_STAT	WT_STAT	CHAR	1	0	Line item status
25	WT_QSFHH	☐	WT_EXMP	WERTV8	CURR	15	2	Amount exempt from withholding tax in local currency
26	WT_QSFHB	☐	WT_EXMP1	WERTV8	CURR	15	2	Amount exempt from withholding tax in document currency
27	WT_QSFH2	☐	WT_EXMP2	WERTV8	CURR	15	2	Withholding tax exempt amount in 2nd local currency
28	WT_QSFH3	☐	WT_EXMP3	WERTV8	CURR	15	2	Withholding tax exempt amount in 3rd local currency
29	WT_WTEXMN	☐	WT_EXNR	CHAR15	CHAR	15	0	Exemption certificate number
30	KOART	☐	KOART	KOART	CHAR	1	0	Account type
31	WT_ACCO	☐	WT_ACNO	CHAR10	CHAR	10	0	Vendor/customer account number
32	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
33	HKONT_OPP	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
34	QSREC	☐	WT_QSREC	WT_QSREC	CHAR	2	0	Type of recipient	T059C
35	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
36	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
37	WT_QSZRT	☐	WT_EXRT	PRZ32	DEC	5	2	Exemption rate
38	WT_WDMBTR	☐	WT_AWT	WERTV8	CURR	15	2	Withholding tax amount (in local currency) already withheld
39	WT_WWRBTR	☐	WT_AWT1	WERTV8	CURR	15	2	Withholding tax amount already withheld in document currency
40	WT_WDMBT2	☐	WT_AWT2	WERTV8	CURR	15	2	Withholding tax amount already withheld in 2nd local curr.
41	WT_WDMBT3	☐	WT_AWT3	WERTV8	CURR	15	2	With/tax amount already withheld in 3rd local currency
42	TEXT15	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
43	WT_QBUIHH	☐	WT_QBUIHH	WERTV8	CURR	15	2	Enter withholding tax amount in local currency manually
44	WT_QBUIHB	☐	WT_QBUIHB	WERTV8	CURR	15	2	Enter withholding tax amount in document currency manually
45	WT_QBUIH2	☐	WT_QBUIH2	WERTV8	CURR	15	2	Manually entered with/tax amount in 2nd local currency
46	WT_QBUIH3	☐	WT_QBUIH3	WERTV8	CURR	15	2	With/tax amount in 3rd local currency entered manually
47	WT_ACCBS	☐	WT_ACCBS	WERTV8	CURR	15	2	Accumulated withholding tax base amount in local currency
48	WT_ACCWT	☐	WT_ACCWT	WERTV8	CURR	15	2	Accumulated withholding tax amount in local currency
49	WT_ACCWTA	☐	WT_ACCWTA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
50	WT_ACCWTHA	☐	WT_ACCWTHA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
51	WT_ACCBS1	☐	WT_ACCBS	WERTV8	CURR	15	2	Accumulated withholding tax base amount in local currency
52	WT_ACCWT1	☐	WT_ACCWT	WERTV8	CURR	15	2	Accumulated withholding tax amount in local currency
53	WT_ACCWTA1	☐	WT_ACCWTA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
54	WT_ACCWTHA1	☐	WT_ACCWTHA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
55	WT_ACCBS2	☐	WT_ACCBS	WERTV8	CURR	15	2	Accumulated withholding tax base amount in local currency
56	WT_ACCWT2	☐	WT_ACCWT	WERTV8	CURR	15	2	Accumulated withholding tax amount in local currency
57	WT_ACCWTA2	☐	WT_ACCWTA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
58	WT_ACCWTHA2	☐	WT_ACCWTHA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
59	QSATZ	☐	WT_QSATZ	PRZ34	DEC	7	4	Withholding tax rate
60	WT_SLFWTPD	☐	WT_SLFWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as self-withholding tax
61	WT_GRUWTPD	☐	WT_GRUWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as "Grossing up"
62	WT_OPOWTPD	☐	WT_OPOWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as a debit/credit
63	WT_GIVENPD	☐	WT_GIVENPD	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually with pmnt
64	CTNUMBER	☐	CTNUMBER	CHAR10	CHAR	10	0	Withholding Tax Certificate Number
65	WT_DOWNC	☐	WT_DOWNC	XFELD	CHAR	1	0	Indicator: Entry belongs to a down payment clearing item
66	WT_RESITEM	☐	WT_RESITEM	XFELD	CHAR	1	0	Indicator: Entry belongs to a residual item
67	CTISSUEDATE	☐	CTISSUEDATE	DATUM	DATS	8	0	Issue or Print Date of Withholding Tax Certificate
68	J_1AF_WT_REPBS	☐	J_1AF_WT_REPBS	WERTV8	CURR	15	2	Withholding tax base amount in local currency for reporting
69	WT_CALC	☐	WT_CALC	WT_CALC	CHAR	2	0	Withholding Tax Already Calculated/Determined?
70	WT_LOGSYS	☐	WT_LOGSYS	LOGSYS	CHAR	10	0	Logical System in Which the Withholding Tax Was Calculated	*
71	.INCLU--AP	☐				0	0	Additional Brazilian Data in Withholding Tax Item
72	J_1BWHTCOLLCODE	☐	J_1BWHTCOLL	WITHCD2	CHAR	16	0	Official Withholding Tax Collection Code	T059Z_WITHCD2
73	J_1BWHTRATE	☐	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
74	.INCLUDE	☐				0	0	Accumulated real base amount(Local currency)
75	J_1BWHT_BS	☐	J_1BWHT_BS	WERTV8	CURR	15	2	Withholding Tax Base Amount from Nota Fiscal
76	J_1BWHTACCBS	☐	J_1BWHT_ACCRB	WERTV8	CURR	15	2	Accumulated withholding tax real base amount(local currency)
77	J_1BWHTACCBS1	☐	J_1BWHT_ACCRB	WERTV8	CURR	15	2	Accumulated withholding tax real base amount(local currency)
78	J_1BWHTACCBS2	☐	J_1BWHT_ACCRB	WERTV8	CURR	15	2	Accumulated withholding tax real base amount(local currency)
79	.INCLU--AP	☐				0	0	append for EWT-India
80	J_1IINTCHLN	☐	J_1IINTCHLN	J_1IINTCHLN	CHAR	12	0	Challan Number
81	J_1IINTCHDT	☐	J_1IINTCHDT		DATS	8	0	Challan Date
82	J_1IEWTREC	☐	J_1IEWTREC	J_1IEWTREC	CHAR	1	0	Record type for EWT transactions-India
83	J_1IBUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
84	J_1ICERTDT	☐	J_1ICERTDT	CK_DATUM	DATS	8	0	Certificate Date
85	J_1ICLRAMT	☐	J_1ICLRAMT	WERT7	CURR	13	2	Amount of EWT for which certificate is received from Custome
86	J_1IREBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
87	J_1ISURAMT	☐	J_1ISURAMT	WERTV7	CURR	13	2	Surcharge amount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WITH_ITEM	BUKRS	T001	BUKRS		1	CN
2	WITH_ITEM	HKONT	SKA1	SAKNR		1	CN
3	WITH_ITEM	HKONT_OPP	SKA1	SAKNR		1	CN
4	WITH_ITEM	J_1BWHTCOLLCODE	T059Z_WITHCD2	WITHCD2	KEY	C	CN
5	WITH_ITEM	MANDT	T000	MANDT		1	CN
6	WITH_ITEM	QSREC	T059C	QSREC		1	CN
7	WITH_ITEM	WITHT	T059P	WITHT	KEY	1	CN
8	WITH_ITEM	WT_WITHCD	T059Z	WT_WITHCD		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in