	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

183 columns | B1 9.3 | OCRCODE2

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPAdministration
1	AEXD	Freight Setup	27	OcrCode2	Distribution Rule 2	nVarChar	8	0
2	OEXD	Freight Setup	27	OcrCode2	Distr. Rule2	nVarChar	8	0
TOPBanking
3	ARC2	Incoming Payment - Invoices - History	53	OcrCode2	Distribution Rule2	nVarChar	8	0
4	ARC4	Incoming Payment - Account List - History	24	OcrCode2	Distribution Rule2	nVarChar	8	0
5	ODPS	Deposit	55	OcrCode2	Distribution Rule 2	nVarChar	8	0
6	ODPT	Postdated Deposit	30	OcrCode2	Distribution Rule 2	nVarChar	8	0
7	PDF2	Payment Draft - Invoices	53	OcrCode2	Distribution Rule2	nVarChar	8	0
8	PDF4	Payment Draft - Account List	24	OcrCode2	Distribution Rule2	nVarChar	8	0
9	PWZ3	Payment Wizard - Rows 3	69	OcrCode2	Distribution Rule2	nVarChar	8	0
10	RCC4	Incoming Payment - Credit Vouchers	24	OcrCode2	Distribution Rule2	nVarChar	8	0
11	RCT2	Incoming Payments - Invoices	53	OcrCode2	Distribution Rule 2	nVarChar	8	0
12	RCT4	Incoming Payment - Account List	24	OcrCode2	Distribution Rule2	nVarChar	8	0
13	VPM2	Outgoing Payments - Invoices	53	OcrCode2	Distribution Rule2	nVarChar	8	0
14	VPM4	Outgoing Payments - Accounts	24	OcrCode2	Distribution Rule2	nVarChar	8	0
TOPFinance
15	ACD1	Credit Memo - Rows	19	OcrCode2	Distribution Rule 2	nVarChar	8	0
16	ACQ1	Capitalization - Rows	19	OcrCode2	Distribution Rule 2	nVarChar	8	0
17	AFA1	Asset Document - Rows	19	OcrCode2	Distribution Rule 2	nVarChar	8	0
18	AJD1	Journal Entry - History - Rows	80	OcrCode2	Costing Code 2	nVarChar	8	0
19	BTF1	Journal Voucher - Rows	80	OcrCode2	Costing Code 2	nVarChar	8	0
20	FTR1	Transfer - Rows	19	OcrCode2	Distribution Rule 2	nVarChar	8	0
21	JDT1	Journal Entry - Rows	80	OcrCode2	Costing Code 2	nVarChar	8	0
22	MDP1	Manual Depreciation - Rows	19	OcrCode2	Distribution Rule 2	nVarChar	8	0
23	OBGS	Budget Scenario	12	OcrCode2	Dimension 2	nVarChar	8	0
24	OCFL	Cash Flow Additional Trans.	15	OcrCode2	Distribution Rule 2	nVarChar	8	0
25	RCR1	Recurring Postings - Rows	20	OcrCode2	Costing Code 2	nVarChar	8	0
26	RTI1	Retirement - Rows	19	OcrCode2	Distribution Rule 2	nVarChar	8	0
27	TRT1	Posting Templates - Rows	18	OcrCode2	Costing Code 2	nVarChar	8	0
TOPInventory and Production
28	AIN1	Inventory Counting - Rows	28	OcrCode2	Distribution Rule 2	nVarChar	8	0
29	AIT6	Asset Item Distribution Rules	6	OcrCode2	Costing Code 2	nVarChar	8	0
30	AITT	Product Tree - History	18	OcrCode2	Distribution Rule2	nVarChar	8	0
31	AMR1	Inventory Revaluation - History - Rows	19	OcrCode2	Distribution Rule2	nVarChar	8	0
32	AQI1	Inventory Opening Balance - Rows	18	OcrCode2	Distribution Rule 2	nVarChar	8	0
33	AQR1	Inventory Posting - Rows	18	OcrCode2	Distribution Rule 2	nVarChar	8	0
34	ATT1	Bill of Materials - Components - History	18	OcrCode2	Distribution Rule2	nVarChar	8	0
35	AWO1	Production Order (Rows) - History	13	OcrCode2	Distribution Rule2	nVarChar	8	0
36	AWOR	Production Order - History	29	OcrCode2	Distribution Rule2	nVarChar	8	0
37	ICD1	Inventory Counting Draft - Rows	28	OcrCode2	Distribution Rule 2	nVarChar	8	0
38	IGE1	Goods Issue - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
39	IGE13	Goods Issue Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
40	IGE2	Goods Issue - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
41	IGE3	Goods Issue - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
42	IGN1	Goods Receipt - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
43	IGN13	Goods Receipt Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
44	IGN2	Goods Receipt - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
45	IGN3	Goods Receipt - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
46	INC1	Inventory Counting - Rows	28	OcrCode2	Distribution Rule 2	nVarChar	8	0
47	IOD1	Inventory Opening Balance Draft - Rows	18	OcrCode2	Distribution Rule 2	nVarChar	8	0
48	IPD1	Inventory Posting Draft - Rows	18	OcrCode2	Distribution Rule 2	nVarChar	8	0
49	IPF1	Landed Costs - Rows	69	OcrCode2	Distribution Rule 2	nVarChar	8	0
50	IQI1	Inventory Opening Balance - Rows	18	OcrCode2	Distribution Rule2	nVarChar	8	0
51	IQR1	Inventory Posting - Rows	18	OcrCode2	Distribution Rule2	nVarChar	8	0
52	ITM6	Asset Item Distribution Rules	6	OcrCode2	Costing Code 2	nVarChar	8	0
53	ITT1	Bill of Materials - Components	18	OcrCode2	Distribution Rule2	nVarChar	8	0
54	MRV1	Inventory Revaluation Information Array	19	OcrCode2	Distribution Rule2	nVarChar	8	0
55	OAIM	Archive Inventory Message	26	OcrCode2	Distribution Rule2	nVarChar	8	0
56	OILM	Inventory Log Message	36	OcrCode2	Distribution Rule2	nVarChar	8	0
57	OITT	Product Tree	18	OcrCode2	Distribution Rule2	nVarChar	8	0
58	OWOR	Production Order	29	OcrCode2	Distribution Rule2	nVarChar	8	0
59	UILM	IVI Inventory Log Message	36	OcrCode2	Distribution Rule2	nVarChar	8	0
60	UWOR	Production Order	29	OcrCode2	Distribution Rule2	nVarChar	8	0
61	UWOR1	Production Order - Rows	13	OcrCode2	Distribution Rule2	nVarChar	8	0
62	WOR1	Production Order - Rows	13	OcrCode2	Distribution Rule2	nVarChar	8	0
63	WTQ1	Inventory Transfer Request - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
64	WTQ13	Inventory Transfer Request Rows - Distributed Freights	55	OcrCode2	Distribution Rule 2	nVarChar	8	0
65	WTQ2	Inventory Transfer Request - Freight - Rows	47	OcrCode2	Distribution Rule 2	nVarChar	8	0
66	WTQ3	Inventory Transfer Request - Freight	55	OcrCode2	Distribution Rule 2	nVarChar	8	0
67	WTR1	Inventory Transfer - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
68	WTR13	Inventory Transfer Rows - Distributed Freights	55	OcrCode2	Distribution Rule2	nVarChar	8	0
69	WTR2	Inventory Transfer - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
70	WTR3	Inventory Transfer - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
TOPMarketing Documents
71	ADO1	A/R Invoice (Rows) - History	183	OcrCode2	Costing Code 2	nVarChar	8	0
72	ADO13	A/R Invoice Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
73	ADO2	A/R Invoice - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
74	ADO3	A/R Invoice - Freight - History	55	OcrCode2	Distribution Rule2	nVarChar	8	0
75	CIN1	Correction Invoice - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
76	CIN13	Correction Invoice Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
77	CIN2	A/R Correction Invoice - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
78	CIN3	A/R Correction Invoice - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
79	CPI1	A/P Correction Invoice - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
80	CPI13	A/P Correction Invoice Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
81	CPI2	A/P Correction Invoice - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
82	CPI3	A/P Correction Invoice - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
83	CPV1	A/P Correction Invoice Reversal - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
84	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
85	CPV2	A/P Correction Invoice Reversal - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
86	CPV3	A/P Correction Invoice Reversal - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
87	CSI1	A/R Correction Invoice - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
88	CSI13	A/R Correction Invoice Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
89	CSI2	A/R Corr Inv - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
90	CSI3	A/R Correction Invoice - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
91	CSV1	A/R Correction Invoice Reversal - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
92	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
93	CSV2	A/R Correction Invoice Reversal - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
94	CSV3	A/R Correction Invoice Reversal - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
95	DLN1	Delivery - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
96	DLN13	Delivery Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
97	DLN2	Delivery Notes - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
98	DLN3	Delivery Notes - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
99	DPI1	A/R Down Payment - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
100	DPI13	A/R Down Payment Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
101	DPI2	A/R Down Payment - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
102	DPI3	A/R Down Payment - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
103	DPO1	A/P Down Payment - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
104	DPO13	A/P Down Payment Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
105	DPO2	A/P Down Payment - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
106	DPO3	A/P Down Payment - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
107	DRF1	Draft - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
108	DRF13	Draft Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
109	DRF2	Draft - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
110	DRF3	Draft - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
111	IEI1	Incoming Excise Invoice - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
112	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
113	IEI2	Incoming Excise Invoice - Freight - History - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
114	IEI3	IEI - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
115	INV1	A/R Invoice - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
116	INV13	A/R Invoice Rows - Distributed Freights	55	OcrCode2	Distribution Rule2	nVarChar	8	0
117	INV2	A/R Invoice - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
118	INV3	A/R Invoice - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
119	ODWZ	Dunning Wizard	26	OcrCode2	Costing Code 2	nVarChar	8	0
120	OEI1	Outgoing Excise Invoice - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
121	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
122	OEI2	OEI - Freight Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
123	OEI3	OEI - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
124	PCH1	A/P Invoice - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
125	PCH13	A/P Invoice Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
126	PCH2	A/P Invoice - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
127	PCH3	A/P Invoice - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
128	PDN1	Goods Receipt PO - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
129	PDN13	Goods Receipt PO Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
130	PDN2	Goods Receipt PO - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
131	PDN3	Goods Receipt PO - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
132	POR1	Purchase Order - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
133	POR13	Purchase Order Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
134	POR2	Purchase Order - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
135	POR3	Purchase Order - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
136	PQT1	Purchase Quotation - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
137	PQT13	Purchase Quotation Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
138	PQT2	Purchase Quotation - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
139	PQT3	Purchase Quotation - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
140	PRQ1	Purchase Request - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
141	PRQ13	Purchase Request Rows - Distributed Expenses	55	OcrCode2	Distribution Rule 2	nVarChar	8	0
142	PRQ2	Purchase Request - Freight - Rows	47	OcrCode2	Distribution Rule 2	nVarChar	8	0
143	PRQ3	Purchase Request - Freight	55	OcrCode2	Distribution Rule 2	nVarChar	8	0
144	PRR1	A/P Return Request - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
145	PRR13	A/P Return Request - Distributed Freights	55	OcrCode2	Distribution Rule2	nVarChar	8	0
146	PRR2	A/P Return Request - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
147	PRR3	A/P Return Request - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
148	QUT1	Sales Quotation - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
149	QUT13	Sales Quotation Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
150	QUT2	Sales Quotation - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
151	QUT3	Sales Quotation - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
152	RDN1	Returns - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
153	RDN13	Returns Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
154	RDN2	Return - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
155	RDN3	Return - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
156	RDR1	Sales Order - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
157	RDR13	Sales Order Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
158	RDR2	Sales Order - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
159	RDR3	Sales Order - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
160	RIN1	A/R Credit Memo - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
161	RIN13	A/R Credit Memo Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
162	RIN2	A/R Credit Memo - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
163	RIN3	A/R Credit Memo - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
164	RPC1	A/P Credit Memo - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
165	RPC13	A/P Credit Memo Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
166	RPC2	A/P Credit Memo Rows - Expenses	47	OcrCode2	Distribution Rule2	nVarChar	8	0
167	RPC3	A/P Credit Memo - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
168	RPD1	Goods Return - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
169	RPD13	Goods Returns Rows - Distributed Expenses	55	OcrCode2	Distribution Rule2	nVarChar	8	0
170	RPD2	Goods Return - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
171	RPD3	Goods Return - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
172	RRR1	A/R Return Request - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
173	RRR13	A/R Return Request - Distributed Freights	55	OcrCode2	Distribution Rule2	nVarChar	8	0
174	RRR2	A/R Return Request - Freight - Rows	47	OcrCode2	Distribution Rule2	nVarChar	8	0
175	RRR3	A/R Return Request - Freight	55	OcrCode2	Distribution Rule2	nVarChar	8	0
176	SFC1	Self Credit Memo - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
177	SFC13	Self Credit Memo Rows - Distributed Freights	55	OcrCode2	Distribution Rule 2	nVarChar	8	0
178	SFC2	Self Credit Memo - Freight - Rows	47	OcrCode2	Distribution Rule 2	nVarChar	8	0
179	SFC3	Self Credit Memo - Freight	55	OcrCode2	Distribution Rule 2	nVarChar	8	0
180	SFI1	Self Invoice - Rows	183	OcrCode2	Costing Code 2	nVarChar	8	0
181	SFI13	Self Invoice Rows - Distributed Freights	55	OcrCode2	Distribution Rule 2	nVarChar	8	0
182	SFI2	Self Invoice - Freight - Rows	47	OcrCode2	Distribution Rule 2	nVarChar	8	0
183	SFI3	Self Invoice - Freight	55	OcrCode2	Distribution Rule 2	nVarChar	8	0

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

183 columns | B1 9.3 | OCRCODE2