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	PA0414	135	1	HR Master Record: Infotype 0414	Personnel Administration

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	SCD01	Seniority code	nvarchar	2	0	Allow NULL?
25	SID01	Seniority identifier	char	1	0	Allow NULL?
26	SYY01	Seniority period - years	nvarchar	2	0	Allow NULL?
27	SMM01	Seniority period - months	nvarchar	2	0	Allow NULL?
28	SDD01	Seniority period - days	nvarchar	3	0	Allow NULL?
29	SCD02	Seniority code	nvarchar	2	0	Allow NULL?
30	SID02	Seniority identifier	char	1	0	Allow NULL?
31	SYY02	Seniority period - years	nvarchar	2	0	Allow NULL?
32	SMM02	Seniority period - months	nvarchar	2	0	Allow NULL?
33	SDD02	Seniority period - days	nvarchar	3	0	Allow NULL?
34	SCD03	Seniority code	nvarchar	2	0	Allow NULL?
35	SID03	Seniority identifier	char	1	0	Allow NULL?
36	SYY03	Seniority period - years	nvarchar	2	0	Allow NULL?
37	SMM03	Seniority period - months	nvarchar	2	0	Allow NULL?
38	SDD03	Seniority period - days	nvarchar	3	0	Allow NULL?
39	SCD04	Seniority code	nvarchar	2	0	Allow NULL?
40	SID04	Seniority identifier	char	1	0	Allow NULL?
41	SYY04	Seniority period - years	nvarchar	2	0	Allow NULL?
42	SMM04	Seniority period - months	nvarchar	2	0	Allow NULL?
43	SDD04	Seniority period - days	nvarchar	3	0	Allow NULL?
44	SCD05	Seniority code	nvarchar	2	0	Allow NULL?
45	SID05	Seniority identifier	char	1	0	Allow NULL?
46	SYY05	Seniority period - years	nvarchar	2	0	Allow NULL?
47	SMM05	Seniority period - months	nvarchar	2	0	Allow NULL?
48	SDD05	Seniority period - days	nvarchar	3	0	Allow NULL?
49	SCD06	Seniority code	nvarchar	2	0	Allow NULL?
50	SID06	Seniority identifier	char	1	0	Allow NULL?
51	SYY06	Seniority period - years	nvarchar	2	0	Allow NULL?
52	SMM06	Seniority period - months	nvarchar	2	0	Allow NULL?
53	SDD06	Seniority period - days	nvarchar	3	0	Allow NULL?
54	SCD07	Seniority code	nvarchar	2	0	Allow NULL?
55	SID07	Seniority identifier	char	1	0	Allow NULL?
56	SYY07	Seniority period - years	nvarchar	2	0	Allow NULL?
57	SMM07	Seniority period - months	nvarchar	2	0	Allow NULL?
58	SDD07	Seniority period - days	nvarchar	3	0	Allow NULL?
59	SCD08	Seniority code	nvarchar	2	0	Allow NULL?
60	SID08	Seniority identifier	char	1	0	Allow NULL?
61	SYY08	Seniority period - years	nvarchar	2	0	Allow NULL?
62	SMM08	Seniority period - months	nvarchar	2	0	Allow NULL?
63	SDD08	Seniority period - days	nvarchar	3	0	Allow NULL?
64	SCD09	Seniority code	nvarchar	2	0	Allow NULL?
65	SID09	Seniority identifier	char	1	0	Allow NULL?
66	SYY09	Seniority period - years	nvarchar	2	0	Allow NULL?
67	SMM09	Seniority period - months	nvarchar	2	0	Allow NULL?
68	SDD09	Seniority period - days	nvarchar	3	0	Allow NULL?
69	SCD10	Seniority code	nvarchar	2	0	Allow NULL?
70	SID10	Seniority identifier	char	1	0	Allow NULL?
71	SYY10	Seniority period - years	nvarchar	2	0	Allow NULL?
72	SMM10	Seniority period - months	nvarchar	2	0	Allow NULL?
73	SDD10	Seniority period - days	nvarchar	3	0	Allow NULL?
74	SCD11	Seniority code	nvarchar	2	0	Allow NULL?
75	SID11	Seniority identifier	char	1	0	Allow NULL?
76	SYY11	Seniority period - years	nvarchar	2	0	Allow NULL?
77	SMM11	Seniority period - months	nvarchar	2	0	Allow NULL?
78	SDD11	Seniority period - days	nvarchar	3	0	Allow NULL?
79	SCD12	Seniority code	nvarchar	2	0	Allow NULL?
80	SID12	Seniority identifier	char	1	0	Allow NULL?
81	SYY12	Seniority period - years	nvarchar	2	0	Allow NULL?
82	SMM12	Seniority period - months	nvarchar	2	0	Allow NULL?
83	SDD12	Seniority period - days	nvarchar	3	0	Allow NULL?
84	SCD13	Seniority code	nvarchar	2	0	Allow NULL?
85	SID13	Seniority identifier	char	1	0	Allow NULL?
86	SYY13	Seniority period - years	nvarchar	2	0	Allow NULL?
87	SMM13	Seniority period - months	nvarchar	2	0	Allow NULL?
88	SDD13	Seniority period - days	nvarchar	3	0	Allow NULL?
89	SCD14	Seniority code	nvarchar	2	0	Allow NULL?
90	SID14	Seniority identifier	char	1	0	Allow NULL?
91	SYY14	Seniority period - years	nvarchar	2	0	Allow NULL?
92	SMM14	Seniority period - months	nvarchar	2	0	Allow NULL?
93	SDD14	Seniority period - days	nvarchar	3	0	Allow NULL?
94	SCD15	Seniority code	nvarchar	2	0	Allow NULL?
95	SID15	Seniority identifier	char	1	0	Allow NULL?
96	SYY15	Seniority period - years	nvarchar	2	0	Allow NULL?
97	SMM15	Seniority period - months	nvarchar	2	0	Allow NULL?
98	SDD15	Seniority period - days	nvarchar	3	0	Allow NULL?
99	SCD16	Seniority code	nvarchar	2	0	Allow NULL?
100	SID16	Seniority identifier	char	1	0	Allow NULL?
101	SYY16	Seniority period - years	nvarchar	2	0	Allow NULL?
102	SMM16	Seniority period - months	nvarchar	2	0	Allow NULL?
103	SDD16	Seniority period - days	nvarchar	3	0	Allow NULL?
104	SCD17	Seniority code	nvarchar	2	0	Allow NULL?
105	SID17	Seniority identifier	char	1	0	Allow NULL?
106	SYY17	Seniority period - years	nvarchar	2	0	Allow NULL?
107	SMM17	Seniority period - months	nvarchar	2	0	Allow NULL?
108	SDD17	Seniority period - days	nvarchar	3	0	Allow NULL?
109	SCD18	Seniority code	nvarchar	2	0	Allow NULL?
110	SID18	Seniority identifier	char	1	0	Allow NULL?
111	SYY18	Seniority period - years	nvarchar	2	0	Allow NULL?
112	SMM18	Seniority period - months	nvarchar	2	0	Allow NULL?
113	SDD18	Seniority period - days	nvarchar	3	0	Allow NULL?
114	SCD19	Seniority code	nvarchar	2	0	Allow NULL?
115	SID19	Seniority identifier	char	1	0	Allow NULL?
116	SYY19	Seniority period - years	nvarchar	2	0	Allow NULL?
117	SMM19	Seniority period - months	nvarchar	2	0	Allow NULL?
118	SDD19	Seniority period - days	nvarchar	3	0	Allow NULL?
119	SCD20	Seniority code	nvarchar	2	0	Allow NULL?
120	SID20	Seniority identifier	char	1	0	Allow NULL?
121	SYY20	Seniority period - years	nvarchar	2	0	Allow NULL?
122	SMM20	Seniority period - months	nvarchar	2	0	Allow NULL?
123	SDD20	Seniority period - days	nvarchar	3	0	Allow NULL?
124	PERTX	Period description	nvarchar	50	0	Allow NULL?
125	LDPER	Leave days at previous employer	decimal	7	5
126	EVRP6	Evidence for RP-6 form code	char	1	0	Allow NULL?
127	FLFLG	First leave after 12 months flag	char	1	0	Allow NULL?
128	RLDPR	Requested leave days at previous employer	decimal	6	5
129	FEFLG	First employment flag	char	1	0	Allow NULL?
130	CHALL	Child Care Leave Deduction	decimal	7	5
131	FAMAL	Family member care leave	decimal	7	5
132	CHL14	Utilized Child Allowance < 14 years old	decimal	7	5
133	PTURN	Deduction rehabilitation leave for previous employer	char	1	0	Allow NULL?
134	LEAPE	Leave taken over from previous employer	decimal	7	5
135	GENLE	Forcing leave generation	char	1	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

135 COLUMNS | 1 INDEXES | ERP 6.0 | PA0414 TABLE

TOP ERP 6.0 | PA0414 COLUMNS

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

135 COLUMNS | 1 INDEXES | ERP 6.0 | PA0414 TABLE

TOPERP 6.0 | PA0414 COLUMNS

TOPERP 6.0 | PA0414 INDEXES

TOP ERP 6.0 | PA0414 COLUMNS

TOP ERP 6.0 | PA0414 INDEXES