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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	Allow NULL?
6	ENDDA	End Date	nvarchar	8	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	Allow NULL?
11	HISTO	Historical Record Flag	char	1	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	Allow NULL?
24	NUMBR	Number	nvarchar	5	Allow NULL?
25	ACTCA	Labour Activity Code	nvarchar	20	Allow NULL?
26	ARBGB	Name of employer (CIS)	nvarchar	200	Allow NULL?
27	ORT01	City	nvarchar	40	Allow NULL?
28	LAND1	Country Key	nvarchar	3	Allow NULL?
29	BRANC	Industry key	nvarchar	4	Allow NULL?
30	DEPRT	Department (CIS)	nvarchar	200	Allow NULL?
31	POSIT	Position (CIS)	nvarchar	200	Allow NULL?
32	ORDNU	Order Number	nvarchar	30	Allow NULL?
33	ORDDT	Order Date	nvarchar	8	Allow NULL?
34	ORDBA	Order Basis	nvarchar	200	Allow NULL?
35	ORUNU	Leave Order Number	nvarchar	30	Allow NULL?
36	ORUDT	Leave Order Date	nvarchar	8	Allow NULL?
37	ORUBA	Leave Order Text	nvarchar	200	Allow NULL?
38	CHECK	Checked Employment Book Entry	char	1	Allow NULL?
39	TLS01	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
40	DUY01	Duration of imputation in years	decimal	3
41	DUM01	Duration of imputation in months	decimal	4
42	DUD01	Duration of imputation in days	decimal	5
43	DUH01	Duration in hours	decimal	5
44	TLS02	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
45	DUY02	Duration of imputation in years	decimal	3
46	DUM02	Duration of imputation in months	decimal	4
47	DUD02	Duration of imputation in days	decimal	5
48	DUH02	Duration in hours	decimal	5
49	TLS03	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
50	DUY03	Duration of imputation in years	decimal	3
51	DUM03	Duration of imputation in months	decimal	4
52	DUD03	Duration of imputation in days	decimal	5
53	DUH03	Duration in hours	decimal	5
54	TLS04	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
55	DUY04	Duration of imputation in years	decimal	3
56	DUM04	Duration of imputation in months	decimal	4
57	DUD04	Duration of imputation in days	decimal	5
58	DUH04	Duration in hours	decimal	5
59	TLS05	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
60	DUY05	Duration of imputation in years	decimal	3
61	DUM05	Duration of imputation in months	decimal	4
62	DUD05	Duration of imputation in days	decimal	5
63	DUH05	Duration in hours	decimal	5
64	TLS06	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
65	DUY06	Duration of imputation in years	decimal	3
66	DUM06	Duration of imputation in months	decimal	4
67	DUD06	Duration of imputation in days	decimal	5
68	DUH06	Duration in hours	decimal	5
69	TLS07	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
70	DUY07	Duration of imputation in years	decimal	3
71	DUM07	Duration of imputation in months	decimal	4
72	DUD07	Duration of imputation in days	decimal	5
73	DUH07	Duration in hours	decimal	5
74	TLS08	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
75	DUY08	Duration of imputation in years	decimal	3
76	DUM08	Duration of imputation in months	decimal	4
77	DUD08	Duration of imputation in days	decimal	5
78	DUH08	Duration in hours	decimal	5
79	TLS09	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
80	DUY09	Duration of imputation in years	decimal	3
81	DUM09	Duration of imputation in months	decimal	4
82	DUD09	Duration of imputation in days	decimal	5
83	DUH09	Duration in hours	decimal	5
84	TLS10	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
85	DUY10	Duration of imputation in years	decimal	3
86	DUM10	Duration of imputation in months	decimal	4
87	DUD10	Duration of imputation in days	decimal	5
88	DUH10	Duration in hours	decimal	5
89	TLS11	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
90	DUY11	Duration of imputation in years	decimal	3
91	DUM11	Duration of imputation in months	decimal	4
92	DUD11	Duration of imputation in days	decimal	5
93	DUH11	Duration in hours	decimal	5
94	TLS12	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
95	DUY12	Duration of imputation in years	decimal	3
96	DUM12	Duration of imputation in months	decimal	4
97	DUD12	Duration of imputation in days	decimal	5
98	DUH12	Duration in hours	decimal	5
99	TLS13	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
100	DUY13	Duration of imputation in years	decimal	3
101	DUM13	Duration of imputation in months	decimal	4
102	DUD13	Duration of imputation in days	decimal	5
103	DUH13	Duration in hours	decimal	5
104	TLS14	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
105	DUY14	Duration of imputation in years	decimal	3
106	DUM14	Duration of imputation in months	decimal	4
107	DUD14	Duration of imputation in days	decimal	5
108	DUH14	Duration in hours	decimal	5
109	TLS15	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
110	DUY15	Duration of imputation in years	decimal	3
111	DUM15	Duration of imputation in months	decimal	4
112	DUD15	Duration of imputation in days	decimal	5
113	DUH15	Duration in hours	decimal	5
114	TLS16	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
115	DUY16	Duration of imputation in years	decimal	3
116	DUM16	Duration of imputation in months	decimal	4
117	DUD16	Duration of imputation in days	decimal	5
118	DUH16	Duration in hours	decimal	5
119	TLS17	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
120	DUY17	Duration of imputation in years	decimal	3
121	DUM17	Duration of imputation in months	decimal	4
122	DUD17	Duration of imputation in days	decimal	5
123	DUH17	Duration in hours	decimal	5
124	TLS18	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
125	DUY18	Duration of imputation in years	decimal	3
126	DUM18	Duration of imputation in months	decimal	4
127	DUD18	Duration of imputation in days	decimal	5
128	DUH18	Duration in hours	decimal	5
129	TLS19	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
130	DUY19	Duration of imputation in years	decimal	3
131	DUM19	Duration of imputation in months	decimal	4
132	DUD19	Duration of imputation in days	decimal	5
133	DUH19	Duration in hours	decimal	5
134	TLS20	Include Employment Book Entry in Seniority Calculation	char	1	Allow NULL?
135	DUY20	Duration of imputation in years	decimal	3
136	DUM20	Duration of imputation in months	decimal	4
137	DUD20	Duration of imputation in days	decimal	5
138	DUH20	Duration in hours	decimal	5
139	INWRN	Internal work-book record number	nvarchar	4	Allow NULL?

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

139 COLUMNS | 1 INDEXES | ERP 6.0 | PA0294 TABLE

TOP ERP 6.0 | PA0294 COLUMNS

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

139 COLUMNS | 1 INDEXES | ERP 6.0 | PA0294 TABLE

TOPERP 6.0 | PA0294 COLUMNS

TOPERP 6.0 | PA0294 INDEXES

TOP ERP 6.0 | PA0294 COLUMNS

TOP ERP 6.0 | PA0294 INDEXES