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 |
Possible values
|
||||||||
CHECKSUMSPLIT | Split Indicator for Totals Document During Check Deposit | CJCHECKSUMSPLIT | CHAR | 2 | 0 |
Possible values
|
||||||||
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 |
Possible values
|
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 |