1. SAP Tutorial
  2. FI Module

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

Here we would like to draw your attention to TCJ_DOCUMENTS 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_DOCUMENTS is a SAP standard transp table used for storing Cash Journal Documents (Header Data) related data in SAP. It comes under the package CAJO.

SAP TCJ_DOCUMENTS table

Table TCJ_DOCUMENTS technical data

TableTCJ_DOCUMENTS
Data storingCash Journal Documents (Header Data)
ModuleFI
Sub ModuleFI-GL-GL-AP
SAP PackageCAJO
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP TCJ_DOCUMENTS 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_DOCUMENTS 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
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • H_RECEIPTS : Cash Journal Amount Field with +/- Sign
    Its data type is CURR (Currency Field) with field length 15
  • H_PAYMENTS : Cash Journal Amount Field with +/- Sign
    Its data type is CURR (Currency Field) with field length 15
  • H_NET_AMOUNT : Cash Journal Document Net Amount – Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • H_NET_PAYMENT_WT : Net Payment Amount (Withholding Tax Deducted)
    Its data type is CURR (Currency Field) with field length 15
  • H_TAX_AMOUNT : Tax amount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • BP_NAME : Name of Receipt Recipient
    Its data type is CHAR (Character String) with field length 35
  • DOCUMENT_DATE : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DOCUMENT_NUMBER : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • POSTING_DATE : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DOCUMENT_STATUS : Cash Journal Entry Document Status
    Its data type is CHAR (Character String) with field length 2
  • ACCOUNTANT : User name
    Its data type is CHAR (Character String) with field length 12
  • PRINT_IND : Cash Journal Print Indicator
    Its data type is CHAR (Character String) with field length 1
  • TAX_PERCENT : Tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • D_POSTING_NUMB : Cash Journal Document Number for Display
    Its data type is CHAR (Character String) with field length 10
  • TEXT1 : Additional Field 1 for Cash Journal Document Header
    Its data type is CHAR (Character String) with field length 100
  • TEXT2 : Additional Field 2 for Cash Journal Document Header
    Its data type is CHAR (Character String) with field length 30
  • MEANS_OF_PAYMENT : Cash Journal Means of Payment
    Its data type is CHAR (Character String) with field length 1
  • CHECK_NUMBER : 13-digit check number
    Its data type is NUMC (Character String with Digits Only) with field length 13
  • CHECK_ISSUER : Check Issuer (Cash Journal)
    Its data type is CHAR (Character String) with field length 14
  • BANK_KEY : Bank Keys
    Its data type is CHAR (Character String) with field length 15
  • BANK_ACCT : Bank account number
    Its data type is CHAR (Character String) with field length 18
  • BANK_CTRY : Bank country key
    Its data type is CHAR (Character String) with field length 3
  • CHECK_STACK : Number of Check Lot in Cash Journal
    Its data type is CHAR (Character String) with field length 8
  • CHECK_STATUS : Posting Status for Checks in Cash Journal
    Its data type is CHAR (Character String) with field length 1
  • REVBELNR : Reversal Document Number for Cash Journal Document
    Its data type is CHAR (Character String) with field length 10
  • EXCH_RATE : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • SECCO : Section Code
    Its data type is CHAR (Character String) with field length 4
  • SPLIT : Split Information for Cash Journal Document
    Its data type is CHAR (Character String) with field length 1
  • LZBKZ : State central bank indicator
    Its data type is CHAR (Character String) with field length 3
  • LANDL : Supplying Country
    Its data type is CHAR (Character String) with field length 3
  • CHECK_FY : Fiscal Year of Check Deposit
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • VALUTA_DATE : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VATDATE : Tax Reporting Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8

    • TCJ_DOCUMENTS related tables

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

    TCJ_DOCUMENTS related transaction codes under SAP package CAJO

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

    Related References

    Related Tutorials

    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...

    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_CHECK_STACKS SAP table for – Check Lists in Cash Journal

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

    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...

    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_CJ_NAMES SAP table for – Cash Journal Names

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

    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...

    «
    »