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	BSEG	345	Accounting Document Segment
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINM	101	Whse Journal
4	OINV	268	A/R Invoice
5	OIVL	77	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Organizational Structure :: Staffing
1	ERP EHP7	6.0	HRP1009	79	2	Infotype 1009 DB table	Staffing

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	PLVAR	Plan Version	nvarchar	2	CHAR	(N' ')	No	T778P	PLVAR	Allow NULL?
3	OTYPE	Object Type	nvarchar	2	CHAR	(N' ')	No	T778O	OTYPE	Allow NULL?
4	OBJID	Object ID	nvarchar	8	NUMC	(N'00000000')	No	PLOGI	HROBJID	Allow NULL?
5	SUBTY	Subtype	nvarchar	4	CHAR	(N' ')	No	*	SUBTYP	Allow NULL?
6	ISTAT	Planning Status	char	1	CHAR	(N' ')	No	T778S	ISTAT_D	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	DATS	(N'00000000')	No		BEGDATUM	Allow NULL?
8	ENDDA	End Date	nvarchar	8	DATS	(N'00000000')	No		ENDDATUM	Allow NULL?
9	VARYF	Variation Field for File PLOG	nvarchar	10	CHAR	(N' ')	No		VARYF	Allow NULL?
10	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	NUMC	(N'000')	No		SEQNR	Allow NULL?
11	INFTY	Infotype	nvarchar	4	CHAR	(N' ')	No	T778T	INFOTYP	Allow NULL?
12	OTJID	Concatenation of Object Type and Object ID	nvarchar	10	CHAR	(N' ')	No		OTJID	Allow NULL?
13	AEDTM	Changed on	nvarchar	8	DATS	(N'00000000')	No		AEDTM	Allow NULL?
14	UNAME	User Name	nvarchar	12	CHAR	(N' ')	No		USRNAME	Allow NULL?
15	REASN	Reason	nvarchar	2	CHAR	(N' ')	No		REASN	Allow NULL?
16	HISTO	Historical Record Flag	char	1	CHAR	(N' ')	No		HISTO	Allow NULL?
17	ITXNR	Text Module for Infotype	nvarchar	8	NUMC	(N'00000000')	No		ITXNR	Allow NULL?
18	UNART	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
19	UNART001	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
20	UNART002	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
21	UNART003	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
22	UNART004	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
23	UNART005	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
24	UNART006	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
25	UNART007	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
26	UNART008	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
27	UNART009	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
28	UNART010	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
29	UNART011	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
30	UNART012	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
31	UNART013	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
32	UNART014	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
33	UNART015	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
34	UNART016	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
35	UNART017	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
36	UNART018	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
37	UNART019	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
38	UNART020	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
39	UNART021	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
40	UNART022	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
41	UNART023	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
42	UNART024	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
43	UNART025	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
44	UNART026	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
45	UNART027	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
46	UNART028	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
47	UNART029	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
48	UNART030	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
49	UNART031	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
50	UNART032	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
51	UNART033	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
52	UNART034	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
53	UNART035	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
54	UNART036	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
55	UNART037	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
56	UNART038	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
57	UNART039	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
58	UNART040	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
59	UNART041	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
60	UNART042	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
61	UNART043	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
62	UNART044	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
63	UNART045	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
64	UNART046	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
65	UNART047	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
66	UNART048	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
67	UNART049	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
68	UNART050	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
69	UNART051	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
70	UNART052	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
71	UNART053	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
72	UNART054	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
73	UNART055	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
74	UNART056	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
75	UNART057	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
76	UNART058	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
77	UNART059	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
78	UNART060	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?
79	UNART061	Examination Type	nvarchar	4	CHAR	(N' ')	No	T778G	UNART	Allow NULL?

Name	Primary	Unique	Type	Columns
HRP1009~0	Yes	Yes	CLUSTERED	SEQNR, VARYF, ENDDA, BEGDA, ISTAT, SUBTY, OBJID, OTYPE, PLVAR, MANDT
HRP1009~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

79 COLUMNS | 2 INDEXES | ERP 6.0 | HRP1009 TABLE

TOP ERP 6.0 | HRP1009 COLUMNS

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

79 COLUMNS | 2 INDEXES | ERP 6.0 | HRP1009 TABLE

TOPERP 6.0 | HRP1009 COLUMNS

TOPERP 6.0 | HRP1009 INDEXES

TOP ERP 6.0 | HRP1009 COLUMNS

TOP ERP 6.0 | HRP1009 INDEXES