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 :: Australia
1	ERP EHP7	6.0	PA0626	162	1		Australia

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

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