1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to TCJ_WTAX_ITEMS table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). TCJ_WTAX_ITEMS is a SAP standard transp table used for storing Withholding Tax Items for Cash Journal Document Items related data in SAP. It comes under the package CAJO.

SAP TCJ_WTAX_ITEMS table

Table TCJ_WTAX_ITEMS technical data

TableTCJ_WTAX_ITEMS
Data storingWithholding Tax Items for Cash Journal Document Items
ModuleFI
Sub ModuleFI-GL-GL-AP
SAP PackageCAJO
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP TCJ_WTAX_ITEMS 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 TCJ_WTAX_ITEMS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • COMP_CODE : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • CAJO_NUMBER : Cash Journal Number
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FISC_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • POSTING_NUMBER : Cash Journal Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • POSITION_NUMBER : Number of Line Item within Cash Journal Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • WTAXTYPE : Indicator for withholding tax type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • STATUS : Status of withholding tax items for cash journal doc. item
    Its data type is CHAR (Character String) with field length 2
  • VENDOR_NO : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Withholding tax information for FI Interface
  • WT_KEY : Grouping key for withholding tax information
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • WITHT : Indicator for withholding tax type
    Its data type is CHAR (Character String) with field length 2
  • WT_WITHCD : Withholding tax code
    Its data type is CHAR (Character String) with field length 2
  • WT_QSSHH : Withholding tax base amount (local currency)
    Its data type is CURR (Currency Field) with field length 15
  • WT_QSSHB : Withholding tax base amount in document currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QSSH2 : Withholding tax base amount in 2nd local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QSSH3 : Withholding tax base amount in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBUIHH : Enter withholding tax amount in local currency manually
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBUIHB : Enter withholding tax amount in document currency manually
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBUIH2 : Manually entered with/tax amount in 2nd local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBUIH3 : With/tax amount in 3rd local currency entered manually
    Its data type is CURR (Currency Field) with field length 15
  • WT_WDMBTR : Withholding tax amount (in local currency) already withheld
    Its data type is CURR (Currency Field) with field length 15
  • WT_WWRBTR : Withholding tax amount already withheld in document currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_WDMBT2 : Withholding tax amount already withheld in 2nd local curr.
    Its data type is CURR (Currency Field) with field length 15
  • WT_WDMBT3 : With/tax amount already withheld in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_BASMAN : Indicator: Withholding tax base amount entered manually
    Its data type is CHAR (Character String) with field length 1
  • WT_AMNMAN : Indicator: Withholding tax amount entered manually
    Its data type is CHAR (Character String) with field length 1
  • WT_QBSHH : Withholding tax amount (in local currency)
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBSHB : Withholding tax amount in document currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBSH2 : Withholding tax amount in 2nd local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBSH3 : Withholding tax amount in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBSHHA : W/tax auxiliary amount for reversal (in local currency)
    Its data type is CURR (Currency Field) with field length 15
  • WT_QBSHHB : W/tax auxiliary amount 2 in local currency for reversal
    Its data type is CURR (Currency Field) with field length 15
  • WT_STAT : Line item status
    Its data type is CHAR (Character String) with field length 1
  • WT_QSFHH : Amount exempt from withholding tax in local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QSFHB : Amount exempt from withholding tax in document currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QSFH2 : Withholding tax exempt amount in 2nd local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_QSFH3 : Withholding tax exempt amount in 3rd local currency
    Its data type is CURR (Currency Field) with field length 15
  • WT_WTEXMN : 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
  • WT_ACCO : Vendor/customer account number
    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
  • HKONT_OPP : 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
  • WT_QSZRT : Exemption rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • TEXT15 : Text (15 characters)
    Its data type is CHAR (Character String) with field length 15
  • QSATZ : Withholding tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • WT_SLFWTPD : Indicator: Entry posted as self-withholding tax
    Its data type is CHAR (Character String) with field length 1
  • WT_GRUWTPD : Indicator: Entry posted as “Grossing up”
    Its data type is CHAR (Character String) with field length 1
  • WT_OPOWTPD : Indicator: Entry posted as a debit/credit
    Its data type is CHAR (Character String) with field length 1
  • WT_GIVENPD : Indicator: Withholding tax amount entered manually with pmnt
    Its data type is CHAR (Character String) with field length 1
  • CTNUMBER : Withholding Tax Certificate Number
    Its data type is CHAR (Character String) with field length 10
  • WT_DOWNC : Indicator: Entry belongs to a down payment clearing item
    Its data type is CHAR (Character String) with field length 1
  • WT_RESITEM : Indicator: Entry belongs to a residual item
    Its data type is CHAR (Character String) with field length 1
  • CTISSUEDATE : Issue or Print Date of Withholding Tax Certificate
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • WT_CALC : Withholding Tax Already Calculated/Determined?
    Its data type is CHAR (Character String) with field length 2
  • WT_LOGSYS : Logical System in Which the Withholding Tax Was Calculated
    Its data type is CHAR (Character String) with field length 10

    • TCJ_WTAX_ITEMS related tables

    • TCJ_TRANSACTIONS : Cash Journal Business Transactions
    • TCJ_CPD : FBCJ: One-Time Account Data of Cash Journal Document Items
    • TCJ_CJ_NAMES : Cash Journal Names
    • TCJ_CHECK_STACKS : Check Lists in Cash Journal
    • TCJ_C_JOURNALS : Cash Journals
    • TCJ_POSITIONS : Cash Journal Document Items
    • TCJ_PRINT : Cash Journal Print Parameters
    • TCJ_MAX_AMOUNT : Cash Journal: Amount Limit
    • TCJ_DOCUMENTS : Cash Journal Documents (Header Data)
    • TCJ_WTAX_ITEMS : Withholding Tax Items for Cash Journal Document Items
    • TCJ_NUMB_GROUPT : Numbering Group for Cash Documents (Text)
    • TCJ_NUMB_GROUP : Numbering Group for Cash Documents
    • TCJ_TRANS_NAMES : Cash Journal Business Transaction Names

    TCJ_WTAX_ITEMS related transaction codes under SAP package CAJO

    • FBCJC1 : Cash Journal Document Number Range
    • FBCJC5 : Maintain Numb. Groups for Cash Docs
    • FBCJC3 : C FI Maintain Tables TCJ_PRINT
    • FBCJ3 : Display Cash Journal
    • FBCJC2 : C FI Maint. Tables TCJ_TRANSACTIONS
    • FBCJC0 : C FI Maintain Tables TCJ_C_JOURNALS
    • FBCJC6 : Number range maintenance: CAJO_DOC3
    • FBCJ : Cash Journal

    Related References

    Related Tutorials

    TCJ_POSITIONS SAP table for – Cash Journal Document Items

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

    TCJ_CPD SAP table for – FBCJ: One-Time Account Data of Cash Journal Document Items

    TCJ_CPD table in SAP FI (General Ledger Accounting in FI) module. This table is used for storing data of FBCJ:...

    TCJ_DOCUMENTS SAP table for – Cash Journal Documents (Header Data)

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

    TCJ_MAX_AMOUNT SAP table for – Cash Journal: Amount Limit

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

    J_1AWITH SAP table for – Withholding transaction data

    J_1AWITH table in SAP FI (Localization in FI) module. This table is used for storing data of Withholding transaction data....

    FBCJC1 SAP tcode for – Cash Journal Document Number Range

    FBCJC1 tcode in SAP FI (General Ledger Accounting in FI) module. This transaction code is used for Cash Journal Document...

    TCJ_TRANSACTIONS SAP table for – Cash Journal Business Transactions

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

    «
    »