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

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0441	208	1	Corrections for reports (Hungary)	Personnel Administration

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

208 COLUMNS | 1 INDEXES | ERP 6.0 | PA0441 TABLE

TOP ERP 6.0 | PA0441 COLUMNS

TOP ERP 6.0 | PA0441 INDEXES

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	Allow NULL?
24	TIPUS	Subtype	nvarchar	4	0	Allow NULL?
25	ERVNY	End Date	nvarchar	8	0	Allow NULL?
26	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
27	ZEINH	Time/Measurement Unit	nvarchar	3	0	Allow NULL?
28	LGT01	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
29	NUM01	Number	decimal	7	2
30	AMT01	Amount	decimal	9	2
31	BEG01	Date	nvarchar	8	0	Allow NULL?
32	END01	Date	nvarchar	8	0	Allow NULL?
33	FL101	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
34	FL201	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
35	FL301	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
36	FL401	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
37	FL501	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
38	LGT02	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
39	NUM02	Number	decimal	7	2
40	AMT02	Amount	decimal	9	2
41	BEG02	Date	nvarchar	8	0	Allow NULL?
42	END02	Date	nvarchar	8	0	Allow NULL?
43	FL102	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
44	FL202	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
45	FL302	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
46	FL402	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
47	FL502	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
48	LGT03	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
49	NUM03	Number	decimal	7	2
50	AMT03	Amount	decimal	9	2
51	BEG03	Date	nvarchar	8	0	Allow NULL?
52	END03	Date	nvarchar	8	0	Allow NULL?
53	FL103	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
54	FL203	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
55	FL303	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
56	FL403	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
57	FL503	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
58	LGT04	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
59	NUM04	Number	decimal	7	2
60	AMT04	Amount	decimal	9	2
61	BEG04	Date	nvarchar	8	0	Allow NULL?
62	END04	Date	nvarchar	8	0	Allow NULL?
63	FL104	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
64	FL204	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
65	FL304	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
66	FL404	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
67	FL504	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
68	LGT05	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
69	NUM05	Number	decimal	7	2
70	AMT05	Amount	decimal	9	2
71	BEG05	Date	nvarchar	8	0	Allow NULL?
72	END05	Date	nvarchar	8	0	Allow NULL?
73	FL105	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
74	FL205	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
75	FL305	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
76	FL405	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
77	FL505	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
78	LGT06	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
79	NUM06	Number	decimal	7	2
80	AMT06	Amount	decimal	9	2
81	BEG06	Date	nvarchar	8	0	Allow NULL?
82	END06	Date	nvarchar	8	0	Allow NULL?
83	FL106	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
84	FL206	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
85	FL306	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
86	FL406	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
87	FL506	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
88	LGT07	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
89	NUM07	Number	decimal	7	2
90	AMT07	Amount	decimal	9	2
91	BEG07	Date	nvarchar	8	0	Allow NULL?
92	END07	Date	nvarchar	8	0	Allow NULL?
93	FL107	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
94	FL207	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
95	FL307	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
96	FL407	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
97	FL507	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
98	LGT08	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
99	NUM08	Number	decimal	7	2
100	AMT08	Amount	decimal	9	2
101	BEG08	Date	nvarchar	8	0	Allow NULL?
102	END08	Date	nvarchar	8	0	Allow NULL?
103	FL108	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
104	FL208	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
105	FL308	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
106	FL408	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
107	FL508	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
108	LGT09	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
109	NUM09	Number	decimal	7	2
110	AMT09	Amount	decimal	9	2
111	BEG09	Date	nvarchar	8	0	Allow NULL?
112	END09	Date	nvarchar	8	0	Allow NULL?
113	FL109	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
114	FL209	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
115	FL309	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
116	FL409	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
117	FL509	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
118	LGT10	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
119	NUM10	Number	decimal	7	2
120	AMT10	Amount	decimal	9	2
121	BEG10	Date	nvarchar	8	0	Allow NULL?
122	END10	Date	nvarchar	8	0	Allow NULL?
123	FL110	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
124	FL210	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
125	FL310	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
126	FL410	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
127	FL510	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
128	LGT11	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
129	NUM11	Number	decimal	7	2
130	AMT11	Amount	decimal	9	2
131	BEG11	Date	nvarchar	8	0	Allow NULL?
132	END11	Date	nvarchar	8	0	Allow NULL?
133	FL111	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
134	FL211	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
135	FL311	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
136	FL411	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
137	FL511	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
138	LGT12	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
139	NUM12	Number	decimal	7	2
140	AMT12	Amount	decimal	9	2
141	BEG12	Date	nvarchar	8	0	Allow NULL?
142	END12	Date	nvarchar	8	0	Allow NULL?
143	FL112	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
144	FL212	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
145	FL312	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
146	FL412	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
147	FL512	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
148	LGT13	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
149	NUM13	Number	decimal	7	2
150	AMT13	Amount	decimal	9	2
151	BEG13	Date	nvarchar	8	0	Allow NULL?
152	END13	Date	nvarchar	8	0	Allow NULL?
153	FL113	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
154	FL213	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
155	FL313	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
156	FL413	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
157	FL513	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
158	LGT14	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
159	NUM14	Number	decimal	7	2
160	AMT14	Amount	decimal	9	2
161	BEG14	Date	nvarchar	8	0	Allow NULL?
162	END14	Date	nvarchar	8	0	Allow NULL?
163	FL114	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
164	FL214	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
165	FL314	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
166	FL414	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
167	FL514	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
168	LGT15	HR-H: serial number field for infotype P0041	nvarchar	2	0	Allow NULL?
169	NUM15	Number	decimal	7	2
170	AMT15	Amount	decimal	9	2
171	BEG15	Date	nvarchar	8	0	Allow NULL?
172	END15	Date	nvarchar	8	0	Allow NULL?
173	FL115	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
174	FL215	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
175	FL315	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
176	FL415	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
177	FL515	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
178	STR01	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
179	STR02	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
180	STR03	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
181	STR04	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
182	STR05	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
183	STR06	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
184	STR07	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
185	STR08	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
186	STR09	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
187	STR10	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
188	STR11	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
189	STR12	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
190	STR13	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
191	STR14	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
192	STR15	HR-H: one character flag to infotype 0441	char	1	0	Allow NULL?
193	TVK01	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
194	TVK02	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
195	TVK03	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
196	TVK04	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
197	TVK05	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
198	TVK06	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
199	TVK07	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
200	TVK08	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
201	TVK09	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
202	TVK10	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
203	TVK11	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
204	TVK12	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
205	TVK13	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
206	TVK14	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
207	TVK15	SI accounting - 5-character absence code	nvarchar	5	0	Allow NULL?
208	HATAR		nvarchar	132	0	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

208 COLUMNS | 1 INDEXES | ERP 6.0 | PA0441 TABLE

TOPERP 6.0 | PA0441 COLUMNS

TOPERP 6.0 | PA0441 INDEXES

TOP ERP 6.0 | PA0441 COLUMNS

TOP ERP 6.0 | PA0441 INDEXES