SAP Table TCJ_DOCUMENTS

Cash Journal Documents (Header Data)

TCJ_DOCUMENTS (Cash Journal Documents (Header Data)) 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_DOCUMENTS to other SAP tables.

TCJ_DOCUMENTS 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 TCJ_C_JOURNALS CHAR 4 0
FISC_YEAR Fiscal Year GJAHR NUMC 4 0
POSTING_NUMBER Cash Journal Document Number CJBELNR CHAR 10 0
CURRENCY Currency Key WAERS TCURC CUKY 5 0
H_RECEIPTS Cash Journal Amount Field with +/- Sign CJAMOUNT CURR 15 2
H_PAYMENTS Cash Journal Amount Field with +/- Sign CJAMOUNT CURR 15 2
H_NET_AMOUNT Cash Journal Document Net Amount - Document Currency CJNET_AMOUNT CURR 13 2
H_NET_PAYMENT_WT Net Payment Amount (Withholding Tax Deducted) CJNET_PAYMENT_WT CURR 15 2
H_TAX_AMOUNT Tax amount in document currency WMWST CURR 13 2
BP_NAME Name of Receipt Recipient CJBPNAME CHAR 35 0
DOCUMENT_DATE Document Date in Document BLDAT DATS 8 0
DOCUMENT_NUMBER Reference Document Number XBLNR1 CHAR 16 0
POSTING_DATE Posting Date in the Document BUDAT DATS 8 0
DOCUMENT_STATUS Cash Journal Entry Document Status CJDOCSTAT CHAR 2 0
P Successfully posted (FI/CO interface)
S Successfully saved (in cash journal)
E Online checks for data entry were carried out
D Document was deleted
C Document was copied
R Document has been reversed
ACCOUNTANT User name USNAM CHAR 12 0
PRINT_IND Cash Journal Print Indicator CJPRINTIND CHAR 1 0
X true
- false
NULL unknown
TAX_PERCENT Tax rate MSATZ_F05L DEC 7 3
D_POSTING_NUMB Cash Journal Document Number for Display CJBELNR_DISP CHAR 10 0
TEXT1 Additional Field 1 for Cash Journal Document Header CJDOCTEXT100 CHAR 100 0
TEXT2 Additional Field 2 for Cash Journal Document Header CJDOCTEXT30 CHAR 30 0
MEANS_OF_PAYMENT Cash Journal Means of Payment CJMOFPAYM CHAR 1 0
B Cash
C Check
CHECK_NUMBER 13-digit check number SCKNR_EB NUMC 13 0
CHECK_ISSUER Check Issuer (Cash Journal) CJCHECKISSUER CHAR 14 0
BANK_KEY Bank Keys BANKK CHAR 15 0
BANK_ACCT Bank account number BANKN CHAR 18 0
BANK_CTRY Bank country key BANKS CHAR 3 0
CHECK_STACK Number of Check Lot in Cash Journal CJCHECKSTACK CHAR 8 0
CHECK_STATUS Posting Status for Checks in Cash Journal CJCHECKSTATUS CHAR 1 0
S Check lot successfully saved (in cash journal)
P Check lot successfully posted (Acc interface)
E Online checks for data entry were carried out
D Check lot was deleted
C Check lot was copied
R Check lot was reversed
REVBELNR Reversal Document Number for Cash Journal Document CJREVBELNR CHAR 10 0
EXCH_RATE Exchange rate KURSF DEC 9 5
BUPLA Business Place BUPLA CHAR 4 0
SECCO Section Code SECCO CHAR 4 0
SPLIT Split Information for Cash Journal Document CJDOCSPLIT CHAR 1 0
NULL No split
X Normal Split
LZBKZ State Central Bank Indicator LZBKZ T015L CHAR 3 0
LANDL Supplying Country LANDL T005 CHAR 3 0
CHECK_FY Fiscal Year of Check Deposit CJCHECKSTACKFY NUMC 4 0
VALUTA_DATE Value date VALUT DATS 8 0
VATDATE Tax Reporting Date VATDATE DATS 8 0

TCJ_DOCUMENTS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCJ_DOCUMENTS CAJO_NUMBER TCJ_DOCUMENTS COMP_CODE TCJ_C_JOURNALS Cash Journals COMP_CODE
TCJ_DOCUMENTS CAJO_NUMBER TCJ_DOCUMENTS CAJO_NUMBER TCJ_C_JOURNALS Cash Journals CAJO_NUMBER
TCJ_DOCUMENTS CAJO_NUMBER TCJ_DOCUMENTS MANDT TCJ_C_JOURNALS Cash Journals MANDT
TCJ_DOCUMENTS COMP_CODE TCJ_DOCUMENTS MANDT T001 Company Codes MANDT
TCJ_DOCUMENTS COMP_CODE TCJ_DOCUMENTS COMP_CODE T001 Company Codes BUKRS
TCJ_DOCUMENTS CURRENCY * TCURC Currency Codes MANDT
TCJ_DOCUMENTS CURRENCY TCJ_DOCUMENTS CURRENCY TCURC Currency Codes WAERS
TCJ_DOCUMENTS LANDL TCJ_DOCUMENTS MANDT T005 Countries MANDT
TCJ_DOCUMENTS LANDL TCJ_DOCUMENTS LANDL T005 Countries LAND1
TCJ_DOCUMENTS LZBKZ TCJ_DOCUMENTS MANDT T015L SCB Ratios MANDT
TCJ_DOCUMENTS LZBKZ TCJ_DOCUMENTS LZBKZ T015L SCB Ratios LZBKZ
TCJ_DOCUMENTS MANDT TCJ_DOCUMENTS MANDT T000 Clients MANDT