SAP table TCJ_CPD (FBCJ: One-Time Account Data of Cash Journal Document Items)

SAP table TCJ_CPD has 6 primary key fields being MANDT,COMP_CODE,CAJO_NUMBER,FISC_YEAR,POSTING_NUMBER,POSITION_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 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 TCJ_DOCUMENTS CJBELNR
POSITION_NUMBER Number of Line Item within Cash Journal Document NUMC 3 0 CJBUZEI
NAME1 Name 1 CHAR 35 0 NAME1_GP
NAME2 Name 2 CHAR 35 0 NAME2_GP
NAME3 Name 3 CHAR 35 0 NAME3_GP
NAME4 Name 4 CHAR 35 0 NAME4_GP
PSTLZ Postal Code CHAR 10 0 PSTLZ
ORT01 City CHAR 35 0 ORT01_GP
LAND1 Country/Region Key CHAR 3 0 LAND1_GP
STRAS Street and House Number CHAR 35 0 STRAS_GP
PFACH PO Box CHAR 10 0 PFACH
PSTL2 P.O. Box Postal Code CHAR 10 0 PSTL2
PSKTO PO Bank Current Acct No. or Building Society Ref. No. CHAR 16 0 PSKTO
BANKN Bank account number CHAR 18 0 BANKN
BANKL Bank Number CHAR 15 0 BANKL
BANKS Country/Region Key of Bank CHAR 3 0 * BANKS
STCD1 Tax Number 1 CHAR 16 0 STCD1
STCD2 Tax Number 2 CHAR 11 0 STCD2
STKZU Liable for VAT CHAR 1 0 STKZU
STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1 0 STKZA
Not subject to equalization tax
X Subject to equalization tax
REGIO Region (State, Province, County) CHAR 3 0 * REGIO
BKONT Bank Control Key CHAR 2 0 BKONT
DTAWS Instruction Key for Data Medium Exchange CHAR 2 0 * DTAWS
DTAMS Report key for data medium exchange CHAR 1 0 DTAMS
Use house bank default value
0 Single data record can be forwarded to the Bundesbank
1 Single data record not to be forwarded to the Bundesbank
XCPDK Indicator: Is the account a one-time account? CHAR 1 0 XCPDK
EMPFG Payment Recipient Code CHAR 16 0 EMPFG
SPRAS Character field of length 1 CHAR 1 0 CHAR_LG_01
FITYP Tax type CHAR 2 0 * J_1AFITP_D
STCDT Tax Number Type CHAR 2 0 * J_1ATOID
STKZN Natural Person CHAR 1 0 STKZN
Legal person
X Natural person
STCD3 Tax Number 3 CHAR 18 0 STCD3
STCD4 Tax Number 4 CHAR 18 0 STCD4
BKREF Reference Details for Bank Details CHAR 20 0 BKREF
J_1KFREPRE Name of Representative CHAR 10 0 REPRES
J_1KFTBUS Type of Business CHAR 30 0 * GESTYP
J_1KFTIND Type of Industry CHAR 30 0 * INDTYP
ANRED Title CHAR 15 0 ANRED
INTAD Internet address of partner company clerk CHAR 130 0 INTAD

TCJ_CPD foreign key relationships

Table Field Check Table Check Field
0 TCJ_CPD CAJO_NUMBER TCJ_C_JOURNALS Cash Journals MANDT
1 TCJ_CPD COMP_CODE T001 Company Codes BUKRS
0 TCJ_CPD POSTING_NUMBER TCJ_DOCUMENTS Cash Journal Documents (Header Data) MANDT
0 TCJ_CPD POSTING_NUMBER TCJ_DOCUMENTS Cash Journal Documents (Header Data) CAJO_NUMBER
0 TCJ_CPD POSTING_NUMBER TCJ_DOCUMENTS Cash Journal Documents (Header Data) FISC_YEAR