ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

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

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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PALEDGER	Currency type for an operating concern	nvarchar	2	0	Allow NULL?
3	VRGAR	Record Type	char	1	0	Allow NULL?
4	VERSI	Plan version (CO-PA)	nvarchar	3	0	Allow NULL?
5	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
6	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	Allow NULL?
7	BELNR	Document number of line item in Profitability Analysis	nvarchar	10	0	Allow NULL?
8	PERBL	Fiscal year/period block	nvarchar	7	0	Allow NULL?
9	HZDAT	Date on Which Record Was Created	nvarchar	8	0	Allow NULL?
10	USNAM	Created by	nvarchar	12	0	Allow NULL?
11	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
12	PAPAOBJNR	Partner profitability segment number (CO-PA)	nvarchar	10	0	Allow NULL?
13	PAPASUBNR	Changes to partner profitability segments (CO-PA)	nvarchar	4	0	Allow NULL?
14	KNDNR	Customer	nvarchar	10	0	Allow NULL?
15	ARTNR	Product number	nvarchar	18	0	Allow NULL?
16	FKART	Billing Type	nvarchar	4	0	Allow NULL?
17	FRWAE	Foreign currency key	nvarchar	5	0	Allow NULL?
18	REC_WAERS	Currency of the data record	nvarchar	5	0	Allow NULL?
19	KAUFN	Sales Order Number	nvarchar	10	0	Allow NULL?
20	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
21	RKAUFNR	Order Number	nvarchar	12	0	Allow NULL?
22	SKOST	Sender cost center	nvarchar	10	0	Allow NULL?
23	PRZNR	Sender Business Process	nvarchar	12	0	Allow NULL?
24	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
25	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
26	WERKS	Plant	nvarchar	4	0	Allow NULL?
27	GSBER	Business Area	nvarchar	4	0	Allow NULL?
28	VKORG	Sales Organization	nvarchar	4	0	Allow NULL?
29	VTWEG	Distribution Channel	nvarchar	2	0	Allow NULL?
30	SPART	Division	nvarchar	2	0	Allow NULL?
31	HRKFT	Origins (CO-PA)	nvarchar	4	0	Allow NULL?
32	KSTAR	Cost Element	nvarchar	10	0	Allow NULL?
33	PSPNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
34	KSTRG	Cost Object	nvarchar	12	0	Allow NULL?
35	RBELN	Reference document number for CO-PA line item	nvarchar	10	0	Allow NULL?
36	RPOSN	Item number from reference document (CO-PA)	nvarchar	6	0	Allow NULL?
37	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
38	PPRCTR	Partner Profit Center	nvarchar	10	0	Allow NULL?
39	RKESTATU	Update status for CO-PA line items	nvarchar	10	0	Allow NULL?
40	TIMESTMP	Time created (Greenwich Meantime)	decimal	16	0
41	MATKL	Material Group	nvarchar	9	0	Allow NULL?
42	MVGR1	Material group 1	nvarchar	3	0	Allow NULL?
43	WWPH1	Prod.hier.1 bef. 4.5	nvarchar	5	0	Allow NULL?
44	WWPH2	Prod.hier.2 bef. 4.5	nvarchar	10	0	Allow NULL?
45	WWPH3	Prod.hier.3 bef. 4.5	nvarchar	18	0	Allow NULL?
46	WWPRC	Product category	nvarchar	8	0	Allow NULL?
47	WWSOP	Prod.group for SOP	nvarchar	18	0	Allow NULL?
48	WWSBU	Strategic Bus.Unit	nvarchar	8	0	Allow NULL?
49	KDGRP	Customer group	nvarchar	2	0	Allow NULL?
50	KUKLA	Customer classification	nvarchar	2	0	Allow NULL?
51	BZIRK	Sales district	nvarchar	6	0	Allow NULL?
52	BRSCH	Industry key	nvarchar	4	0	Allow NULL?
53	WWREG	Region before 4.5	nvarchar	6	0	Allow NULL?
54	LAND1	Country Key	nvarchar	3	0	Allow NULL?
55	KUNWE	Ship-to party	nvarchar	10	0	Allow NULL?
56	WWCST	Country Ship-to	nvarchar	3	0	Allow NULL?
57	WWRST	Intern.Region Ship-t	nvarchar	3	0	Allow NULL?
58	HIE01	Customer hierarchy Level 1	nvarchar	10	0	Allow NULL?
59	HIE02	Customer hierarchy Level 2	nvarchar	10	0	Allow NULL?
60	HIE03	Customer hierarchy Level 3	nvarchar	10	0	Allow NULL?
61	VRTNR	Sales employee	nvarchar	8	0	Allow NULL?
62	VKBUR	Sales Office	nvarchar	4	0	Allow NULL?
63	VKGRP	Sales Group	nvarchar	3	0	Allow NULL?
64	WWICI	Intercompany ind.	char	1	0	Allow NULL?
65	AUGRU	Order reason (reason for the business transaction)	nvarchar	3	0	Allow NULL?
66	WWPRO	Promotion	nvarchar	10	0	Allow NULL?
67	WWSDL	Sales deal	nvarchar	10	0	Allow NULL?
68	PAPH1	Prod.hierarchy01-1	nvarchar	5	0	Allow NULL?
69	PAPH2	Prod.hierarchy01-2	nvarchar	10	0	Allow NULL?
70	PAPH3	Prod.hierarchy01-3	nvarchar	18	0	Allow NULL?
71	PAREG	CO-PA special characteristic: (Land, Region)	nvarchar	6	0	Allow NULL?
72	SORHIST	Sales Order History	char	1	0	Allow NULL?
73	WWMEA	Measurements	nvarchar	2	0	Allow NULL?
74	WWQUA	Quality	nvarchar	5	0	Allow NULL?
75	WWSUR	User Interface	nvarchar	2	0	Allow NULL?
76	REGIO	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
77	CRMELEM	CRM Marketing Element	nvarchar	8	0	Allow NULL?
78	CRMCSTY	CRM Cost Element	nvarchar	10	0	Allow NULL?
79	ROUTE	Route	nvarchar	6	0	Allow NULL?
80	VVOQT_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
81	VVIQT_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
82	VVSQT_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
83	VVGRW_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
84	VV550_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
85	VV560_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
86	VV570_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
87	VV580_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
88	VV495_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
89	VVSTU_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
90	VVOQU_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
91	VV810_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
92	VV820_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
93	VV930_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
94	VV931_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
95	VVSV_ME	Base Unit of Measure	nvarchar	3	0	Allow NULL?
96	VVOQT001	Ordered quantity	decimal	15	3
97	VVIQT001	Invoiced quantity	decimal	15	3
98	VVSQT001	Invoic. qty in SKU	decimal	15	3
99	VVGRW001	Gross weight	decimal	15	3
100	VV010001	Revenue	decimal	15	2
101	VV020001	Quantity discount	decimal	15	2
102	VV030001	Customer discount	decimal	15	2
103	VV040001	Material discount	decimal	15	2
104	VV060001	Other rebates	decimal	15	2
105	VV070001	Accrued Sales deduc.	decimal	15	2
106	VV090001	Accrued bonus	decimal	15	2
107	VV100001	Outgoing freight	decimal	15	2
108	VV110001	Accrued freight	decimal	15	2
109	VV120001	Dispatch packaging	decimal	15	2
110	VV130001	Internal sales Comm.	decimal	15	2
111	VV140001	Cost of goods sold	decimal	15	2
112	VV150001	Material Input	decimal	15	2
113	VV160001	Trading Goods	decimal	15	2
114	VV170001	Production Labor fix	decimal	15	2
115	VV180001	Production Labor var	decimal	15	2
116	VV190001	Production Setup	decimal	15	2
117	VV200001	Produc. machine fix	decimal	15	2
118	VV210001	Produc. machine var	decimal	15	2
119	VV220001	Produc. Burn-in fix	decimal	15	2
120	VV230001	Produc. Burn-in var	decimal	15	2
121	VV240001	Outside Processing	decimal	15	2
122	VV250001	Material Overhead	decimal	15	2
123	VV260001	Administr. Overhead	decimal	15	2
124	VV270001	Sales Overhead	decimal	15	2
125	VV280001	Miscellaneous Costs	decimal	15	2
126	VV290001	Price variance	decimal	15	2
127	VV300001	Quant. Variance Mat.	decimal	15	2
128	VV310001	Quant. Variance Prod	decimal	15	2
129	VV320001	Lot-size Variance	decimal	15	2
130	VV330001	Usage variance	decimal	15	2
131	VV340001	Input Variances	decimal	15	2
132	VV350001	Scrap	decimal	15	2
133	VV360001	Remaining Variances	decimal	15	2
134	VV370001	Gen.Admin. costs CCA	decimal	15	2
135	VV380001	General Market.costs	decimal	15	2
136	VV390001	Distribution costs	decimal	15	2
137	VV400001	Production costs	decimal	15	2
138	VV410001	Marketing activities	decimal	15	2
139	VV420001	Research & Develop.	decimal	15	2
140	VV430001	Reserv.f.imminent lo	decimal	15	2
141	VV440001	Corr:Material Input	decimal	15	2
142	VV450001	Corr:Manuf.Costs fix	decimal	15	2
143	VV460001	Corr:Manuf.Costs var	decimal	15	2
144	VV470001	Corr:Overhead Costs	decimal	15	2
145	VV480001	Maintenance	decimal	15	2
146	VV145001	COGS alternative	decimal	15	2
147	VV075001	Actual Sales deduc.	decimal	15	2
148	VV500001	Process "Production"	decimal	15	2
149	VV510001	Process "Procurement"	decimal	15	2
150	VV520001	Process "Sales"	decimal	15	2
151	VV530001	Process "Administration"	decimal	15	2
152	VV550001	Number of sales order items	decimal	15	3
153	VV560001	Number of payment problems	decimal	15	3
154	VV570001	Number of purchase orders for sales order	decimal	15	3
155	VV580001	Number of goods receipts for sales orders	decimal	15	3
156	VV495001	Number of employees	decimal	15	3
157	VVSTU001	Standard Unit of M.	decimal	15	3
158	VV155001	Grace costs	decimal	15	2
159	VV365001	Price differences	decimal	15	2
160	VV364001	Mixed-price variance	decimal	15	2
161	VVK15001	Group: Material	decimal	15	2
162	VVK20001	Group: Material overhead costs	decimal	15	2
163	VVK25001	Group: Production	decimal	15	2
164	VVK30001	Group: Misc.	decimal	15	2
165	VVK10001	Group price	decimal	15	2
166	VVO10001	PCA: Int. revenues	decimal	15	2
167	VVO20001	PCA: Int. costs	decimal	15	2
168	VVOQU001	PCA: Delivery quantity	decimal	15	3
169	VV366001	Other Actual Costs	decimal	15	2
170	VV367001	Sales and Administration Costs - Actual	decimal	15	2
171	VV368001	Process "Production" Actual	decimal	15	2
172	VV151001	Actual Mat. Input	decimal	15	2
173	VV171001	Act. Fxd Prod. Costs	decimal	15	2
174	VV181001	Actual Variable Production Costs	decimal	15	2
175	VV191001	Actual Setup Costs	decimal	15	2
176	VV201001	Actual Fixed Machine Hours	decimal	15	2
177	VV211001	Actual Variable Machine Hours	decimal	15	2
178	VV251001	Actual Material Overhead Costs	decimal	15	2
179	VV810001	No. of Inquiries	decimal	15	3
180	VV820001	No. of Complaints	decimal	15	3
181	VV830001	Cost of Inquiries	decimal	15	2
182	VV840001	Cost of Complaints	decimal	15	2
183	VV095001	oth. sales deduct.	decimal	15	2
184	VV713001	Advertising	decimal	15	2
185	VV900001	Revenue fee	decimal	15	2
186	VV910001	Revenue from Expenses/Travel Costs	decimal	15	2
187	VV915001	Revenues from External Activities	decimal	15	2
188	VV920001	Sales Deductions	decimal	15	2
189	VV930001	Number of Labor Hours	decimal	15	3
190	VV931001	Number of Hours Billed	decimal	15	3
191	VV940001	Cost of Labor Hours	decimal	15	2
192	VV950001	Travel expenses	decimal	15	2
193	VV960001	Other expenses	decimal	15	2
194	VV970001	Costs from External Activities	decimal	15	2
195	VV999001	X_Technical	decimal	15	2
196	VVADV001	Advert. Costs SEM215	decimal	15	2
197	VVCGS001	COGS in SEM215	decimal	15	2
198	VVDEP001	Deprec. Costs SEM215	decimal	15	2
199	VVENG001	Energy Costs SEM215	decimal	15	2
200	VVNR001	NetRevenue in SEM215	decimal	15	2
201	VVPSC001	PersonnelCost SEM215	decimal	15	2
202	VVREN001	Rent Costs SEM215	decimal	15	2
203	VVREV001	Revenue SEM215	decimal	15	2
204	VVSD001	SalesDiscount SEM215	decimal	15	2
205	VVCM2001	Contr.Margin2 SEM215	decimal	15	2
206	VVSV001	Sales Volume SEM215	decimal	15	3
207	VVLS1001	Costs pre-leg	decimal	15	2
208	VVLS2001	Costs main-leg	decimal	15	2
209	VVLS3001	Costs sub-leg	decimal	15	2
210	AUSFR001	OutgoingFreight	decimal	15	2

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