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 :: Organizational Structure :: Staffing
1	ERP EHP7	6.0	HRP1010	100	2	Infotype 1010 DB table	Staffing

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	PLVAR	Plan Version	nvarchar	2	Allow NULL?
3	OTYPE	Object Type	nvarchar	2	Allow NULL?
4	OBJID	Object ID	nvarchar	8	Allow NULL?
5	SUBTY	Subtype	nvarchar	4	Allow NULL?
6	ISTAT	Planning Status	char	1	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	Allow NULL?
8	ENDDA	End Date	nvarchar	8	Allow NULL?
9	VARYF	Variation Field for File PLOG	nvarchar	10	Allow NULL?
10	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	Allow NULL?
11	INFTY	Infotype	nvarchar	4	Allow NULL?
12	OTJID	Concatenation of Object Type and Object ID	nvarchar	10	Allow NULL?
13	AEDTM	Changed on	nvarchar	8	Allow NULL?
14	UNAME	User Name	nvarchar	12	Allow NULL?
15	REASN	Reason	nvarchar	2	Allow NULL?
16	HISTO	Historical Record Flag	char	1	Allow NULL?
17	ITXNR	Text Module for Infotype	nvarchar	8	Allow NULL?
18	HILFM	Resources	nvarchar	3	Allow NULL?
19	HILFM001	Resources	nvarchar	3	Allow NULL?
20	HILFM002	Resources	nvarchar	3	Allow NULL?
21	HILFM003	Resources	nvarchar	3	Allow NULL?
22	HILFM004	Resources	nvarchar	3	Allow NULL?
23	HILFM005	Resources	nvarchar	3	Allow NULL?
24	HILFM006	Resources	nvarchar	3	Allow NULL?
25	HILFM007	Resources	nvarchar	3	Allow NULL?
26	HILFM008	Resources	nvarchar	3	Allow NULL?
27	HILFM009	Resources	nvarchar	3	Allow NULL?
28	HILFM010	Resources	nvarchar	3	Allow NULL?
29	HILFM011	Resources	nvarchar	3	Allow NULL?
30	HILFM012	Resources	nvarchar	3	Allow NULL?
31	HILFM013	Resources	nvarchar	3	Allow NULL?
32	HILFM014	Resources	nvarchar	3	Allow NULL?
33	HILFM015	Resources	nvarchar	3	Allow NULL?
34	HILFM016	Resources	nvarchar	3	Allow NULL?
35	HILFM017	Resources	nvarchar	3	Allow NULL?
36	HILFM018	Resources	nvarchar	3	Allow NULL?
37	HILFM019	Resources	nvarchar	3	Allow NULL?
38	HILFM020	Resources	nvarchar	3	Allow NULL?
39	HILFM021	Resources	nvarchar	3	Allow NULL?
40	HILFM022	Resources	nvarchar	3	Allow NULL?
41	HILFM023	Resources	nvarchar	3	Allow NULL?
42	HILFM024	Resources	nvarchar	3	Allow NULL?
43	HILFM025	Resources	nvarchar	3	Allow NULL?
44	HILFM026	Resources	nvarchar	3	Allow NULL?
45	HILFM027	Resources	nvarchar	3	Allow NULL?
46	HILFM028	Resources	nvarchar	3	Allow NULL?
47	HILFM029	Resources	nvarchar	3	Allow NULL?
48	HILFM030	Resources	nvarchar	3	Allow NULL?
49	HILFM031	Resources	nvarchar	3	Allow NULL?
50	HILFM032	Resources	nvarchar	3	Allow NULL?
51	HILFM033	Resources	nvarchar	3	Allow NULL?
52	HILFM034	Resources	nvarchar	3	Allow NULL?
53	HILFM035	Resources	nvarchar	3	Allow NULL?
54	HILFM036	Resources	nvarchar	3	Allow NULL?
55	HILFM037	Resources	nvarchar	3	Allow NULL?
56	HILFM038	Resources	nvarchar	3	Allow NULL?
57	HILFM039	Resources	nvarchar	3	Allow NULL?
58	HILFM040	Resources	nvarchar	3	Allow NULL?
59	HILFM041	Resources	nvarchar	3	Allow NULL?
60	HILFM042	Resources	nvarchar	3	Allow NULL?
61	HILFM043	Resources	nvarchar	3	Allow NULL?
62	HILFM044	Resources	nvarchar	3	Allow NULL?
63	HILFM045	Resources	nvarchar	3	Allow NULL?
64	HILFM046	Resources	nvarchar	3	Allow NULL?
65	HILFM047	Resources	nvarchar	3	Allow NULL?
66	HILFM048	Resources	nvarchar	3	Allow NULL?
67	HILFM049	Resources	nvarchar	3	Allow NULL?
68	HILFM050	Resources	nvarchar	3	Allow NULL?
69	HILFM051	Resources	nvarchar	3	Allow NULL?
70	HILFM052	Resources	nvarchar	3	Allow NULL?
71	HILFM053	Resources	nvarchar	3	Allow NULL?
72	HILFM054	Resources	nvarchar	3	Allow NULL?
73	HILFM055	Resources	nvarchar	3	Allow NULL?
74	HILFM056	Resources	nvarchar	3	Allow NULL?
75	HILFM057	Resources	nvarchar	3	Allow NULL?
76	HILFM058	Resources	nvarchar	3	Allow NULL?
77	HILFM059	Resources	nvarchar	3	Allow NULL?
78	HILFM060	Resources	nvarchar	3	Allow NULL?
79	HILFM061	Resources	nvarchar	3	Allow NULL?
80	HILFM062	Resources	nvarchar	3	Allow NULL?
81	HILFM063	Resources	nvarchar	3	Allow NULL?
82	HILFM064	Resources	nvarchar	3	Allow NULL?
83	HILFM065	Resources	nvarchar	3	Allow NULL?
84	HILFM066	Resources	nvarchar	3	Allow NULL?
85	HILFM067	Resources	nvarchar	3	Allow NULL?
86	HILFM068	Resources	nvarchar	3	Allow NULL?
87	HILFM069	Resources	nvarchar	3	Allow NULL?
88	HILFM070	Resources	nvarchar	3	Allow NULL?
89	HILFM071	Resources	nvarchar	3	Allow NULL?
90	HILFM072	Resources	nvarchar	3	Allow NULL?
91	HILFM073	Resources	nvarchar	3	Allow NULL?
92	HILFM074	Resources	nvarchar	3	Allow NULL?
93	HILFM075	Resources	nvarchar	3	Allow NULL?
94	HILFM076	Resources	nvarchar	3	Allow NULL?
95	HILFM077	Resources	nvarchar	3	Allow NULL?
96	HILFM078	Resources	nvarchar	3	Allow NULL?
97	HILFM079	Resources	nvarchar	3	Allow NULL?
98	HILFM080	Resources	nvarchar	3	Allow NULL?
99	HILFM081	Resources	nvarchar	3	Allow NULL?
100	HILFM082	Resources	nvarchar	3	Allow NULL?

Name	Primary	Unique	Type	Columns
HRP1010~0	Yes	Yes	CLUSTERED	SEQNR, VARYF, ENDDA, BEGDA, ISTAT, SUBTY, OBJID, OTYPE, PLVAR, MANDT
HRP1010~1	No	No	NONCLUSTERED	MANDT, PLVAR, OTJID

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

100 COLUMNS | 2 INDEXES | ERP 6.0 | HRP1010 TABLE

TOP ERP 6.0 | HRP1010 COLUMNS

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

100 COLUMNS | 2 INDEXES | ERP 6.0 | HRP1010 TABLE

TOPERP 6.0 | HRP1010 COLUMNS

TOPERP 6.0 | HRP1010 INDEXES

TOP ERP 6.0 | HRP1010 COLUMNS

TOP ERP 6.0 | HRP1010 INDEXES