SAP ABAP View V_POSTINGS2 (View on Cash Journal Posting Documents w/o Language)

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_POSTINGS2
Short Description	View on Cash Journal Posting Documents w/o Language
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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TCJ_DOCUMENTS	MANDT	JL	EQ				0	0
2	TCJ_POSITIONS	MANDT	JR	EQ			AND	0	0
3	TCJ_DOCUMENTS	COMP_CODE	JL	EQ				0	0
4	TCJ_POSITIONS	COMP_CODE	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	FISC_YEAR	JL	EQ				0	0
8	TCJ_POSITIONS	FISC_YEAR	JR	EQ			AND	0	0
9	TCJ_DOCUMENTS	POSTING_NUMBER	JL	EQ				0	0
10	TCJ_POSITIONS	POSTING_NUMBER	JR	EQ			AND	0	0
11	TCJ_POSITIONS	POSITION_TYPE		EQ	'O'		OR	0	0
12	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_NUMBER	TCJ_POSITIONS	TRANSACT_NUMBER		☐	CJTRANSNUMB	☐	Number of Cash Journal Business Transaction
19	CAJO_NUMBER	TCJ_DOCUMENTS	CAJO_NUMBER		☐	CJNR	☐	Cash Journal Number
20	COMP_CODE	TCJ_DOCUMENTS	COMP_CODE		☐	BUKRS	☐	Company Code
21	VENDOR_NO	TCJ_POSITIONS	VENDOR_NO		☐	LIFNR	☐	Account Number of Vendor or Creditor
22	CUSTOMER	TCJ_POSITIONS	CUSTOMER		☐	KUNNR	☐	Customer Number
23	D_POSTING_NUMB	TCJ_DOCUMENTS	D_POSTING_NUMB		☐	CJBELNR_DISP	☐	Cash Journal Document Number for Display
24	GSBER	TCJ_POSITIONS	GSBER		☐	GSBER	☐	Business Area
25	PARGB	TCJ_POSITIONS	PARGB		☐	PARGB	☐	Trading partner's business area
26	VBUND	TCJ_POSITIONS	VBUND		☐	RASSC	☐	Company ID of trading partner
27	RMVCT	TCJ_POSITIONS	RMVCT		☐	RMVCT	☐	Transaction type
28	FKBER	TCJ_POSITIONS	FKBER		☐	FKBER	☐	Functional Area
29	KOKRS	TCJ_POSITIONS	KOKRS		☐	KOKRS	☐	Controlling Area
30	KOSTL	TCJ_POSITIONS	KOSTL		☐	KOSTL	☐	Cost Center
31	LSTAR	TCJ_POSITIONS	LSTAR		☐	LSTAR	☐	Activity Type
32	AUFNR	TCJ_POSITIONS	AUFNR		☐	AUFNR	☐	Order Number
33	AFPOS	TCJ_POSITIONS	AFPOS		☐	CO_POSNR	☐	Order item number
34	BEMOT	TCJ_POSITIONS	BEMOT		☐	BEMOT	☐	Accounting Indicator
35	KSTRG	TCJ_POSITIONS	KSTRG		☐	KSTRG	☐	Cost Object
36	PRZNR	TCJ_POSITIONS	PRZNR		☐	CO_PRZNR	☐	Business Process
37	PRCTR	TCJ_POSITIONS	PRCTR		☐	PRCTR	☐	Profit Center
38	PPRCTR	TCJ_POSITIONS	PPRCTR		☐	PPRCTR	☐	Partner Profit Center
39	PS_PSP_PNR	TCJ_POSITIONS	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
40	NPLNR	TCJ_POSITIONS	NPLNR		☐	NPLNR	☐	Network Number for Account Assignment
41	VORNR	TCJ_POSITIONS	VORNR		☐	VORNR	☐	Operation/Activity Number
42	ANLN1	TCJ_POSITIONS	ANLN1		☐	BF_ANLN1	☐	Main Asset Number
43	ANLN2	TCJ_POSITIONS	ANLN2		☐	BF_ANLN2	☐	Asset Subnumber
44	BZDAT	TCJ_POSITIONS	BZDAT		☐	BF_BZDAT	☐	Reference date
45	ANBWA	TCJ_POSITIONS	ANBWA		☐	BF_ANBWA	☐	Asset transaction type
46	WERKS	TCJ_POSITIONS	WERKS		☐	WERKS_D	☐	Plant
47	BWTAR	TCJ_POSITIONS	BWTAR		☐	BWTAR_D	☐	Valuation type
48	BWKEY	TCJ_POSITIONS	BWKEY		☐	BWKEY	☐	Valuation area
49	MATNR	TCJ_POSITIONS	MATNR		☐	MATNR	☐	Material Number
50	HRKFT	TCJ_POSITIONS	HRKFT		☐	HRKFT	☐	Origin Group as Subdivision of Cost Element
51	HKMAT	TCJ_POSITIONS	HKMAT		☐	HKMAT	☐	Material-related origin
52	KDAUF	TCJ_POSITIONS	KDAUF		☐	KDAUF	☐	Sales Order Number
53	KDEIN	TCJ_POSITIONS	KDEIN		☐	KDEIN	☐	Delivery schedule for sales order
54	KDPOS	TCJ_POSITIONS	KDPOS		☐	KDPOS	☐	Item number in Sales Order
55	VNAME	TCJ_POSITIONS	VNAME		☐	JV_NAME	☐	Joint venture
56	RECID	TCJ_POSITIONS	RECID		☐	JV_RECIND	☐	Recovery Indicator
57	RECID_MAN	TCJ_POSITIONS	RECID_MAN		☐	JV_RECID_M	☐	Indicator: Recovery Indicator Set Manually.
58	EGRUP	TCJ_POSITIONS	EGRUP		☐	JV_EGROUP	☐	Equity group
59	ETYPE	TCJ_POSITIONS	ETYPE		☐	JV_ETYPE	☐	Equity type
60	VPTNR	TCJ_POSITIONS	VPTNR		☐	JV_PART	☐	Partner account number
61	CONDI	TCJ_POSITIONS	CONDI		☐	JV_CONDCOD	☐	Joint Venture Indicator (Condition Key)
62	CRPCAL	TCJ_POSITIONS	CRPCAL		☐	JV_CRPCAL	☐	Flag CRP Calculation: Yes or NO
63	FIKRS	TCJ_POSITIONS	FIKRS		☐	FIKRS	☐	Financial Management Area
64	FISTL	TCJ_POSITIONS	FISTL		☐	FISTL	☐	Funds Center
65	FIPOS	TCJ_POSITIONS	FIPOS		☐	FIPOS	☐	Commitment Item
66	GEBER	TCJ_POSITIONS	GEBER		☐	BP_GEBER	☐	Fund
67	KBLNR	TCJ_POSITIONS	KBLNR		☐	KBLNR_FI	☐	Document number for earmarked funds
68	KBLPOS	TCJ_POSITIONS	KBLPOS		☐	KBLPOS	☐	Earmarked Funds: Document Item
69	ERLKZ	TCJ_POSITIONS	ERLKZ		☐	REFSETERLK	☐	Used earmarked funds set to "Complete"
70	PERNR	TCJ_POSITIONS	PERNR		☐	PERNR_D	☐	Personnel Number
71	PAOBJNR	TCJ_POSITIONS	PAOBJNR		☐	RKEOBJNR	☐	Profitability Segment Number (CO-PA)
72	IMKEY	TCJ_POSITIONS	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
73	KONTT	TCJ_POSITIONS	KONTT		☐	KONTT_FI	☐	Account Assignment Category for Industry Solution
74	KONTL	TCJ_POSITIONS	KONTL		☐	KONTL_FI	☐	Acct assignment string for industry-specific acct assignmnts
75	TAXJURCODE	TCJ_POSITIONS	TAXJURCODE		☐	TXJCD	☐	Tax Jurisdiction
76	TEXT1	TCJ_DOCUMENTS	TEXT1		☐	CJDOCTEXT100	☐	Additional Field 1 for Cash Journal Document Header
77	TEXT2	TCJ_DOCUMENTS	TEXT2		☐	CJDOCTEXT30	☐	Additional Field 2 for Cash Journal Document Header
78	MEANS_OF_PAYMENT	TCJ_DOCUMENTS	MEANS_OF_PAYMENT		☐	CJMOFPAYM	☐	Cash Journal Means of Payment
79	CHECK_NUMBER	TCJ_DOCUMENTS	CHECK_NUMBER		☐	SCKNR_EB	☐	13-digit check number
80	CHECK_ISSUER	TCJ_DOCUMENTS	CHECK_ISSUER		☐	CJCHECKISSUER	☐	Check Issuer (Cash Journal)
81	BANK_KEY	TCJ_DOCUMENTS	BANK_KEY		☐	BANKK	☐	Bank Keys
82	BANK_ACCT	TCJ_DOCUMENTS	BANK_ACCT		☐	BANKN	☐	Bank account number
83	BANK_CTRY	TCJ_DOCUMENTS	BANK_CTRY		☐	BANKS	☐	Bank country key
84	CHECK_STACK	TCJ_DOCUMENTS	CHECK_STACK		☐	CJCHECKSTACK	☐	Number of Check Lot in Cash Journal
85	CHECK_STATUS	TCJ_DOCUMENTS	CHECK_STATUS		☐	CJCHECKSTATUS	☐	Posting Status for Checks in Cash Journal
86	ALLOC_NMBR	TCJ_POSITIONS	ALLOC_NMBR		☐	DZUONR	☐	Assignment number
87	BRANCH	TCJ_POSITIONS	BRANCH		☐	FILKD	☐	Account Number of the Branch
88	REVBELNR	TCJ_DOCUMENTS	REVBELNR		☐	CJREVBELNR	☐	Reversal Document Number for Cash Journal Document
89	EXCH_RATE	TCJ_DOCUMENTS	EXCH_RATE		☐	KURSF	☐	Exchange rate
90	BUPLA	TCJ_DOCUMENTS	BUPLA		☐	BUPLA	☐	Business Place
91	SECCO	TCJ_DOCUMENTS	SECCO		☐	SECCO	☐	Section Code
92	POSITION_NUMBER	TCJ_POSITIONS	POSITION_NUMBER		☐	CJBUZEI	☐	Number of Line Item within Cash Journal Document
93	POSITION_TYPE	TCJ_POSITIONS	POSITION_TYPE		☐	CJPOSTYPE	☐	Cash Journal Item Type
94	P_RECEIPTS	TCJ_POSITIONS	P_RECEIPTS		☐	CJAMOUNT	☐	Cash Journal Amount Field with +/- Sign
95	P_PAYMENTS	TCJ_POSITIONS	P_PAYMENTS		☐	CJAMOUNT	☐	Cash Journal Amount Field with +/- Sign
96	P_NET_AMOUNT	TCJ_POSITIONS	P_NET_AMOUNT		☐	CJNET_AMOUNT	☐	Cash Journal Document Net Amount - Document Currency
97	P_NET_PAYMENT_WT	TCJ_POSITIONS	P_NET_PAYMENT_WT		☐	CJNET_PAYMENT_WT	☐	Net Payment Amount (Withholding Tax Deducted)
98	P_TAX_AMOUNT	TCJ_POSITIONS	P_TAX_AMOUNT		☐	WMWST	☐	Tax amount in document currency
99	SPLIT	TCJ_DOCUMENTS	SPLIT		☐	CJDOCSPLIT	☐	Split Information for Cash Journal Document
100	LZBKZ	TCJ_DOCUMENTS	LZBKZ		☐	LZBKZ	☐	State central bank indicator
101	LANDL	TCJ_DOCUMENTS	LANDL		☐	LANDL	☐	Supplying Country
102	P_FWBAS	TCJ_POSITIONS	P_FWBAS		☐	FWBAS	☐	Tax Base Amount in Document Currency
103	GL_ACCOUNT	TCJ_POSITIONS	GL_ACCOUNT		☐	HKONT	☐	General Ledger Account
104	GRANT_NBR	TCJ_POSITIONS	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
105	VALUTA_DATE	TCJ_DOCUMENTS	VALUTA_DATE		☐	VALUT	☐	Fixed Value Date
106	VATDATE	TCJ_DOCUMENTS	VATDATE		☐	VATDATE	☐	Tax Reporting Date
107	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