SAP table TCJ_C_JOURNALS (Cash Journals)
SAP table TCJ_C_JOURNALS has 3 primary key fields being MANDT,COMP_CODE,CAJO_NUMBER.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| COMP_CODE | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| CAJO_NUMBER | Cash Journal Number | CHAR | 4 | 0 | CJNR | ||
| GL_ACCOUNT | G/L Account Number | CHAR | 10 | 0 | SKB1 | SAKNR | |
| CURRENCY | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| DOC_TYPE_SK | Cash Journal Document Type: G/L Account Posting | CHAR | 2 | 0 | T003 | CJDOCTYPSK | |
| DOC_TYPE_SO | Document Type for Cash Disbursements | CHAR | 2 | 0 | T003 | CJDOCTYPSO | |
| DOC_TYPE_KZ | Cash Journal Document Type: Payment to Vendor | CHAR | 2 | 0 | T003 | CJDOCTYPKZ | |
| DOC_TYPE_KG | Cash Journal Document Type: Payment from Vendor | CHAR | 2 | 0 | T003 | CJDOCTYPKG | |
| DOC_TYPE_DZ | Cash Journal Document: Payment from Customer | CHAR | 2 | 0 | T003 | CJDOCTYPDZ | |
| DOC_TYPE_DG | Cash Journal Document Type: Payment to Customer | CHAR | 2 | 0 | T003 | CJDOCTYPDG | |
| BEGRU | Authorization Group | CHAR | 4 | 0 | BEGRU | ||
| PERSON1 | Cash Journal: Person 1 | CHAR | 40 | 0 | CJPERSON1 | ||
| PERSON2 | Cash Journal: Person 2 | CHAR | 40 | 0 | CJPERSON2 | ||
| TEXT | Additional Field for Cash Journal | CHAR | 30 | 0 | CJCJTEXT30 | ||
| CJCLOSED | Indicator: Cash Journal Closed? | CHAR | 1 | 0 | CJCLOSED | ||
| CHECKSUMSPLIT | Split Indicator for Totals Document During Check Deposit | CHAR | 2 | 0 | CJCHECKSUMSPLIT | ||
| NUMBERING_OUT | Numbering Group for Payments | CHAR | 6 | 0 | TCJ_NUMB_GROUP | CJDNUMOUT | |
| NUMBERING_IN | Numbering Group for Receipts | CHAR | 6 | 0 | TCJ_NUMB_GROUP | CJDNUMIN | |
| NUMBERING_IN_CHE | Numbering Group for Check Receipts | CHAR | 6 | 0 | TCJ_NUMB_GROUP | CJDNUMINCHEQUE | |
| CJSUBST | Indicator: Substitution in Cash Journal? | CHAR | 1 | 0 | CJSUBST | ||
| CJSIMULTAN | Indicator: Simultaneous Cash Journal Access Permitted? | CHAR | 1 | 0 | CJSIMULTAN |
TCJ_C_JOURNALS foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 TCJ_C_JOURNALS | COMP_CODE | T001 | Company Codes | BUKRS |
| 1 TCJ_C_JOURNALS | CURRENCY | TCURC | Currency Codes | MANDT |
| 1 TCJ_C_JOURNALS | CURRENCY | TCURC | Currency Codes | WAERS |
| 0 TCJ_C_JOURNALS | DOC_TYPE_DG | T003 | Document Types | MANDT |
| 1 TCJ_C_JOURNALS | DOC_TYPE_DZ | T003 | Document Types | MANDT |
| 0 TCJ_C_JOURNALS | DOC_TYPE_KG | T003 | Document Types | MANDT |
| 1 TCJ_C_JOURNALS | DOC_TYPE_KZ | T003 | Document Types | MANDT |
| 0 TCJ_C_JOURNALS | DOC_TYPE_SK | T003 | Document Types | MANDT |
| 1 TCJ_C_JOURNALS | DOC_TYPE_SO | T003 | Document Types | MANDT |
| 0 TCJ_C_JOURNALS | GL_ACCOUNT | SKB1 | G/L account master (company code) | MANDT |
| 0 TCJ_C_JOURNALS | GL_ACCOUNT | SKB1 | G/L account master (company code) | BUKRS |
| 1 TCJ_C_JOURNALS | NUMBERING_IN | TCJ_NUMB_GROUP | Numbering Group for Cash Documents | MANDT |
| 1 TCJ_C_JOURNALS | NUMBERING_IN | TCJ_NUMB_GROUP | Numbering Group for Cash Documents | GROUP_NAME |
| 0 TCJ_C_JOURNALS | NUMBERING_IN_CHE | TCJ_NUMB_GROUP | Numbering Group for Cash Documents | MANDT |
| 0 TCJ_C_JOURNALS | NUMBERING_IN_CHE | TCJ_NUMB_GROUP | Numbering Group for Cash Documents | GROUP_NAME |
| 1 TCJ_C_JOURNALS | NUMBERING_OUT | TCJ_NUMB_GROUP | Numbering Group for Cash Documents | MANDT |
| 1 TCJ_C_JOURNALS | NUMBERING_OUT | TCJ_NUMB_GROUP | Numbering Group for Cash Documents | GROUP_NAME |