TCJ_C_JOURNALS SAP table for – Cash Journals

Here we would like to draw your attention to TCJ_C_JOURNALS 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_C_JOURNALS is a SAP standard transp table used for storing Cash Journals related data in SAP. It comes under the package CAJO.

SAP TCJ_C_JOURNALS table

Table TCJ_C_JOURNALS technical data

TableTCJ_C_JOURNALS
Data storingCash Journals
ModuleFI
Sub ModuleFI-GL-GL-AP
SAP PackageCAJO
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_FIN
Table CategoryTRANSP

SAP TCJ_C_JOURNALS 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_C_JOURNALS 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
  • GL_ACCOUNT : G/L Account Number
    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
  • DOC_TYPE_SK : Cash Journal Document Type: G/L Account Posting
    Its data type is CHAR (Character String) with field length 2
  • DOC_TYPE_SO : Document Type for Cash Disbursements
    Its data type is CHAR (Character String) with field length 2
  • DOC_TYPE_KZ : Cash Journal Document Type: Payment to Vendor
    Its data type is CHAR (Character String) with field length 2
  • DOC_TYPE_KG : Cash Journal Document Type: Payment from Vendor
    Its data type is CHAR (Character String) with field length 2
  • DOC_TYPE_DZ : Cash Journal Document: Payment from Customer
    Its data type is CHAR (Character String) with field length 2
  • DOC_TYPE_DG : Cash Journal Document Type: Payment to Customer
    Its data type is CHAR (Character String) with field length 2
  • BEGRU : Authorization Group
    Its data type is CHAR (Character String) with field length 4
  • PERSON1 : Cash Journal: Person 1
    Its data type is CHAR (Character String) with field length 40
  • PERSON2 : Cash Journal: Person 2
    Its data type is CHAR (Character String) with field length 40
  • TEXT : Additional Field for Cash Journal
    Its data type is CHAR (Character String) with field length 30
  • CJCLOSED : Indicator: Cash Journal Closed?
    Its data type is CHAR (Character String) with field length 1
  • CHECKSUMSPLIT : Split Indicator for Totals Document During Check Deposit
    Its data type is CHAR (Character String) with field length 2
  • NUMBERING_OUT : Numbering Group for Payments
    Its data type is CHAR (Character String) with field length 6
  • NUMBERING_IN : Numbering Group for Receipts
    Its data type is CHAR (Character String) with field length 6
  • NUMBERING_IN_CHE : Numbering Group for Check Receipts
    Its data type is CHAR (Character String) with field length 6
  • CJSUBST : Indicator: Substitution in Cash Journal?
    Its data type is CHAR (Character String) with field length 1