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
Payroll :: Payroll General Parts :: Reuse Services for Country Development
1	ERP EHP7	6.0	PA0865	153	1	HR Master Record: Infotype 0865	Reuse Services for Country Development

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	MOBID	Record Name	nvarchar	30	0	Allow NULL?
25	VWEEK	Record is Valid Full Time	char	1	0	Allow NULL?
26	VMOND	Valid on Mondays	char	1	0	Allow NULL?
27	VTUES	Valid on Tuesdays	char	1	0	Allow NULL?
28	VWEND	Valid on Wednesdays	char	1	0	Allow NULL?
29	VTHUR	Valid on Thursdays	char	1	0	Allow NULL?
30	VFRID	Valid on Fridays	char	1	0	Allow NULL?
31	VSATU	Valid on Saturdays	char	1	0	Allow NULL?
32	VSUND	Valid on Sundays	char	1	0	Allow NULL?
33	VALID	Record Validity: Amount	nvarchar	6	0	Allow NULL?
34	VUNIT	Record Validity: Percentage or Days	char	1	0	Allow NULL?
35	DISTN	Total Home-Work Distance calculated by the system	decimal	5	0
36	NAME1	ID for Sub-Route in Mobility Record	nvarchar	5	0	Allow NULL?
37	MOBM1	Means of Transport	nvarchar	4	0	Allow NULL?
38	DSTN1	Distance Traveled with Means of Transport	decimal	5	0
39	RULE1	Reimbursement Rule	nvarchar	4	0	Allow NULL?
40	TYPE1	Cost Type	nvarchar	4	0	Allow NULL?
41	PANZ1	Cost Interval Number	nvarchar	3	0	Allow NULL?
42	CVAL1	Cost Interval Unit	nvarchar	3	0	Allow NULL?
43	DEFL1	Indicator: Use Defaults or Manual Input	char	1	0	Allow NULL?
44	CAMT1	HR Payroll: Amount	decimal	15	2
45	WAER1	Currency Key	nvarchar	5	0	Allow NULL?
46	PERC1	Reimbursement Percentage	decimal	5	0
47	RATE1	Reimbursement Rate per Kilometer	decimal	10	2
48	COMA1	Fixed Reimbursement	decimal	10	2
49	PAYM1	Payment Frequency	char	1	0	Allow NULL?
50	PAYD1	First payment date	nvarchar	8	0	Allow NULL?
51	REGN1	License plate number	nvarchar	10	0	Allow NULL?
52	MAMT1	Paid Mobility Reimbursement Amount	decimal	15	2
53	NAME2	ID for Sub-Route in Mobility Record	nvarchar	5	0	Allow NULL?
54	MOBM2	Means of Transport	nvarchar	4	0	Allow NULL?
55	DSTN2	Distance Traveled with Means of Transport	decimal	5	0
56	RULE2	Reimbursement Rule	nvarchar	4	0	Allow NULL?
57	TYPE2	Cost Type	nvarchar	4	0	Allow NULL?
58	PANZ2	Cost Interval Number	nvarchar	3	0	Allow NULL?
59	CVAL2	Cost Interval Unit	nvarchar	3	0	Allow NULL?
60	DEFL2	Indicator: Use Defaults or Manual Input	char	1	0	Allow NULL?
61	CAMT2	HR Payroll: Amount	decimal	15	2
62	WAER2	Currency Key	nvarchar	5	0	Allow NULL?
63	PERC2	Reimbursement Percentage	decimal	5	0
64	RATE2	Reimbursement Rate per Kilometer	decimal	10	2
65	COMA2	Fixed Reimbursement	decimal	10	2
66	PAYM2	Payment Frequency	char	1	0	Allow NULL?
67	PAYD2	First payment date	nvarchar	8	0	Allow NULL?
68	REGN2	License plate number	nvarchar	10	0	Allow NULL?
69	MAMT2	Paid Mobility Reimbursement Amount	decimal	15	2
70	NAME3	ID for Sub-Route in Mobility Record	nvarchar	5	0	Allow NULL?
71	MOBM3	Means of Transport	nvarchar	4	0	Allow NULL?
72	DSTN3	Distance Traveled with Means of Transport	decimal	5	0
73	RULE3	Reimbursement Rule	nvarchar	4	0	Allow NULL?
74	TYPE3	Cost Type	nvarchar	4	0	Allow NULL?
75	PANZ3	Cost Interval Number	nvarchar	3	0	Allow NULL?
76	CVAL3	Cost Interval Unit	nvarchar	3	0	Allow NULL?
77	DEFL3	Indicator: Use Defaults or Manual Input	char	1	0	Allow NULL?
78	CAMT3	HR Payroll: Amount	decimal	15	2
79	WAER3	Currency Key	nvarchar	5	0	Allow NULL?
80	PERC3	Reimbursement Percentage	decimal	5	0
81	RATE3	Reimbursement Rate per Kilometer	decimal	10	2
82	COMA3	Fixed Reimbursement	decimal	10	2
83	PAYM3	Payment Frequency	char	1	0	Allow NULL?
84	PAYD3	First payment date	nvarchar	8	0	Allow NULL?
85	REGN3	License plate number	nvarchar	10	0	Allow NULL?
86	MAMT3	Paid Mobility Reimbursement Amount	decimal	15	2
87	NAME4	ID for Sub-Route in Mobility Record	nvarchar	5	0	Allow NULL?
88	MOBM4	Means of Transport	nvarchar	4	0	Allow NULL?
89	DSTN4	Distance Traveled with Means of Transport	decimal	5	0
90	RULE4	Reimbursement Rule	nvarchar	4	0	Allow NULL?
91	TYPE4	Cost Type	nvarchar	4	0	Allow NULL?
92	PANZ4	Cost Interval Number	nvarchar	3	0	Allow NULL?
93	CVAL4	Cost Interval Unit	nvarchar	3	0	Allow NULL?
94	DEFL4	Indicator: Use Defaults or Manual Input	char	1	0	Allow NULL?
95	CAMT4	HR Payroll: Amount	decimal	15	2
96	WAER4	Currency Key	nvarchar	5	0	Allow NULL?
97	PERC4	Reimbursement Percentage	decimal	5	0
98	RATE4	Reimbursement Rate per Kilometer	decimal	10	2
99	COMA4	Fixed Reimbursement	decimal	10	2
100	PAYM4	Payment Frequency	char	1	0	Allow NULL?
101	PAYD4	First payment date	nvarchar	8	0	Allow NULL?
102	REGN4	License plate number	nvarchar	10	0	Allow NULL?
103	MAMT4	Paid Mobility Reimbursement Amount	decimal	15	2
104	NAME5	ID for Sub-Route in Mobility Record	nvarchar	5	0	Allow NULL?
105	MOBM5	Means of Transport	nvarchar	4	0	Allow NULL?
106	DSTN5	Distance Traveled with Means of Transport	decimal	5	0
107	RULE5	Reimbursement Rule	nvarchar	4	0	Allow NULL?
108	TYPE5	Cost Type	nvarchar	4	0	Allow NULL?
109	PANZ5	Cost Interval Number	nvarchar	3	0	Allow NULL?
110	CVAL5	Cost Interval Unit	nvarchar	3	0	Allow NULL?
111	DEFL5	Indicator: Use Defaults or Manual Input	char	1	0	Allow NULL?
112	CAMT5	HR Payroll: Amount	decimal	15	2
113	WAER5	Currency Key	nvarchar	5	0	Allow NULL?
114	PERC5	Reimbursement Percentage	decimal	5	0
115	RATE5	Reimbursement Rate per Kilometer	decimal	10	2
116	COMA5	Fixed Reimbursement	decimal	10	2
117	PAYM5	Payment Frequency	char	1	0	Allow NULL?
118	PAYD5	First payment date	nvarchar	8	0	Allow NULL?
119	REGN5	License plate number	nvarchar	10	0	Allow NULL?
120	MAMT5	Paid Mobility Reimbursement Amount	decimal	15	2
121	NAME6	ID for Sub-Route in Mobility Record	nvarchar	5	0	Allow NULL?
122	MOBM6	Means of Transport	nvarchar	4	0	Allow NULL?
123	DSTN6	Distance Traveled with Means of Transport	decimal	5	0
124	RULE6	Reimbursement Rule	nvarchar	4	0	Allow NULL?
125	TYPE6	Cost Type	nvarchar	4	0	Allow NULL?
126	PANZ6	Cost Interval Number	nvarchar	3	0	Allow NULL?
127	CVAL6	Cost Interval Unit	nvarchar	3	0	Allow NULL?
128	DEFL6	Indicator: Use Defaults or Manual Input	char	1	0	Allow NULL?
129	CAMT6	HR Payroll: Amount	decimal	15	2
130	WAER6	Currency Key	nvarchar	5	0	Allow NULL?
131	PERC6	Reimbursement Percentage	decimal	5	0
132	RATE6	Reimbursement Rate per Kilometer	decimal	10	2
133	COMA6	Fixed Reimbursement	decimal	10	2
134	PAYM6	Payment Frequency	char	1	0	Allow NULL?
135	PAYD6	First payment date	nvarchar	8	0	Allow NULL?
136	REGN6	License plate number	nvarchar	10	0	Allow NULL?
137	MAMT6	Paid Mobility Reimbursement Amount	decimal	15	2
138	NAME7	ID for Sub-Route in Mobility Record	nvarchar	5	0	Allow NULL?
139	MOBM7	Means of Transport	nvarchar	4	0	Allow NULL?
140	DSTN7	Distance Traveled with Means of Transport	decimal	5	0
141	RULE7	Reimbursement Rule	nvarchar	4	0	Allow NULL?
142	TYPE7	Cost Type	nvarchar	4	0	Allow NULL?
143	PANZ7	Cost Interval Number	nvarchar	3	0	Allow NULL?
144	CVAL7	Cost Interval Unit	nvarchar	3	0	Allow NULL?
145	DEFL7	Indicator: Use Defaults or Manual Input	char	1	0	Allow NULL?
146	CAMT7	HR Payroll: Amount	decimal	15	2
147	WAER7	Currency Key	nvarchar	5	0	Allow NULL?
148	PERC7	Reimbursement Percentage	decimal	5	0
149	RATE7	Reimbursement Rate per Kilometer	decimal	10	2
150	COMA7	Fixed Reimbursement	decimal	10	2
151	PAYM7	Payment Frequency	char	1	0	Allow NULL?
152	PAYD7	First payment date	nvarchar	8	0	Allow NULL?
153	REGN7	License plate number	nvarchar	10	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

153 COLUMNS | 1 INDEXES | ERP 6.0 | PA0865 TABLE

TOP ERP 6.0 | PA0865 COLUMNS

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

153 COLUMNS | 1 INDEXES | ERP 6.0 | PA0865 TABLE

TOPERP 6.0 | PA0865 COLUMNS

TOPERP 6.0 | PA0865 INDEXES

TOP ERP 6.0 | PA0865 COLUMNS

TOP ERP 6.0 | PA0865 INDEXES