WITH_ITEM

Witholding tax info per W/tax type and FI line item | #transactional | Component: Withholding Tax (Calculation)
Column Name Description
MANDT FK Client
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
J_1AF_WT_REPBS Withholding tax base amount in local currency for reporting
FIWTCO_PEN_VOL_DEDO Voluntary Pension Contribution
VOL_CONTRIBUTION Volunteers' Pension Contribution
CO_MAX_DEDUCTION Maximum Deduction
FIWTCO_MAND_BASE Mandatory Contributions Base
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)
J_1ICLRAMT Amount of EWT for which certificate is received from Custome
J_1ISURAMT Surcharge amount
💲 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.
💲 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.
Column Name Description
Column Name Description
AUGDT Clearing Date
CTISSUEDATE Issue or Print Date of Withholding Tax Certificate
_DATAAGING Data Filter Value for Data Aging
J_1IINTCHDT Challan Date
J_1ICERTDT Certificate Date
Column Name Description
WT_BASMAN Indicator: Withholding Tax Base Amount Entered Manually Show values
WT_AMNMAN Indicator: Withholding Tax Amount Entered Manually Show values
WT_STAT Line Item Status Show values
KOART Account type Show values
WT_SLFWTPD 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_DOWNC Indicator: Entry Belongs to a Down Payment Clearing Item Show values
WT_RESITEM Indicator: Entry Belongs to a Residual Item Show values
WT_CALC Withholding Tax Already Calculated/Determined? Show values
J_1IEWTREC Record type for EWT transactions-India Show values
FIWTIN_PAR_EXEM Partial Exemption Show values
Column Name Description Domain name
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
CTNUMBER Withholding Tax Certificate Number CHAR10
WT_LOGSYS Logical System in Which the Withholding Tax Was Calculated LOGSYS
J_1BWHTRATE Tax Rate J_1BTXRATE
J_1IINTCHLN Challan Number J_1IINTCHLN
J_1IBUZEI Number of Line Item Within Accounting Document BUZEI
J_1IREBZG Document No. of the Invoice to Which the Transaction Belongs BELNR
Master Data Relations Join Conditions
Company Code
  • WITH_ITEM.MANDT == T001.MANDT
  • WITH_ITEM.BUKRS == T001.BUKRS
General Ledger Account
  • ?
  • Client
  • General Ledger Account
  • WITH_ITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • WITH_ITEM.MANDT == SKA1.MANDT
  • WITH_ITEM.HKONT == SKA1.SAKNR
General Ledger Account
  • ?
  • Client
  • General Ledger Account
  • WITH_ITEM.[column in domain "KTOPL"] == SKA1.KTOPL
  • WITH_ITEM.MANDT == SKA1.MANDT
  • WITH_ITEM.HKONT_OPP == SKA1.SAKNR
Official Withholding Tax Collection Code
  • Official Withholding Tax Collection Code
  • Client
  • ?
Client WITH_ITEM.MANDT == T000.MANDT
Type of Recipient
  • ?
  • Client
  • Indicator for Withholding Tax Type
  • Type of Recipient
  • WITH_ITEM.[column in domain "LAND1"] == T059C.LAND1
  • WITH_ITEM.MANDT == T059C.MANDT
  • WITH_ITEM.WITHT == T059C.WITHT
  • WITH_ITEM.QSREC == T059C.QSREC
Indicator for Withholding Tax Type
  • Indicator for Withholding Tax Type
  • ?
  • WITH_ITEM.MANDT == T059P.MANDT
  • WITH_ITEM.WITHT == T059P.WITHT
  • WITH_ITEM.[column in domain "LAND1"] == T059P.LAND1
Withholding Tax Code
  • Indicator for Withholding Tax Type
  • Client
  • ?
  • Withholding Tax Code
  • WITH_ITEM.WITHT == T059Z.WITHT
  • WITH_ITEM.MANDT == T059Z.MANDT
  • WITH_ITEM.[column in domain "LAND1"] == T059Z.LAND1
  • WITH_ITEM.WT_WITHCD == T059Z.WT_WITHCD