REGUPW

W/tax information per w/tax type/FI line item in pmnt run | #transactional | Component: Withholding Tax (Calculation)
Column Name Description
MANDT FK Client
LAUFD Date on Which the Program Is to Be Run
LAUFI Additional Identification
BUKRS FK Company Code
BELNR Document Number of an Accounting Document
GJAHR Fiscal Year
BUZEI Number of Line Item Within Accounting Document
WITHT FK Indicator for Withholding Tax Type
Column Name Description
💲 Currency Key (T001.WAERS):
WT_QSSHH Withholding Tax Base Amount (Local Currency)
WT_QSSHB Withholding Tax Base Amount in Document Currency
WT_QSSHHC Withholding Tax Base Amount in Local Crcy for Calculation
WT_QSSHBC Withholding Tax Base Amount in Document Crcy for Calculation
WT_QBSHH Withholding Tax Amount in Local Currency
WT_QBSHB Withholding Tax Amount in Document Currency
WT_QBSHHA Withholding Tax Auxiliary Amount in Local Crcy for Reversal
WT_QBSHHB Withholding Tax Auxiliary Amt 2 in Local Crcy for Reversal
WT_QSFHH Amount Exempt from Withholding Tax in Local Currency
WT_QSFHB Amount Exempt from Withholding Tax in Document Currency
WT_WDMBTR Withholding Tax Amount Already Withheld in Local Currency
WT_WWRBTR Withholding Tax Amount Already Withheld in Document Currency
WT_QBUIHH Withholding Tax Amount Entered Manually in Local Currency
WT_QBUIHB Withholding Tax Amount Entered Manually in Document Currency
WT_ACCBS Accumulated Withholding Tax Base Amount in Local Currency
WT_ACCWT Accumulated Withholding Tax Amount in Local Currency
WT_ACCWTA Accumulated Auxiliary WTax Amount in Local Currency
WT_ACCWTHA Accumulated Auxiliary WTax Amount in Local Currency
WT_ACCBS1 Accumulated Withholding Tax Base Amount in Local Currency
WT_ACCWT1 Accumulated Withholding Tax Amount in Local Currency
WT_ACCWTA1 Accumulated Auxiliary WTax Amount in Local Currency
WT_ACCWTHA1 Accumulated Auxiliary WTax Amount in Local Currency
WT_ACCBS2 Accumulated Withholding Tax Base Amount in Local Currency
WT_ACCWT2 Accumulated Withholding Tax Amount in Local Currency
WT_ACCWTA2 Accumulated Auxiliary WTax Amount in Local Currency
WT_ACCWTHA2 Accumulated Auxiliary WTax Amount in Local Currency
WT_BSPPH Withholding Tax Base Amount (Local Currency)
WT_BSPPB Withholding Tax Base Amount in Document Currency
J_1AF_WT_REPBS Withholding tax base amount in local currency for reporting
J_1BWHT_BS Withholding Tax Base Amount from Nota Fiscal
J_1BWHTACCBS Accumulated withholding tax real base amount(local currency)
J_1BWHTACCBS1 Accumulated withholding tax real base amount(local currency)
J_1BWHTACCBS2 Accumulated withholding tax real base amount(local currency)
💲 Currency Key of Second Local Currency (BKPF.HWAE2):
WT_QSSH2 Withholding Tax Base Amount in Second Local Currency
WT_QSSH2C WTax Base Amount in 2nd Local Currency for Calculation
WT_QBSH2 Withholding Tax Amount in Second Local Currency
WT_QSFH2 Amount Exempt from Withholding Tax in 2nd Local Currency
WT_WDMBT2 Withholding tax amount already withheld in 2nd local curr.
WT_QBUIH2 Withholding Tax Amount Entered Manually in 2nd Local Curr.
WT_BSPP2 Withholding Tax Base Amount in Second Local Currency
💲 Currency Key of Third Local Currency (BKPF.HWAE3):
WT_QSSH3 Withholding Tax Base Amount in Third Local Currency
WT_QSSH3C Withholding Tax Base Amount in 3rd Local Currency for Calc.
WT_QBSH3 Withholding Tax Amount in Third Local Currency
WT_QSFH3 Amount Exempt from Withholding Tax in 3rd Local Currency
WT_WDMBT3 Withholding Tax Amt Already Withheld in 3rd Local Currency
WT_QBUIH3 Withholding Tax Amount Entered Manually in 3rd Local Curr.
WT_BSPP3 Withholding Tax Base Amount in Third Local Currency
💲 Update Currency for General Ledger Transaction Figures (REGUP.PSWSL):
WT_ORGAMNT WTax Amount in the Document Currency of the Invoice
Column Name Description
Column Name Description
LAUFD Date on Which the Program Is to Be Run
AUGDT Clearing Date
Column Name Description
WT_AMNMAN Indicator: Withholding Tax Amount Entered Manually Show values
WT_STAT Line Item Status Show values
KOART Account type Show values
WT_SLFWTDP Indicator: Entry Posted as Self-Withholding Tax Show values
WT_GRUWTPD Indicator: Entry Posted as "Grossing Up" Show values
WT_OPOWTPD Indicator: Entry Posted as Debit/Credit Show values
WT_GIVENPD Indicator: Withholding Tax Amount Entered Manually with Payt Show values
WT_FIRST Indicator: First Open Item Cleared by the Payment Show values
FIWTIN_PAR_EXEM Partial Exemption Show values
Column Name Description Domain name
VBLNR Document Number of the Payment Document BELNR
WT_WTEXMN Exemption Certificate Number CHAR25
WT_ACCO Vendor/Customer Account Number CHAR10
AUGBL Document Number of the Clearing Document BELNR
WT_QSZRT Exemption Rate PRZ32
TEXT15 Text (15 characters) TEXT15
QSATZ Withholding Tax Rate PRZ34
J_1BWHTRATE Tax Rate J_1BTXRATE
Master Data Relations Join Conditions
Company Code
  • REGUPW.MANDT == T001.MANDT
  • REGUPW.BUKRS == T001.BUKRS
General Ledger Account
  • ?
  • Client
  • General Ledger Account
  • REGUPW.[column in domain "KTOPL"] == SKA1.KTOPL
  • REGUPW.MANDT == SKA1.MANDT
  • REGUPW.HKONT == SKA1.SAKNR
Official Withholding Tax Collection Code
  • Official Withholding Tax Collection Code
  • Client
  • ?
Client REGUPW.MANDT == T000.MANDT
Type of Recipient
  • ?
  • Client
  • Indicator for Withholding Tax Type
  • Type of Recipient
  • REGUPW.[column in domain "LAND1"] == T059C.LAND1
  • REGUPW.MANDT == T059C.MANDT
  • REGUPW.WITHT == T059C.WITHT
  • REGUPW.QSREC == T059C.QSREC
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • ?
  • REGUPW.MANDT == T059P.MANDT
  • REGUPW.WITHT == T059P.WITHT
  • REGUPW.[column in domain "LAND1"] == T059P.LAND1
Withholding Tax Code
  • Indicator for Withholding Tax Type
  • Client
  • ?
  • Withholding Tax Code
  • REGUPW.WITHT == T059Z.WITHT
  • REGUPW.MANDT == T059Z.MANDT
  • REGUPW.[column in domain "LAND1"] == T059Z.LAND1
  • REGUPW.WT_WITHCD == T059Z.WT_WITHCD