	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

226 COLUMNS | 3 INDEXES | ERP 6.0 | CE1IDEA TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Controlling :: Profitability Analysis
1	ERP EHP7	6.0	CE1IDEA	226	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, PERIO, PAOBJNR, PASUBNR, BELNR, POSNR, HZDAT, USNAM, GJAHR, PERDE, WADAT, FADAT, BUDAT, ALTPERIO, PAPAOBJNR, PAPASUBNR, KNDNR, ARTNR, FKART, FRWAE, KURSF, KURSBK, KURSKZ, REC_WAERS, KAUFN, KDPOS, RKAUFNR, SKOST, PRZNR, BUKRS, KOKRS, WERKS, GSBER, VKORG, VTWEG, SPART, HRKFT, PLIKZ, KSTAR, PSPNR, KSTRG, RBELN, RPOSN, STO_BELNR, STO_POSNR, PRCTR, PPRCTR, RKESTATU, TIMESTMP, COPA_AWTYP, COPA_AWORG, COPA_BWZPT, COPA_AWSYS, 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, VVOQT, VVIQT, VVSQT, VVGRW, VV010, VV020, VV030, VV040, VV060, VV070, VV090, VV100, VV110, VV120, VV130, VV140, VV150, VV160, VV170, VV180, VV190, VV200, VV210, VV220, VV230, VV240, VV250, VV260, VV270, VV280, VV290, VV300, VV310, VV320, VV330, VV340, VV350, VV360, VV370, VV380, VV390, VV400, VV410, VV420, VV430, VV440, VV450, VV460, VV470, VV480, VV145, VV075, VV500, VV510, VV520, VV530, VV550, VV560, VV570, VV580, VV495, VVSTU, VV155, VV365, VV364, VVK15, VVK20, VVK25, VVK30, VVK10, VVO10, VVO20, VVOQU, VV366, VV367, VV368, VV151, VV171, VV181, VV191, VV201, VV211, VV251, VV810, VV820, VV830, VV840, VV095, VV713, VV900, VV910, VV915, VV920, VV930, VV931, VV940, VV950, VV960, VV970, VV999, VVADV, VVCGS, VVDEP, VVENG, VVNR, VVPSC, VVREN, VVREV, VVSD, VVCM2, VVSV, VVLS1, VVLS2, VVLS3, AUSFR FROM CE1IDEA

TOP ERP 6.0 | CE1IDEA 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	PERIO	Period/year	nvarchar	7	0	NUMC	(N'0000000')	No		JAHRPER	Allow NULL?
6	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	No		RKEOBJNR	Allow NULL?
7	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	NUMC	(N'0000')	No		RKESUBNR	Allow NULL?
8	BELNR	Document number of line item in Profitability Analysis	nvarchar	10	0	CHAR	(N' ')	No		RKE_BELNR	Allow NULL?
9	POSNR	Item no. of CO-PA line item	nvarchar	6	0	CHAR	(N' ')	No		RKE_POSNR	Allow NULL?
10	HZDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
11	USNAM	Created by	nvarchar	12	0	CHAR	(N' ')	Yes		ERFASSER	Allow NULL?
12	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
13	PERDE	Period	nvarchar	3	0	NUMC	(N'000')	Yes		PERIODE	Allow NULL?
14	WADAT	Goods Issue Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WADAT	Allow NULL?
15	FADAT	Invoice date (date created)	nvarchar	8	0	DATS	(N'00000000')	Yes		FADAT	Allow NULL?
16	BUDAT	Posting Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DAERF	Allow NULL?
17	ALTPERIO	Period/year in alternative period type	nvarchar	7	0	NUMC	(N'0000000')	Yes		JAHRPERALT	Allow NULL?
18	PAPAOBJNR	Partner profitability segment number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEPOBJ	Allow NULL?
19	PAPASUBNR	Changes to partner profitability segments (CO-PA)	nvarchar	4	0	NUMC	(N'0000')	Yes		RKEPSUBNR	Allow NULL?
20	KNDNR	Customer	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNDE_PA	Allow NULL?
21	ARTNR	Product number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	ARTNR	Allow NULL?
22	FKART	Billing Type	nvarchar	4	0	CHAR	(N' ')	Yes	TVFK	FKART	Allow NULL?
23	FRWAE	Foreign currency key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	FRWAE	Allow NULL?
24	KURSF	Exchange rate	decimal	9	5	DEC	((0))	Yes		KURSF
25	KURSBK	Exchange rate for op.concern currency -> Co.code currency	decimal	9	5	DEC	((0))	Yes		KURSBK
26	KURSKZ	Exchange rate op.concern currency -> group currency	decimal	9	5	DEC	((0))	Yes		KURSKZ
27	REC_WAERS	Currency of the data record	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	RKE_REC_WAERS	Allow NULL?
28	KAUFN	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	KDAUF	Allow NULL?
29	KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
30	RKAUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
31	SKOST	Sender cost center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	SKOST	Allow NULL?
32	PRZNR	Sender Business Process	nvarchar	12	0	CHAR	(N' ')	Yes	CBPR	SEPRZ	Allow NULL?
33	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
34	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
35	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
36	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
37	VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
38	VTWEG	Distribution Channel	nvarchar	2	0	CHAR	(N' ')	Yes	TVTW	VTWEG	Allow NULL?
39	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
40	HRKFT	Origins (CO-PA)	nvarchar	4	0	CHAR	(N' ')	Yes		RKEHERK	Allow NULL?
41	PLIKZ	Plan/Actual Indicator	char	1	0	CHAR	(N' ')	Yes		PLIKZ	Allow NULL?
42	KSTAR	Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	CSKA	KSTAR	Allow NULL?
43	PSPNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_PNR	Allow NULL?
44	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	Yes	CKPH	KSTRG	Allow NULL?
45	RBELN	Reference document number for CO-PA line item	nvarchar	10	0	CHAR	(N' ')	Yes		RKERFBELNR	Allow NULL?
46	RPOSN	Item number from reference document (CO-PA)	nvarchar	6	0	CHAR	(N' ')	Yes		RKERFPOSNR	Allow NULL?
47	STO_BELNR	Canceled document	nvarchar	10	0	CHAR	(N' ')	Yes		RKE_STO_BELNR	Allow NULL?
48	STO_POSNR	Canceled document item	nvarchar	6	0	CHAR	(N' ')	Yes		RKE_STO_POSNR	Allow NULL?
49	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PRCTR	Allow NULL?
50	PPRCTR	Partner Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PPRCTR	Allow NULL?
51	RKESTATU	Update status for CO-PA line items	nvarchar	10	0	CHAR	(N' ')	Yes		RKESTATU	Allow NULL?
52	TIMESTMP	Time created (Greenwich Meantime)	decimal	16	0	DEC	((0))	Yes		RKE_HZSTMP
53	COPA_AWTYP	Reference Transaction	nvarchar	5	0	CHAR	(N' ')	Yes	*	AWTYP	Allow NULL?
54	COPA_AWORG	Reference Organizational Units	nvarchar	10	0	CHAR	(N' ')	Yes		AWORG	Allow NULL?
55	COPA_BWZPT	CO-PA Point of valuation	char	1	0	CHAR	(N' ')	Yes		BWZPT	Allow NULL?
56	COPA_AWSYS	Logical system of source document	nvarchar	10	0	CHAR	(N' ')	Yes	TBDLS	AWSYS	Allow NULL?
57	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
58	MVGR1	Material group 1	nvarchar	3	0	CHAR	(N' ')	Yes	TVM1	MVGR1	Allow NULL?
59	WWPH1	Prod.hier.1 bef. 4.5	nvarchar	5	0	CHAR	(N' ')	Yes	T2508	RKEG_WWPH1	Allow NULL?
60	WWPH2	Prod.hier.2 bef. 4.5	nvarchar	10	0	CHAR	(N' ')	Yes	T2509	RKEG_WWPH2	Allow NULL?
61	WWPH3	Prod.hier.3 bef. 4.5	nvarchar	18	0	CHAR	(N' ')	Yes	T2510	RKEG_WWPH3	Allow NULL?
62	WWPRC	Product category	nvarchar	8	0	CHAR	(N' ')	Yes	T2520	RKEG_WWPRC	Allow NULL?
63	WWSOP	Prod.group for SOP	nvarchar	18	0	CHAR	(N' ')	Yes	T2511	RKEG_WWSOP	Allow NULL?
64	WWSBU	Strategic Bus.Unit	nvarchar	8	0	CHAR	(N' ')	Yes	T2515	RKEG_WWSBU	Allow NULL?
65	KDGRP	Customer group	nvarchar	2	0	CHAR	(N' ')	Yes	T151	KDGRP	Allow NULL?
66	KUKLA	Customer classification	nvarchar	2	0	CHAR	(N' ')	Yes	TKUKL	KUKLA	Allow NULL?
67	BZIRK	Sales district	nvarchar	6	0	CHAR	(N' ')	Yes	T171	BZIRK	Allow NULL?
68	BRSCH	Industry key	nvarchar	4	0	CHAR	(N' ')	Yes	T016	BRSCH	Allow NULL?
69	WWREG	Region before 4.5	nvarchar	6	0	CHAR	(N' ')	Yes	T2516	RKEG_WWREG	Allow NULL?
70	LAND1	Country Key	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LAND1_GP	Allow NULL?
71	KUNWE	Ship-to party	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNWE	Allow NULL?
72	WWCST	Country Ship-to	nvarchar	3	0	CHAR	(N' ')	Yes	T2517	RKEG_WWCST	Allow NULL?
73	WWRST	Intern.Region Ship-t	nvarchar	3	0	CHAR	(N' ')	Yes	T2518	RKEG_WWRST	Allow NULL?
74	HIE01	Customer hierarchy Level 1	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	HIEZU01	Allow NULL?
75	HIE02	Customer hierarchy Level 2	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	HIEZU02	Allow NULL?
76	HIE03	Customer hierarchy Level 3	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	HIEZU03	Allow NULL?
77	VRTNR	Sales employee	nvarchar	8	0	NUMC	(N'00000000')	Yes		VRTNR	Allow NULL?
78	VKBUR	Sales Office	nvarchar	4	0	CHAR	(N' ')	Yes	TVBUR	VKBUR	Allow NULL?
79	VKGRP	Sales Group	nvarchar	3	0	CHAR	(N' ')	Yes	TVKGR	VKGRP	Allow NULL?
80	WWICI	Intercompany ind.	char	1	0	CHAR	(N' ')	Yes	T2519	RKEG_WWICI	Allow NULL?
81	AUGRU	Order reason (reason for the business transaction)	nvarchar	3	0	CHAR	(N' ')	Yes	TVAU	AUGRU	Allow NULL?
82	WWPRO	Promotion	nvarchar	10	0	CHAR	(N' ')	Yes	KONA	KNUMA_PI	Allow NULL?
83	WWSDL	Sales deal	nvarchar	10	0	CHAR	(N' ')	Yes	KONA	KNUMA_AG	Allow NULL?
84	PAPH1	Prod.hierarchy01-1	nvarchar	5	0	CHAR	(N' ')	Yes		RKEG_PAPH1	Allow NULL?
85	PAPH2	Prod.hierarchy01-2	nvarchar	10	0	CHAR	(N' ')	Yes		RKEG_PAPH2	Allow NULL?
86	PAPH3	Prod.hierarchy01-3	nvarchar	18	0	CHAR	(N' ')	Yes		RKEG_PAPH3	Allow NULL?
87	PAREG	CO-PA special characteristic: (Land, Region)	nvarchar	6	0	CHAR	(N' ')	Yes		RKE_PAREG	Allow NULL?
88	SORHIST	Sales Order History	char	1	0	CHAR	(N' ')	Yes		RKE_SORHI	Allow NULL?
89	WWMEA	Measurements	nvarchar	2	0	CHAR	(N' ')	Yes	T2521	RKEG_WWMEA	Allow NULL?
90	WWQUA	Quality	nvarchar	5	0	CHAR	(N' ')	Yes	T2522	RKEG_WWQUA	Allow NULL?
91	WWSUR	User Interface	nvarchar	2	0	CHAR	(N' ')	Yes	T2501	RKEG_WWSUR	Allow NULL?
92	REGIO	Region (State, Province, County)	nvarchar	3	0	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
93	CRMELEM	CRM Marketing Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	RKECRMELEM	Allow NULL?
94	CRMCSTY	CRM Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	CSKA	RKECRMCSTY	Allow NULL?
95	ROUTE	Route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	ROUTE	Allow NULL?
96	VVOQT_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
97	VVIQT_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
98	VVSQT_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
99	VVGRW_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
100	VV550_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
101	VV560_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
102	VV570_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
103	VV580_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
104	VV495_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
105	VVSTU_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
106	VVOQU_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
107	VV810_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
108	VV820_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
109	VV930_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
110	VV931_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
111	VVSV_ME	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
112	VVOQT	Ordered quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVOQT
113	VVIQT	Invoiced quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVIQT
114	VVSQT	Invoic. qty in SKU	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSQT
115	VVGRW	Gross weight	decimal	15	3	QUAN	((0))	Yes		RKE2_VVGRW
116	VV010	Revenue	decimal	15	2	CURR	((0))	Yes		RKE2_VV010
117	VV020	Quantity discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV020
118	VV030	Customer discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV030
119	VV040	Material discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV040
120	VV060	Other rebates	decimal	15	2	CURR	((0))	Yes		RKE2_VV060
121	VV070	Accrued Sales deduc.	decimal	15	2	CURR	((0))	Yes		RKE2_VV070
122	VV090	Accrued bonus	decimal	15	2	CURR	((0))	Yes		RKE2_VV090
123	VV100	Outgoing freight	decimal	15	2	CURR	((0))	Yes		RKE2_VV100
124	VV110	Accrued freight	decimal	15	2	CURR	((0))	Yes		RKE2_VV110
125	VV120	Dispatch packaging	decimal	15	2	CURR	((0))	Yes		RKE2_VV120
126	VV130	Internal sales Comm.	decimal	15	2	CURR	((0))	Yes		RKE2_VV130
127	VV140	Cost of goods sold	decimal	15	2	CURR	((0))	Yes		RKE2_VV140
128	VV150	Material Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV150
129	VV160	Trading Goods	decimal	15	2	CURR	((0))	Yes		RKE2_VV160
130	VV170	Production Labor fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV170
131	VV180	Production Labor var	decimal	15	2	CURR	((0))	Yes		RKE2_VV180
132	VV190	Production Setup	decimal	15	2	CURR	((0))	Yes		RKE2_VV190
133	VV200	Produc. machine fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV200
134	VV210	Produc. machine var	decimal	15	2	CURR	((0))	Yes		RKE2_VV210
135	VV220	Produc. Burn-in fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV220
136	VV230	Produc. Burn-in var	decimal	15	2	CURR	((0))	Yes		RKE2_VV230
137	VV240	Outside Processing	decimal	15	2	CURR	((0))	Yes		RKE2_VV240
138	VV250	Material Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV250
139	VV260	Administr. Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV260
140	VV270	Sales Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV270
141	VV280	Miscellaneous Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV280
142	VV290	Price variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV290
143	VV300	Quant. Variance Mat.	decimal	15	2	CURR	((0))	Yes		RKE2_VV300
144	VV310	Quant. Variance Prod	decimal	15	2	CURR	((0))	Yes		RKE2_VV310
145	VV320	Lot-size Variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV320
146	VV330	Usage variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV330
147	VV340	Input Variances	decimal	15	2	CURR	((0))	Yes		RKE2_VV340
148	VV350	Scrap	decimal	15	2	CURR	((0))	Yes		RKE2_VV350
149	VV360	Remaining Variances	decimal	15	2	CURR	((0))	Yes		RKE2_VV360
150	VV370	Gen.Admin. costs CCA	decimal	15	2	CURR	((0))	Yes		RKE2_VV370
151	VV380	General Market.costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV380
152	VV390	Distribution costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV390
153	VV400	Production costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV400
154	VV410	Marketing activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV410
155	VV420	Research & Develop.	decimal	15	2	CURR	((0))	Yes		RKE2_VV420
156	VV430	Reserv.f.imminent lo	decimal	15	2	CURR	((0))	Yes		RKE2_VV430
157	VV440	Corr:Material Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV440
158	VV450	Corr:Manuf.Costs fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV450
159	VV460	Corr:Manuf.Costs var	decimal	15	2	CURR	((0))	Yes		RKE2_VV460
160	VV470	Corr:Overhead Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV470
161	VV480	Maintenance	decimal	15	2	CURR	((0))	Yes		RKE2_VV480
162	VV145	COGS alternative	decimal	15	2	CURR	((0))	Yes		RKE2_VV145
163	VV075	Actual Sales deduc.	decimal	15	2	CURR	((0))	Yes		RKE2_VV075
164	VV500	Process "Production"	decimal	15	2	CURR	((0))	Yes		RKE2_VV500
165	VV510	Process "Procurement"	decimal	15	2	CURR	((0))	Yes		RKE2_VV510
166	VV520	Process "Sales"	decimal	15	2	CURR	((0))	Yes		RKE2_VV520
167	VV530	Process "Administration"	decimal	15	2	CURR	((0))	Yes		RKE2_VV530
168	VV550	Number of sales order items	decimal	15	3	QUAN	((0))	Yes		RKE2_VV550
169	VV560	Number of payment problems	decimal	15	3	QUAN	((0))	Yes		RKE2_VV560
170	VV570	Number of purchase orders for sales order	decimal	15	3	QUAN	((0))	Yes		RKE2_VV570
171	VV580	Number of goods receipts for sales orders	decimal	15	3	QUAN	((0))	Yes		RKE2_VV580
172	VV495	Number of employees	decimal	15	3	QUAN	((0))	Yes		RKE2_VV495
173	VVSTU	Standard Unit of M.	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSTU
174	VV155	Grace costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV155
175	VV365	Price differences	decimal	15	2	CURR	((0))	Yes		RKE2_VV365
176	VV364	Mixed-price variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV364
177	VVK15	Group: Material	decimal	15	2	CURR	((0))	Yes		RKE2_VVK15
178	VVK20	Group: Material overhead costs	decimal	15	2	CURR	((0))	Yes		RKE2_VVK20
179	VVK25	Group: Production	decimal	15	2	CURR	((0))	Yes		RKE2_VVK25
180	VVK30	Group: Misc.	decimal	15	2	CURR	((0))	Yes		RKE2_VVK30
181	VVK10	Group price	decimal	15	2	CURR	((0))	Yes		RKE2_VVK10
182	VVO10	PCA: Int. revenues	decimal	15	2	CURR	((0))	Yes		RKE2_VVO10
183	VVO20	PCA: Int. costs	decimal	15	2	CURR	((0))	Yes		RKE2_VVO20
184	VVOQU	PCA: Delivery quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVOQU
185	VV366	Other Actual Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV366
186	VV367	Sales and Administration Costs - Actual	decimal	15	2	CURR	((0))	Yes		RKE2_VV367
187	VV368	Process "Production" Actual	decimal	15	2	CURR	((0))	Yes		RKE2_VV368
188	VV151	Actual Mat. Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV151
189	VV171	Act. Fxd Prod. Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV171
190	VV181	Actual Variable Production Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV181
191	VV191	Actual Setup Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV191
192	VV201	Actual Fixed Machine Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV201
193	VV211	Actual Variable Machine Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV211
194	VV251	Actual Material Overhead Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV251
195	VV810	No. of Inquiries	decimal	15	3	QUAN	((0))	Yes		RKE2_VV810
196	VV820	No. of Complaints	decimal	15	3	QUAN	((0))	Yes		RKE2_VV820
197	VV830	Cost of Inquiries	decimal	15	2	CURR	((0))	Yes		RKE2_VV830
198	VV840	Cost of Complaints	decimal	15	2	CURR	((0))	Yes		RKE2_VV840
199	VV095	oth. sales deduct.	decimal	15	2	CURR	((0))	Yes		RKE2_VV095
200	VV713	Advertising	decimal	15	2	CURR	((0))	Yes		RKE2_VV713
201	VV900	Revenue fee	decimal	15	2	CURR	((0))	Yes		RKE2_VV900
202	VV910	Revenue from Expenses/Travel Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV910
203	VV915	Revenues from External Activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV915
204	VV920	Sales Deductions	decimal	15	2	CURR	((0))	Yes		RKE2_VV920
205	VV930	Number of Labor Hours	decimal	15	3	QUAN	((0))	Yes		RKE2_VV930
206	VV931	Number of Hours Billed	decimal	15	3	QUAN	((0))	Yes		RKE2_VV931
207	VV940	Cost of Labor Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV940
208	VV950	Travel expenses	decimal	15	2	CURR	((0))	Yes		RKE2_VV950
209	VV960	Other expenses	decimal	15	2	CURR	((0))	Yes		RKE2_VV960
210	VV970	Costs from External Activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV970
211	VV999	X_Technical	decimal	15	2	CURR	((0))	Yes		RKE2_VV999
212	VVADV	Advert. Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVADV
213	VVCGS	COGS in SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVCGS
214	VVDEP	Deprec. Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVDEP
215	VVENG	Energy Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVENG
216	VVNR	NetRevenue in SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVNR
217	VVPSC	PersonnelCost SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVPSC
218	VVREN	Rent Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVREN
219	VVREV	Revenue SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVREV
220	VVSD	SalesDiscount SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVSD
221	VVCM2	Contr.Margin2 SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVCM2
222	VVSV	Sales Volume SEM215	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSV
223	VVLS1	Costs pre-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS1
224	VVLS2	Costs main-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS2
225	VVLS3	Costs sub-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS3
226	AUSFR	OutgoingFreight	decimal	15	2	CURR	((0))	Yes		RKE2_AUSFR

TOP ERP 6.0 | CE1IDEA INDEXES

Name	Primary	Unique	Type	Columns
CE1IDEA~0	Yes	Yes	CLUSTERED	POSNR, BELNR, PASUBNR, PAOBJNR, PERIO, VERSI, VRGAR, PALEDGER, MANDT
CE1IDEA~1	No	No	NONCLUSTERED	RPOSN, RBELN, VRGAR, MANDT
CE1IDEA~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

226 COLUMNS | 3 INDEXES | ERP 6.0 | CE1IDEA TABLE

TOP ERP 6.0 | CE1IDEA COLUMNS

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

226 COLUMNS | 3 INDEXES | ERP 6.0 | CE1IDEA TABLE

TOPERP 6.0 | CE1IDEA COLUMNS

TOPERP 6.0 | CE1IDEA INDEXES

TOP ERP 6.0 | CE1IDEA COLUMNS

TOP ERP 6.0 | CE1IDEA INDEXES