	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

190 columns | B1 9.3 | OCRCODE

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

190 columns | B1 9.3 | OCRCODE