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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: USA
1	ERP EHP7	6.0	PA0446	105	1		USA

Column	Field	SQL Type	Length	Default Value	Null Allowed	SQL Create Statement
1	MANDT	nvarchar	3	(N'000')	Yes	Allow NULL?
2	PERNR	nvarchar	8	(N'00000000')	Yes	Allow NULL?
3	SUBTY	nvarchar	4	(N' ')	Yes	Allow NULL?
4	OBJPS	nvarchar	2	(N' ')	Yes	Allow NULL?
5	SPRPS	char	1	(N' ')	Yes	Allow NULL?
6	ENDDA	nvarchar	8	(N'00000000')	Yes	Allow NULL?
7	BEGDA	nvarchar	8	(N'00000000')	Yes	Allow NULL?
8	SEQNR	nvarchar	3	(N'000')	Yes	Allow NULL?
9	AEDTM	nvarchar	8	(N'00000000')	Yes	Allow NULL?
10	UNAME	nvarchar	12	(N' ')	Yes	Allow NULL?
11	HISTO	char	1	(N' ')	Yes	Allow NULL?
12	ITXEX	char	1	(N' ')	Yes	Allow NULL?
13	REFEX	char	1	(N' ')	Yes	Allow NULL?
14	ORDEX	char	1	(N' ')	Yes	Allow NULL?
15	ITBLD	nvarchar	2	(N' ')	Yes	Allow NULL?
16	PREAS	nvarchar	2	(N' ')	Yes	Allow NULL?
17	FLAG1	char	1	(N' ')	Yes	Allow NULL?
18	FLAG2	char	1	(N' ')	Yes	Allow NULL?
19	FLAG3	char	1	(N' ')	Yes	Allow NULL?
20	FLAG4	char	1	(N' ')	Yes	Allow NULL?
21	RESE1	nvarchar	2	(N' ')	Yes	Allow NULL?
22	RESE2	nvarchar	2	(N' ')	Yes	Allow NULL?
23	GRPVL	nvarchar	4	(N' ')	Yes	Allow NULL?
24	PY_SEQNR	nvarchar	5	(N'00000')	Yes	Allow NULL?
25	MOLGA	nvarchar	2	(N' ')	Yes	Allow NULL?
26	ABKRS	nvarchar	2	(N' ')	Yes	Allow NULL?
27	WAERS	nvarchar	5	(N' ')	Yes	Allow NULL?
28	FPPER	nvarchar	6	(N' ')	Yes	Allow NULL?
29	PAYTY	char	1	(N' ')	Yes	Allow NULL?
30	PAYID	char	1	(N' ')	Yes	Allow NULL?
31	PAY_DATE	nvarchar	8	(N'00000000')	Yes	Allow NULL?
32	TXCMP	nvarchar	4	(N' ')	Yes	Allow NULL?
33	TAXAU	nvarchar	4	(N' ')	Yes	Allow NULL?
34	ZZTEL0042B	decimal	15	((0))	Yes
35	ZZTEL0043B	decimal	15	((0))	Yes
36	ZZTEL0044B	decimal	15	((0))	Yes
37	ZZTEL0045B	decimal	15	((0))	Yes
38	ZZTEL0046B	decimal	15	((0))	Yes
39	ZZTEL0047B	decimal	15	((0))	Yes
40	ZZTEL0048B	decimal	15	((0))	Yes
41	ZZTEL0049B	decimal	15	((0))	Yes
42	ZZTEL0050B	decimal	15	((0))	Yes
43	ZZTEL0051B	decimal	15	((0))	Yes
44	ZZTEL0052B	decimal	15	((0))	Yes
45	ZZTEL0053B	decimal	15	((0))	Yes
46	ZZTEL0054B	decimal	15	((0))	Yes
47	ZZTEL0055B	decimal	15	((0))	Yes
48	ZZTEL0056B	decimal	15	((0))	Yes
49	ZZTEL0057B	decimal	15	((0))	Yes
50	ZZTEL0058B	decimal	15	((0))	Yes
51	ZZTEL0059B	decimal	15	((0))	Yes
52	ZZTEL0060B	decimal	15	((0))	Yes
53	ZZTEL0061B	decimal	15	((0))	Yes
54	ZZTEL0062B	decimal	15	((0))	Yes
55	ZZTEL0063B	decimal	15	((0))	Yes
56	ZZTEL0064B	decimal	15	((0))	Yes
57	ZZTEL0065B	decimal	15	((0))	Yes
58	ZZTEL0066B	decimal	15	((0))	Yes
59	ZZTEL0067B	decimal	15	((0))	Yes
60	ZZTEL0068B	decimal	15	((0))	Yes
61	ZZTEL0069B	decimal	15	((0))	Yes
62	ZZTEL0070B	decimal	15	((0))	Yes
63	ZZTEL0071B	decimal	15	((0))	Yes
64	ZZTEL0072B	decimal	15	((0))	Yes
65	ZZTEL0073B	decimal	15	((0))	Yes
66	ZZTEL0074B	decimal	15	((0))	Yes
67	ZZTEL0075B	decimal	15	((0))	Yes
68	ZZTEL0076B	decimal	15	((0))	Yes
69	ZZTEL0077B	decimal	15	((0))	Yes
70	ZZTEL0078B	decimal	15	((0))	Yes
71	ZZTEL0079B	decimal	15	((0))	Yes
72	ZZTEL0080B	decimal	15	((0))	Yes
73	ZZTEL0081B	decimal	15	((0))	Yes
74	ZZTEL0082B	decimal	15	((0))	Yes
75	ZZTEL0083B	decimal	15	((0))	Yes
76	ZZTEL0084B	decimal	15	((0))	Yes
77	ZZTEL0085B	decimal	15	((0))	Yes
78	ZZTEL0086B	decimal	15	((0))	Yes
79	ZZTEL0087B	decimal	15	((0))	Yes
80	ZZTEL0088B	decimal	15	((0))	Yes
81	ZZTEL0089B	decimal	15	((0))	Yes
82	ZZTEL0090B	decimal	15	((0))	Yes
83	ZZTEL0091B	decimal	15	((0))	Yes
84	ZZTEL0092B	decimal	15	((0))	Yes
85	ZZTEL0093B	decimal	15	((0))	Yes
86	ZZTEL0094B	decimal	15	((0))	Yes
87	ZZTEL0095B	decimal	15	((0))	Yes
88	ZZTEL0096B	decimal	15	((0))	Yes
89	ZZTEL0097B	decimal	15	((0))	Yes
90	ZZTEL0098B	decimal	15	((0))	Yes
91	ZZTEL0099B	decimal	15	((0))	Yes
92	ZZTEL0100B	decimal	15	((0))	Yes
93	ZZTEL0101B	decimal	15	((0))	Yes
94	ZZTEL0102B	decimal	15	((0))	Yes
95	ZZTEL0103B	decimal	15	((0))	Yes
96	ZZTEL0104B	decimal	15	((0))	Yes
97	ZZTEL0105B	decimal	15	((0))	Yes
98	ZZTEL0106B	decimal	15	((0))	Yes
99	ZZTEL0107B	decimal	15	((0))	Yes
100	ZZTEL0108B	decimal	15	((0))	Yes
101	ZZTEL0109B	decimal	15	((0))	Yes
102	ZZTEL0110B	decimal	15	((0))	Yes
103	ZZTEL0111B	decimal	15	((0))	Yes
104	ZZTEL0112B	decimal	15	((0))	Yes
105	ZZTEL0113B	decimal	15	((0))	Yes

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

105 COLUMNS | 1 INDEXES | ERP 6.0 | PA0446 TABLE

TOP ERP 6.0 | PA0446 COLUMNS

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

105 COLUMNS | 1 INDEXES | ERP 6.0 | PA0446 TABLE

TOPERP 6.0 | PA0446 COLUMNS

TOPERP 6.0 | PA0446 INDEXES

TOP ERP 6.0 | PA0446 COLUMNS

TOP ERP 6.0 | PA0446 INDEXES