SAP ABAP Table TCJ_POSITIONS (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_POSITIONS	Table Relationship Diagram
Short Description	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	T000
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	POSITION_TYPE	☐	CJPOSTYPE	CJPOSTYPE	CHAR	2	0	Cash Journal Item Type
8	TRANSACT_NUMBER	☐	CJTRANSNUMB	CHAR4	CHAR	4	0	Number of Cash Journal Business Transaction	TCJ_TRANSACTIONS
9	TRANSACT_TYPE	☐	CJTRANSTYP	CJTTYP	CHAR	1	0	Business Transaction Type
10	POSTING_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
11	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
12	P_RECEIPTS	☐	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
13	P_PAYMENTS	☐	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
14	P_NET_AMOUNT	☐	CJNET_AMOUNT	WERTV7	CURR	13	2	Cash Journal Document Net Amount - Document Currency
15	P_NET_PAYMENT_WT	☐	CJNET_PAYMENT_WT	CJAMT	CURR	15	2	Net Payment Amount (Withholding Tax Deducted)
16	P_TAX_AMOUNT	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
17	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
18	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
19	TAX_PERCENT	☐	MSATZ_F05L	PRZ43V	DEC	7	3	Tax rate
20	POSITION_TEXT	☐	CJPOSTEXT	TEXT50	CHAR	50	0	Cash Journal Line Item Text
21	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
22	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
23	.INCLUDE	☐				0	0	Include with Additional Account Assignments for DB Tables
24	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
25	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
26	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
27	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	*
28	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
29	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
30	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
31	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
32	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
33	AFPOS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
34	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
35	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
36	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
37	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
38	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
39	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
40	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
41	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
42	ANLN1	☐	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
43	ANLN2	☐	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
44	BZDAT	☐	BF_BZDAT	DATUM	DATS	8	0	Reference date
45	ANBWA	☐	BF_ANBWA	CHAR3	CHAR	3	0	Asset transaction type
46	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
47	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
48	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
49	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
50	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
51	HKMAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
52	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
53	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
54	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
55	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
56	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
57	RECID_MAN	☐	JV_RECID_M	XFELD	CHAR	1	0	Indicator: Recovery Indicator Set Manually.
58	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
59	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	*
60	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
61	CONDI	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)	*
62	CRPCAL	☐	JV_CRPCAL	XFELD	CHAR	1	0	Flag CRP Calculation: Yes or NO
63	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
64	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
65	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
66	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
67	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
68	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
69	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
70	ERLKZ	☐	REFSETERLK	CHAR1_X	CHAR	1	0	Used earmarked funds set to "Complete"
71	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
72	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
73	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
74	KONTT	☐	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
75	KONTL	☐	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
76	.INCLUDE	☐				0	0
77	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
78	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
79	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
80	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
81	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
82	ALLOC_NMBR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
83	BRANCH	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
84	P_FWBAS	☐	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
85	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
86	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
87	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
88	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TCJ_POSITIONS	CAJO_NUMBER	TCJ_C_JOURNALS	CAJO_NUMBER
2	TCJ_POSITIONS	COMP_CODE	T001	BUKRS
3	TCJ_POSITIONS	CURRENCY	TCURC	WAERS
4	TCJ_POSITIONS	CUSTOMER	KNA1	KUNNR
5	TCJ_POSITIONS	GL_ACCOUNT	SKA1	SAKNR
6	TCJ_POSITIONS	MANDT	T000	MANDT
7	TCJ_POSITIONS	POSTING_NUMBER	TCJ_DOCUMENTS	POSTING_NUMBER
8	TCJ_POSITIONS	PSEGMENT	FAGL_SEGM	SEGMENT
9	TCJ_POSITIONS	SEGMENT	FAGL_SEGM	SEGMENT
10	TCJ_POSITIONS	TAXJURCODE	TTXJ	TXJCD	REF	C	CN
11	TCJ_POSITIONS	TAX_CODE	T007A	MWSKZ
12	TCJ_POSITIONS	TRANSACT_NUMBER	TCJ_TRANSACTIONS	TRANSACT_NUMBER
13	TCJ_POSITIONS	VENDOR_NO	LFA1	LIFNR

History

Last changed by/on	SAP	20130529
SAP Release Created in