	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

	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

	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

58 columns | ERP 6.0 | KEY_EXT3

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length
1	YIT_INFOBASE_XD	IDES Infobase: Application Data Assignments	6	KEY_EXT3	Infobase Key Field for Data Assignment	nvarchar	25
2	YIT_INITIAL	Infobase: Initialtabelle für Views	3	KEY_EXT3	Infobase: Platzhalter Key	nvarchar	1
3	YIT_O1ACC	IDA: Original Table ACC	3	KEY_EXT3	G/L Account Number	nvarchar	10
4	YIT_O1ASS	IDA: Original Table ASS	3	KEY_EXT3	Main Asset Number	nvarchar	12
5	YIT_O1BNK	IDA: Original Table BNK	3	KEY_EXT3	Bank Keys	nvarchar	15
6	YIT_O1BOM	IDA: Original Table BOM	3	KEY_EXT3	Material Number	nvarchar	18
7	YIT_O1COE	IDA: Original Table COE	3	KEY_EXT3	IDA: Cost element, analogous to KSTAR	nvarchar	10
8	YIT_O1COS	IDA: Original Table COS	3	KEY_EXT3	Cost Center	nvarchar	10
9	YIT_O1DOC	IDA: Original Table DOC	3	KEY_EXT3	Document number	nvarchar	25
10	YIT_O1OBJ	IDA: Original Table OBJ	3	KEY_EXT3	Object Type	nvarchar	2
11	YIT_O1ORD	IDA: Original Table ORD	3	KEY_EXT3	Order category	nvarchar	2
12	YIT_O1PRC	IDA: Original Table COS	3	KEY_EXT3	IDA: Datum valid to, analogous to DATBI	nvarchar	8
13	YIT_O1ROU	IDA: Original Table ROU	3	KEY_EXT3	Key for Task List Group	nvarchar	8
14	YIT_O1WOR	IDA: Original Table WOR	3	KEY_EXT3	Work center	nvarchar	8
15	YIT_O1__1	IDA: Original Table __1 Org. Units	3	KEY_EXT3	Key organizational unit	nvarchar	15
16	YIT_O1__2	IDA: Original Table __2 Application Customizing	3	KEY_EXT3	Organizational Unit	nvarchar	4
17	YIT_O2ACC	IDA: Original Table ACC	3	KEY_EXT3	G/L Account Number	nvarchar	10
18	YIT_O2ASS	IDA: Original Table ASS	3	KEY_EXT3	Main Asset Number	nvarchar	12
19	YIT_O2BNK	IDA: Original Table BNK	3	KEY_EXT3	Bank Keys	nvarchar	15
20	YIT_O2BOM	IDA: Original Table BOM	3	KEY_EXT3	Material Number	nvarchar	18
21	YIT_O2COE	IDA: Original Table COE	3	KEY_EXT3	IDA: Cost element, analogous to KSTAR	nvarchar	10
22	YIT_O2COS	IDA: Original Table COS	3	KEY_EXT3	Cost Center	nvarchar	10
23	YIT_O2DOC	IDA: Original Table DOC	3	KEY_EXT3	Document number	nvarchar	25
24	YIT_O2OBJ	IDA: Original Table OBJ	3	KEY_EXT3	Object Type	nvarchar	2
25	YIT_O2ORD	IDA: Original Table ORD	3	KEY_EXT3	Order category	nvarchar	2
26	YIT_O2PRC	IDA: Original Table PRC	3	KEY_EXT3	IDA: Datum valid to, analogous to DATBI	nvarchar	8
27	YIT_O2ROU	IDA: Original Table ROU	3	KEY_EXT3	Key for Task List Group	nvarchar	8
28	YIT_O2WOR	IDA: Original Table WOR	3	KEY_EXT3	Work center	nvarchar	8
29	YIT_O2__1	IDA: Original Table __1 Org. Units	3	KEY_EXT3	Key organizational unit	nvarchar	15
30	YIT_O2__2	IDA: Original Table __2 Application Customizing	3	KEY_EXT3	Organizational Unit	nvarchar	4
31	YIT_O3ACC	IDA: Original Table ACC	4	KEY_EXT3	G/L Account Number	nvarchar	10
32	YIT_O3ASS	IDA: Original Table ASS	3	KEY_EXT3	Main Asset Number	nvarchar	12
33	YIT_O3BNK	IDA: Original Table BNK	3	KEY_EXT3	Bank Keys	nvarchar	15
34	YIT_O3BOM	IDA: Original Table BOM	4	KEY_EXT3	Material Number	nvarchar	18
35	YIT_O3COE	IDA: Original Table COE	4	KEY_EXT3	IDA: Cost element, analogous to KSTAR	nvarchar	10
36	YIT_O3COS	IDA: Original Table COS	4	KEY_EXT3	Cost Center	nvarchar	10
37	YIT_O3DOC	IDA: Original Table DOC	4	KEY_EXT3	Document number	nvarchar	25
38	YIT_O3OBJ	IDA: Original Table OBJ	4	KEY_EXT3	Object Type	nvarchar	2
39	YIT_O3ORD	IDA: Original Table ORD	3	KEY_EXT3	Order category	nvarchar	2
40	YIT_O3PRC	IDA: Original Table COS	4	KEY_EXT3	IDA: Datum valid to, analogous to DATBI	nvarchar	8
41	YIT_O3ROU	IDA: Original Table ROU	3	KEY_EXT3	Key for Task List Group	nvarchar	8
42	YIT_O3WOR	IDA: Original Table WOR	4	KEY_EXT3	Work center	nvarchar	8
43	YIT_O3__1	IDA: Original Table __1 Org. Units	4	KEY_EXT3	Key organizational unit	nvarchar	15
44	YIT_O3__2	IDA: Original Table __2 Application Customizing	4	KEY_EXT3	Organizational Unit	nvarchar	4
45	YIT_R1ACC	IDA: Reference Table ACC	5	KEY_EXT3	G/L Account Number	nvarchar	10
46	YIT_R1ASS	IDA: Reference Table ASS	5	KEY_EXT3	Main Asset Number	nvarchar	12
47	YIT_R1BNK	IDA: Reference Table BNK	5	KEY_EXT3	Bank Keys	nvarchar	15
48	YIT_R1BOM	IDA: Reference Table BOM	5	KEY_EXT3	Material Number	nvarchar	18
49	YIT_R1COE	IDA: Reference Table COE	5	KEY_EXT3	IDA: Cost element, analogous to KSTAR	nvarchar	10
50	YIT_R1COS	IDA: Reference Table COS	5	KEY_EXT3	Cost Center	nvarchar	10
51	YIT_R1DOC	IDA: Reference Table DOC	5	KEY_EXT3	Document number	nvarchar	25
52	YIT_R1OBJ	IDA: Reference table OBJ	5	KEY_EXT3	Object Type	nvarchar	2
53	YIT_R1ORD	IDA: Reference table ORD	5	KEY_EXT3	Order category	nvarchar	2
54	YIT_R1PRC	IDA: Reference Table COS	5	KEY_EXT3	IDA: Datum valid to, analogous to DATBI	nvarchar	8
55	YIT_R1ROU	IDA: Reference table ROU	5	KEY_EXT3	Key for Task List Group	nvarchar	8
56	YIT_R1WOR	IDA: Reference Table WOR	5	KEY_EXT3	Work center	nvarchar	8
57	YIT_R1__1	IDA: Reference Table __1 Org. Units	5	KEY_EXT3	Key organizational unit	nvarchar	15
58	YIT_R1__2	IDA: Reference Table __2 Application Customizing	5	KEY_EXT3	Organizational Unit	nvarchar	4

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

58 columns | ERP 6.0 | KEY_EXT3