SAP ABAP Table ISCJ_R_SPLIT_POSTINGS (Structure for Split Additions to Cash Journal)

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_R_SPLIT_POSTINGS	Table Relationship Diagram
Short Description	Structure for Split Additions to Cash Journal

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

History

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