1. SAP Tutorial
  2. FI Module

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

    • J_1AWITH related tables

    • J_1AWITH : Withholding transaction data

    Related References

    Related Tutorials

    TCJ_WTAX_ITEMS SAP table for – Withholding Tax Items for Cash Journal Document Items

    TCJ_WTAX_ITEMS table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of Withholding...

    IDWT_EMPDATA_VE SAP table for – To store the employee data for Venezuela payroll

    IDWT_EMPDATA_VE table in SAP FI (Localization in FI) module. This table is used for storing data of To store the...

    RFUMSV00_HIST SAP table for – Maintain data for previous VAT return run

    RFUMSV00_HIST table in SAP FI (Localization in FI) module. This table is used for storing data of Maintain data for...

    FIWT_TAX_AMOUNT SAP table for – Table to maintain withholding tax amounts

    FIWT_TAX_AMOUNT table in SAP FI (Localization in FI) module. This table is used for storing data of Table to maintain...

    DFKKQSR SAP table for – Individual Records for Withholding Tax Report

    DFKKQSR table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    FIEUD_FIDOC_I SAP table for – SAFT: FI Transaction Document Item

    FIEUD_FIDOC_I table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT: FI Transaction...

    IDSAU_WT_CERT SAP table for – Withholding tax certificate details

    IDSAU_WT_CERT table in SAP FI (Localization in FI) module. This table is used for storing data of Withholding tax certificate...

    «
    »