SAP ABAP View V_POSTINGS (View on Cash Journal Posting Documents)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_POSTINGS
Short Description	View on Cash Journal Posting Documents
Root table	TCJ_DOCUMENTS	Cash Journal Documents (Header Data)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TCJ_DOCUMENTS	TCJ_DOCUMENTS
2	TCJ_POSITIONS
3	TCJ_TRANSACTIONS
4	TCJ_TRANS_NAMES

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TCJ_DOCUMENTS	FISC_YEAR	JL	EQ				0	0
2	TCJ_POSITIONS	FISC_YEAR	JR	EQ			AND	0	0
3	TCJ_DOCUMENTS	POSTING_NUMBER	JL	EQ				0	0
4	TCJ_POSITIONS	POSTING_NUMBER	JR	EQ			AND	0	0
5	TCJ_DOCUMENTS	CAJO_NUMBER	JL	EQ				0	0
6	TCJ_POSITIONS	CAJO_NUMBER	JR	EQ			AND	0	0
7	TCJ_DOCUMENTS	COMP_CODE	JL	EQ				0	0
8	TCJ_POSITIONS	COMP_CODE	JR	EQ			AND	0	0
9	TCJ_DOCUMENTS	COMP_CODE	JL	EQ				0	0
10	TCJ_TRANSACTIONS	COMP_CODE	JR	EQ			AND	0	0
11	TCJ_POSITIONS	TRANSACT_NUMBER	JL	EQ				0	0
12	TCJ_TRANSACTIONS	TRANSACT_NUMBER	JR	EQ			AND	0	0
13	TCJ_POSITIONS	TRANSACT_NUMBER	JL	EQ				0	0
14	TCJ_TRANS_NAMES	TRANSACT_NUMBER	JR	EQ			AND	0	0
15	TCJ_TRANSACTIONS	COMP_CODE	JL	EQ				0	0
16	TCJ_TRANS_NAMES	COMP_CODE	JR	EQ			AND	0	0
17	TCJ_DOCUMENTS	MANDT	JL	EQ				0	0
18	TCJ_POSITIONS	MANDT	JR	EQ			AND	0	0
19	TCJ_DOCUMENTS	MANDT	JL	EQ				0	0
20	TCJ_TRANSACTIONS	MANDT	JR	EQ			AND	0	0
21	TCJ_DOCUMENTS	MANDT	JL	EQ				0	0
22	TCJ_TRANS_NAMES	MANDT	JR	EQ			AND	0	0
23	TCJ_POSITIONS	POSITION_TYPE		EQ	'O'		OR	0	0
24	TCJ_POSITIONS	POSITION_TYPE		EQ	'T'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TCJ_DOCUMENTS	MANDT		☐	MANDT	☐	Client
2	FISC_YEAR	TCJ_DOCUMENTS	FISC_YEAR		☐	GJAHR	☐	Fiscal Year
3	POSTING_NUMBER	TCJ_DOCUMENTS	POSTING_NUMBER		☐	CJBELNR	☐	Cash Journal Document Number
4	H_RECEIPTS	TCJ_DOCUMENTS	H_RECEIPTS		☐	CJAMOUNT	☐	Cash Journal Amount Field with +/- Sign
5	H_PAYMENTS	TCJ_DOCUMENTS	H_PAYMENTS		☐	CJAMOUNT	☐	Cash Journal Amount Field with +/- Sign
6	H_NET_AMOUNT	TCJ_DOCUMENTS	H_NET_AMOUNT		☐	CJNET_AMOUNT	☐	Cash Journal Document Net Amount - Document Currency
7	H_NET_PAYMENT_WT	TCJ_DOCUMENTS	H_NET_PAYMENT_WT		☐	CJNET_PAYMENT_WT	☐	Net Payment Amount (Withholding Tax Deducted)
8	H_TAX_AMOUNT	TCJ_DOCUMENTS	H_TAX_AMOUNT		☐	WMWST	☐	Tax amount in document currency
9	BP_NAME	TCJ_DOCUMENTS	BP_NAME		☐	CJBPNAME	☐	Name of Receipt Recipient
10	DOCUMENT_DATE	TCJ_DOCUMENTS	DOCUMENT_DATE		☐	BLDAT	☐	Document Date in Document
11	DOCUMENT_NUMBER	TCJ_DOCUMENTS	DOCUMENT_NUMBER		☐	XBLNR1	☐	Reference Document Number
12	POSTING_DATE	TCJ_DOCUMENTS	POSTING_DATE		☐	BUDAT	☐	Posting Date in the Document
13	DOCUMENT_STATUS	TCJ_DOCUMENTS	DOCUMENT_STATUS		☐	CJDOCSTAT	☐	Cash Journal Entry Document Status
14	PRINT_IND	TCJ_DOCUMENTS	PRINT_IND		☐	CJPRINTIND	☐	Cash Journal Print Indicator
15	TAX_CODE	TCJ_POSITIONS	TAX_CODE		☐	MWSKZ	☐	Tax on sales/purchases code
16	TAX_PERCENT	TCJ_POSITIONS	TAX_PERCENT		☐	MSATZ_F05L	☐	Tax rate
17	POSITION_TEXT	TCJ_POSITIONS	POSITION_TEXT		☐	CJPOSTEXT	☐	Cash Journal Line Item Text
18	TRANSACT_NAME	TCJ_TRANS_NAMES	TRANSACT_NAME		☐	CJTRANSTXT	☐	Cash Journal Business Transaction
19	LONG_TEXT	TCJ_TRANS_NAMES	LONG_TEXT		☐	CJTRANSLTXT	☐	Cash Journal Business Transaction Long Text
20	CAJO_NUMBER	TCJ_DOCUMENTS	CAJO_NUMBER		☐	CJNR	☐	Cash Journal Number
21	COMP_CODE	TCJ_DOCUMENTS	COMP_CODE		☐	BUKRS	☐	Company Code
22	VENDOR_NO	TCJ_POSITIONS	VENDOR_NO		☐	LIFNR	☐	Account Number of Vendor or Creditor
23	CUSTOMER	TCJ_POSITIONS	CUSTOMER		☐	KUNNR	☐	Customer Number
24	D_POSTING_NUMB	TCJ_DOCUMENTS	D_POSTING_NUMB		☐	CJBELNR_DISP	☐	Cash Journal Document Number for Display
25	LANGU	TCJ_TRANS_NAMES	LANGU		☐	SPRAS	☐	Language Key
26	GSBER	TCJ_POSITIONS	GSBER		☐	GSBER	☐	Business Area
27	PARGB	TCJ_POSITIONS	PARGB		☐	PARGB	☐	Trading partner's business area
28	VBUND	TCJ_POSITIONS	VBUND		☐	RASSC	☐	Company ID of trading partner
29	RMVCT	TCJ_POSITIONS	RMVCT		☐	RMVCT	☐	Transaction type
30	FKBER	TCJ_POSITIONS	FKBER		☐	FKBER	☐	Functional Area
31	KOKRS	TCJ_POSITIONS	KOKRS		☐	KOKRS	☐	Controlling Area
32	KOSTL	TCJ_POSITIONS	KOSTL		☐	KOSTL	☐	Cost Center
33	LSTAR	TCJ_POSITIONS	LSTAR		☐	LSTAR	☐	Activity Type
34	AUFNR	TCJ_POSITIONS	AUFNR		☐	AUFNR	☐	Order Number
35	AFPOS	TCJ_POSITIONS	AFPOS		☐	CO_POSNR	☐	Order item number
36	BEMOT	TCJ_POSITIONS	BEMOT		☐	BEMOT	☐	Accounting Indicator
37	KSTRG	TCJ_POSITIONS	KSTRG		☐	KSTRG	☐	Cost Object
38	PRZNR	TCJ_POSITIONS	PRZNR		☐	CO_PRZNR	☐	Business Process
39	PRCTR	TCJ_POSITIONS	PRCTR		☐	PRCTR	☐	Profit Center
40	PPRCTR	TCJ_POSITIONS	PPRCTR		☐	PPRCTR	☐	Partner Profit Center
41	PS_PSP_PNR	TCJ_POSITIONS	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
42	NPLNR	TCJ_POSITIONS	NPLNR		☐	NPLNR	☐	Network Number for Account Assignment
43	VORNR	TCJ_POSITIONS	VORNR		☐	VORNR	☐	Operation/Activity Number
44	ANLN1	TCJ_POSITIONS	ANLN1		☐	BF_ANLN1	☐	Main Asset Number
45	ANLN2	TCJ_POSITIONS	ANLN2		☐	BF_ANLN2	☐	Asset Subnumber
46	BZDAT	TCJ_POSITIONS	BZDAT		☐	BF_BZDAT	☐	Reference date
47	ANBWA	TCJ_POSITIONS	ANBWA		☐	BF_ANBWA	☐	Asset transaction type
48	WERKS	TCJ_POSITIONS	WERKS		☐	WERKS_D	☐	Plant
49	BWTAR	TCJ_POSITIONS	BWTAR		☐	BWTAR_D	☐	Valuation type
50	BWKEY	TCJ_POSITIONS	BWKEY		☐	BWKEY	☐	Valuation area
51	MATNR	TCJ_POSITIONS	MATNR		☐	MATNR	☐	Material Number
52	HRKFT	TCJ_POSITIONS	HRKFT		☐	HRKFT	☐	Origin Group as Subdivision of Cost Element
53	HKMAT	TCJ_POSITIONS	HKMAT		☐	HKMAT	☐	Material-related origin
54	KDAUF	TCJ_POSITIONS	KDAUF		☐	KDAUF	☐	Sales Order Number
55	KDEIN	TCJ_POSITIONS	KDEIN		☐	KDEIN	☐	Delivery schedule for sales order
56	KDPOS	TCJ_POSITIONS	KDPOS		☐	KDPOS	☐	Item number in Sales Order
57	VNAME	TCJ_POSITIONS	VNAME		☐	JV_NAME	☐	Joint venture
58	RECID	TCJ_POSITIONS	RECID		☐	JV_RECIND	☐	Recovery Indicator
59	RECID_MAN	TCJ_POSITIONS	RECID_MAN		☐	JV_RECID_M	☐	Indicator: Recovery Indicator Set Manually.
60	EGRUP	TCJ_POSITIONS	EGRUP		☐	JV_EGROUP	☐	Equity group
61	ETYPE	TCJ_POSITIONS	ETYPE		☐	JV_ETYPE	☐	Equity type
62	VPTNR	TCJ_POSITIONS	VPTNR		☐	JV_PART	☐	Partner account number
63	CONDI	TCJ_POSITIONS	CONDI		☐	JV_CONDCOD	☐	Joint Venture Indicator (Condition Key)
64	CRPCAL	TCJ_POSITIONS	CRPCAL		☐	JV_CRPCAL	☐	Flag CRP Calculation: Yes or NO
65	FIKRS	TCJ_POSITIONS	FIKRS		☐	FIKRS	☐	Financial Management Area
66	FISTL	TCJ_POSITIONS	FISTL		☐	FISTL	☐	Funds Center
67	FIPOS	TCJ_POSITIONS	FIPOS		☐	FIPOS	☐	Commitment Item
68	GEBER	TCJ_POSITIONS	GEBER		☐	BP_GEBER	☐	Fund
69	KBLNR	TCJ_POSITIONS	KBLNR		☐	KBLNR_FI	☐	Document number for earmarked funds
70	KBLPOS	TCJ_POSITIONS	KBLPOS		☐	KBLPOS	☐	Earmarked Funds: Document Item
71	ERLKZ	TCJ_POSITIONS	ERLKZ		☐	REFSETERLK	☐	Used earmarked funds set to "Complete"
72	PERNR	TCJ_POSITIONS	PERNR		☐	PERNR_D	☐	Personnel Number
73	PAOBJNR	TCJ_POSITIONS	PAOBJNR		☐	RKEOBJNR	☐	Profitability Segment Number (CO-PA)
74	IMKEY	TCJ_POSITIONS	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
75	KONTT	TCJ_POSITIONS	KONTT		☐	KONTT_FI	☐	Account Assignment Category for Industry Solution
76	KONTL	TCJ_POSITIONS	KONTL		☐	KONTL_FI	☐	Acct assignment string for industry-specific acct assignmnts
77	TAXJURCODE	TCJ_POSITIONS	TAXJURCODE		☐	TXJCD	☐	Tax Jurisdiction
78	TEXT1	TCJ_DOCUMENTS	TEXT1		☐	CJDOCTEXT100	☐	Additional Field 1 for Cash Journal Document Header
79	TEXT2	TCJ_DOCUMENTS	TEXT2		☐	CJDOCTEXT30	☐	Additional Field 2 for Cash Journal Document Header
80	MEANS_OF_PAYMENT	TCJ_DOCUMENTS	MEANS_OF_PAYMENT		☐	CJMOFPAYM	☐	Cash Journal Means of Payment
81	CHECK_NUMBER	TCJ_DOCUMENTS	CHECK_NUMBER		☐	SCKNR_EB	☐	13-digit check number
82	CHECK_ISSUER	TCJ_DOCUMENTS	CHECK_ISSUER		☐	CJCHECKISSUER	☐	Check Issuer (Cash Journal)
83	BANK_KEY	TCJ_DOCUMENTS	BANK_KEY		☐	BANKK	☐	Bank Keys
84	BANK_ACCT	TCJ_DOCUMENTS	BANK_ACCT		☐	BANKN	☐	Bank account number
85	BANK_CTRY	TCJ_DOCUMENTS	BANK_CTRY		☐	BANKS	☐	Bank country key
86	CHECK_STACK	TCJ_DOCUMENTS	CHECK_STACK		☐	CJCHECKSTACK	☐	Number of Check Lot in Cash Journal
87	CHECK_STATUS	TCJ_DOCUMENTS	CHECK_STATUS		☐	CJCHECKSTATUS	☐	Posting Status for Checks in Cash Journal
88	ALLOC_NMBR	TCJ_POSITIONS	ALLOC_NMBR		☐	DZUONR	☐	Assignment number
89	BRANCH	TCJ_POSITIONS	BRANCH		☐	FILKD	☐	Account Number of the Branch
90	REVBELNR	TCJ_DOCUMENTS	REVBELNR		☐	CJREVBELNR	☐	Reversal Document Number for Cash Journal Document
91	EXCH_RATE	TCJ_DOCUMENTS	EXCH_RATE		☐	KURSF	☐	Exchange rate
92	BUPLA	TCJ_DOCUMENTS	BUPLA		☐	BUPLA	☐	Business Place
93	SECCO	TCJ_DOCUMENTS	SECCO		☐	SECCO	☐	Section Code
94	POSITION_NUMBER	TCJ_POSITIONS	POSITION_NUMBER		☐	CJBUZEI	☐	Number of Line Item within Cash Journal Document
95	POSITION_TYPE	TCJ_POSITIONS	POSITION_TYPE		☐	CJPOSTYPE	☐	Cash Journal Item Type
96	P_RECEIPTS	TCJ_POSITIONS	P_RECEIPTS		☐	CJAMOUNT	☐	Cash Journal Amount Field with +/- Sign
97	P_PAYMENTS	TCJ_POSITIONS	P_PAYMENTS		☐	CJAMOUNT	☐	Cash Journal Amount Field with +/- Sign
98	P_NET_AMOUNT	TCJ_POSITIONS	P_NET_AMOUNT		☐	CJNET_AMOUNT	☐	Cash Journal Document Net Amount - Document Currency
99	P_NET_PAYMENT_WT	TCJ_POSITIONS	P_NET_PAYMENT_WT		☐	CJNET_PAYMENT_WT	☐	Net Payment Amount (Withholding Tax Deducted)
100	P_TAX_AMOUNT	TCJ_POSITIONS	P_TAX_AMOUNT		☐	WMWST	☐	Tax amount in document currency
101	SPLIT	TCJ_DOCUMENTS	SPLIT		☐	CJDOCSPLIT	☐	Split Information for Cash Journal Document
102	LZBKZ	TCJ_DOCUMENTS	LZBKZ		☐	LZBKZ	☐	State central bank indicator
103	LANDL	TCJ_DOCUMENTS	LANDL		☐	LANDL	☐	Supplying Country
104	P_FWBAS	TCJ_POSITIONS	P_FWBAS		☐	FWBAS	☐	Tax Base Amount in Document Currency
105	GL_ACCOUNT	TCJ_POSITIONS	GL_ACCOUNT		☐	HKONT	☐	General Ledger Account
106	GRANT_NBR	TCJ_POSITIONS	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
107	UMSKZ	TCJ_TRANSACTIONS	UMSKZ		☐	UMSKZ	☐	Special G/L Indicator
108	SEGMENT	TCJ_POSITIONS	SEGMENT		☐	FB_SEGMENT	☐	Segment for Segmental Reporting
109	PSEGMENT	TCJ_POSITIONS	PSEGMENT		☐	FB_PSEGMENT	☐	Partner Segment for Segmental Reporting
110	VATDATE	TCJ_DOCUMENTS	VATDATE		☐	VATDATE	☐	Tax Reporting Date
111	BUDGET_PD	TCJ_POSITIONS	BUDGET_PD		☐	FM_BUDGET_PERIOD	☐	FM: Budget Period

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in