	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

111 columns | ERP 6.0 | KEY_EXT2

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

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

111 columns | ERP 6.0 | KEY_EXT2