SAP ABAP Table V_POSTINGS2 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_POSTINGS2	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	FISC_YEAR	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	POSTING_NUMBER	CJBELNR	BELNR	CHAR	10	0	Cash Journal Document Number
4	H_RECEIPTS	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
5	H_PAYMENTS	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
6	H_NET_AMOUNT	CJNET_AMOUNT	WERTV7	CURR	13	2	Cash Journal Document Net Amount - Document Currency
7	H_NET_PAYMENT_WT	CJNET_PAYMENT_WT	CJAMT	CURR	15	2	Net Payment Amount (Withholding Tax Deducted)
8	H_TAX_AMOUNT	WMWST	WERT7	CURR	13	2	Tax amount in document currency
9	BP_NAME	CJBPNAME	NAME	CHAR	35	0	Name of Receipt Recipient
10	DOCUMENT_DATE	BLDAT	DATUM	DATS	8	0	Document Date in Document
11	DOCUMENT_NUMBER	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
12	POSTING_DATE	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
13	DOCUMENT_STATUS	CJDOCSTAT	CJDOCSTAT	CHAR	2	0	Cash Journal Entry Document Status
14	PRINT_IND	CJPRINTIND	BOOLEAN	CHAR	1	0	Cash Journal Print Indicator
15	TAX_CODE	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
16	TAX_PERCENT	MSATZ_F05L	PRZ43V	DEC	7	3	Tax rate
17	POSITION_TEXT	CJPOSTEXT	TEXT50	CHAR	50	0	Cash Journal Line Item Text
18	TRANSACT_NUMBER	CJTRANSNUMB	CHAR4	CHAR	4	0	Number of Cash Journal Business Transaction	TCJ_TRANSACTIONS
19	CAJO_NUMBER	CJNR	CJNR	CHAR	4	0	Cash Journal Number	TCJ_C_JOURNALS
20	COMP_CODE	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
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	D_POSTING_NUMB	CJBELNR_DISP	BELNR	CHAR	10	0	Cash Journal Document Number for Display
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	GEBER	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
67	KBLNR	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds
68	KBLPOS	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item
69	ERLKZ	REFSETERLK	CHAR1_X	CHAR	1	0	Used earmarked funds set to "Complete"
70	PERNR	PERNR_D	PERNR	NUMC	8	0	Personnel Number
71	PAOBJNR	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
72	IMKEY	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
73	KONTT	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
74	KONTL	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
75	TAXJURCODE	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
76	TEXT1	CJDOCTEXT100	TEXT100	CHAR	100	0	Additional Field 1 for Cash Journal Document Header
77	TEXT2	CJDOCTEXT30	TEXT30	CHAR	30	0	Additional Field 2 for Cash Journal Document Header
78	MEANS_OF_PAYMENT	CJMOFPAYM	CJMOP	CHAR	1	0	Cash Journal Means of Payment
79	CHECK_NUMBER	SCKNR_EB	NUMC13	NUMC	13	0	13-digit check number
80	CHECK_ISSUER	CJCHECKISSUER	TEXT14	CHAR	14	0	Check Issuer (Cash Journal)
81	BANK_KEY	BANKK	BANKK	CHAR	15	0	Bank Keys
82	BANK_ACCT	BANKN	BANKN	CHAR	18	0	Bank account number
83	BANK_CTRY	BANKS	LAND1	CHAR	3	0	Bank country key
84	CHECK_STACK	CJCHECKSTACK	CHAR8	CHAR	8	0	Number of Check Lot in Cash Journal
85	CHECK_STATUS	CJCHECKSTATUS	CJCHSTAT	CHAR	1	0	Posting Status for Checks in Cash Journal
86	ALLOC_NMBR	DZUONR	ZUONR	CHAR	18	0	Assignment number
87	BRANCH	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
88	REVBELNR	CJREVBELNR	BELNR	CHAR	10	0	Reversal Document Number for Cash Journal Document
89	EXCH_RATE	KURSF	KURSF	DEC	9	5	Exchange rate
90	BUPLA	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place
91	SECCO	SECCO	SECCO	CHAR	4	0	Section Code
92	POSITION_NUMBER	CJBUZEI	BUZEI	NUMC	3	0	Number of Line Item within Cash Journal Document
93	POSITION_TYPE	CJPOSTYPE	CJPOSTYPE	CHAR	2	0	Cash Journal Item Type
94	P_RECEIPTS	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
95	P_PAYMENTS	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
96	P_NET_AMOUNT	CJNET_AMOUNT	WERTV7	CURR	13	2	Cash Journal Document Net Amount - Document Currency
97	P_NET_PAYMENT_WT	CJNET_PAYMENT_WT	CJAMT	CURR	15	2	Net Payment Amount (Withholding Tax Deducted)
98	P_TAX_AMOUNT	WMWST	WERT7	CURR	13	2	Tax amount in document currency
99	SPLIT	CJDOCSPLIT	CJDSPLIT	CHAR	1	0	Split Information for Cash Journal Document
100	LZBKZ	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	T015L
101	LANDL	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
102	P_FWBAS	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
103	GL_ACCOUNT	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
104	GRANT_NBR	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
105	VALUTA_DATE	VALUT	DATUM	DATS	8	0	Fixed Value Date
106	VATDATE	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
107	BUDGET_PD	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_POSTINGS2	CAJO_NUMBER	TCJ_C_JOURNALS	CAJO_NUMBER
2	V_POSTINGS2	COMP_CODE	T001	BUKRS
3	V_POSTINGS2	CUSTOMER	KNA1	KUNNR
4	V_POSTINGS2	GL_ACCOUNT	SKA1	SAKNR
5	V_POSTINGS2	LANDL	T005	LAND1
6	V_POSTINGS2	LZBKZ	T015L	LZBKZ
7	V_POSTINGS2	MANDT	T000	MANDT
8	V_POSTINGS2	TAXJURCODE	TTXJ	TXJCD	REF	C	CN
9	V_POSTINGS2	TAX_CODE	T007A	MWSKZ
10	V_POSTINGS2	TRANSACT_NUMBER	TCJ_TRANSACTIONS	TRANSACT_NUMBER
11	V_POSTINGS2	VENDOR_NO	LFA1	LIFNR