	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

	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

	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

106 columns | ERP 6.0 | KEY_EXT1

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length
1	YIT_INFOBASE_XD	IDES Infobase: Application Data Assignments	4	KEY_EXT1	Client	nvarchar	3
2	YIT_INITIAL	Infobase: Initialtabelle für Views	1	KEY_EXT1	Infobase: Platzhalter Key	nvarchar	1
3	YIT_O1ACC	IDA: Original Table ACC	1	KEY_EXT1	Client	nvarchar	3
4	YIT_O1ASS	IDA: Original Table ASS	1	KEY_EXT1	Client	nvarchar	3
5	YIT_O1BNK	IDA: Original Table BNK	1	KEY_EXT1	Client	nvarchar	3
6	YIT_O1BOM	IDA: Original Table BOM	1	KEY_EXT1	Client	nvarchar	3
7	YIT_O1COE	IDA: Original Table COE	1	KEY_EXT1	Client	nvarchar	3
8	YIT_O1COS	IDA: Original Table COS	1	KEY_EXT1	Client	nvarchar	3
9	YIT_O1CRE	IDA: Original Table CRE	1	KEY_EXT1	Client	nvarchar	3
10	YIT_O1DEB	IDA: Original Table DEB	1	KEY_EXT1	Client	nvarchar	3
11	YIT_O1DOC	IDA: Original Table DOC	1	KEY_EXT1	Client	nvarchar	3
12	YIT_O1EQU	IDA: Original Table EQU	1	KEY_EXT1	Client	nvarchar	3
13	YIT_O1IPR	IDA: Original Table IPR	1	KEY_EXT1	Client	nvarchar	3
14	YIT_O1MAT	IDA: Original Table MAT.	1	KEY_EXT1	Client	nvarchar	3
15	YIT_O1MPL	IDA: Original Table MPL	1	KEY_EXT1	Client	nvarchar	3
16	YIT_O1NET	IDA: Original Table NET	1	KEY_EXT1	Client	nvarchar	3
17	YIT_O1OBJ	IDA: Original Table OBJ	1	KEY_EXT1	Client	nvarchar	3
18	YIT_O1ORD	IDA: Original Table ORD	1	KEY_EXT1	Client	nvarchar	3
19	YIT_O1PER	IDA: Original Table PER	1	KEY_EXT1	Client	nvarchar	3
20	YIT_O1PRC	IDA: Original Table COS	1	KEY_EXT1	Client	nvarchar	3
21	YIT_O1PRO	IDA: Original Table PRO	1	KEY_EXT1	Client	nvarchar	3
22	YIT_O1ROU	IDA: Original Table ROU	1	KEY_EXT1	Client	nvarchar	3
23	YIT_O1STN	IDA: Original Table STN	1	KEY_EXT1	Client	nvarchar	3
24	YIT_O1STP	IDA: Original Table STP	1	KEY_EXT1	Client	nvarchar	3
25	YIT_O1TPL	IDA: Original Table TPL	1	KEY_EXT1	Client	nvarchar	3
26	YIT_O1WOR	IDA: Original Table WOR	1	KEY_EXT1	Client	nvarchar	3
27	YIT_O1__1	IDA: Original Table __1 Org. Units	1	KEY_EXT1	Client	nvarchar	3
28	YIT_O1__2	IDA: Original Table __2 Application Customizing	1	KEY_EXT1	Client	nvarchar	3
29	YIT_O2ACC	IDA: Original Table ACC	1	KEY_EXT1	Client	nvarchar	3
30	YIT_O2ASS	IDA: Original Table ASS	1	KEY_EXT1	Client	nvarchar	3
31	YIT_O2BNK	IDA: Original Table BNK	1	KEY_EXT1	Client	nvarchar	3
32	YIT_O2BOM	IDA: Original Table BOM	1	KEY_EXT1	Client	nvarchar	3
33	YIT_O2COE	IDA: Original Table COE	1	KEY_EXT1	Client	nvarchar	3
34	YIT_O2COS	IDA: Original Table COS	1	KEY_EXT1	Client	nvarchar	3
35	YIT_O2CRE	IDA: Original Table CRE	1	KEY_EXT1	Client	nvarchar	3
36	YIT_O2DEB	IDA: Original Table DEB	1	KEY_EXT1	Client	nvarchar	3
37	YIT_O2DOC	IDA: Original Table DOC	1	KEY_EXT1	Client	nvarchar	3
38	YIT_O2EQU	IDA: Original Table EQU	1	KEY_EXT1	Client	nvarchar	3
39	YIT_O2IPR	IDA: Original Table IPR	1	KEY_EXT1	Client	nvarchar	3
40	YIT_O2MAT	IDA: Original Table MAT	1	KEY_EXT1	Client	nvarchar	3
41	YIT_O2MPL	IDA: Original Table MPL	1	KEY_EXT1	Client	nvarchar	3
42	YIT_O2NET	IDA: Original Table NET	1	KEY_EXT1	Client	nvarchar	3
43	YIT_O2OBJ	IDA: Original Table OBJ	1	KEY_EXT1	Client	nvarchar	3
44	YIT_O2ORD	IDA: Original Table ORD	1	KEY_EXT1	Client	nvarchar	3
45	YIT_O2PER	IDA: Original Table PER	1	KEY_EXT1	Client	nvarchar	3
46	YIT_O2PRC	IDA: Original Table PRC	1	KEY_EXT1	Client	nvarchar	3
47	YIT_O2PRO	IDA: Original Table PRO	1	KEY_EXT1	Client	nvarchar	3
48	YIT_O2ROU	IDA: Original Table ROU	1	KEY_EXT1	Client	nvarchar	3
49	YIT_O2STN	IDA: Original Table STN	1	KEY_EXT1	Client	nvarchar	3
50	YIT_O2STP	IDA: Original Table STP	1	KEY_EXT1	Client	nvarchar	3
51	YIT_O2TPL	IDA: Original Table TPL	1	KEY_EXT1	Client	nvarchar	3
52	YIT_O2WOR	IDA: Original Table WOR	1	KEY_EXT1	Client	nvarchar	3
53	YIT_O2__1	IDA: Original Table __1 Org. Units	1	KEY_EXT1	Client	nvarchar	3
54	YIT_O2__2	IDA: Original Table __2 Application Customizing	1	KEY_EXT1	Client	nvarchar	3
55	YIT_O3ACC	IDA: Original Table ACC	2	KEY_EXT1	Client	nvarchar	3
56	YIT_O3ASS	IDA: Original Table ASS	1	KEY_EXT1	Client	nvarchar	3
57	YIT_O3BNK	IDA: Original Table BNK	1	KEY_EXT1	Client	nvarchar	3
58	YIT_O3BOM	IDA: Original Table BOM	2	KEY_EXT1	Client	nvarchar	3
59	YIT_O3COE	IDA: Original Table COE	2	KEY_EXT1	Client	nvarchar	3
60	YIT_O3COS	IDA: Original Table COS	2	KEY_EXT1	Client	nvarchar	3
61	YIT_O3CRE	IDA: Original Table CRE	1	KEY_EXT1	Client	nvarchar	3
62	YIT_O3DEB	IDA: Original Table DEB	1	KEY_EXT1	Client	nvarchar	3
63	YIT_O3DOC	IDA: Original Table DOC	2	KEY_EXT1	Client	nvarchar	3
64	YIT_O3EQU	IDA: Original Table EQU	2	KEY_EXT1	Client	nvarchar	3
65	YIT_O3IPR	IDA: Original Table IPR	2	KEY_EXT1	Client	nvarchar	3
66	YIT_O3MAT	IDA: Original Table MAT	2	KEY_EXT1	Client	nvarchar	3
67	YIT_O3MPL	IDA: Original Table MPL	1	KEY_EXT1	Client	nvarchar	3
68	YIT_O3NET	IDA: Original Table NET	1	KEY_EXT1	Client	nvarchar	3
69	YIT_O3OBJ	IDA: Original Table OBJ	2	KEY_EXT1	Client	nvarchar	3
70	YIT_O3ORD	IDA: Original Table ORD	1	KEY_EXT1	Client	nvarchar	3
71	YIT_O3PER	IDA: Original Table PER	1	KEY_EXT1	Client	nvarchar	3
72	YIT_O3PRC	IDA: Original Table COS	2	KEY_EXT1	Client	nvarchar	3
73	YIT_O3PRO	IDA: Original Table PRO	1	KEY_EXT1	Client	nvarchar	3
74	YIT_O3ROU	IDA: Original Table ROU	1	KEY_EXT1	Client	nvarchar	3
75	YIT_O3STN	IDA: Original Table STN	1	KEY_EXT1	Client	nvarchar	3
76	YIT_O3STP	IDA: Original Table STP	1	KEY_EXT1	Client	nvarchar	3
77	YIT_O3TPL	IDA: Original Table TPL	2	KEY_EXT1	Client	nvarchar	3
78	YIT_O3WOR	IDA: Original Table WOR	2	KEY_EXT1	Client	nvarchar	3
79	YIT_O3__1	IDA: Original Table __1 Org. Units	2	KEY_EXT1	Client	nvarchar	3
80	YIT_O3__2	IDA: Original Table __2 Application Customizing	2	KEY_EXT1	Client	nvarchar	3
81	YIT_R1ACC	IDA: Reference Table ACC	3	KEY_EXT1	Client	nvarchar	3
82	YIT_R1ASS	IDA: Reference Table ASS	3	KEY_EXT1	Client	nvarchar	3
83	YIT_R1BNK	IDA: Reference Table BNK	3	KEY_EXT1	Client	nvarchar	3
84	YIT_R1BOM	IDA: Reference Table BOM	3	KEY_EXT1	Client	nvarchar	3
85	YIT_R1COE	IDA: Reference Table COE	3	KEY_EXT1	Client	nvarchar	3
86	YIT_R1COS	IDA: Reference Table COS	3	KEY_EXT1	Client	nvarchar	3
87	YIT_R1CRE	IDA: Reference Table CRE	3	KEY_EXT1	Client	nvarchar	3
88	YIT_R1DEB	IDA: Reference Table DEB	3	KEY_EXT1	Client	nvarchar	3
89	YIT_R1DOC	IDA: Reference Table DOC	3	KEY_EXT1	Client	nvarchar	3
90	YIT_R1EQU	IDA: Reference Table EQU	3	KEY_EXT1	Client	nvarchar	3
91	YIT_R1IPR	IDA: Reference Table IPR	3	KEY_EXT1	Client	nvarchar	3
92	YIT_R1MAT	IDA: Reference Table MAT	3	KEY_EXT1	Client	nvarchar	3
93	YIT_R1MPL	IDA: Reference table MPL	3	KEY_EXT1	Client	nvarchar	3
94	YIT_R1NET	IDA: Reference table NET	3	KEY_EXT1	Client	nvarchar	3
95	YIT_R1OBJ	IDA: Reference table OBJ	3	KEY_EXT1	Client	nvarchar	3
96	YIT_R1ORD	IDA: Reference table ORD	3	KEY_EXT1	Client	nvarchar	3
97	YIT_R1PER	IDA: Reference table PER	3	KEY_EXT1	Client	nvarchar	3
98	YIT_R1PRC	IDA: Reference Table COS	3	KEY_EXT1	Client	nvarchar	3
99	YIT_R1PRO	IDA: Reference table PRO	3	KEY_EXT1	Client	nvarchar	3
100	YIT_R1ROU	IDA: Reference table ROU	3	KEY_EXT1	Client	nvarchar	3
101	YIT_R1STN	IDA: Reference table STN	3	KEY_EXT1	Client	nvarchar	3
102	YIT_R1STP	IDA: Reference table STP	3	KEY_EXT1	Client	nvarchar	3
103	YIT_R1TPL	IDA: Reference Table TPL	3	KEY_EXT1	Client	nvarchar	3
104	YIT_R1WOR	IDA: Reference Table WOR	3	KEY_EXT1	Client	nvarchar	3
105	YIT_R1__1	IDA: Reference Table __1 Org. Units	3	KEY_EXT1	Client	nvarchar	3
106	YIT_R1__2	IDA: Reference Table __2 Application Customizing	3	KEY_EXT1	Client	nvarchar	3

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

106 columns | ERP 6.0 | KEY_EXT1