SAP ABAP Table ISCJ_POSTINGS (Cash Journal Structure Screen 0100 SAPMFCJ0)

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	INTTAB	Structure
Structure	ISCJ_POSTINGS	Table Relationship Diagram
Short Description	Cash Journal Structure Screen 0100 SAPMFCJ0

Delivery and Maintenance

Pool/cluster
Delivery Class
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	CAJO_NUMBER	☐	CJNR	CJNR	CHAR	4	0	Cash Journal Number	*
2	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	FISC_YEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	POSTING_NUMBER	☑	CJBELNR	BELNR	CHAR	10	0	Cash Journal Document Number
5	H_RECEIPTS	☐	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
6	H_PAYMENTS	☐	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
7	H_NET_AMOUNT	☐	CJNET_AMOUNT	WERTV7	CURR	13	2	Cash Journal Document Net Amount - Document Currency
8	H_NET_PAYMENT_WT	☐	CJNET_PAYMENT_WT	CJAMT	CURR	15	2	Net Payment Amount (Withholding Tax Deducted)
9	H_TOTAL_AMOUNT	☐	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
10	H_TAX_AMOUNT	☐	FWSTE	WERT7	CURR	13	2	Tax Amount in Document Currency
11	BP_NAME	☐	CJBPNAME	NAME	CHAR	35	0	Name of Receipt Recipient
12	DOCUMENT_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
13	DOCUMENT_NUMBER	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
14	POSTING_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
15	DOCUMENT_STATUS	☐	CJDOCSTAT	CJDOCSTAT	CHAR	2	0	Cash Journal Entry Document Status
16	ACCOUNTANT	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
17	PRINT_IND	☐	CJPRINTIND	BOOLEAN	CHAR	1	0	Cash Journal Print Indicator
18	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
19	TAX_PERCENT	☐	MSATZ_F05L	PRZ43V	DEC	7	3	Tax rate
20	TRANSACT_NAME	☐	CJTRANSTXT	CHAR_25	CHAR	25	0	Cash Journal Business Transaction
21	POSITION_TEXT	☐	CJPOSTEXT	TEXT50	CHAR	50	0	Cash Journal Line Item Text
22	PROCESS_STATUS	☐	CJDOCSTAT	CJDOCSTAT	CHAR	2	0	Cash Journal Entry Document Status
23	VENDOR_NO	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
24	CUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
25	D_POSTING_NUMB	☐	CJBELNR_DISP	BELNR	CHAR	10	0	Cash Journal Document Number for Display
26	TEMP_POSTING_NUMB	☐	CJBELNR_TEMP	BELNR	CHAR	10	0	Temporary Number for Cash Journal Document
27	.INCLUDE	☐				0	0	Include with Additional Account Assignments for DB Tables
28	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
29	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
30	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
31	RMVCT	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	*
32	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
33	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
34	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
35	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	*
36	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
37	AFPOS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
38	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	*
39	KSTRG	☐	KSTRG	KSTRG	CHAR	12	0	Cost Object	*
40	PRZNR	☐	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process	*
41	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
42	PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
43	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
44	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
45	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
46	ANLN1	☐	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
47	ANLN2	☐	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
48	BZDAT	☐	BF_BZDAT	DATUM	DATS	8	0	Reference date
49	ANBWA	☐	BF_ANBWA	CHAR3	CHAR	3	0	Asset transaction type
50	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
51	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
52	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
53	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
54	HRKFT	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
55	HKMAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
56	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	*
57	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
58	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
59	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
60	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
61	RECID_MAN	☐	JV_RECID_M	XFELD	CHAR	1	0	Indicator: Recovery Indicator Set Manually.
62	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
63	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	*
64	VPTNR	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
65	CONDI	☐	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)	*
66	CRPCAL	☐	JV_CRPCAL	XFELD	CHAR	1	0	Flag CRP Calculation: Yes or NO
67	FIKRS	☐	FIKRS	FIKRS	CHAR	4	0	Financial Management Area	*
68	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
69	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
70	FIPEX	☐	FM_FIPEX	FM_FIPEX	CHAR	24	0	Commitment item	*
71	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
72	KBLNR	☐	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds	*
73	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
74	ERLKZ	☐	REFSETERLK	CHAR1_X	CHAR	1	0	Used earmarked funds set to "Complete"
75	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
76	PAOBJNR	☐	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
77	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
78	KONTT	☐	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
79	KONTL	☐	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
80	.INCLUDE	☐				0	0
81	SMIVE	☐	SMIVE	VVSMIVE	CHAR	13	0	Lease-Out Number
82	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
83	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
84	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
85	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
86	TEXT1	☐	CJDOCTEXT100	TEXT100	CHAR	100	0	Additional Field 1 for Cash Journal Document Header
87	TEXT2	☐	CJDOCTEXT30	TEXT30	CHAR	30	0	Additional Field 2 for Cash Journal Document Header
88	LINE_NUMBER	☐	CJLINENUMB	TABIX	INT4	10	0	Line Number in Cash Journal Document Table
89	MEANS_OF_PAYMENT	☐	CJMOFPAYM	CJMOP	CHAR	1	0	Cash Journal Means of Payment
90	CHECK_NUMBER	☐	SCKNR_EB	NUMC13	NUMC	13	0	13-digit check number
91	CHECK_ISSUER	☐	CJCHECKISSUER	TEXT14	CHAR	14	0	Check Issuer (Cash Journal)
92	BANK_KEY	☐	BANKK	BANKK	CHAR	15	0	Bank Keys	BNKA
93	BANK_ACCT	☐	BANKN	BANKN	CHAR	18	0	Bank account number
94	BANK_CTRY	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
95	CHECK_STACK	☐	CJCHECKSTACK	CHAR8	CHAR	8	0	Number of Check Lot in Cash Journal
96	CHECK_STATUS	☐	CJCHECKSTATUS	CJCHSTAT	CHAR	1	0	Posting Status for Checks in Cash Journal
97	CHECK_FY	☐	CJCHECKSTACKFY	GJAHR	NUMC	4	0	Fiscal Year of Check Deposit
98	TEXT	☐	CJCJTEXT30	TEXT30	CHAR	30	0	Additional Field for Cash Journal
99	VALUTA_DATE	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
100	ALLOC_NMBR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
101	LINE_SEL	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
102	BRANCH	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
103	REVBELNR	☐	CJREVBELNR	BELNR	CHAR	10	0	Reversal Document Number for Cash Journal Document
104	EXCH_RATE	☐	KURSF	KURSF	DEC	9	5	Exchange rate
105	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
106	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
107	POSITION_NUMBER	☐	CJBUZEI	BUZEI	NUMC	3	0	Number of Line Item within Cash Journal Document
108	POSITION_TYPE	☐	CJPOSTYPE	CJPOSTYPE	CHAR	2	0	Cash Journal Item Type
109	P_RECEIPTS	☐	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
110	P_PAYMENTS	☐	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
111	P_NET_AMOUNT	☐	CJNET_AMOUNT	WERTV7	CURR	13	2	Cash Journal Document Net Amount - Document Currency
112	P_NET_PAYMENT_WT	☐	CJNET_PAYMENT_WT	CJAMT	CURR	15	2	Net Payment Amount (Withholding Tax Deducted)
113	P_TAX_AMOUNT	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
114	SPLIT	☐	CJDOCSPLIT	CJDSPLIT	CHAR	1	0	Split Information for Cash Journal Document
115	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	T015L
116	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
117	P_FWBAS	☐	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
118	GL_ACCOUNT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKB1
119	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
120	PSEGMENT	☐	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
121	VATDATE	☐	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
122	MAN_TAX	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
123	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
124	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	ISCJ_POSTINGS	BANK_CTRY	T005	LAND1
2	ISCJ_POSTINGS	BANK_KEY	BNKA	BANKL
3	ISCJ_POSTINGS	CUSTOMER	KNA1	KUNNR
4	ISCJ_POSTINGS	GL_ACCOUNT	SKB1	SAKNR
5	ISCJ_POSTINGS	LANDL	T005	LAND1
6	ISCJ_POSTINGS	LZBKZ	T015L	LZBKZ
7	ISCJ_POSTINGS	PSEGMENT	FAGL_SEGM	SEGMENT
8	ISCJ_POSTINGS	SEGMENT	FAGL_SEGM	SEGMENT
9	ISCJ_POSTINGS	TAXJURCODE	TTXJ	TXJCD
10	ISCJ_POSTINGS	TAX_CODE	T007A	MWSKZ
11	ISCJ_POSTINGS	VENDOR_NO	LFA1	LIFNR

History

Last changed by/on	SAP	20131127
SAP Release Created in