SAP ABAP Table REGUPW (W/tax information per w/tax type/FI line item in pmnt run)

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	REGUPW	Table Relationship Diagram
Short Description	W/tax information per w/tax type/FI line item in pmnt run

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	LAUFD	☑	LAUFD	DATUM	DATS	8	0	Date on Which the Program Is to Be Run
3	LAUFI	☑	LAUFI	LAUFI	CHAR	6	0	Additional Identification
4	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	BELNR	☑	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
6	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
7	BUZEI	☑	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
8	WITHT	☑	WITHT	WITHT	CHAR	2	0	Indicator for withholding tax type	T059P
9	WT_WITHCD	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	T059Z
10	VBLNR	☐	VBLNR	BELNR	CHAR	10	0	Document Number of the Payment Document
11	WT_QSSHH	☐	WT_BS	WERTV8	CURR	15	2	Withholding tax base amount (local currency)
12	WT_QSSHB	☐	WT_BS1	WERTV8	CURR	15	2	Withholding tax base amount in document currency
13	WT_QSSH2	☐	WT_BS2	WERTV8	CURR	15	2	Withholding tax base amount in 2nd local currency
14	WT_QSSH3	☐	WT_BS3	WERTV8	CURR	15	2	Withholding tax base amount in 3rd local currency
15	WT_QSSHHC	☐	WT_BSC	WERTV8	CURR	15	2	Withholding tax base amount in LC for calculation
16	WT_QSSHBC	☐	WT_BS1C	WERTV8	CURR	15	2	Withholding tax base amount in doc. currency for calculation
17	WT_QSSH2C	☐	WT_BS2C	WERTV8	CURR	15	2	With/tax base amount in 2nd local currency for calculation
18	WT_QSSH3C	☐	WT_BS3C	WERTV8	CURR	15	2	Withholding tax base amount in 3rd local currency for calc.
19	WT_QBSHH	☐	WT_WT	WERTV8	CURR	15	2	Withholding tax amount (in local currency)
20	WT_QBSHB	☐	WT_WT1	WERTV8	CURR	15	2	Withholding tax amount in document currency
21	WT_QBSH2	☐	WT_WT2	WERTV8	CURR	15	2	Withholding tax amount in 2nd local currency
22	WT_QBSH3	☐	WT_WT3	WERTV8	CURR	15	2	Withholding tax amount in 3rd local currency
23	WT_AMNMAN	☐	WT_AMNMAN	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually
24	WT_QBSHHA	☐	WT_WTA	WERTV8	CURR	15	2	W/tax auxiliary amount for reversal (in local currency)
25	WT_QBSHHB	☐	WT_WTB	WERTV8	CURR	15	2	W/tax auxiliary amount 2 in local currency for reversal
26	WT_STAT	☐	WT_STAT	WT_STAT	CHAR	1	0	Line item status
27	WT_QSFHH	☐	WT_EXMP	WERTV8	CURR	15	2	Amount exempt from withholding tax in local currency
28	WT_QSFHB	☐	WT_EXMP1	WERTV8	CURR	15	2	Amount exempt from withholding tax in document currency
29	WT_QSFH2	☐	WT_EXMP2	WERTV8	CURR	15	2	Withholding tax exempt amount in 2nd local currency
30	WT_QSFH3	☐	WT_EXMP3	WERTV8	CURR	15	2	Withholding tax exempt amount in 3rd local currency
31	WT_WTEXMN	☐	WT_EXNR	CHAR15	CHAR	15	0	Exemption certificate number
32	KOART	☐	KOART	KOART	CHAR	1	0	Account type
33	WT_ACCO	☐	WT_ACNO	CHAR10	CHAR	10	0	Vendor/customer account number
34	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
35	QSREC	☐	WT_QSREC	WT_QSREC	CHAR	2	0	Type of recipient	T059C
36	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
37	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
38	WT_QSZRT	☐	WT_EXRT	PRZ32	DEC	5	2	Exemption rate
39	WT_WDMBTR	☐	WT_AWT	WERTV8	CURR	15	2	Withholding tax amount (in local currency) already withheld
40	WT_WWRBTR	☐	WT_AWT1	WERTV8	CURR	15	2	Withholding tax amount already withheld in document currency
41	WT_WDMBT2	☐	WT_AWT2	WERTV8	CURR	15	2	Withholding tax amount already withheld in 2nd local curr.
42	WT_WDMBT3	☐	WT_AWT3	WERTV8	CURR	15	2	With/tax amount already withheld in 3rd local currency
43	TEXT15	☐	TEXT15	TEXT15	CHAR	15	0	Text (15 characters)
44	WT_QBUIHH	☐	WT_QBUIHH	WERTV8	CURR	15	2	Enter withholding tax amount in local currency manually
45	WT_QBUIHB	☐	WT_QBUIHB	WERTV8	CURR	15	2	Enter withholding tax amount in document currency manually
46	WT_QBUIH2	☐	WT_QBUIH2	WERTV8	CURR	15	2	Manually entered with/tax amount in 2nd local currency
47	WT_QBUIH3	☐	WT_QBUIH3	WERTV8	CURR	15	2	With/tax amount in 3rd local currency entered manually
48	WT_ACCBS	☐	WT_ACCBS	WERTV8	CURR	15	2	Accumulated withholding tax base amount in local currency
49	WT_ACCWT	☐	WT_ACCWT	WERTV8	CURR	15	2	Accumulated withholding tax amount in local currency
50	WT_ACCWTA	☐	WT_ACCWTA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
51	WT_ACCWTHA	☐	WT_ACCWTHA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
52	WT_ACCBS1	☐	WT_ACCBS	WERTV8	CURR	15	2	Accumulated withholding tax base amount in local currency
53	WT_ACCWT1	☐	WT_ACCWT	WERTV8	CURR	15	2	Accumulated withholding tax amount in local currency
54	WT_ACCWTA1	☐	WT_ACCWTA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
55	WT_ACCWTHA1	☐	WT_ACCWTHA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
56	WT_ACCBS2	☐	WT_ACCBS	WERTV8	CURR	15	2	Accumulated withholding tax base amount in local currency
57	WT_ACCWT2	☐	WT_ACCWT	WERTV8	CURR	15	2	Accumulated withholding tax amount in local currency
58	WT_ACCWTA2	☐	WT_ACCWTA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
59	WT_ACCWTHA2	☐	WT_ACCWTHA	WERTV8	CURR	15	2	Accumulated auxiliary with/tax amount in local currency
60	QSATZ	☐	WT_QSATZ	PRZ34	DEC	7	4	Withholding tax rate
61	WT_BSPPH	☐	WT_BS	WERTV8	CURR	15	2	Withholding tax base amount (local currency)
62	WT_BSPPB	☐	WT_BS1	WERTV8	CURR	15	2	Withholding tax base amount in document currency
63	WT_BSPP2	☐	WT_BS2	WERTV8	CURR	15	2	Withholding tax base amount in 2nd local currency
64	WT_BSPP3	☐	WT_BS3	WERTV8	CURR	15	2	Withholding tax base amount in 3rd local currency
65	WT_SLFWTDP	☐	WT_SLFWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as self-withholding tax
66	WT_GRUWTPD	☐	WT_GRUWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as "Grossing up"
67	WT_OPOWTPD	☐	WT_OPOWTPD	XFELD	CHAR	1	0	Indicator: Entry posted as a debit/credit
68	WT_GIVENPD	☐	WT_GIVENPD	XFELD	CHAR	1	0	Indicator: Withholding tax amount entered manually with pmnt
69	WT_FIRST	☐	WT_FIRST	XFELD	CHAR	1	0	Indicator: 1st open item cleared by the payment
70	WT_ORGAMNT	☐	WT_ORGAMNT	WERTV8	CURR	15	2	W/tax amount in the document currency of the invoice
71	J_1AF_WT_REPBS	☐	J_1AF_WT_REPBS	WERTV8	CURR	15	2	Withholding tax base amount in local currency for reporting
72	.INCLU--AP	☐				0	0	Additional Brazilian Data in Withholding Tax Data Paymnt Run
73	J_1BWHTCOLLCODE	☐	J_1BWHTCOLL	WITHCD2	CHAR	16	0	Official Withholding Tax Collection Code	T059Z_WITHCD2
74	J_1BWHTRATE	☐	J_1BTXRATE	J_1BTXRATE	DEC	6	2	Tax Rate
75	.INCLUDE	☐				0	0	Accumulated real base amount(Local currency)
76	J_1BWHT_BS	☐	J_1BWHT_BS	WERTV8	CURR	15	2	Withholding Tax Base Amount from Nota Fiscal
77	J_1BWHTACCBS	☐	J_1BWHT_ACCRB	WERTV8	CURR	15	2	Accumulated withholding tax real base amount(local currency)
78	J_1BWHTACCBS1	☐	J_1BWHT_ACCRB	WERTV8	CURR	15	2	Accumulated withholding tax real base amount(local currency)
79	J_1BWHTACCBS2	☐	J_1BWHT_ACCRB	WERTV8	CURR	15	2	Accumulated withholding tax real base amount(local currency)

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in