	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

199 COLUMNS | 2 INDEXES | ERP 6.0 | COEJ TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Controlling :: Overhead Cost Controlling
1	ERP EHP7	6.0	COEJ	199	2	CO Object: Line Items (by Fiscal Year)	Overhead Cost Controlling

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, KOKRS, BELNR, BUZEI, PERBL, WTG001, WTG002, WTG003, WTG004, WTG005, WTG006, WTG007, WTG008, WTG009, WTG010, WTG011, WTG012, WTG013, WTG014, WTG015, WTG016, WOG001, WOG002, WOG003, WOG004, WOG005, WOG006, WOG007, WOG008, WOG009, WOG010, WOG011, WOG012, WOG013, WOG014, WOG015, WOG016, WKG001, WKG002, WKG003, WKG004, WKG005, WKG006, WKG007, WKG008, WKG009, WKG010, WKG011, WKG012, WKG013, WKG014, WKG015, WKG016, WKF001, WKF002, WKF003, WKF004, WKF005, WKF006, WKF007, WKF008, WKF009, WKF010, WKF011, WKF012, WKF013, WKF014, WKF015, WKF016, PAG001, PAG002, PAG003, PAG004, PAG005, PAG006, PAG007, PAG008, PAG009, PAG010, PAG011, PAG012, PAG013, PAG014, PAG015, PAG016, PAF001, PAF002, PAF003, PAF004, PAF005, PAF006, PAF007, PAF008, PAF009, PAF010, PAF011, PAF012, PAF013, PAF014, PAF015, PAF016, MEG001, MEG002, MEG003, MEG004, MEG005, MEG006, MEG007, MEG008, MEG009, MEG010, MEG011, MEG012, MEG013, MEG014, MEG015, MEG016, MEF001, MEF002, MEF003, MEF004, MEF005, MEF006, MEF007, MEF008, MEF009, MEF010, MEF011, MEF012, MEF013, MEF014, MEF015, MEF016, MBG001, MBG002, MBG003, MBG004, MBG005, MBG006, MBG007, MBG008, MBG009, MBG010, MBG011, MBG012, MBG013, MBG014, MBG015, MBG016, MBF001, MBF002, MBF003, MBF004, MBF005, MBF006, MBF007, MBF008, MBF009, MBF010, MBF011, MBF012, MBF013, MBF014, MBF015, MBF016, LEDNR, OBJNR, GJAHR, WRTTP, VERSN, KSTAR, HRKFT, VRGNG, PAROB, PAROB1, USPOB, VBUND, PARGB, BEKNZ, TWAER, MEINH, MEINB, SGTXT, REFBZ, ZLENR, BW_REFBZ, BELTP, TIMESTMP, PAOBJNR, FKBER, PFKBER, GEBER, PGEBER, GRANT_NBR, PGRANT_NBR, SEGMENT, PSEGMENT, BUDGET_PD, PBUDGET_PD FROM COEJ

TOP ERP 6.0 | COEJ COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	No	TKA01	KOKRS	Allow NULL?
3	BELNR	Document Number	nvarchar	10	0	CHAR	(N' ')	No	COBK	CO_BELNR	Allow NULL?
4	BUZEI	Posting row	nvarchar	3	0	NUMC	(N'000')	No		CO_BUZEI	Allow NULL?
5	PERBL	Period block	nvarchar	3	0	NUMC	(N'000')	No		PERBL	Allow NULL?
6	WTG001	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
7	WTG002	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
8	WTG003	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
9	WTG004	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
10	WTG005	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
11	WTG006	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
12	WTG007	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
13	WTG008	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
14	WTG009	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
15	WTG010	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
16	WTG011	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
17	WTG012	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
18	WTG013	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
19	WTG014	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
20	WTG015	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
21	WTG016	Total Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		WTGXXX
22	WOG001	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
23	WOG002	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
24	WOG003	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
25	WOG004	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
26	WOG005	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
27	WOG006	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
28	WOG007	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
29	WOG008	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
30	WOG009	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
31	WOG010	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
32	WOG011	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
33	WOG012	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
34	WOG013	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
35	WOG014	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
36	WOG015	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
37	WOG016	Total Value in Object Currency	decimal	15	2	CURR	((0))	Yes		WOGXXX
38	WKG001	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
39	WKG002	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
40	WKG003	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
41	WKG004	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
42	WKG005	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
43	WKG006	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
44	WKG007	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
45	WKG008	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
46	WKG009	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
47	WKG010	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
48	WKG011	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
49	WKG012	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
50	WKG013	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
51	WKG014	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
52	WKG015	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
53	WKG016	Total Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKGXXX
54	WKF001	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
55	WKF002	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
56	WKF003	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
57	WKF004	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
58	WKF005	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
59	WKF006	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
60	WKF007	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
61	WKF008	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
62	WKF009	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
63	WKF010	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
64	WKF011	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
65	WKF012	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
66	WKF013	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
67	WKF014	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
68	WKF015	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
69	WKF016	Fixed Value in Controlling Area Currency	decimal	15	2	CURR	((0))	Yes		WKFXXX
70	PAG001	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
71	PAG002	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
72	PAG003	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
73	PAG004	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
74	PAG005	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
75	PAG006	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
76	PAG007	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
77	PAG008	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
78	PAG009	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
79	PAG010	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
80	PAG011	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
81	PAG012	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
82	PAG013	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
83	PAG014	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
84	PAG015	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
85	PAG016	Total Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAGXXX
86	PAF001	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
87	PAF002	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
88	PAF003	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
89	PAF004	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
90	PAF005	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
91	PAF006	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
92	PAF007	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
93	PAF008	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
94	PAF009	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
95	PAF010	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
96	PAF011	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
97	PAF012	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
98	PAF013	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
99	PAF014	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
100	PAF015	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
101	PAF016	Fixed Price Variance in CO Area Currency	decimal	15	2	CURR	((0))	Yes		PAFXXX
102	MEG001	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
103	MEG002	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
104	MEG003	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
105	MEG004	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
106	MEG005	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
107	MEG006	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
108	MEG007	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
109	MEG008	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
110	MEG009	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
111	MEG010	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
112	MEG011	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
113	MEG012	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
114	MEG013	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
115	MEG014	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
116	MEG015	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
117	MEG016	Total Quantity	decimal	15	3	QUAN	((0))	Yes		MEGXXX
118	MEF001	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
119	MEF002	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
120	MEF003	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
121	MEF004	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
122	MEF005	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
123	MEF006	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
124	MEF007	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
125	MEF008	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
126	MEF009	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
127	MEF010	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
128	MEF011	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
129	MEF012	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
130	MEF013	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
131	MEF014	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
132	MEF015	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
133	MEF016	Fixed Quantity	decimal	15	3	QUAN	((0))	Yes		MEFXXX
134	MBG001	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
135	MBG002	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
136	MBG003	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
137	MBG004	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
138	MBG005	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
139	MBG006	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
140	MBG007	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
141	MBG008	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
142	MBG009	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
143	MBG010	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
144	MBG011	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
145	MBG012	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
146	MBG013	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
147	MBG014	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
148	MBG015	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
149	MBG016	Total quantity entered	decimal	15	3	QUAN	((0))	Yes		MBGXXX
150	MBF001	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
151	MBF002	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
152	MBF003	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
153	MBF004	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
154	MBF005	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
155	MBF006	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
156	MBF007	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
157	MBF008	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
158	MBF009	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
159	MBF010	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
160	MBF011	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
161	MBF012	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
162	MBF013	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
163	MBF014	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
164	MBF015	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
165	MBF016	Fixed quantity entered	decimal	15	3	QUAN	((0))	Yes		MBFXXX
166	LEDNR	Ledger for Controlling objects	nvarchar	2	0	CHAR	(N' ')	Yes		LEDNR	Allow NULL?
167	OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	J_OBJNR	Allow NULL?
168	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
169	WRTTP	Value Type	nvarchar	2	0	CHAR	(N' ')	Yes		CO_WRTTP	Allow NULL?
170	VERSN	Version	nvarchar	3	0	CHAR	(N' ')	Yes	TKA09	VERSN	Allow NULL?
171	KSTAR	Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	CSKA	KSTAR	Allow NULL?
172	HRKFT	CO key subnumber	nvarchar	14	0	CHAR	(N' ')	Yes	*	CO_SUBKEY	Allow NULL?
173	VRGNG	CO Business Transaction	nvarchar	4	0	CHAR	(N' ')	Yes	*	CO_VORGANG	Allow NULL?
174	PAROB	Partner Object	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	PAROB	Allow NULL?
175	PAROB1	Partner object (always filled)	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	PAROB1	Allow NULL?
176	USPOB	Source Object (Cost Center/Activity Type)	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	USPOB	Allow NULL?
177	VBUND	Company ID of trading partner	nvarchar	6	0	CHAR	(N' ')	Yes	T880	RASSC	Allow NULL?
178	PARGB	Trading partner's business area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	PARGB	Allow NULL?
179	BEKNZ	Debit/credit indicator	char	1	0	CHAR	(N' ')	Yes		BEKNZ	Allow NULL?
180	TWAER	Transaction Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	TWAER	Allow NULL?
181	MEINH	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	CO_MEINH	Allow NULL?
182	MEINB	Posted Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINB	Allow NULL?
183	SGTXT	Segment text	nvarchar	50	0	CHAR	(N' ')	Yes		CO_SGTXT	Allow NULL?
184	REFBZ	Posting row of reference document	nvarchar	3	0	NUMC	(N'000')	Yes		CO_REFBZ	Allow NULL?
185	ZLENR	Document Item Number	nvarchar	3	0	NUMC	(N'000')	Yes		DZLENR	Allow NULL?
186	BW_REFBZ	Posting Row in Operative Version	nvarchar	3	0	NUMC	(N'000')	Yes		BW_REFBZ	Allow NULL?
187	BELTP	Debit type	char	1	0	NUMC	(N'0')	Yes		BP_INOUT	Allow NULL?
188	TIMESTMP	Time created (Greenwich Meantime)	decimal	16	0	DEC	((0))	Yes		RKE_HZSTMP
189	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
190	FKBER	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	TFKB	FKBER	Allow NULL?
191	PFKBER	Partner Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	TFKB	SFKBER	Allow NULL?
192	GEBER	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_FUND	Allow NULL?
193	PGEBER	Partner Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_PFUND	Allow NULL?
194	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
195	PGRANT_NBR	Partner Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_PARTNER	Allow NULL?
196	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	FAGL_SEGM	FB_SEGMENT	Allow NULL?
197	PSEGMENT	Partner Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	FAGL_SEGM	FB_PSEGMENT	Allow NULL?
198	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
199	PBUDGET_PD	FM: Partner Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_PBUDGET_PERIOD	Allow NULL?

TOP ERP 6.0 | COEJ INDEXES

Name	Primary	Unique	Type	Columns
COEJ~0	Yes	Yes	CLUSTERED	PERBL, BUZEI, BELNR, KOKRS, MANDT
COEJ~1	No	No	NONCLUSTERED	TWAER, BEKNZ, PARGB, VBUND, USPOB, PAROB, VRGNG, PERBL, HRKFT, KSTAR, VERSN, WRTTP, GJAHR, OBJNR, LEDNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

199 COLUMNS | 2 INDEXES | ERP 6.0 | COEJ TABLE

TOP ERP 6.0 | COEJ COLUMNS

TOP ERP 6.0 | COEJ INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

199 COLUMNS | 2 INDEXES | ERP 6.0 | COEJ TABLE

TOPERP 6.0 | COEJ COLUMNS

TOPERP 6.0 | COEJ INDEXES

TOP ERP 6.0 | COEJ COLUMNS

TOP ERP 6.0 | COEJ INDEXES