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

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL-GL-AP (Application Component) G/L Account Posting
     ⤷ CAJO (Package) Cash Journal Development

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TCJ_CPD	Table Relationship Diagram
Short Description	FBCJ: One-Time Account Data of Cash Journal Document Items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	COMP_CODE	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	CAJO_NUMBER	☑	CJNR	CJNR	CHAR	4	0	Cash Journal Number	TCJ_C_JOURNALS
4	FISC_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	POSTING_NUMBER	☑	CJBELNR	BELNR	CHAR	10	0	Cash Journal Document Number	TCJ_DOCUMENTS
6	POSITION_NUMBER	☑	CJBUZEI	BUZEI	NUMC	3	0	Number of Line Item within Cash Journal Document
7	.INCLUDE	☐				0	0	Financial Accounting: One-Time Account Data without Pointer
8	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
9	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
10	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
11	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
12	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
13	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
14	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
15	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
16	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
17	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
18	PSKTO	☐	PSKTO	PSKTO	CHAR	16	0	Account Number of Bank Account At Post Office
19	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
20	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
21	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
22	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
23	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
24	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
25	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
26	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
27	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
28	DTAWS	☐	DTAWS	DTAWS	CHAR	2	0	Instruction key for data medium exchange	*
29	DTAMS	☐	DTAMS	DTAMS	CHAR	1	0	Report key for data medium exchange
30	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
31	EMPFG	☐	EMPFG	EMPFG	CHAR	16	0	Payee code
32	SPRAS	☐	CHAR_LG_01	CHAR_LG_01	CHAR	1	0	Character field of length 1
33	FITYP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	*
34	STCDT	☐	J_1ATOID	J_1ATOID	CHAR	2	0	Tax Number Type	*
35	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
36	STCD3	☐	STCD3	CHAR18	CHAR	18	0	Tax Number 3
37	STCD4	☐	STCD4	CHAR18	CHAR	18	0	Tax Number 4
38	BKREF	☐	BKREF	CHAR20	CHAR	20	0	Reference specifications for bank details
39	J_1KFREPRE	☐	REPRES	REPRES	CHAR	10	0	Name of Representative
40	J_1KFTBUS	☐	GESTYP	GESTYP	CHAR	30	0	Type of Business	*
41	J_1KFTIND	☐	INDTYP	INDTYP	CHAR	30	0	Type of Industry	*
42	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCJ_CPD	CAJO_NUMBER	TCJ_C_JOURNALS	CAJO_NUMBER
2	TCJ_CPD	COMP_CODE	T001	BUKRS
3	TCJ_CPD	POSTING_NUMBER	TCJ_DOCUMENTS	POSTING_NUMBER

History

Last changed by/on	SAP	20130529
SAP Release Created in	470