J_1AWITH SAP table for – Withholding transaction data

Here we would like to draw your attention to J_1AWITH table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_1AWITH is a SAP standard transp table used for storing Withholding transaction data related data in SAP. It comes under the package ID-OBS.

SAP J_1AWITH table

Table J_1AWITH technical data

TableJ_1AWITH
Data storingWithholding transaction data
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-OBS
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_APPL
Table CategoryTRANSP

SAP J_1AWITH Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_1AWITH table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • J_1AWTPKEY : Partial key of withholding information
    Its a key field. Its data type is CHAR (Character String) with field length 24
  • WITHT : Indicator for withholding tax type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • J_1AWITHCD : Withholding tax code
    Its data type is CHAR (Character String) with field length 2
  • J_1AQSSHH : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSSHB : Withholding tax base amount in document currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSSH2 : Withholding tax base amount in 2nd local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSSH3 : Withholding tax base amount in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1ABASMAN : Indicator: Withholding tax base amount entered manually
    Its data type is CHAR (Character String) with field length 1
  • J_1AQSSHHC : Withholding tax base amount in LC for calculation
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSSHBC : Withholding tax base amount in doc. currency for calculation
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSSH2C : With/tax base amount in 2nd local currency for calculation
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSSH3C : Withholding tax base amount in 3rd local currency for calc.
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQBSHH : Withholding tax amount (in local currency)
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQBSHB : Withholding tax amount in document currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQBSH2 : Withholding tax amount in 2nd local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQBSH3 : Withholding tax amount in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AAMNMAN : Indicator: Withholding tax amount entered manually
    Its data type is CHAR (Character String) with field length 1
  • J_1AREPRT : Indicator: Entry posted as self-withholding tax
    Its data type is CHAR (Character String) with field length 1
  • J_1ASTAT : Line item status
    Its data type is CHAR (Character String) with field length 1
  • J_1AQSFHH : Amount exempt from withholding tax in local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSFHB : Amount exempt from withholding tax in document currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSFH2 : Withholding tax exempt amount in 2nd local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQSFH3 : Withholding tax exempt amount in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AWTEXMN : Exemption certificate number
    Its data type is CHAR (Character String) with field length 15
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • J_1AACCO : Account number of vendor/customer
    Its data type is CHAR (Character String) with field length 10
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • QSREC : Type of recipient
    Its data type is CHAR (Character String) with field length 2
  • AUGBL : Document Number of the Clearing Document
    Its data type is CHAR (Character String) with field length 10
  • AUGDT : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • J_1AQSZRT : Exemption rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • J_1AWDMBTR : Withholding tax amount (in local currency) already withheld
    Its data type is CURR (Currency Field) with field length 15
  • J_1AWWRBTR : Withholding tax amount already withheld in document currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AWDMBT2 : Withholding tax amount already withheld in 2nd local curr.
    Its data type is CURR (Currency Field) with field length 15
  • J_1AWDMBT3 : With/tax amount already withheld in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • TEXT15 : Text (15 characters)
    Its data type is CHAR (Character String) with field length 15
  • J_1AGWT : Withholding tax amount (in local currency) already withheld
    Its data type is CURR (Currency Field) with field length 15
  • J_1AGWT1 : Withholding tax amount already withheld in document currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AGWT2 : Withholding tax amount already withheld in 2nd local curr.
    Its data type is CURR (Currency Field) with field length 15
  • J_1AGWT3 : With/tax amount already withheld in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQBUIHH : Enter withholding tax amount in local currency manually
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQBUIHB : Enter withholding tax amount in document currency manually
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQBUIH2 : Manually entered with/tax amount in 2nd local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AQBUIH3 : With/tax amount in 3rd local currency entered manually
    Its data type is CURR (Currency Field) with field length 15
  • J_1AWTDONE : Indicator: Do not write this entry to the database
    Its data type is CHAR (Character String) with field length 1
  • J_1AORIGBS : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • J_1AORIGWT : Withholding tax amount (in local currency)
    Its data type is CURR (Currency Field) with field length 15
  • J_1ASLFWT : Indicator: Entry posted as self-withholding tax
    Its data type is CHAR (Character String) with field length 1
  • J_1AACCBS : Accumulated withholding tax base amount in local currency
    Its data type is CURR (Currency Field) with field length 15
  • J_1AACCWT : Accumulated withholding tax amount in local currency
    Its data type is CURR (Currency Field) with field length 15
  • QSATZ : Percentage Subject to Withholding Tax
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WT_GIVEN : Indicator: Withholding tax amount entered manually with pmnt
    Its data type is CHAR (Character String) with field length 1
  • J_1ADOWNC : Indicator: Entry belongs to a down payment clearing item
    Its data type is CHAR (Character String) with field length 1
  • J_1AFIRST : Indicator: 1st open item cleared by the payment
    Its data type is CHAR (Character String) with field length 1