SAP table TCJ_DOCUMENTS (Cash Journal Documents (Header Data))

SAP table TCJ_DOCUMENTS has 5 primary key fields being MANDT,COMP_CODE,CAJO_NUMBER,FISC_YEAR,POSTING_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 TCJ_C_JOURNALS CJNR
FISC_YEAR Fiscal Year NUMC 4 0 GJAHR
POSTING_NUMBER Cash Journal Document Number CHAR 10 0 CJBELNR
CURRENCY Currency Key CUKY 5 0 TCURC WAERS
H_RECEIPTS Cash Journal Amount Field with +/- Sign CURR 23 2 CJAMOUNT
H_PAYMENTS Cash Journal Amount Field with +/- Sign CURR 23 2 CJAMOUNT
H_NET_AMOUNT Cash Journal Document Net Amount - Document Currency CURR 23 2 CJNET_AMOUNT
H_NET_PAYMENT_WT Net Payment Amount (Withholding Tax Deducted) CURR 23 2 CJNET_PAYMENT_WT
H_TAX_AMOUNT Tax Amount in Document Currency CURR 23 2 WMWST
BP_NAME Name of Receipt Recipient CHAR 35 0 CJBPNAME
DOCUMENT_DATE Document Date in Document DATS 8 0 BLDAT
DOCUMENT_NUMBER Reference Document Number CHAR 16 0 XBLNR1
POSTING_DATE Posting Date in the Document DATS 8 0 BUDAT
DOCUMENT_STATUS Cash Journal Entry Document Status CHAR 2 0 CJDOCSTAT
C Document was copied
D Document was deleted
E Online checks for data entry were carried out
P Successfully posted (FI/CO interface)
R Document has been reversed
S Successfully saved (in cash journal)
ACCOUNTANT User Name CHAR 12 0 USNAM
PRINT_IND Cash Journal Print Indicator CHAR 1 0 CJPRINTIND
TAX_PERCENT Tax rate DEC 7 3 MSATZ_F05L
D_POSTING_NUMB Cash Journal Document Number for Display CHAR 10 0 CJBELNR_DISP
TEXT1 Additional Field 1 for Cash Journal Document Header CHAR 100 0 CJDOCTEXT100
TEXT2 Additional Field 2 for Cash Journal Document Header CHAR 30 0 CJDOCTEXT30
MEANS_OF_PAYMENT Cash Journal Means of Payment CHAR 1 0 CJMOFPAYM
CHECK_NUMBER 13-Digit Check Number NUMC 13 0 SCKNR_EB
CHECK_ISSUER Check Issuer (Cash Journal) CHAR 14 0 CJCHECKISSUER
BANK_KEY Bank Keys CHAR 15 0 BANKK
BANK_ACCT Bank account number CHAR 18 0 BANKN
BANK_CTRY Country/Region Key of Bank CHAR 3 0 BANKS
CHECK_STACK Number of Check Lot in Cash Journal CHAR 8 0 CJCHECKSTACK
CHECK_STATUS Posting Status for Checks in Cash Journal CHAR 1 0 CJCHECKSTATUS
REVBELNR Reversal Document Number for Cash Journal Document CHAR 10 0 CJREVBELNR
EXCH_RATE Exchange rate DEC 9 5 KURSF
BUPLA Business Place CHAR 4 0 BUPLA
SECCO Section Code CHAR 4 0 SECCO
SPLIT Split Information for Cash Journal Document CHAR 1 0 CJDOCSPLIT
LZBKZ State Central Bank Indicator CHAR 3 0 T015L LZBKZ
LANDL Supplying Country/Region CHAR 3 0 T005 LANDL
CHECK_FY Fiscal Year of Check Deposit NUMC 4 0 CJCHECKSTACKFY
VALUTA_DATE Value date DATS 8 0 VALUT
VATDATE Tax Reporting Date DATS 8 0 VATDATE
BKONT Bank Control Key CHAR 2 0 BKONT
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
IBAN IBAN (International Bank Account Number) CHAR 34 0 IBAN
CJ_ENTRY Transaction code CHAR 40 0 TCODEL
FULFILLDATE Tax Fulfillment Date DATS 8 0 FOT_FULFILLDATE

TCJ_DOCUMENTS foreign key relationships

Table Field Check Table Check Field
0 TCJ_DOCUMENTS CAJO_NUMBER TCJ_C_JOURNALS Cash Journals MANDT
1 TCJ_DOCUMENTS COMP_CODE T001 Company Codes BUKRS
0 TCJ_DOCUMENTS CURRENCY TCURC Currency Codes MANDT
0 TCJ_DOCUMENTS CURRENCY TCURC Currency Codes WAERS
1 TCJ_DOCUMENTS LANDL T005 Countries MANDT
1 TCJ_DOCUMENTS LANDL T005 Countries LAND1
0 TCJ_DOCUMENTS LZBKZ T015L SCB Ratios LZBKZ