SAP ABAP Table V_POSTINGS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_POSTINGS	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_NAME	CJTRANSTXT	CHAR_25	CHAR	25	0	Cash Journal Business Transaction
19	LONG_TEXT	CJTRANSLTXT	CHR50	CHAR	50	0	Cash Journal Business Transaction Long Text
20	CAJO_NUMBER	CJNR	CJNR	CHAR	4	0	Cash Journal Number	TCJ_C_JOURNALS
21	COMP_CODE	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
22	VENDOR_NO	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
23	CUSTOMER	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
24	D_POSTING_NUMB	CJBELNR_DISP	BELNR	CHAR	10	0	Cash Journal Document Number for Display
25	LANGU	SPRAS	SPRAS	LANG	1	0	Language Key	T002
26	GSBER	GSBER	GSBER	CHAR	4	0	Business Area
27	PARGB	PARGB	GSBER	CHAR	4	0	Trading partner's business area
28	VBUND	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner
29	RMVCT	RMVCT	RMVCT	CHAR	3	0	Transaction type
30	FKBER	FKBER	FKBER	CHAR	16	0	Functional Area
31	KOKRS	KOKRS	CACCD	CHAR	4	0	Controlling Area
32	KOSTL	KOSTL	KOSTL	CHAR	10	0	Cost Center
33	LSTAR	LSTAR	LSTAR	CHAR	6	0	Activity Type
34	AUFNR	AUFNR	AUFNR	CHAR	12	0	Order Number
35	AFPOS	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
36	BEMOT	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator
37	KSTRG	KSTRG	KSTRG	CHAR	12	0	Cost Object
38	PRZNR	CO_PRZNR	CO_PRZNR	CHAR	12	0	Business Process
39	PRCTR	PRCTR	PRCTR	CHAR	10	0	Profit Center
40	PPRCTR	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center
41	PS_PSP_PNR	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
42	NPLNR	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment
43	VORNR	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
44	ANLN1	BF_ANLN1	BF_ANLN1	CHAR	12	0	Main Asset Number
45	ANLN2	BF_ANLN2	BF_ANLN2	CHAR	4	0	Asset Subnumber
46	BZDAT	BF_BZDAT	DATUM	DATS	8	0	Reference date
47	ANBWA	BF_ANBWA	CHAR3	CHAR	3	0	Asset transaction type
48	WERKS	WERKS_D	WERKS	CHAR	4	0	Plant
49	BWTAR	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
50	BWKEY	BWKEY	BWKEY	CHAR	4	0	Valuation area
51	MATNR	MATNR	MATNR	CHAR	18	0	Material Number
52	HRKFT	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element
53	HKMAT	HKMAT	HKMAT	CHAR	1	0	Material-related origin
54	KDAUF	KDAUF	VBELN	CHAR	10	0	Sales Order Number
55	KDEIN	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
56	KDPOS	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
57	VNAME	JV_NAME	JV_NAME	CHAR	6	0	Joint venture
58	RECID	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator
59	RECID_MAN	JV_RECID_M	XFELD	CHAR	1	0	Indicator: Recovery Indicator Set Manually.
60	EGRUP	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group
61	ETYPE	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type
62	VPTNR	JV_PART	KUNNR	CHAR	10	0	Partner account number
63	CONDI	JV_CONDCOD	JV_CONDCOD	CHAR	2	0	Joint Venture Indicator (Condition Key)
64	CRPCAL	JV_CRPCAL	XFELD	CHAR	1	0	Flag CRP Calculation: Yes or NO
65	FIKRS	FIKRS	FIKRS	CHAR	4	0	Financial Management Area
66	FISTL	FISTL	FISTL	CHAR	16	0	Funds Center
67	FIPOS	FIPOS	FIPOS	CHAR	14	0	Commitment Item
68	GEBER	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
69	KBLNR	KBLNR_FI	KBLNR	CHAR	10	0	Document number for earmarked funds
70	KBLPOS	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item
71	ERLKZ	REFSETERLK	CHAR1_X	CHAR	1	0	Used earmarked funds set to "Complete"
72	PERNR	PERNR_D	PERNR	NUMC	8	0	Personnel Number
73	PAOBJNR	RKEOBJNR	RKEOBJNR	NUMC	10	0	Profitability Segment Number (CO-PA)
74	IMKEY	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
75	KONTT	KONTT_FI	KONTT_FI	CHAR	2	0	Account Assignment Category for Industry Solution
76	KONTL	KONTL_FI	CHAR50	CHAR	50	0	Acct assignment string for industry-specific acct assignmnts
77	TAXJURCODE	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
78	TEXT1	CJDOCTEXT100	TEXT100	CHAR	100	0	Additional Field 1 for Cash Journal Document Header
79	TEXT2	CJDOCTEXT30	TEXT30	CHAR	30	0	Additional Field 2 for Cash Journal Document Header
80	MEANS_OF_PAYMENT	CJMOFPAYM	CJMOP	CHAR	1	0	Cash Journal Means of Payment
81	CHECK_NUMBER	SCKNR_EB	NUMC13	NUMC	13	0	13-digit check number
82	CHECK_ISSUER	CJCHECKISSUER	TEXT14	CHAR	14	0	Check Issuer (Cash Journal)
83	BANK_KEY	BANKK	BANKK	CHAR	15	0	Bank Keys
84	BANK_ACCT	BANKN	BANKN	CHAR	18	0	Bank account number
85	BANK_CTRY	BANKS	LAND1	CHAR	3	0	Bank country key
86	CHECK_STACK	CJCHECKSTACK	CHAR8	CHAR	8	0	Number of Check Lot in Cash Journal
87	CHECK_STATUS	CJCHECKSTATUS	CJCHSTAT	CHAR	1	0	Posting Status for Checks in Cash Journal
88	ALLOC_NMBR	DZUONR	ZUONR	CHAR	18	0	Assignment number
89	BRANCH	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
90	REVBELNR	CJREVBELNR	BELNR	CHAR	10	0	Reversal Document Number for Cash Journal Document
91	EXCH_RATE	KURSF	KURSF	DEC	9	5	Exchange rate
92	BUPLA	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place
93	SECCO	SECCO	SECCO	CHAR	4	0	Section Code
94	POSITION_NUMBER	CJBUZEI	BUZEI	NUMC	3	0	Number of Line Item within Cash Journal Document
95	POSITION_TYPE	CJPOSTYPE	CJPOSTYPE	CHAR	2	0	Cash Journal Item Type
96	P_RECEIPTS	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
97	P_PAYMENTS	CJAMOUNT	CJAMT	CURR	15	2	Cash Journal Amount Field with +/- Sign
98	P_NET_AMOUNT	CJNET_AMOUNT	WERTV7	CURR	13	2	Cash Journal Document Net Amount - Document Currency
99	P_NET_PAYMENT_WT	CJNET_PAYMENT_WT	CJAMT	CURR	15	2	Net Payment Amount (Withholding Tax Deducted)
100	P_TAX_AMOUNT	WMWST	WERT7	CURR	13	2	Tax amount in document currency
101	SPLIT	CJDOCSPLIT	CJDSPLIT	CHAR	1	0	Split Information for Cash Journal Document
102	LZBKZ	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	T015L
103	LANDL	LANDL	LAND1	CHAR	3	0	Supplying Country	T005
104	P_FWBAS	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
105	GL_ACCOUNT	HKONT	SAKNR	CHAR	10	0	General Ledger Account	SKA1
106	GRANT_NBR	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
107	UMSKZ	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator
108	SEGMENT	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
109	PSEGMENT	FB_PSEGMENT	FB_SEGMENT	CHAR	10	0	Partner Segment for Segmental Reporting	FAGL_SEGM
110	VATDATE	VATDATE	DATUM	DATS	8	0	Tax Reporting Date
111	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_POSTINGS	CAJO_NUMBER	TCJ_C_JOURNALS	CAJO_NUMBER
2	V_POSTINGS	COMP_CODE	T001	BUKRS
3	V_POSTINGS	CUSTOMER	KNA1	KUNNR
4	V_POSTINGS	GL_ACCOUNT	SKA1	SAKNR
5	V_POSTINGS	LANDL	T005	LAND1
6	V_POSTINGS	LANGU	T002	SPRAS
7	V_POSTINGS	LZBKZ	T015L	LZBKZ
8	V_POSTINGS	MANDT	T000	MANDT
9	V_POSTINGS	PSEGMENT	FAGL_SEGM	SEGMENT
10	V_POSTINGS	SEGMENT	FAGL_SEGM	SEGMENT
11	V_POSTINGS	TAXJURCODE	TTXJ	TXJCD	REF	C	CN
12	V_POSTINGS	TAX_CODE	T007A	MWSKZ
13	V_POSTINGS	VENDOR_NO	LFA1	LIFNR