REGUPW - W/tax information per w/tax type/FI line item in pmnt run
W/tax information per w/tax type/FI line item in pmnt run information is stored in SAP table REGUPW.
It is part of development package FQST in software component FI-AP-AP-Q. This development package consists of objects that can be grouped under "Infrastructure for withholding tax".
It is part of development package FQST in software component FI-AP-AP-Q. This development package consists of objects that can be grouped under "Infrastructure for withholding tax".
Fields for table REGUPW
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
LAUFD | Date on Which the Program Is to Be Run | X | LAUFD | DATS | 16 | |
LAUFI | Additional Identification | X | LAUFI | CHAR | 12 | |
BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
BELNR | Document Number of an Accounting Document | X | BELNR_D | CHAR | 20 | |
GJAHR | Fiscal Year | X | GJAHR | NUMC | 8 | |
BUZEI | Number of Line Item Within Accounting Document | X | BUZEI | NUMC | 6 | |
WITHT | Indicator for Withholding Tax Type | X | WITHT | CHAR | 4 | T059P |
WT_WITHCD | Withholding Tax Code | WT_WITHCD | CHAR | 4 | T059Z | |
VBLNR | Document Number of the Payment Document | VBLNR | CHAR | 20 | ||
WT_QSSHH | Withholding Tax Base Amount (Local Currency) | WT_BS | CURR | 12 | ||
WT_QSSHB | Withholding Tax Base Amount in Document Currency | WT_BS1 | CURR | 12 | ||
WT_QSSH2 | Withholding Tax Base Amount in Second Local Currency | WT_BS2 | CURR | 12 | ||
WT_QSSH3 | Withholding Tax Base Amount in Third Local Currency | WT_BS3 | CURR | 12 | ||
WT_QSSHHC | Withholding Tax Base Amount in Local Crcy for Calculation | WT_BSC | CURR | 12 | ||
WT_QSSHBC | Withholding Tax Base Amount in Document Crcy for Calculation | WT_BS1C | CURR | 12 | ||
WT_QSSH2C | WTax Base Amount in 2nd Local Currency for Calculation | WT_BS2C | CURR | 12 | ||
WT_QSSH3C | Withholding Tax Base Amount in 3rd Local Currency for Calc. | WT_BS3C | CURR | 12 | ||
WT_QBSHH | Withholding Tax Amount in Local Currency | WT_WT | CURR | 12 | ||
WT_QBSHB | Withholding Tax Amount in Document Currency | WT_WT1 | CURR | 12 | ||
WT_QBSH2 | Withholding Tax Amount in Second Local Currency | WT_WT2 | CURR | 12 | ||
WT_QBSH3 | Withholding Tax Amount in Third Local Currency | WT_WT3 | CURR | 12 | ||
WT_AMNMAN | Indicator: Withholding Tax Amount Entered Manually | WT_AMNMAN | CHAR | 2 | ||
WT_QBSHHA | Withholding Tax Auxiliary Amount in Local Crcy for Reversal | WT_WTA | CURR | 12 | ||
WT_QBSHHB | Withholding Tax Auxiliary Amt 2 in Local Crcy for Reversal | WT_WTB | CURR | 12 | ||
WT_STAT | Line Item Status | WT_STAT | CHAR | 2 | ||
WT_QSFHH | Amount Exempt from Withholding Tax in Local Currency | WT_EXMP | CURR | 12 | ||
WT_QSFHB | Amount Exempt from Withholding Tax in Document Currency | WT_EXMP1 | CURR | 12 | ||
WT_QSFH2 | Amount Exempt from Withholding Tax in 2nd Local Currency | WT_EXMP2 | CURR | 12 | ||
WT_QSFH3 | Amount Exempt from Withholding Tax in 3rd Local Currency | WT_EXMP3 | CURR | 12 | ||
WT_WTEXMN | Exemption Certificate Number | WT_EXNR | CHAR | 50 | ||
KOART | Account type | KOART | CHAR | 2 | ||
WT_ACCO | Vendor/Customer Account Number | WT_ACNO | CHAR | 20 | ||
HKONT | General Ledger Account | HKONT | CHAR | 20 | SKA1 | |
QSREC | Type of Recipient | WT_QSREC | CHAR | 4 | T059C | |
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 20 | ||
AUGDT | Clearing Date | AUGDT | DATS | 16 | ||
WT_QSZRT | Exemption Rate | WT_EXRT | DEC | 3 | ||
WT_WDMBTR | Withholding Tax Amount Already Withheld in Local Currency | WT_AWT | CURR | 12 | ||
WT_WWRBTR | Withholding Tax Amount Already Withheld in Document Currency | WT_AWT1 | CURR | 12 | ||
WT_WDMBT2 | Withholding tax amount already withheld in 2nd local curr. | WT_AWT2 | CURR | 12 | ||
WT_WDMBT3 | Withholding Tax Amt Already Withheld in 3rd Local Currency | WT_AWT3 | CURR | 12 | ||
TEXT15 | Text (15 characters) | TEXT15 | CHAR | 30 | ||
WT_QBUIHH | Withholding Tax Amount Entered Manually in Local Currency | WT_QBUIHH | CURR | 12 | ||
WT_QBUIHB | Withholding Tax Amount Entered Manually in Document Currency | WT_QBUIHB | CURR | 12 | ||
WT_QBUIH2 | Withholding Tax Amount Entered Manually in 2nd Local Curr. | WT_QBUIH2 | CURR | 12 | ||
WT_QBUIH3 | Withholding Tax Amount Entered Manually in 3rd Local Curr. | WT_QBUIH3 | CURR | 12 | ||
WT_ACCBS | Accumulated Withholding Tax Base Amount in Local Currency | WT_ACCBS | CURR | 12 | ||
WT_ACCWT | Accumulated Withholding Tax Amount in Local Currency | WT_ACCWT | CURR | 12 | ||
WT_ACCWTA | Accumulated Auxiliary WTax Amount in Local Currency | WT_ACCWTA | CURR | 12 | ||
WT_ACCWTHA | Accumulated Auxiliary WTax Amount in Local Currency | WT_ACCWTHA | CURR | 12 | ||
WT_ACCBS1 | Accumulated Withholding Tax Base Amount in Local Currency | WT_ACCBS | CURR | 12 | ||
WT_ACCWT1 | Accumulated Withholding Tax Amount in Local Currency | WT_ACCWT | CURR | 12 | ||
WT_ACCWTA1 | Accumulated Auxiliary WTax Amount in Local Currency | WT_ACCWTA | CURR | 12 | ||
WT_ACCWTHA1 | Accumulated Auxiliary WTax Amount in Local Currency | WT_ACCWTHA | CURR | 12 | ||
WT_ACCBS2 | Accumulated Withholding Tax Base Amount in Local Currency | WT_ACCBS | CURR | 12 | ||
WT_ACCWT2 | Accumulated Withholding Tax Amount in Local Currency | WT_ACCWT | CURR | 12 | ||
WT_ACCWTA2 | Accumulated Auxiliary WTax Amount in Local Currency | WT_ACCWTA | CURR | 12 | ||
WT_ACCWTHA2 | Accumulated Auxiliary WTax Amount in Local Currency | WT_ACCWTHA | CURR | 12 | ||
QSATZ | Withholding Tax Rate | WT_QSATZ | DEC | 4 | ||
WT_BSPPH | Withholding Tax Base Amount (Local Currency) | WT_BS | CURR | 12 | ||
WT_BSPPB | Withholding Tax Base Amount in Document Currency | WT_BS1 | CURR | 12 | ||
WT_BSPP2 | Withholding Tax Base Amount in Second Local Currency | WT_BS2 | CURR | 12 | ||
WT_BSPP3 | Withholding Tax Base Amount in Third Local Currency | WT_BS3 | CURR | 12 | ||
WT_SLFWTDP | Indicator: Entry Posted as Self-Withholding Tax | WT_SLFWTPD | CHAR | 2 | ||
WT_GRUWTPD | Indicator: Entry Posted as "Grossing Up" | WT_GRUWTPD | CHAR | 2 | ||
WT_OPOWTPD | Indicator: Entry Posted as Debit/Credit | WT_OPOWTPD | CHAR | 2 | ||
WT_GIVENPD | Indicator: Withholding Tax Amount Entered Manually with Payt | WT_GIVENPD | CHAR | 2 | ||
WT_FIRST | Indicator: First Open Item Cleared by the Payment | WT_FIRST | CHAR | 2 | ||
WT_ORGAMNT | WTax Amount in the Document Currency of the Invoice | WT_ORGAMNT | CURR | 12 | ||
J_1AF_WT_REPBS | Withholding tax base amount in local currency for reporting | J_1AF_WT_REPBS | CURR | 12 | ||
.INCLU--AP | FIWT_REGUPW_IN | 0 | ||||
FIWTIN_PAR_EXEM | Partial Exemption | FIWTIN_PAR_EXEM_IND | CHAR | 2 | ||
.INCLU--AP | J_1BREGUP_BR | 0 | ||||
J_1BWHTCOLLCODE | Official Withholding Tax Collection Code | J_1BWHTCOLL | CHAR | 32 | T059Z_WITHCD2 | |
J_1BWHTRATE | Tax Rate | J_1BTXRATE | DEC | 4 | ||
.INCLUDE | J_1BWHTACCBS_BR | 0 | ||||
J_1BWHT_BS | Withholding Tax Base Amount from Nota Fiscal | J_1BWHT_BS_FI_CS | CURR | 12 | ||
J_1BWHTACCBS | Accumulated withholding tax real base amount(local currency) | J_1BWHT_ACCRB_FI_CS | CURR | 12 | ||
J_1BWHTACCBS1 | Accumulated withholding tax real base amount(local currency) | J_1BWHT_ACCRB_FI_CS | CURR | 12 | ||
J_1BWHTACCBS2 | Accumulated withholding tax real base amount(local currency) | J_1BWHT_ACCRB_FI_CS | CURR | 12 |