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	BSEG	345	Accounting Document Segment
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	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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	REGUI	P2E: Request Guid	nvarchar	22	0	Allow NULL?
3	PERNR	Personnel number	nvarchar	8	0	Allow NULL?
4	POGUI	Policy Guid	nvarchar	22	0	Allow NULL?
5	VERSN	Policy Version	nvarchar	4	0	Allow NULL?
6	RESTS	P2E: Policy Request Status	char	1	0	Allow NULL?
7	REQST	Policy Step ID	nvarchar	8	0	Allow NULL?
8	LDRES	P2E: Decision Result	char	1	0	Allow NULL?
9	CREBY	User Name in User Master Record	nvarchar	12	0	Allow NULL?
10	CREON	P2E: Date and Time	decimal	15	0
11	CHABY	User Name in User Master Record	nvarchar	12	0	Allow NULL?
12	CHAON	P2E: Date and Time	decimal	15	0
13	ATIND	Mandate Check	char	1	0	Allow NULL?
14	ARKEY	Area Key	nvarchar	5	0	Allow NULL?
15	CLRST	P2E: Closure Status	nvarchar	2	0	Allow NULL?
16	STPPR	P2E: String	ntext	1073741823	0
17	CDT01	P2E: Date Field	nvarchar	8	0	Allow NULL?
18	CDT02	P2E: Date Field	nvarchar	8	0	Allow NULL?
19	CDT03	P2E: Date Field	nvarchar	8	0	Allow NULL?
20	CDT04	P2E: Date Field	nvarchar	8	0	Allow NULL?
21	CDT05	P2E: Date Field	nvarchar	8	0	Allow NULL?
22	CDT06	P2E: Date Field	nvarchar	8	0	Allow NULL?
23	CDT07	P2E: Date Field	nvarchar	8	0	Allow NULL?
24	CDT08	P2E: Date Field	nvarchar	8	0	Allow NULL?
25	CDT09	P2E: Date Field	nvarchar	8	0	Allow NULL?
26	CDT10	P2E: Date Field	nvarchar	8	0	Allow NULL?
27	C01T1	P2E: Text (01) Field	char	1	0	Allow NULL?
28	C01T2	P2E: Text (01) Field	char	1	0	Allow NULL?
29	C01T3	P2E: Text (01) Field	char	1	0	Allow NULL?
30	C01T4	P2E: Text (01) Field	char	1	0	Allow NULL?
31	C01T5	P2E: Text (01) Field	char	1	0	Allow NULL?
32	C03T1	P2E: Text (03) Field	nvarchar	3	0	Allow NULL?
33	C03T2	P2E: Text (03) Field	nvarchar	3	0	Allow NULL?
34	C03T3	P2E: Text (03) Field	nvarchar	3	0	Allow NULL?
35	C03T4	P2E: Text (03) Field	nvarchar	3	0	Allow NULL?
36	C03T5	P2E: Text (03) Field	nvarchar	3	0	Allow NULL?
37	C10T1	P2E: Text (10) Field	nvarchar	10	0	Allow NULL?
38	C10T2	P2E: Text (10) Field	nvarchar	10	0	Allow NULL?
39	C10T3	P2E: Text (10) Field	nvarchar	10	0	Allow NULL?
40	C10T4	P2E: Text (10) Field	nvarchar	10	0	Allow NULL?
41	C10T5	P2E: Text (10) Field	nvarchar	10	0	Allow NULL?
42	C20T1	P2E: Text(20) Field	nvarchar	20	0	Allow NULL?
43	C20T2	P2E: Text(20) Field	nvarchar	20	0	Allow NULL?
44	C20T3	P2E: Text(20) Field	nvarchar	20	0	Allow NULL?
45	C20T4	P2E: Text(20) Field	nvarchar	20	0	Allow NULL?
46	C20T5	P2E: Text(20) Field	nvarchar	20	0	Allow NULL?
47	C40T1	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
48	C40T2	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
49	C40T3	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
50	C40T4	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
51	C40T5	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
52	C40T6	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
53	C40T7	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
54	C40T8	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
55	C40T9	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
56	C40T0	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
57	C41T1	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
58	C41T2	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
59	C41T3	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
60	C41T4	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
61	C41T5	P2E: Text (40) Field	nvarchar	40	0	Allow NULL?
62	N02N1	P2E: 2 Digit Number Field	nvarchar	2	0	Allow NULL?
63	N02N2	P2E: 2 Digit Number Field	nvarchar	2	0	Allow NULL?
64	N02N3	P2E: 2 Digit Number Field	nvarchar	2	0	Allow NULL?
65	N02N4	P2E: 2 Digit Number Field	nvarchar	2	0	Allow NULL?
66	N02N5	P2E: 2 Digit Number Field	nvarchar	2	0	Allow NULL?
67	N05N1	P2E: 5 Digit Number Field	nvarchar	5	0	Allow NULL?
68	N05N2	P2E: 5 Digit Number Field	nvarchar	5	0	Allow NULL?
69	N05N3	P2E: 5 Digit Number Field	nvarchar	5	0	Allow NULL?
70	N05N4	P2E: 5 Digit Number Field	nvarchar	5	0	Allow NULL?
71	N05N5	P2E: 5 Digit Number Field	nvarchar	5	0	Allow NULL?
72	N10N1	P2E: 10 Digit Number Field	nvarchar	10	0	Allow NULL?
73	N10N2	P2E: 10 Digit Number Field	nvarchar	10	0	Allow NULL?
74	N10N3	P2E: 10 Digit Number Field	nvarchar	10	0	Allow NULL?
75	N10N4	P2E: 10 Digit Number Field	nvarchar	10	0	Allow NULL?
76	N10N5	P2E: 10 Digit Number Field	nvarchar	10	0	Allow NULL?
77	N20N1	P2E: 20 Digit Number Field	nvarchar	20	0	Allow NULL?
78	N20N2	P2E: 20 Digit Number Field	nvarchar	20	0	Allow NULL?
79	N20N3	P2E: 20 Digit Number Field	nvarchar	20	0	Allow NULL?
80	N20N4	P2E: 20 Digit Number Field	nvarchar	20	0	Allow NULL?
81	N20N5	P2E: 20 Digit Number Field	nvarchar	20	0	Allow NULL?
82	N16N1	P2E: 16 Digit Number Field	nvarchar	16	0	Allow NULL?
83	N16N2	P2E: 16 Digit Number Field	nvarchar	16	0	Allow NULL?
84	N16N3	P2E: 16 Digit Number Field	nvarchar	16	0	Allow NULL?
85	N16N4	P2E: 16 Digit Number Field	nvarchar	16	0	Allow NULL?
86	N16N5	P2E: 16 Digit Number Field	nvarchar	16	0	Allow NULL?
87	CKB01	P2E: Check-Box Field	char	1	0	Allow NULL?
88	CKB02	P2E: Check-Box Field	char	1	0	Allow NULL?
89	CKB03	P2E: Check-Box Field	char	1	0	Allow NULL?
90	CKB04	P2E: Check-Box Field	char	1	0	Allow NULL?
91	CKB05	P2E: Check-Box Field	char	1	0	Allow NULL?
92	CKB06	P2E: Check-Box Field	char	1	0	Allow NULL?
93	CKB07	P2E: Check-Box Field	char	1	0	Allow NULL?
94	CKB08	P2E: Check-Box Field	char	1	0	Allow NULL?
95	CKB09	P2E: Check-Box Field	char	1	0	Allow NULL?
96	CKB10	P2E: Check-Box Field	char	1	0	Allow NULL?
97	AMT01	P2E: Amount Field	decimal	15	2
98	AMT02	P2E: Amount Field	decimal	15	2
99	AMT03	P2E: Amount Field	decimal	15	2
100	AMT04	P2E: Amount Field	decimal	15	2
101	AMT05	P2E: Amount Field	decimal	15	2
102	WAER1	Currency Key	nvarchar	5	0	Allow NULL?
103	WAER2	Currency Key	nvarchar	5	0	Allow NULL?
104	WAER3	Currency Key	nvarchar	5	0	Allow NULL?
105	WAER4	Currency Key	nvarchar	5	0	Allow NULL?
106	WAER5	Currency Key	nvarchar	5	0	Allow NULL?
107	DEC01	P2E: Decimal Field	decimal	15	2
108	DEC02	P2E: Decimal Field	decimal	15	2
109	DEC03	P2E: Decimal Field	decimal	15	2
110	DEC04	P2E: Decimal Field	decimal	15	2
111	DEC05	P2E: Decimal Field	decimal	15	2
112	C04T1	P2E: Text (04) Field	nvarchar	4	0	Allow NULL?
113	C04T2	P2E: Text (04) Field	nvarchar	4	0	Allow NULL?
114	C04T3	P2E: Text (04) Field	nvarchar	4	0	Allow NULL?
115	C04T4	P2E: Text (04) Field	nvarchar	4	0	Allow NULL?
116	C04T5	P2E: Text (04) Field	nvarchar	4	0	Allow NULL?
117	C80T1	P2E: Text (80) Field	nvarchar	80	0	Allow NULL?
118	C80T2	P2E: Text (80) Field	nvarchar	80	0	Allow NULL?
119	C80T3	P2E: Text (80) Field	nvarchar	80	0	Allow NULL?
120	C80T4	P2E: Text (80) Field	nvarchar	80	0	Allow NULL?
121	C80T5	P2E: Text (80) Field	nvarchar	80	0	Allow NULL?
122	C200T1	P2E: Text (200) Field	nvarchar	200	0	Allow NULL?
123	C200T2	P2E: Text (200) Field	nvarchar	200	0	Allow NULL?
124	C200T3	P2E: Text (200) Field	nvarchar	200	0	Allow NULL?
125	C500T1	P2E: String	ntext	1073741823	0
126	C500T2	P2E: String	ntext	1073741823	0
127	C1000T1	P2E: String	ntext	1073741823	0
128	TBL01	Mandate Check	char	1	0	Allow NULL?
129	TBL02	Mandate Check	char	1	0	Allow NULL?
130	REQID	P2E: Policy Request ID	nvarchar	10	0	Allow NULL?
131	TXGUI	Name	nvarchar	70	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

131 COLUMNS | 1 INDEXES | ERP 6.0 | T7INPEX1 TABLE

TOP ERP 6.0 | T7INPEX1 COLUMNS

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

131 COLUMNS | 1 INDEXES | ERP 6.0 | T7INPEX1 TABLE

TOPERP 6.0 | T7INPEX1 COLUMNS

TOPERP 6.0 | T7INPEX1 INDEXES

TOP ERP 6.0 | T7INPEX1 COLUMNS

TOP ERP 6.0 | T7INPEX1 INDEXES