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	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	OINM	101	Whse Journal

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Australia
1	ERP EHP7	6.0	PA0626	162	1		Australia

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	PYBDT	nvarchar	8	(N'00000000')	Yes	Allow NULL?
25	PYEDT	nvarchar	8	(N'00000000')	Yes	Allow NULL?
26	PYFIN	char	1	(N' ')	Yes	Allow NULL?
27	PYETP	char	1	(N' ')	Yes	Allow NULL?
28	PYTIM	nvarchar	6	(N'000000')	Yes	Allow NULL?
29	PYDAT	nvarchar	8	(N'00000000')	Yes	Allow NULL?
30	PYNUM	tinyint	3	((0))	Yes
31	PYLTM	nvarchar	6	(N'000000')	Yes	Allow NULL?
32	PYLDT	nvarchar	8	(N'00000000')	Yes	Allow NULL?
33	PYATO	tinyint	3	((0))	Yes
34	PYATM	nvarchar	6	(N'000000')	Yes	Allow NULL?
35	PYADT	nvarchar	8	(N'00000000')	Yes	Allow NULL?
36	PYWIT	char	1	(N' ')	Yes	Allow NULL?
37	PYMAN	char	1	(N' ')	Yes	Allow NULL?
38	PYSEQ	nvarchar	5	(N'00000')	Yes	Allow NULL?
39	PYTAX	decimal	10	((0))	Yes
40	PYGRO	decimal	10	((0))	Yes
41	PYLSA	decimal	10	((0))	Yes
42	PYLSB	decimal	10	((0))	Yes
43	PYLSD	decimal	10	((0))	Yes
44	PYLSE	decimal	10	((0))	Yes
45	PYTAL	decimal	10	((0))	Yes
46	PYFBT	decimal	10	((0))	Yes
47	PYCDP	decimal	10	((0))	Yes
48	PYP83	decimal	8	((0))	Yes
49	PYA83	decimal	8	((0))	Yes
50	PYCGT	decimal	10	((0))	Yes
51	PYNQC	decimal	10	((0))	Yes
52	PYUCO	decimal	10	((0))	Yes
53	PYCON	decimal	10	((0))	Yes
54	PYE83	decimal	10	((0))	Yes
55	PYU83	decimal	10	((0))	Yes
56	PYT83	decimal	10	((0))	Yes
57	PYI94	decimal	10	((0))	Yes
58	PYEGR	decimal	10	((0))	Yes
59	PYETA	decimal	10	((0))	Yes
60	PYEAS	decimal	10	((0))	Yes
61	PYDEA	char	1	(N' ')	Yes	Allow NULL?
62	PYDTY	char	1	(N' ')	Yes	Allow NULL?
63	PYOTI	decimal	10	((0))	Yes
64	PYUNI	decimal	10	((0))	Yes
65	PYABN	nvarchar	11	(N'00000000000')	Yes	Allow NULL?
66	PYABR	nvarchar	3	(N'000')	Yes	Allow NULL?
67	PYW01	nvarchar	4	(N' ')	Yes	Allow NULL?
68	PYA01	decimal	10	((0))	Yes
69	PYW02	nvarchar	4	(N' ')	Yes	Allow NULL?
70	PYA02	decimal	10	((0))	Yes
71	PYW03	nvarchar	4	(N' ')	Yes	Allow NULL?
72	PYA03	decimal	10	((0))	Yes
73	PYW04	nvarchar	4	(N' ')	Yes	Allow NULL?
74	PYA04	decimal	10	((0))	Yes
75	PYW05	nvarchar	4	(N' ')	Yes	Allow NULL?
76	PYA05	decimal	10	((0))	Yes
77	PYW06	nvarchar	4	(N' ')	Yes	Allow NULL?
78	PYA06	decimal	10	((0))	Yes
79	PYW07	nvarchar	4	(N' ')	Yes	Allow NULL?
80	PYA07	decimal	10	((0))	Yes
81	PYW08	nvarchar	4	(N' ')	Yes	Allow NULL?
82	PYA08	decimal	10	((0))	Yes
83	PYW09	nvarchar	4	(N' ')	Yes	Allow NULL?
84	PYA09	decimal	10	((0))	Yes
85	PYW10	nvarchar	4	(N' ')	Yes	Allow NULL?
86	PYA10	decimal	10	((0))	Yes
87	PYW11	nvarchar	4	(N' ')	Yes	Allow NULL?
88	PYA11	decimal	10	((0))	Yes
89	PYW12	nvarchar	4	(N' ')	Yes	Allow NULL?
90	PYA12	decimal	10	((0))	Yes
91	PYW13	nvarchar	4	(N' ')	Yes	Allow NULL?
92	PYA13	decimal	10	((0))	Yes
93	PYW14	nvarchar	4	(N' ')	Yes	Allow NULL?
94	PYA14	decimal	10	((0))	Yes
95	PYW15	nvarchar	4	(N' ')	Yes	Allow NULL?
96	PYA15	decimal	10	((0))	Yes
97	PYENM	tinyint	3	((0))	Yes
98	PYETM	nvarchar	6	(N'000000')	Yes	Allow NULL?
99	PYETD	nvarchar	8	(N'00000000')	Yes	Allow NULL?
100	PYTNA	tinyint	3	((0))	Yes
101	PYTUF	tinyint	3	((0))	Yes
102	PYEDP	nvarchar	8	(N'00000000')	Yes	Allow NULL?
103	PYEDS	nvarchar	8	(N'00000000')	Yes	Allow NULL?
104	PYUFW	nvarchar	4	(N' ')	Yes	Allow NULL?
105	PYWPG	decimal	10	((0))	Yes
106	PYTWG	tinyint	3	((0))	Yes
107	ETTXC	decimal	10	((0))	Yes
108	ETTFC	decimal	10	((0))	Yes
109	PUW01	nvarchar	4	(N' ')	Yes	Allow NULL?
110	PUA01	decimal	10	((0))	Yes
111	PUW02	nvarchar	4	(N' ')	Yes	Allow NULL?
112	PUA02	decimal	10	((0))	Yes
113	PUW03	nvarchar	4	(N' ')	Yes	Allow NULL?
114	PUA03	decimal	10	((0))	Yes
115	PUW04	nvarchar	4	(N' ')	Yes	Allow NULL?
116	PUA04	decimal	10	((0))	Yes
117	PUW05	nvarchar	4	(N' ')	Yes	Allow NULL?
118	PUA05	decimal	10	((0))	Yes
119	PUW06	nvarchar	4	(N' ')	Yes	Allow NULL?
120	PUA06	decimal	10	((0))	Yes
121	PUW07	nvarchar	4	(N' ')	Yes	Allow NULL?
122	PUA07	decimal	10	((0))	Yes
123	PUW08	nvarchar	4	(N' ')	Yes	Allow NULL?
124	PUA08	decimal	10	((0))	Yes
125	PUW09	nvarchar	4	(N' ')	Yes	Allow NULL?
126	PUA09	decimal	10	((0))	Yes
127	PUW10	nvarchar	4	(N' ')	Yes	Allow NULL?
128	PUA10	decimal	10	((0))	Yes
129	PUW11	nvarchar	4	(N' ')	Yes	Allow NULL?
130	PUA11	decimal	10	((0))	Yes
131	PUW12	nvarchar	4	(N' ')	Yes	Allow NULL?
132	PUA12	decimal	10	((0))	Yes
133	PUW13	nvarchar	4	(N' ')	Yes	Allow NULL?
134	PUA13	decimal	10	((0))	Yes
135	PUW14	nvarchar	4	(N' ')	Yes	Allow NULL?
136	PUA14	decimal	10	((0))	Yes
137	PUW15	nvarchar	4	(N' ')	Yes	Allow NULL?
138	PUA15	decimal	10	((0))	Yes
139	PUW16	nvarchar	4	(N' ')	Yes	Allow NULL?
140	PUA16	decimal	10	((0))	Yes
141	PUW17	nvarchar	4	(N' ')	Yes	Allow NULL?
142	PUA17	decimal	10	((0))	Yes
143	PUW18	nvarchar	4	(N' ')	Yes	Allow NULL?
144	PUA18	decimal	10	((0))	Yes
145	PUW19	nvarchar	4	(N' ')	Yes	Allow NULL?
146	PUA19	decimal	10	((0))	Yes
147	PYAMD	char	1	(N' ')	Yes	Allow NULL?
148	ETAMD	char	1	(N' ')	Yes	Allow NULL?
149	TRTAX	decimal	10	((0))	Yes
150	LBTAX	decimal	10	((0))	Yes
151	DBTAX	decimal	10	((0))	Yes
152	TRTCP	decimal	10	((0))	Yes
153	LBTCP	decimal	10	((0))	Yes
154	DBTCP	decimal	10	((0))	Yes
155	TRTFP	decimal	10	((0))	Yes
156	LBTFP	decimal	10	((0))	Yes
157	DBTFP	decimal	10	((0))	Yes
158	SPLIT	char	1	(N' ')	Yes	Allow NULL?
159	PYSUP	decimal	10	((0))	Yes
160	PYFET	decimal	10	((0))	Yes
161	PYLAT	char	1	(N' ')	Yes	Allow NULL?
162	PYDPA	decimal	10	((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

162 COLUMNS | 1 INDEXES | ERP 6.0 | PA0626 TABLE

TOP ERP 6.0 | PA0626 COLUMNS

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

162 COLUMNS | 1 INDEXES | ERP 6.0 | PA0626 TABLE

TOPERP 6.0 | PA0626 COLUMNS

TOPERP 6.0 | PA0626 INDEXES

TOP ERP 6.0 | PA0626 COLUMNS

TOP ERP 6.0 | PA0626 INDEXES