SAP ABAP Table REGUPW_REP (REGUPW for reporting purposes)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	REGUPW_REP	Table Relationship Diagram
Short Description	REGUPW for reporting purposes

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in