J_1AWITH

Withholding transaction data | #transactional | Component: Localization Financials (generic parts)
Column Name Description
MANDT FK Client
BUKRS FK Company Code
J_1AWTPKEY Partial key of withholding information
WITHT FK Indicator for Withholding Tax Type
Column Name Description
💲 Currency Key (T001.WAERS):
J_1AQSSHH Withholding Tax Base Amount (Local Currency)
J_1AQSSHB Withholding Tax Base Amount in Document Currency
J_1AQSSHHC Withholding Tax Base Amount in Local Crcy for Calculation
J_1AQSSHBC Withholding Tax Base Amount in Document Crcy for Calculation
J_1AQBSHH Withholding Tax Amount in Local Currency
J_1AQBSHB Withholding Tax Amount in Document Currency
J_1AQSFHH Amount Exempt from Withholding Tax in Local Currency
J_1AQSFHB Amount Exempt from Withholding Tax in Document Currency
J_1AWDMBTR Withholding Tax Amount Already Withheld in Local Currency
J_1AWWRBTR Withholding Tax Amount Already Withheld in Document Currency
J_1AGWT Withholding Tax Amount Already Withheld in Local Currency
J_1AGWT1 Withholding Tax Amount Already Withheld in Document Currency
J_1AQBUIHH Withholding Tax Amount Entered Manually in Local Currency
J_1AQBUIHB Withholding Tax Amount Entered Manually in Document Currency
J_1AORIGBS Withholding Tax Base Amount (Local Currency)
J_1AORIGWT Withholding Tax Amount in Local Currency
J_1AACCBS Accumulated Withholding Tax Base Amount in Local Currency
J_1AACCWT Accumulated Withholding Tax Amount in Local Currency
💲 Currency Key of Second Local Currency (BKPF.HWAE2):
J_1AQSSH2 Withholding Tax Base Amount in Second Local Currency
J_1AQSSH2C WTax Base Amount in 2nd Local Currency for Calculation
J_1AQBSH2 Withholding Tax Amount in Second Local Currency
J_1AQSFH2 Amount Exempt from Withholding Tax in 2nd Local Currency
J_1AWDMBT2 Withholding tax amount already withheld in 2nd local curr.
J_1AGWT2 Withholding tax amount already withheld in 2nd local curr.
J_1AQBUIH2 Withholding Tax Amount Entered Manually in 2nd Local Curr.
💲 Currency Key of Third Local Currency (BKPF.HWAE3):
J_1AQSSH3 Withholding Tax Base Amount in Third Local Currency
J_1AQSSH3C Withholding Tax Base Amount in 3rd Local Currency for Calc.
J_1AQBSH3 Withholding Tax Amount in Third Local Currency
J_1AQSFH3 Amount Exempt from Withholding Tax in 3rd Local Currency
J_1AWDMBT3 Withholding Tax Amt Already Withheld in 3rd Local Currency
J_1AGWT3 Withholding Tax Amt Already Withheld in 3rd Local Currency
J_1AQBUIH3 Withholding Tax Amount Entered Manually in 3rd Local Curr.
Column Name Description
Column Name Description
AUGDT Clearing Date
Column Name Description
J_1ABASMAN Indicator: Withholding Tax Base Amount Entered Manually Show values
J_1AAMNMAN Indicator: Withholding Tax Amount Entered Manually Show values
J_1AREPRT Indicator: Entry Posted as Self-Withholding Tax Show values
J_1ASTAT Line Item Status Show values
KOART Account type Show values
J_1AWTDONE Indicator: Do Not Write This Entry to the Database Show values
J_1ASLFWT Indicator: Entry Posted as Self-Withholding Tax Show values
WT_GIVEN Indicator: Withholding Tax Amount Entered Manually with Payt Show values
J_1ADOWNC Indicator: Entry Belongs to a Down Payment Clearing Item Show values
J_1AFIRST Indicator: First Open Item Cleared by the Payment Show values
Column Name Description Domain name
J_1AWITHCD Withholding Tax Code WT_WITHCD
J_1AWTEXMN Exemption Certificate Number CHAR25
J_1AACCO Account number of vendor/customer CHAR10
QSREC Type of Recipient WT_QSREC
AUGBL Document Number of the Clearing Document BELNR
J_1AQSZRT Exemption rate PRZ32
TEXT15 Text (15 characters) TEXT15
QSATZ Percentage Subject to Withholding Tax PRZ32
Master Data Relations Join Conditions
Company code
  • J_1AWITH.MANDT == T001.MANDT
  • J_1AWITH.BUKRS == T001.BUKRS
Account, where the withholding tax is posted
  • ?
  • Client
  • General Ledger Account
  • J_1AWITH.[column in domain "KTOPL"] == SKA1.KTOPL
  • J_1AWITH.MANDT == SKA1.MANDT
  • J_1AWITH.HKONT == SKA1.SAKNR
Client J_1AWITH.MANDT == T000.MANDT
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • ?
  • J_1AWITH.MANDT == T059P.MANDT
  • J_1AWITH.WITHT == T059P.WITHT
  • J_1AWITH.[column in domain "LAND1"] == T059P.LAND1