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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
CHECKSUMSPLIT
Split Indicator for Totals Document During Check Deposit
|
CJCHECKSUMSPLIT |
CHAR
|
2 | 0 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||
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 | DOC_TYPE_KG |
T003
Document Types
|
BLART |
| TCJ_C_JOURNALS | DOC_TYPE_KG | TCJ_C_JOURNALS | MANDT |
T003
Document Types
|
MANDT |
| 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 | * |
T003
Document Types
|
MANDT | |
| TCJ_C_JOURNALS | DOC_TYPE_SK | TCJ_C_JOURNALS | DOC_TYPE_SK |
T003
Document Types
|
BLART |
| 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 |