SAP Table TCJ_TRANSACTIONS
Cash Journal Business Transactions
TCJ_TRANSACTIONS (Cash Journal Business Transactions) 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_TRANSACTIONS to other SAP tables.
TCJ_TRANSACTIONS 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 | |||||||||||||||
|
TRANSACT_NUMBER
Number of Cash Journal Business Transaction
|
CJTRANSNUMB |
CHAR
|
4 | 0 | ||||||||||||||||
|
TRANSACT_TYPE
Business Transaction Type
|
CJTRANSTYP |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
GL_ACCOUNT
G/L Account Number
|
SAKNR | SKB1 |
CHAR
|
10 | 0 | |||||||||||||||
|
TAX_CODE
Tax on sales/purchases code
|
MWSKZ | T007A |
CHAR
|
2 | 0 | |||||||||||||||
|
CJTRANSCLOSED
Indicator: Business Transaction Blocked?
|
CJTRANSCLOSED |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
UMSKZ
Special G/L Indicator
|
UMSKZ | T074U |
CHAR
|
1 | 0 | |||||||||||||||
|
CJACCCHANGE
Indicator: Account Modifiable during Document Entry
|
CJACCCHANGE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
CJTAXCHANGE
Indicator: Tax Code Modifiable during Document Entry
|
CJTAXCHANGE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
TRANSACT_CLAS
Classification of Cash Journal Business Transaction
|
CJTRANSCLAS |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
TCJ_TRANSACTIONS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TCJ_TRANSACTIONS | COMP_CODE | * |
T001
Company Codes
|
MANDT | |
| TCJ_TRANSACTIONS | COMP_CODE | TCJ_TRANSACTIONS | COMP_CODE |
T001
Company Codes
|
BUKRS |
| TCJ_TRANSACTIONS | GL_ACCOUNT | TCJ_TRANSACTIONS | MANDT |
SKB1
G/L account master (company code)
|
MANDT |
| TCJ_TRANSACTIONS | GL_ACCOUNT | TCJ_TRANSACTIONS | COMP_CODE |
SKB1
G/L account master (company code)
|
BUKRS |
| TCJ_TRANSACTIONS | GL_ACCOUNT | TCJ_TRANSACTIONS | GL_ACCOUNT |
SKB1
G/L account master (company code)
|
SAKNR |
| TCJ_TRANSACTIONS | MANDT | TCJ_TRANSACTIONS | MANDT |
T000
Clients
|
MANDT |
| TCJ_TRANSACTIONS | TAX_CODE | * |
T007A
Tax Keys
|
MANDT | |
| TCJ_TRANSACTIONS | TAX_CODE | * |
T007A
Tax Keys
|
KALSM | |
| TCJ_TRANSACTIONS | TAX_CODE | TCJ_TRANSACTIONS | TAX_CODE |
T007A
Tax Keys
|
MWSKZ |
| TCJ_TRANSACTIONS | UMSKZ | TCJ_TRANSACTIONS | UMSKZ |
T074U
Special G/L Indicator Properties
|
UMSKZ |
| TCJ_TRANSACTIONS | UMSKZ | TCJ_TRANSACTIONS | MANDT |
T074U
Special G/L Indicator Properties
|
MANDT |
| TCJ_TRANSACTIONS | UMSKZ | TCJ_TRANSACTIONS | TRANSACT_TYPE |
T074U
Special G/L Indicator Properties
|
KOART |