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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

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

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	AKTBO	Current profitability segment (CO-PA)	char	1	CHAR	(N' ')	No		AKTBO	Allow NULL?
3	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	NUMC	(N'0000000000')	No		RKEOBJNR	Allow NULL?
4	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	NUMC	(N'0000')	No		RKESUBNR	Allow NULL?
5	BISDAT	Valid to	nvarchar	8	DATS	(N'00000000')	No		AUFDATBI	Allow NULL?
6	KNT_FRM_KZ	Indicator for use in account-based Profitability Analysis	char	1	NUMC	(N'0')	No		RKE_KNTFRM	Allow NULL?
7	UNUSED_CE3	Flag: NOT Posted to Costing-Based Profitability Analysis	char	1	CHAR	(N' ')	No		COPA_UNUSED_CE3	Allow NULL?
8	KNDNR	Customer	nvarchar	10	CHAR	(N' ')	No	KNA1	KUNDE_PA	Allow NULL?
9	ARTNR	Product number	nvarchar	18	CHAR	(N' ')	No	MARA	ARTNR	Allow NULL?
10	FKART	Billing Type	nvarchar	4	CHAR	(N' ')	No	TVFK	FKART	Allow NULL?
11	KAUFN	Sales Order Number	nvarchar	10	CHAR	(N' ')	No	VBUK	KDAUF	Allow NULL?
12	KDPOS	Item Number in Sales Order	nvarchar	6	NUMC	(N'000000')	No		KDPOS	Allow NULL?
13	AUFNR	Order Number	nvarchar	12	CHAR	(N' ')	No	AUFK	AUFNR	Allow NULL?
14	BUKRS	Company Code	nvarchar	4	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
15	KOKRS	Controlling Area	nvarchar	4	CHAR	(N' ')	No	TKA01	KOKRS	Allow NULL?
16	WERKS	Plant	nvarchar	4	CHAR	(N' ')	No	T001W	WERKS_D	Allow NULL?
17	GSBER	Business Area	nvarchar	4	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
18	VKORG	Sales Organization	nvarchar	4	CHAR	(N' ')	No	TVKO	VKORG	Allow NULL?
19	VTWEG	Distribution Channel	nvarchar	2	CHAR	(N' ')	No	TVTW	VTWEG	Allow NULL?
20	SPART	Division	nvarchar	2	CHAR	(N' ')	No	TSPA	SPART	Allow NULL?
21	PRCTR	Profit Center	nvarchar	10	CHAR	(N' ')	No	CEPC	PRCTR	Allow NULL?
22	PPRCTR	Partner Profit Center	nvarchar	10	CHAR	(N' ')	No	CEPC	PPRCTR	Allow NULL?
23	KSTRG	Cost Object	nvarchar	12	CHAR	(N' ')	No	CKPH	KSTRG	Allow NULL?
24	PSPNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	NUMC	(N'00000000')	No	PRPS	PS_PSP_PNR	Allow NULL?
25	MEINH	Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	CO_MEINH	Allow NULL?
26	MATKL	Material Group	nvarchar	9	CHAR	(N' ')	No	T023	MATKL	Allow NULL?
27	MVGR1	Material group 1	nvarchar	3	CHAR	(N' ')	No	TVM1	MVGR1	Allow NULL?
28	WWPH1	Prod.hier.1 bef. 4.5	nvarchar	5	CHAR	(N' ')	No	T2508	RKEG_WWPH1	Allow NULL?
29	WWPH2	Prod.hier.2 bef. 4.5	nvarchar	10	CHAR	(N' ')	No	T2509	RKEG_WWPH2	Allow NULL?
30	WWPH3	Prod.hier.3 bef. 4.5	nvarchar	18	CHAR	(N' ')	No	T2510	RKEG_WWPH3	Allow NULL?
31	WWPRC	Product category	nvarchar	8	CHAR	(N' ')	No	T2520	RKEG_WWPRC	Allow NULL?
32	WWSOP	Prod.group for SOP	nvarchar	18	CHAR	(N' ')	No	T2511	RKEG_WWSOP	Allow NULL?
33	WWSBU	Strategic Bus.Unit	nvarchar	8	CHAR	(N' ')	No	T2515	RKEG_WWSBU	Allow NULL?
34	KDGRP	Customer group	nvarchar	2	CHAR	(N' ')	No	T151	KDGRP	Allow NULL?
35	KUKLA	Customer classification	nvarchar	2	CHAR	(N' ')	No	TKUKL	KUKLA	Allow NULL?
36	BZIRK	Sales district	nvarchar	6	CHAR	(N' ')	No	T171	BZIRK	Allow NULL?
37	BRSCH	Industry key	nvarchar	4	CHAR	(N' ')	No	T016	BRSCH	Allow NULL?
38	WWREG	Region before 4.5	nvarchar	6	CHAR	(N' ')	No	T2516	RKEG_WWREG	Allow NULL?
39	LAND1	Country Key	nvarchar	3	CHAR	(N' ')	No	T005	LAND1_GP	Allow NULL?
40	KUNWE	Ship-to party	nvarchar	10	CHAR	(N' ')	No	KNA1	KUNWE	Allow NULL?
41	WWCST	Country Ship-to	nvarchar	3	CHAR	(N' ')	No	T2517	RKEG_WWCST	Allow NULL?
42	WWRST	Intern.Region Ship-t	nvarchar	3	CHAR	(N' ')	No	T2518	RKEG_WWRST	Allow NULL?
43	HIE01	Customer hierarchy Level 1	nvarchar	10	CHAR	(N' ')	No	KNA1	HIEZU01	Allow NULL?
44	HIE02	Customer hierarchy Level 2	nvarchar	10	CHAR	(N' ')	No	KNA1	HIEZU02	Allow NULL?
45	HIE03	Customer hierarchy Level 3	nvarchar	10	CHAR	(N' ')	No	KNA1	HIEZU03	Allow NULL?
46	VRTNR	Sales employee	nvarchar	8	NUMC	(N'00000000')	No		VRTNR	Allow NULL?
47	VKBUR	Sales Office	nvarchar	4	CHAR	(N' ')	No	TVBUR	VKBUR	Allow NULL?
48	VKGRP	Sales Group	nvarchar	3	CHAR	(N' ')	No	TVKGR	VKGRP	Allow NULL?
49	WWICI	Intercompany ind.	char	1	CHAR	(N' ')	No	T2519	RKEG_WWICI	Allow NULL?
50	AUGRU	Order reason (reason for the business transaction)	nvarchar	3	CHAR	(N' ')	No	TVAU	AUGRU	Allow NULL?
51	WWPRO	Promotion	nvarchar	10	CHAR	(N' ')	No	KONA	KNUMA_PI	Allow NULL?
52	WWSDL	Sales deal	nvarchar	10	CHAR	(N' ')	No	KONA	KNUMA_AG	Allow NULL?
53	PAPH1	Prod.hierarchy01-1	nvarchar	5	CHAR	(N' ')	No		RKEG_PAPH1	Allow NULL?
54	PAPH2	Prod.hierarchy01-2	nvarchar	10	CHAR	(N' ')	No		RKEG_PAPH2	Allow NULL?
55	PAPH3	Prod.hierarchy01-3	nvarchar	18	CHAR	(N' ')	No		RKEG_PAPH3	Allow NULL?
56	PAREG	CO-PA special characteristic: (Land, Region)	nvarchar	6	CHAR	(N' ')	No		RKE_PAREG	Allow NULL?
57	SORHIST	Sales Order History	char	1	CHAR	(N' ')	No		RKE_SORHI	Allow NULL?
58	WWMEA	Measurements	nvarchar	2	CHAR	(N' ')	No	T2521	RKEG_WWMEA	Allow NULL?
59	WWQUA	Quality	nvarchar	5	CHAR	(N' ')	No	T2522	RKEG_WWQUA	Allow NULL?
60	WWSUR	User Interface	nvarchar	2	CHAR	(N' ')	No	T2501	RKEG_WWSUR	Allow NULL?
61	REGIO	Region (State, Province, County)	nvarchar	3	CHAR	(N' ')	No	T005S	REGIO	Allow NULL?
62	CRMELEM	CRM Marketing Element	nvarchar	8	NUMC	(N'00000000')	No	PRPS	RKECRMELEM	Allow NULL?
63	CRMCSTY	CRM Cost Element	nvarchar	10	CHAR	(N' ')	No	CSKA	RKECRMCSTY	Allow NULL?
64	ROUTE	Route	nvarchar	6	CHAR	(N' ')	No	TVRO	ROUTE	Allow NULL?
65	VVOQT_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
66	VVIQT_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
67	VVSQT_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
68	VVGRW_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
69	VV550_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
70	VV560_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
71	VV570_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
72	VV580_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
73	VV495_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
74	VVSTU_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
75	VVOQU_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
76	VV810_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
77	VV820_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
78	VV930_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
79	VV931_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?
80	VVSV_ME	Base Unit of Measure	nvarchar	3	UNIT	(N' ')	No	T006	MEINS	Allow NULL?

Name	Primary	Unique	Type	Columns
CE4IDEA~0	Yes	Yes	CLUSTERED	PASUBNR, PAOBJNR, AKTBO, MANDT
CE4IDEA~1	No	No	NONCLUSTERED	VTWEG, WERKS, BUKRS, ARTNR, KNDNR, AKTBO, 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

80 COLUMNS | 2 INDEXES | ERP 6.0 | CE4IDEA TABLE

TOP ERP 6.0 | CE4IDEA COLUMNS

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

80 COLUMNS | 2 INDEXES | ERP 6.0 | CE4IDEA TABLE

TOPERP 6.0 | CE4IDEA COLUMNS

TOPERP 6.0 | CE4IDEA INDEXES

TOP ERP 6.0 | CE4IDEA COLUMNS

TOP ERP 6.0 | CE4IDEA INDEXES