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	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

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	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

B1 8.8: Top 10 requests

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

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

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	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	No		RKEOBJNR	Allow NULL?
3	PALEDGER	Currency type for an operating concern	nvarchar	2	0	CHAR	(N' ')	No	TKEL	LEDBO	Allow NULL?
4	VRGAR	Record Type	char	1	0	CHAR	(N' ')	No	TVGA	RKE_VRGAR	Allow NULL?
5	PLIKZ	Plan/Actual Indicator	char	1	0	CHAR	(N' ')	No		PLIKZ	Allow NULL?
6	VERSI	Plan version (CO-PA)	nvarchar	3	0	CHAR	(N' ')	No	TKVS	RKEVERSI	Allow NULL?
7	PERBL	Fiscal year/period block	nvarchar	7	0	NUMC	(N'0000000')	No		JAHRPERBL	Allow NULL?
8	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	NUMC	(N'0000')	No		RKESUBNR	Allow NULL?
9	PAPAOBJNR	Partner profitability segment number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	No		RKEPOBJ	Allow NULL?
10	PAPASUBNR	Changes to partner profitability segments (CO-PA)	nvarchar	4	0	NUMC	(N'0000')	No		RKEPSUBNR	Allow NULL?
11	HRKFT	Origins (CO-PA)	nvarchar	4	0	CHAR	(N' ')	No		RKEHERK	Allow NULL?
12	UPDAT	Date of Last Change	nvarchar	8	0	DATS	(N'00000000')	Yes		LAEDA	Allow NULL?
13	USNAM	Last changed by	nvarchar	12	0	CHAR	(N' ')	Yes		AENNM	Allow NULL?
14	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
15	REC_WAERS	Currency of the data record	nvarchar	5	0	CUKY	(N' ')	Yes	*	RKE_REC_WAERS	Allow NULL?
16	TIMESTMP	Time created (Greenwich Meantime)	decimal	16	0	DEC	((0))	Yes		RKE_HZSTMP
17	VVOQT001	Ordered quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVOQT
18	VVIQT001	Invoiced quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVIQT
19	VVSQT001	Invoic. qty in SKU	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSQT
20	VVGRW001	Gross weight	decimal	15	3	QUAN	((0))	Yes		RKE2_VVGRW
21	VV010001	Revenue	decimal	15	2	CURR	((0))	Yes		RKE2_VV010
22	VV020001	Quantity discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV020
23	VV030001	Customer discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV030
24	VV040001	Material discount	decimal	15	2	CURR	((0))	Yes		RKE2_VV040
25	VV060001	Other rebates	decimal	15	2	CURR	((0))	Yes		RKE2_VV060
26	VV070001	Accrued Sales deduc.	decimal	15	2	CURR	((0))	Yes		RKE2_VV070
27	VV090001	Accrued bonus	decimal	15	2	CURR	((0))	Yes		RKE2_VV090
28	VV100001	Outgoing freight	decimal	15	2	CURR	((0))	Yes		RKE2_VV100
29	VV110001	Accrued freight	decimal	15	2	CURR	((0))	Yes		RKE2_VV110
30	VV120001	Dispatch packaging	decimal	15	2	CURR	((0))	Yes		RKE2_VV120
31	VV130001	Internal sales Comm.	decimal	15	2	CURR	((0))	Yes		RKE2_VV130
32	VV140001	Cost of goods sold	decimal	15	2	CURR	((0))	Yes		RKE2_VV140
33	VV150001	Material Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV150
34	VV160001	Trading Goods	decimal	15	2	CURR	((0))	Yes		RKE2_VV160
35	VV170001	Production Labor fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV170
36	VV180001	Production Labor var	decimal	15	2	CURR	((0))	Yes		RKE2_VV180
37	VV190001	Production Setup	decimal	15	2	CURR	((0))	Yes		RKE2_VV190
38	VV200001	Produc. machine fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV200
39	VV210001	Produc. machine var	decimal	15	2	CURR	((0))	Yes		RKE2_VV210
40	VV220001	Produc. Burn-in fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV220
41	VV230001	Produc. Burn-in var	decimal	15	2	CURR	((0))	Yes		RKE2_VV230
42	VV240001	Outside Processing	decimal	15	2	CURR	((0))	Yes		RKE2_VV240
43	VV250001	Material Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV250
44	VV260001	Administr. Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV260
45	VV270001	Sales Overhead	decimal	15	2	CURR	((0))	Yes		RKE2_VV270
46	VV280001	Miscellaneous Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV280
47	VV290001	Price variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV290
48	VV300001	Quant. Variance Mat.	decimal	15	2	CURR	((0))	Yes		RKE2_VV300
49	VV310001	Quant. Variance Prod	decimal	15	2	CURR	((0))	Yes		RKE2_VV310
50	VV320001	Lot-size Variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV320
51	VV330001	Usage variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV330
52	VV340001	Input Variances	decimal	15	2	CURR	((0))	Yes		RKE2_VV340
53	VV350001	Scrap	decimal	15	2	CURR	((0))	Yes		RKE2_VV350
54	VV360001	Remaining Variances	decimal	15	2	CURR	((0))	Yes		RKE2_VV360
55	VV370001	Gen.Admin. costs CCA	decimal	15	2	CURR	((0))	Yes		RKE2_VV370
56	VV380001	General Market.costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV380
57	VV390001	Distribution costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV390
58	VV400001	Production costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV400
59	VV410001	Marketing activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV410
60	VV420001	Research & Develop.	decimal	15	2	CURR	((0))	Yes		RKE2_VV420
61	VV430001	Reserv.f.imminent lo	decimal	15	2	CURR	((0))	Yes		RKE2_VV430
62	VV440001	Corr:Material Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV440
63	VV450001	Corr:Manuf.Costs fix	decimal	15	2	CURR	((0))	Yes		RKE2_VV450
64	VV460001	Corr:Manuf.Costs var	decimal	15	2	CURR	((0))	Yes		RKE2_VV460
65	VV470001	Corr:Overhead Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV470
66	VV480001	Maintenance	decimal	15	2	CURR	((0))	Yes		RKE2_VV480
67	VV145001	COGS alternative	decimal	15	2	CURR	((0))	Yes		RKE2_VV145
68	VV075001	Actual Sales deduc.	decimal	15	2	CURR	((0))	Yes		RKE2_VV075
69	VV500001	Process "Production"	decimal	15	2	CURR	((0))	Yes		RKE2_VV500
70	VV510001	Process "Procurement"	decimal	15	2	CURR	((0))	Yes		RKE2_VV510
71	VV520001	Process "Sales"	decimal	15	2	CURR	((0))	Yes		RKE2_VV520
72	VV530001	Process "Administration"	decimal	15	2	CURR	((0))	Yes		RKE2_VV530
73	VV550001	Number of sales order items	decimal	15	3	QUAN	((0))	Yes		RKE2_VV550
74	VV560001	Number of payment problems	decimal	15	3	QUAN	((0))	Yes		RKE2_VV560
75	VV570001	Number of purchase orders for sales order	decimal	15	3	QUAN	((0))	Yes		RKE2_VV570
76	VV580001	Number of goods receipts for sales orders	decimal	15	3	QUAN	((0))	Yes		RKE2_VV580
77	VV495001	Number of employees	decimal	15	3	QUAN	((0))	Yes		RKE2_VV495
78	VVSTU001	Standard Unit of M.	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSTU
79	VV155001	Grace costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV155
80	VV365001	Price differences	decimal	15	2	CURR	((0))	Yes		RKE2_VV365
81	VV364001	Mixed-price variance	decimal	15	2	CURR	((0))	Yes		RKE2_VV364
82	VVK15001	Group: Material	decimal	15	2	CURR	((0))	Yes		RKE2_VVK15
83	VVK20001	Group: Material overhead costs	decimal	15	2	CURR	((0))	Yes		RKE2_VVK20
84	VVK25001	Group: Production	decimal	15	2	CURR	((0))	Yes		RKE2_VVK25
85	VVK30001	Group: Misc.	decimal	15	2	CURR	((0))	Yes		RKE2_VVK30
86	VVK10001	Group price	decimal	15	2	CURR	((0))	Yes		RKE2_VVK10
87	VVO10001	PCA: Int. revenues	decimal	15	2	CURR	((0))	Yes		RKE2_VVO10
88	VVO20001	PCA: Int. costs	decimal	15	2	CURR	((0))	Yes		RKE2_VVO20
89	VVOQU001	PCA: Delivery quantity	decimal	15	3	QUAN	((0))	Yes		RKE2_VVOQU
90	VV366001	Other Actual Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV366
91	VV367001	Sales and Administration Costs - Actual	decimal	15	2	CURR	((0))	Yes		RKE2_VV367
92	VV368001	Process "Production" Actual	decimal	15	2	CURR	((0))	Yes		RKE2_VV368
93	VV151001	Actual Mat. Input	decimal	15	2	CURR	((0))	Yes		RKE2_VV151
94	VV171001	Act. Fxd Prod. Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV171
95	VV181001	Actual Variable Production Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV181
96	VV191001	Actual Setup Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV191
97	VV201001	Actual Fixed Machine Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV201
98	VV211001	Actual Variable Machine Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV211
99	VV251001	Actual Material Overhead Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV251
100	VV810001	No. of Inquiries	decimal	15	3	QUAN	((0))	Yes		RKE2_VV810
101	VV820001	No. of Complaints	decimal	15	3	QUAN	((0))	Yes		RKE2_VV820
102	VV830001	Cost of Inquiries	decimal	15	2	CURR	((0))	Yes		RKE2_VV830
103	VV840001	Cost of Complaints	decimal	15	2	CURR	((0))	Yes		RKE2_VV840
104	VV095001	oth. sales deduct.	decimal	15	2	CURR	((0))	Yes		RKE2_VV095
105	VV713001	Advertising	decimal	15	2	CURR	((0))	Yes		RKE2_VV713
106	VV900001	Revenue fee	decimal	15	2	CURR	((0))	Yes		RKE2_VV900
107	VV910001	Revenue from Expenses/Travel Costs	decimal	15	2	CURR	((0))	Yes		RKE2_VV910
108	VV915001	Revenues from External Activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV915
109	VV920001	Sales Deductions	decimal	15	2	CURR	((0))	Yes		RKE2_VV920
110	VV930001	Number of Labor Hours	decimal	15	3	QUAN	((0))	Yes		RKE2_VV930
111	VV931001	Number of Hours Billed	decimal	15	3	QUAN	((0))	Yes		RKE2_VV931
112	VV940001	Cost of Labor Hours	decimal	15	2	CURR	((0))	Yes		RKE2_VV940
113	VV950001	Travel expenses	decimal	15	2	CURR	((0))	Yes		RKE2_VV950
114	VV960001	Other expenses	decimal	15	2	CURR	((0))	Yes		RKE2_VV960
115	VV970001	Costs from External Activities	decimal	15	2	CURR	((0))	Yes		RKE2_VV970
116	VV999001	X_Technical	decimal	15	2	CURR	((0))	Yes		RKE2_VV999
117	VVADV001	Advert. Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVADV
118	VVCGS001	COGS in SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVCGS
119	VVDEP001	Deprec. Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVDEP
120	VVENG001	Energy Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVENG
121	VVNR001	NetRevenue in SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVNR
122	VVPSC001	PersonnelCost SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVPSC
123	VVREN001	Rent Costs SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVREN
124	VVREV001	Revenue SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVREV
125	VVSD001	SalesDiscount SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVSD
126	VVCM2001	Contr.Margin2 SEM215	decimal	15	2	CURR	((0))	Yes		RKE2_VVCM2
127	VVSV001	Sales Volume SEM215	decimal	15	3	QUAN	((0))	Yes		RKE2_VVSV
128	VVLS1001	Costs pre-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS1
129	VVLS2001	Costs main-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS2
130	VVLS3001	Costs sub-leg	decimal	15	2	CURR	((0))	Yes		RKE2_VVLS3
131	AUSFR001	OutgoingFreight	decimal	15	2	CURR	((0))	Yes		RKE2_AUSFR

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

131 COLUMNS | 1 INDEXES | ERP 6.0 | CE3IDEA TABLE

TOP ERP 6.0 | CE3IDEA COLUMNS

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

131 COLUMNS | 1 INDEXES | ERP 6.0 | CE3IDEA TABLE

TOPERP 6.0 | CE3IDEA COLUMNS

TOPERP 6.0 | CE3IDEA INDEXES

TOP ERP 6.0 | CE3IDEA COLUMNS

TOP ERP 6.0 | CE3IDEA INDEXES