SAP Table TCJ_C_JOURNALS

Cash Journals

TCJ_C_JOURNALS (Cash Journals) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TCJ_C_JOURNALS to other SAP tables.

TCJ_C_JOURNALS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
COMP_CODE Company Code BUKRS T001 CHAR 4 0
CAJO_NUMBER Cash Journal Number CJNR CHAR 4 0
GL_ACCOUNT G/L Account Number SAKNR SKB1 CHAR 10 0
CURRENCY Currency Key WAERS TCURC CUKY 5 0
DOC_TYPE_SK Cash Journal Document Type: G/L Account Posting CJDOCTYPSK T003 CHAR 2 0
DOC_TYPE_SO Document Type for Cash Disbursements CJDOCTYPSO T003 CHAR 2 0
DOC_TYPE_KZ Cash Journal Document Type: Payment to Vendor CJDOCTYPKZ T003 CHAR 2 0
DOC_TYPE_KG Cash Journal Document Type: Payment from Vendor CJDOCTYPKG T003 CHAR 2 0
DOC_TYPE_DZ Cash Journal Document: Payment from Customer CJDOCTYPDZ T003 CHAR 2 0
DOC_TYPE_DG Cash Journal Document Type: Payment to Customer CJDOCTYPDG T003 CHAR 2 0
BEGRU Authorization Group BEGRU CHAR 4 0
PERSON1 Cash Journal: Person 1 CJPERSON1 CHAR 40 0
PERSON2 Cash Journal: Person 2 CJPERSON2 CHAR 40 0
TEXT Additional Field for Cash Journal CJCJTEXT30 CHAR 30 0
CJCLOSED Indicator: Cash Journal Closed? CJCLOSED CHAR 1 0
X Yes
NULL No
CHECKSUMSPLIT Split Indicator for Totals Document During Check Deposit CJCHECKSUMSPLIT CHAR 2 0
OP Offsetting Item of Totals Document Split
AL All Items of Totals Document Split
NULL No Split of Line Items of Totals Document
NUMBERING_OUT Numbering Group for Payments CJDNUMOUT TCJ_NUMB_GROUP CHAR 6 0
NUMBERING_IN Numbering Group for Receipts CJDNUMIN TCJ_NUMB_GROUP CHAR 6 0
NUMBERING_IN_CHE Numbering Group for Check Receipts CJDNUMINCHEQUE TCJ_NUMB_GROUP CHAR 6 0
CJSUBST Indicator: Substitution in Cash Journal? CJSUBST CHAR 1 0
X Yes
NULL No

TCJ_C_JOURNALS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCJ_C_JOURNALS COMP_CODE * T001 Company Codes MANDT
TCJ_C_JOURNALS COMP_CODE TCJ_C_JOURNALS COMP_CODE T001 Company Codes BUKRS
TCJ_C_JOURNALS CURRENCY * TCURC Currency Codes MANDT
TCJ_C_JOURNALS CURRENCY TCJ_C_JOURNALS CURRENCY TCURC Currency Codes WAERS
TCJ_C_JOURNALS DOC_TYPE_DG TCJ_C_JOURNALS MANDT T003 Document Types MANDT
TCJ_C_JOURNALS DOC_TYPE_DG TCJ_C_JOURNALS DOC_TYPE_DG T003 Document Types BLART
TCJ_C_JOURNALS DOC_TYPE_DZ TCJ_C_JOURNALS MANDT T003 Document Types MANDT
TCJ_C_JOURNALS DOC_TYPE_DZ TCJ_C_JOURNALS DOC_TYPE_DZ T003 Document Types BLART
TCJ_C_JOURNALS DOC_TYPE_KG TCJ_C_JOURNALS MANDT T003 Document Types MANDT
TCJ_C_JOURNALS DOC_TYPE_KG TCJ_C_JOURNALS DOC_TYPE_KG T003 Document Types BLART
TCJ_C_JOURNALS DOC_TYPE_KZ TCJ_C_JOURNALS MANDT T003 Document Types MANDT
TCJ_C_JOURNALS DOC_TYPE_KZ TCJ_C_JOURNALS DOC_TYPE_KZ T003 Document Types BLART
TCJ_C_JOURNALS DOC_TYPE_SK TCJ_C_JOURNALS DOC_TYPE_SK T003 Document Types BLART
TCJ_C_JOURNALS DOC_TYPE_SK * T003 Document Types MANDT
TCJ_C_JOURNALS DOC_TYPE_SO TCJ_C_JOURNALS MANDT T003 Document Types MANDT
TCJ_C_JOURNALS DOC_TYPE_SO TCJ_C_JOURNALS DOC_TYPE_SO T003 Document Types BLART
TCJ_C_JOURNALS GL_ACCOUNT TCJ_C_JOURNALS MANDT SKB1 G/L account master (company code) MANDT
TCJ_C_JOURNALS GL_ACCOUNT TCJ_C_JOURNALS COMP_CODE SKB1 G/L account master (company code) BUKRS
TCJ_C_JOURNALS GL_ACCOUNT TCJ_C_JOURNALS GL_ACCOUNT SKB1 G/L account master (company code) SAKNR
TCJ_C_JOURNALS MANDT TCJ_C_JOURNALS MANDT T000 Clients MANDT
TCJ_C_JOURNALS NUMBERING_IN TCJ_C_JOURNALS MANDT TCJ_NUMB_GROUP Numbering Group for Cash Documents MANDT
TCJ_C_JOURNALS NUMBERING_IN TCJ_C_JOURNALS NUMBERING_IN TCJ_NUMB_GROUP Numbering Group for Cash Documents GROUP_NAME
TCJ_C_JOURNALS NUMBERING_IN_CHE TCJ_C_JOURNALS MANDT TCJ_NUMB_GROUP Numbering Group for Cash Documents MANDT
TCJ_C_JOURNALS NUMBERING_IN_CHE TCJ_C_JOURNALS NUMBERING_IN_CHE TCJ_NUMB_GROUP Numbering Group for Cash Documents GROUP_NAME
TCJ_C_JOURNALS NUMBERING_OUT TCJ_C_JOURNALS MANDT TCJ_NUMB_GROUP Numbering Group for Cash Documents MANDT
TCJ_C_JOURNALS NUMBERING_OUT TCJ_C_JOURNALS NUMBERING_OUT TCJ_NUMB_GROUP Numbering Group for Cash Documents GROUP_NAME