	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

210 COLUMNS | 3 INDEXES | ERP 6.0 | CE2IDEA TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Controlling :: Profitability Analysis
1	ERP EHP7	6.0	CE2IDEA	210	3	Op. Concern BR World	Profitability Analysis

SQL: selectupdate insert create

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

SELECT MANDT, PALEDGER, VRGAR, VERSI, PAOBJNR, PASUBNR, BELNR, PERBL, HZDAT, USNAM, GJAHR, PAPAOBJNR, PAPASUBNR, KNDNR, ARTNR, FKART, FRWAE, REC_WAERS, KAUFN, KDPOS, RKAUFNR, SKOST, PRZNR, BUKRS, KOKRS, WERKS, GSBER, VKORG, VTWEG, SPART, HRKFT, KSTAR, PSPNR, KSTRG, RBELN, RPOSN, PRCTR, PPRCTR, RKESTATU, TIMESTMP, MATKL, MVGR1, WWPH1, WWPH2, WWPH3, WWPRC, WWSOP, WWSBU, KDGRP, KUKLA, BZIRK, BRSCH, WWREG, LAND1, KUNWE, WWCST, WWRST, HIE01, HIE02, HIE03, VRTNR, VKBUR, VKGRP, WWICI, AUGRU, WWPRO, WWSDL, PAPH1, PAPH2, PAPH3, PAREG, SORHIST, WWMEA, WWQUA, WWSUR, REGIO, CRMELEM, CRMCSTY, ROUTE, VVOQT_ME, VVIQT_ME, VVSQT_ME, VVGRW_ME, VV550_ME, VV560_ME, VV570_ME, VV580_ME, VV495_ME, VVSTU_ME, VVOQU_ME, VV810_ME, VV820_ME, VV930_ME, VV931_ME, VVSV_ME, VVOQT001, VVIQT001, VVSQT001, VVGRW001, VV010001, VV020001, VV030001, VV040001, VV060001, VV070001, VV090001, VV100001, VV110001, VV120001, VV130001, VV140001, VV150001, VV160001, VV170001, VV180001, VV190001, VV200001, VV210001, VV220001, VV230001, VV240001, VV250001, VV260001, VV270001, VV280001, VV290001, VV300001, VV310001, VV320001, VV330001, VV340001, VV350001, VV360001, VV370001, VV380001, VV390001, VV400001, VV410001, VV420001, VV430001, VV440001, VV450001, VV460001, VV470001, VV480001, VV145001, VV075001, VV500001, VV510001, VV520001, VV530001, VV550001, VV560001, VV570001, VV580001, VV495001, VVSTU001, VV155001, VV365001, VV364001, VVK15001, VVK20001, VVK25001, VVK30001, VVK10001, VVO10001, VVO20001, VVOQU001, VV366001, VV367001, VV368001, VV151001, VV171001, VV181001, VV191001, VV201001, VV211001, VV251001, VV810001, VV820001, VV830001, VV840001, VV095001, VV713001, VV900001, VV910001, VV915001, VV920001, VV930001, VV931001, VV940001, VV950001, VV960001, VV970001, VV999001, VVADV001, VVCGS001, VVDEP001, VVENG001, VVNR001, VVPSC001, VVREN001, VVREV001, VVSD001, VVCM2001, VVSV001, VVLS1001, VVLS2001, VVLS3001, AUSFR001 FROM CE2IDEA

TOP ERP 6.0 | CE2IDEA 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	PALEDGER	Currency type for an operating concern	nvarchar	2	0	CHAR	(N' ')	No	TKEL	LEDBO	Allow NULL?
3	VRGAR	Record Type	char	1	0	CHAR	(N' ')	No	TVGA	RKE_VRGAR	Allow NULL?
4	VERSI	Plan version (CO-PA)	nvarchar	3	0	CHAR	(N' ')	No	TKVS	RKEVERSI	Allow NULL?
5	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	No		RKEOBJNR	Allow NULL?
6	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	NUMC	(N'0000')	No		RKESUBNR	Allow NULL?
7	BELNR	Document number of line item in Profitability Analysis	nvarchar	10	0	CHAR	(N' ')	No		RKE_BELNR	Allow NULL?
8	PERBL	Fiscal year/period block	nvarchar	7	0	NUMC	(N'0000000')	No		JAHRPERBL	Allow NULL?
9	HZDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
10	USNAM	Created by	nvarchar	12	0	CHAR	(N' ')	Yes		ERFASSER	Allow NULL?
11	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
12	PAPAOBJNR	Partner profitability segment number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEPOBJ	Allow NULL?
13	PAPASUBNR	Changes to partner profitability segments (CO-PA)	nvarchar	4	0	NUMC	(N'0000')	Yes		RKEPSUBNR	Allow NULL?
14	KNDNR	Customer	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNDE_PA	Allow NULL?
15	ARTNR	Product number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	ARTNR	Allow NULL?
16	FKART	Billing Type	nvarchar	4	0	CHAR	(N' ')	Yes	TVFK	FKART	Allow NULL?
17	FRWAE	Foreign currency key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	FRWAE	Allow NULL?
18	REC_WAERS	Currency of the data record	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	RKE_REC_WAERS	Allow NULL?
19	KAUFN	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	KDAUF	Allow NULL?
20	KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
21	RKAUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
22	SKOST	Sender cost center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	SKOST	Allow NULL?
23	PRZNR	Sender Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	CBPR	SEPRZ	Allow NULL?
24	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
25	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
26	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
27	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
28	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
29	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	TVTW	VTWEG	Allow NULL?
30	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
31	HRKFT	Origins (CO-PA)	nvarchar	4	0	CHAR	(N' ')	Yes		RKEHERK	Allow NULL?
32	KSTAR	Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	CSKA	KSTAR	Allow NULL?
33	PSPNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_PNR	Allow NULL?
34	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	Yes	CKPH	KSTRG	Allow NULL?
35	RBELN	Reference document number for CO-PA line item	nvarchar	10	0	CHAR	(N' ')	Yes		RKERFBELNR	Allow NULL?
36	RPOSN	Item number from reference document (CO-PA)	nvarchar	6	0	CHAR	(N' ')	Yes		RKERFPOSNR	Allow NULL?
37	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PRCTR	Allow NULL?
38	PPRCTR	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PPRCTR	Allow NULL?
39	RKESTATU	Update status for CO-PA line items	nvarchar	10	0	CHAR	(N' ')	Yes		RKESTATU	Allow NULL?
40	TIMESTMP	Time created (Greenwich Meantime)	decimal	16	0	DEC	((0))	Yes		RKE_HZSTMP
41	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
42	MVGR1	Material group 1	nvarchar	3	0	CHAR	(N' ')	Yes	TVM1	MVGR1	Allow NULL?
43	WWPH1	Prod.hier.1 bef. 4.5	nvarchar	5	0	CHAR	(N' ')	Yes	T2508	RKEG_WWPH1	Allow NULL?
44	WWPH2	Prod.hier.2 bef. 4.5	nvarchar	10	0	CHAR	(N' ')	Yes	T2509	RKEG_WWPH2	Allow NULL?
45	WWPH3	Prod.hier.3 bef. 4.5	nvarchar	18	0	CHAR	(N' ')	Yes	T2510	RKEG_WWPH3	Allow NULL?
46	WWPRC	Product category	nvarchar	8	0	CHAR	(N' ')	Yes	T2520	RKEG_WWPRC	Allow NULL?
47	WWSOP	Prod.group for SOP	nvarchar	18	0	CHAR	(N' ')	Yes	T2511	RKEG_WWSOP	Allow NULL?
48	WWSBU	Strategic Bus.Unit	nvarchar	8	0	CHAR	(N' ')	Yes	T2515	RKEG_WWSBU	Allow NULL?
49	KDGRP	Customer group	nvarchar	2	0	CHAR	(N' ')	Yes	T151	KDGRP	Allow NULL?
50	KUKLA	Customer classification	nvarchar	2	0	CHAR	(N' ')	Yes	TKUKL	KUKLA	Allow NULL?
51	BZIRK	Sales district	nvarchar	6	0	CHAR	(N' ')	Yes	T171	BZIRK	Allow NULL?
52	BRSCH	Industry key	nvarchar	4	0	CHAR	(N' ')	Yes	T016	BRSCH	Allow NULL?
53	WWREG	Region before 4.5	nvarchar	6	0	CHAR	(N' ')	Yes	T2516	RKEG_WWREG	Allow NULL?
54	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1_GP	Allow NULL?
55	KUNWE	Ship-to party	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNWE	Allow NULL?
56	WWCST	Country Ship-to	nvarchar	3	0	CHAR	(N' ')	Yes	T2517	RKEG_WWCST	Allow NULL?
57	WWRST	Intern.Region Ship-t	nvarchar	3	0	CHAR	(N' ')	Yes	T2518	RKEG_WWRST	Allow NULL?
58	HIE01	Customer hierarchy Level 1	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	HIEZU01	Allow NULL?
59	HIE02	Customer hierarchy Level 2	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	HIEZU02	Allow NULL?
60	HIE03	Customer hierarchy Level 3	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	HIEZU03	Allow NULL?
61	VRTNR	Sales employee	nvarchar	8	0	NUMC	(N'00000000')	Yes		VRTNR	Allow NULL?
62	VKBUR	Sales Office	nvarchar	4	0	CHAR	(N' ')	Yes	TVBUR	VKBUR	Allow NULL?
63	VKGRP	Sales Group	nvarchar	3	0	CHAR	(N' ')	Yes	TVKGR	VKGRP	Allow NULL?
64	WWICI	Intercompany ind.	char	1	0	CHAR	(N' ')	Yes	T2519	RKEG_WWICI	Allow NULL?
65	AUGRU	Order reason (reason for the business transaction)	nvarchar	3	0	CHAR	(N' ')	Yes	TVAU	AUGRU	Allow NULL?
66	WWPRO	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	KONA	KNUMA_PI	Allow NULL?
67	WWSDL	Sales deal	nvarchar	10	0	CHAR	(N' ')	Yes	KONA	KNUMA_AG	Allow NULL?
68	PAPH1	Prod.hierarchy01-1	nvarchar	5	0	CHAR	(N' ')	Yes		RKEG_PAPH1	Allow NULL?
69	PAPH2	Prod.hierarchy01-2	nvarchar	10	0	CHAR	(N' ')	Yes		RKEG_PAPH2	Allow NULL?
70	PAPH3	Prod.hierarchy01-3	nvarchar	18	0	CHAR	(N' ')	Yes		RKEG_PAPH3	Allow NULL?
71	PAREG	CO-PA special characteristic: (Land, Region)	nvarchar	6	0	CHAR	(N' ')	Yes		RKE_PAREG	Allow NULL?
72	SORHIST	Sales Order History	char	1	0	CHAR	(N' ')	Yes		RKE_SORHI	Allow NULL?
73	WWMEA	Measurements	nvarchar	2	0	CHAR	(N' ')	Yes	T2521	RKEG_WWMEA	Allow NULL?
74	WWQUA	Quality	nvarchar	5	0	CHAR	(N' ')	Yes	T2522	RKEG_WWQUA	Allow NULL?
75	WWSUR	User Interface	nvarchar	2	0	CHAR	(N' ')	Yes	T2501	RKEG_WWSUR	Allow NULL?
76	REGIO	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
77	CRMELEM	CRM Marketing Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	RKECRMELEM	Allow NULL?
78	CRMCSTY	CRM Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	CSKA	RKECRMCSTY	Allow NULL?
79	ROUTE	Route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	ROUTE	Allow NULL?
80	VVOQT_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
81	VVIQT_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
82	VVSQT_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
83	VVGRW_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
84	VV550_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
85	VV560_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
86	VV570_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
87	VV580_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
88	VV495_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
89	VVSTU_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
90	VVOQU_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
91	VV810_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
92	VV820_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
93	VV930_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
94	VV931_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
95	VVSV_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
96	VVOQT001	Ordered quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVOQT
97	VVIQT001	Invoiced quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVIQT
98	VVSQT001	Invoic. qty in SKU	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSQT
99	VVGRW001	Gross weight	decimal	15	3	QUAN	((0))	Yes		RKE2_VVGRW
100	VV010001	Revenue	decimal	15	2	CURR	((0))	Yes		RKE2_VV010
101	VV020001	Quantity discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV020
102	VV030001	Customer discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV030
103	VV040001	Material discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV040
104	VV060001	Other rebates	decimal	15	2	CURR	((0))	Yes		RKE2_VV060
105	VV070001	Accrued Sales deduc.	decimal	15	2	CURR	((0))	Yes		RKE2_VV070
106	VV090001	Accrued bonus	decimal	15	2	CURR	((0))	Yes		RKE2_VV090
107	VV100001	Outgoing freight	decimal	15	2	CURR	((0))	Yes		RKE2_VV100
108	VV110001	Accrued freight	decimal	15	2	CURR	((0))	Yes		RKE2_VV110
109	VV120001	Dispatch packaging	decimal	15	2	CURR	((0))	Yes		RKE2_VV120
110	VV130001	Internal sales Comm.	decimal	15	2	CURR	((0))	Yes		RKE2_VV130
111	VV140001	Cost of goods sold	decimal	15	2	CURR	((0))	Yes		RKE2_VV140
112	VV150001	Material Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV150
113	VV160001	Trading Goods	decimal	15	2	CURR	((0))	Yes		RKE2_VV160
114	VV170001	Production Labor fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV170
115	VV180001	Production Labor var	decimal	15	2	CURR	((0))	Yes		RKE2_VV180
116	VV190001	Production Setup	decimal	15	2	CURR	((0))	Yes		RKE2_VV190
117	VV200001	Produc. machine fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV200
118	VV210001	Produc. machine var	decimal	15	2	CURR	((0))	Yes		RKE2_VV210
119	VV220001	Produc. Burn-in fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV220
120	VV230001	Produc. Burn-in var	decimal	15	2	CURR	((0))	Yes		RKE2_VV230
121	VV240001	Outside Processing	decimal	15	2	CURR	((0))	Yes		RKE2_VV240
122	VV250001	Material Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV250
123	VV260001	Administr. Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV260
124	VV270001	Sales Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV270
125	VV280001	Miscellaneous Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV280
126	VV290001	Price variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV290
127	VV300001	Quant. Variance Mat.	decimal	15	2	CURR	((0))	Yes		RKE2_VV300
128	VV310001	Quant. Variance Prod	decimal	15	2	CURR	((0))	Yes		RKE2_VV310
129	VV320001	Lot-size Variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV320
130	VV330001	Usage variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV330
131	VV340001	Input Variances	decimal	15	2	CURR	((0))	Yes		RKE2_VV340
132	VV350001	Scrap	decimal	15	2	CURR	((0))	Yes		RKE2_VV350
133	VV360001	Remaining Variances	decimal	15	2	CURR	((0))	Yes		RKE2_VV360
134	VV370001	Gen.Admin. costs CCA	decimal	15	2	CURR	((0))	Yes		RKE2_VV370
135	VV380001	General Market.costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV380
136	VV390001	Distribution costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV390
137	VV400001	Production costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV400
138	VV410001	Marketing activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV410
139	VV420001	Research & Develop.	decimal	15	2	CURR	((0))	Yes		RKE2_VV420
140	VV430001	Reserv.f.imminent lo	decimal	15	2	CURR	((0))	Yes		RKE2_VV430
141	VV440001	Corr:Material Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV440
142	VV450001	Corr:Manuf.Costs fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV450
143	VV460001	Corr:Manuf.Costs var	decimal	15	2	CURR	((0))	Yes		RKE2_VV460
144	VV470001	Corr:Overhead Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV470
145	VV480001	Maintenance	decimal	15	2	CURR	((0))	Yes		RKE2_VV480
146	VV145001	COGS alternative	decimal	15	2	CURR	((0))	Yes		RKE2_VV145
147	VV075001	Actual Sales deduc.	decimal	15	2	CURR	((0))	Yes		RKE2_VV075
148	VV500001	Process "Production"	decimal	15	2	CURR	((0))	Yes		RKE2_VV500
149	VV510001	Process "Procurement"	decimal	15	2	CURR	((0))	Yes		RKE2_VV510
150	VV520001	Process "Sales"	decimal	15	2	CURR	((0))	Yes		RKE2_VV520
151	VV530001	Process "Administration"	decimal	15	2	CURR	((0))	Yes		RKE2_VV530
152	VV550001	Number of sales order items	decimal	15	3	QUAN	((0))	Yes		RKE2_VV550
153	VV560001	Number of payment problems	decimal	15	3	QUAN	((0))	Yes		RKE2_VV560
154	VV570001	Number of purchase orders for sales order	decimal	15	3	QUAN	((0))	Yes		RKE2_VV570
155	VV580001	Number of goods receipts for sales orders	decimal	15	3	QUAN	((0))	Yes		RKE2_VV580
156	VV495001	Number of employees	decimal	15	3	QUAN	((0))	Yes		RKE2_VV495
157	VVSTU001	Standard Unit of M.	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSTU
158	VV155001	Grace costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV155
159	VV365001	Price differences	decimal	15	2	CURR	((0))	Yes		RKE2_VV365
160	VV364001	Mixed-price variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV364
161	VVK15001	Group: Material	decimal	15	2	CURR	((0))	Yes		RKE2_VVK15
162	VVK20001	Group: Material overhead costs	decimal	15	2	CURR	((0))	Yes		RKE2_VVK20
163	VVK25001	Group: Production	decimal	15	2	CURR	((0))	Yes		RKE2_VVK25
164	VVK30001	Group: Misc.	decimal	15	2	CURR	((0))	Yes		RKE2_VVK30
165	VVK10001	Group price	decimal	15	2	CURR	((0))	Yes		RKE2_VVK10
166	VVO10001	PCA: Int. revenues	decimal	15	2	CURR	((0))	Yes		RKE2_VVO10
167	VVO20001	PCA: Int. costs	decimal	15	2	CURR	((0))	Yes		RKE2_VVO20
168	VVOQU001	PCA: Delivery quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVOQU
169	VV366001	Other Actual Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV366
170	VV367001	Sales and Administration Costs - Actual	decimal	15	2	CURR	((0))	Yes		RKE2_VV367
171	VV368001	Process "Production" Actual	decimal	15	2	CURR	((0))	Yes		RKE2_VV368
172	VV151001	Actual Mat. Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV151
173	VV171001	Act. Fxd Prod. Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV171
174	VV181001	Actual Variable Production Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV181
175	VV191001	Actual Setup Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV191
176	VV201001	Actual Fixed Machine Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV201
177	VV211001	Actual Variable Machine Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV211
178	VV251001	Actual Material Overhead Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV251
179	VV810001	No. of Inquiries	decimal	15	3	QUAN	((0))	Yes		RKE2_VV810
180	VV820001	No. of Complaints	decimal	15	3	QUAN	((0))	Yes		RKE2_VV820
181	VV830001	Cost of Inquiries	decimal	15	2	CURR	((0))	Yes		RKE2_VV830
182	VV840001	Cost of Complaints	decimal	15	2	CURR	((0))	Yes		RKE2_VV840
183	VV095001	oth. sales deduct.	decimal	15	2	CURR	((0))	Yes		RKE2_VV095
184	VV713001	Advertising	decimal	15	2	CURR	((0))	Yes		RKE2_VV713
185	VV900001	Revenue fee	decimal	15	2	CURR	((0))	Yes		RKE2_VV900
186	VV910001	Revenue from Expenses/Travel Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV910
187	VV915001	Revenues from External Activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV915
188	VV920001	Sales Deductions	decimal	15	2	CURR	((0))	Yes		RKE2_VV920
189	VV930001	Number of Labor Hours	decimal	15	3	QUAN	((0))	Yes		RKE2_VV930
190	VV931001	Number of Hours Billed	decimal	15	3	QUAN	((0))	Yes		RKE2_VV931
191	VV940001	Cost of Labor Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV940
192	VV950001	Travel expenses	decimal	15	2	CURR	((0))	Yes		RKE2_VV950
193	VV960001	Other expenses	decimal	15	2	CURR	((0))	Yes		RKE2_VV960
194	VV970001	Costs from External Activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV970
195	VV999001	X_Technical	decimal	15	2	CURR	((0))	Yes		RKE2_VV999
196	VVADV001	Advert. Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVADV
197	VVCGS001	COGS in SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVCGS
198	VVDEP001	Deprec. Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVDEP
199	VVENG001	Energy Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVENG
200	VVNR001	NetRevenue in SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVNR
201	VVPSC001	PersonnelCost SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVPSC
202	VVREN001	Rent Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVREN
203	VVREV001	Revenue SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVREV
204	VVSD001	SalesDiscount SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVSD
205	VVCM2001	Contr.Margin2 SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVCM2
206	VVSV001	Sales Volume SEM215	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSV
207	VVLS1001	Costs pre-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS1
208	VVLS2001	Costs main-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS2
209	VVLS3001	Costs sub-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS3
210	AUSFR001	OutgoingFreight	decimal	15	2	CURR	((0))	Yes		RKE2_AUSFR

TOP ERP 6.0 | CE2IDEA INDEXES

Name	Primary	Unique	Type	Columns
CE2IDEA~0	Yes	Yes	CLUSTERED	PERBL, BELNR, PASUBNR, PAOBJNR, VERSI, VRGAR, PALEDGER, MANDT
CE2IDEA~1	No	No	NONCLUSTERED	VRGAR, RBELN
CE2IDEA~2	No	No	NONCLUSTERED	PAOBJNR, TIMESTMP, 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

210 COLUMNS | 3 INDEXES | ERP 6.0 | CE2IDEA TABLE

TOP ERP 6.0 | CE2IDEA COLUMNS

TOP ERP 6.0 | CE2IDEA 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

210 COLUMNS | 3 INDEXES | ERP 6.0 | CE2IDEA TABLE

TOPERP 6.0 | CE2IDEA COLUMNS

TOPERP 6.0 | CE2IDEA INDEXES

TOP ERP 6.0 | CE2IDEA COLUMNS

TOP ERP 6.0 | CE2IDEA INDEXES