	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

206 columns | B1 8.82 | STATUS

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals	Default Value	Constraints
TOPAdministration
1	ALR1	Queue of messages to be sent	8	Status	Status	VarChar	1	0	U	P=In Process, S=Sent, U=Not Sent
2	ODAB	Dashboard	7	Status	Dashboard Status	VarChar	1	0	A	A=Active, I=Inactive
3	ORLD	Reference Links Definition	4	Status	Status	VarChar	1	0	O
4	USR1	Short Cut	1	STATUS	Status	VarChar	1	0
TOPBanking
5	ARCT	Incoming Payment - History	84	Status	Created by Payment Wizard	VarChar	1	0	N
6	CHO2	Checks for Payment - Print Status	3	Status	Status	VarChar	1	0	N	D=Details, N=Not Confirmed, O=Overflow, T=Not Printed, V=Void
7	OBNH	Bank Statement Header	5	Status	Status	VarChar	1	0	D
8	OPDF	Payment Draft	84	Status	Created by Payment Run	VarChar	1	0	N
9	OPEX	Payment Results Table	40	Status	Status	VarChar	1	0	O
10	OPWZ	Payment Wizard	20	Status	Object Status	VarChar	1	0	S
11	ORCT	Incoming Payment	84	Status	Created by Payment Run	VarChar	1	0	N
12	OVPM	Outgoing Payments	84	Status	Created by Payment Run	VarChar	1	0	N
13	PWZ3	Payment Wizard - Rows 3	56	Status	Inv Status	VarChar	1	0
TOPBusiness Partners
14	ACP1	Campaign - BPs	7	Status	BP Status	VarChar	1	0
15	ACPN	Campaign	6	Status	Campaign Status	VarChar	1	0	O
16	AOAT	Blanket Agreement	10	Status	Agreement Status	VarChar	1	0	D
17	CPN1	Campaign - BPs	7	Status	BP Status	VarChar	1	0
18	OCLG	Activities	42	status	Status	Int	11	0
19	OCPN	Campaign	6	Status	Campaign Status	VarChar	1	0	O
20	OOAT	Blanket Agreement	10	Status	Agreement Status	VarChar	1	0	D
TOPFinance
21	AJD2	Withholding Tax - History	24	Status	Status	VarChar	1	0	O
22	BTF2	Journal Voucher Withholding Tax - History	24	Status	Status	VarChar	1	0	O
23	JDT2	Withholding Tax - History	24	Status	Status	VarChar	1	0	O
24	OBTD	Journal Vouchers List	2	Status	Open/Closed Document	VarChar	1	0	O	C=Closed, O=Open
25	OCFT	Cash Flow Transactions - Rows	20	Status	Status	VarChar	1	0
26	OSCM	Special Ledger - Analytical Accounting Configuration Rules: Material	4	Status	Rule Status	VarChar	1	0
27	OSCR	Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses	4	Status	Rule Status	VarChar	1	0
28	OSLM	Special Ledger - Analytical Accounting Report: Material	5	Status	Document Status	VarChar	1	0
29	OSLR	Special Ledger - Analytical Accounting Report: Revenues & Expenses	5	Status	Document Status	VarChar	1	0
30	SLM1	Special Ledger - Analytical Accounting Report Lines: Material	9	Status	Status	VarChar	1	0
31	SLR1	Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses	9	Status	Status	VarChar	1	0
TOPHuman Resources
32	AHEM	Employees	28	status	Status	Int	11	0
33	HET1	Employee Transfer Details	4	Status	Processing Status	VarChar	1	0	N	A=Accepted, E=Error, N=New, S=Sent
34	OHEM	Employees	28	status	Status	Int	11	0
35	OHET	Object: HR Employee Transfer	4	Status	Processing Status	VarChar	1	0	N	A=Accepted, E=Error, N=New, P=Processing, R=Received, S=Sent
TOPInventory and Production
36	ABTN	Batch Numbers Master Data	13	Status	Status	VarChar	1	0	0
37	APKL	Pick List - History	9	Status	Status	VarChar	1	0	R	C=Closed, D=Partially Delivered, P=Partially Picked, R=Released, Y=Picked
38	ASRN	Serial Numbers Master Data	13	Status	Status	VarChar	1	0
39	AWOR	Production Order - History	5	Status	Production Order Status	VarChar	1	0	P
40	IGE13	Goods Issue Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
41	IGE2	Goods Issue - Freight - Rows	41	Status	Status	VarChar	1	0	O
42	IGE3	Goods Issue - Freight	45	Status	Status	VarChar	1	0	O
43	IGE5	Goods Issue - Withholding Tax	24	Status	Status	VarChar	1	0	O
44	IGE6	Goods Issue - Installments	6	Status	Installment Status	VarChar	1	0	O
45	IGN13	Goods Receipt Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
46	IGN2	Goods Receipt - Freight - Rows	41	Status	Status	VarChar	1	0	O
47	IGN3	Goods Receipt - Freight	45	Status	Status	VarChar	1	0	O
48	IGN5	Goods Receipt - Withholding Tax	24	Status	Status	VarChar	1	0	O
49	IGN6	Goods Receipt- Installments	6	Status	Installment Status	VarChar	1	0	O
50	OBTN	Batch Numbers Master Data	13	Status	Status	VarChar	1	0	0
51	ODBN	Bat. Nos - Draft - Master Data	13	Status	Status	VarChar	1	0	0
52	ODSN	SNs - Draft - Master Data	13	Status	Status	VarChar	1	0
53	OIBT	Batch No. for Item	20	Status	Status	VarChar	1	0	0	0=Released, 1=Not Accessible, 2=Locked
54	OISL	Simulation Log File	10	Status	Status	VarChar	1	0		F=Failed, R=Running, S=Successful
55	OPKL	Pick List	9	Status	Status	VarChar	1	0	R	C=Closed, D=Partially Delivered, P=Partially Picked, R=Released, Y=Picked
56	OSRI	Serial Numbers for Items	23	Status	Status	VarChar	1	0	0	0=Available, 1=Unavailable
57	OSRN	Serial Numbers Master Data	13	Status	Status	VarChar	1	0
58	OWKO	Production Instructions	2	Status	Processing Status	VarChar	1	0	O	E=Production Completed, I=Work Instructions, O=Work Instructions
59	OWOR	Production Order	5	Status	Production Order Status	VarChar	1	0	P
60	UWKO	Production Instructions	2	Status	Processing Status	VarChar	1	0	O	E=Production Completed, I=Work Instructions, O=Work Instructions
61	UWOR	Production Order	5	Status	Production Order Status	VarChar	1	0	P
62	WTQ13	Inventory Transfer Request Rows - Distributed Freights	47	Status	Status	VarChar	1	0	O
63	WTQ2	Inventory Transfer Request - Freight - Rows	41	Status	Status	VarChar	1	0	O
64	WTQ3	Inventory Transfer Request - Freight	45	Status	Status	VarChar	1	0	O
65	WTQ5	Inventory Transfer Request - Withholding Tax	24	Status	Status	VarChar	1	0	O
66	WTQ6	Inventory Transfer Request - Installments	6	Status	Installment Status	VarChar	1	0	O
67	WTR13	Inventory Transfer Rows - Distributed Freights	47	Status	Status	VarChar	1	0	O
68	WTR2	Inventory Transfer - Freight - Rows	41	Status	Status	VarChar	1	0	O
69	WTR3	Inventory Transfer - Freight	45	Status	Status	VarChar	1	0	O
70	WTR5	Inventory Transfer - Withholding Tax	24	Status	Status	VarChar	1	0	O
71	WTR6	Inventory Transfer - Installments	6	Status	Installment Status	VarChar	1	0	O
TOPMarketing Documents
72	ADO13	A/R Invoice Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
73	ADO2	A/R Invoice - Freight - Rows	41	Status	Status	VarChar	1	0	O
74	ADO3	A/R Invoice - Freight - History	45	Status	Status	VarChar	1	0	O
75	ADO5	Withholding Tax - History	24	Status	Status	VarChar	1	0	O
76	ADO6	Documents History - Installments	6	Status	Installment Status	VarChar	1	0	O
77	CIN13	Correction Invoice Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
78	CIN2	A/R Correction Invoice - Freight - Rows	41	Status	Status	VarChar	1	0	O
79	CIN3	A/R Correction Invoice - Freight	45	Status	Status	VarChar	1	0	O
80	CIN5	AR Correction Invoice - Withholding Tax	24	Status	Status	VarChar	1	0	O
81	CIN6	Correction Invoice - Installments	6	Status	Installment Status	VarChar	1	0	O
82	CPI13	A/P Correction Invoice Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
83	CPI2	A/P Correction Invoice - Freight - Rows	41	Status	Status	VarChar	1	0	O
84	CPI3	A/P Correction Invoice - Freight	45	Status	Status	VarChar	1	0	O
85	CPI5	Withholding Tax Data	24	Status	Status	VarChar	1	0	O
86	CPI6	Documents History - Installments	6	Status	Installment Status	VarChar	1	0	O
87	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
88	CPV2	A/P Correction Invoice Reversal - Freight - Rows	41	Status	Status	VarChar	1	0	O
89	CPV3	A/P Correction Invoice Reversal - Freight	45	Status	Status	VarChar	1	0	O
90	CPV5	A/P Correction Invoice Reversal - WTax	24	Status	Status	VarChar	1	0	O
91	CPV6	A/P Correction Invoice Reversal - Installments	6	Status	Installment Status	VarChar	1	0	O
92	CSI13	A/R Correction Invoice Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
93	CSI2	A/R Corr Inv - Freight - Rows	41	Status	Status	VarChar	1	0	O
94	CSI3	A/R Correction Invoice - Freight	45	Status	Status	VarChar	1	0	O
95	CSI5	A/R Correction Invoice - Withholding Tax	24	Status	Status	VarChar	1	0	O
96	CSI6	A/R Corr. Inv. - Installments	6	Status	Installment Status	VarChar	1	0	O
97	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
98	CSV2	A/R Correction Invoice Reversal - Freight - Rows	41	Status	Status	VarChar	1	0	O
99	CSV3	A/R Correction Invoice Reversal - Freight	45	Status	Status	VarChar	1	0	O
100	CSV5	A/R Correction Invoice Reversal - WTax	24	Status	Status	VarChar	1	0	O
101	CSV6	A/R Correction Invoice Reversal - Installments	6	Status	Installment Status	VarChar	1	0	O
102	DLN13	Delivery Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
103	DLN2	Delivery Notes - Freight - Rows	41	Status	Status	VarChar	1	0	O
104	DLN3	Delivery Notes - Freight	45	Status	Status	VarChar	1	0	O
105	DLN5	Delivery - Withholding Tax	24	Status	Status	VarChar	1	0	O
106	DLN6	Delivery - Installments	6	Status	Installment Status	VarChar	1	0	O
107	DPI13	A/R Down Payment Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
108	DPI2	A/R Down Payment - Freight - Rows	41	Status	Status	VarChar	1	0	O
109	DPI3	A/R Down Payment - Freight	45	Status	Status	VarChar	1	0	O
110	DPI5	A/R Down Payment - Withholding Tax	24	Status	Status	VarChar	1	0	O
111	DPI6	A/R Down Payment - Installments	6	Status	Installment Status	VarChar	1	0	O
112	DPO13	A/P Down Payment Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
113	DPO2	A/P Down Payment - Freight - Rows	41	Status	Status	VarChar	1	0	O
114	DPO3	A/P Down Payment - Freight	45	Status	Status	VarChar	1	0	O
115	DPO5	A/P Down Payment - Withholding Tax	24	Status	Status	VarChar	1	0	O
116	DPO6	Down Payment Out - Installments	6	Status	Installment Status	VarChar	1	0	O
117	DRF13	Draft Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
118	DRF2	Draft - Freight - Rows	41	Status	Status	VarChar	1	0	O
119	DRF3	Draft - Freight	45	Status	Status	VarChar	1	0	O
120	DRF5	Draft Documents - Withholding Tax	24	Status	Status	VarChar	1	0	O
121	DRF6	Document Drafts - Installments	6	Status	Installment Status	VarChar	1	0	O
122	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
123	IEI2	Incoming Excise Invoice - Freight - History - Rows	41	Status	Status	VarChar	1	0	O
124	IEI3	IEI - Freight	45	Status	Status	VarChar	1	0	O
125	IEI5	Incoming Excise Invoice - Withholding Tax	24	Status	Status	VarChar	1	0	O
126	IEI6	IEI - Installments	6	Status	Installment Status	VarChar	1	0	O
127	INV13	A/R Invoice Rows - Distributed Freights	47	Status	Status	VarChar	1	0	O
128	INV2	A/R Invoice - Freight - Rows	41	Status	Status	VarChar	1	0	O
129	INV3	A/R Invoice - Freight	45	Status	Status	VarChar	1	0	O
130	INV5	A/R Invoice - Withholding Tax	24	Status	Status	VarChar	1	0	O
131	INV6	A/R Invoice - Installments	6	Status	Installment Status	VarChar	1	0	O
132	ODWZ	Dunning Wizard	5	Status	Wizard Status	VarChar	1	0	S
133	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
134	OEI2	OEI - Freight Rows	41	Status	Status	VarChar	1	0	O
135	OEI3	OEI - Freight	45	Status	Status	VarChar	1	0	O
136	OEI5	Outgoing Excise Invoice - Withholding Tax	24	Status	Status	VarChar	1	0	O
137	OEI6	Outgoing Excise Invoice - Installments	6	Status	Installment Status	VarChar	1	0	O
138	ORCL	Recurring Transaction Instances	5	Status	Recurrence Status	VarChar	1	0	N	E=Executed, N=Not Executed, R=Removed
139	OWDD	Docs. for Confirmation	8	Status	Status	VarChar	1	0	W
140	PCH13	A/P Invoice Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
141	PCH2	A/P Invoice - Freight - Rows	41	Status	Status	VarChar	1	0	O
142	PCH3	A/P Invoice - Freight	45	Status	Status	VarChar	1	0	O
143	PCH5	A/P Invoice - Withholding Tax Data	24	Status	Status	VarChar	1	0	O
144	PCH6	A/P Invoice - Installments	6	Status	Installment Status	VarChar	1	0	O
145	PDN13	Goods Receipt PO Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
146	PDN2	Goods Receipt PO - Freight - Rows	41	Status	Status	VarChar	1	0	O
147	PDN3	Goods Receipt PO - Freight	45	Status	Status	VarChar	1	0	O
148	PDN5	Goods Reciept PO - Withholding Tax	24	Status	Status	VarChar	1	0	O
149	PDN6	Goods Receipt PO - Installments	6	Status	Installment Status	VarChar	1	0	O
150	POR13	Purchase Order Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
151	POR2	Purchase Order - Freight - Rows	41	Status	Status	VarChar	1	0	O
152	POR3	Purchase Order - Freight	45	Status	Status	VarChar	1	0	O
153	POR5	Purchase Order - Withholding Tax	24	Status	Status	VarChar	1	0	O
154	POR6	Purchase Order - Installments	6	Status	Installment Status	VarChar	1	0	O
155	PQT13	Purchase Quotation Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
156	PQT2	Purchase Quotation - Freight - Rows	41	Status	Status	VarChar	1	0	O
157	PQT3	Purchase Quotation - Freight	45	Status	Status	VarChar	1	0	O
158	PQT5	Purchase Quotation - Withholding Tax	24	Status	Status	VarChar	1	0	O
159	PQT6	Purchase Quotation - Installments	6	Status	Installment Status	VarChar	1	0	O
160	QUT13	Sales Quotation Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
161	QUT2	Sales Quotation - Freight - Rows	41	Status	Status	VarChar	1	0	O
162	QUT3	Sales Quotation - Freight	45	Status	Status	VarChar	1	0	O
163	QUT5	Sales Quotation - Tax	24	Status	Status	VarChar	1	0	O
164	QUT6	Sales Quotation - Installments	6	Status	Installment Status	VarChar	1	0	O
165	RDN13	Returns Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
166	RDN2	Return - Freight - Rows	41	Status	Status	VarChar	1	0	O
167	RDN3	Return - Freight	45	Status	Status	VarChar	1	0	O
168	RDN5	Returns - Withholding Tax	24	Status	Status	VarChar	1	0	O
169	RDN6	Returns - Installments	6	Status	Installment Status	VarChar	1	0	O
170	RDR13	Sales Order Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
171	RDR2	Sales Order - Freight - Rows	41	Status	Status	VarChar	1	0	O
172	RDR3	Sales Order - Freight	45	Status	Status	VarChar	1	0	O
173	RDR5	Sales Order - Withholding Tax	24	Status	Status	VarChar	1	0	O
174	RDR6	Sales Order - Installments	6	Status	Installment Status	VarChar	1	0	O
175	RIN13	A/R Credit Memo Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
176	RIN2	A/R Credit Memo - Freight - Rows	41	Status	Status	VarChar	1	0	O
177	RIN3	A/R Credit Memo - Freight	45	Status	Status	VarChar	1	0	O
178	RIN5	A/R Credit Memo - Withholding Tax	24	Status	Status	VarChar	1	0	O
179	RIN6	A/R Credit Memo - Installments	6	Status	Installment Status	VarChar	1	0	O
180	RPC13	A/P Credit Memo Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
181	RPC2	A/P Credit Memo Rows - Expenses	41	Status	Status	VarChar	1	0	O
182	RPC3	A/P Credit Memo - Freight	45	Status	Status	VarChar	1	0	O
183	RPC5	A/P Credit Memo - Withholding Tax	24	Status	Status	VarChar	1	0	O
184	RPC6	A/P Credit Memo - Installments	6	Status	Installment Status	VarChar	1	0	O
185	RPD13	Goods Returns Rows - Distributed Expenses	47	Status	Status	VarChar	1	0	O
186	RPD2	Goods Return - Freight - Rows	41	Status	Status	VarChar	1	0	O
187	RPD3	Goods Return - Freight	45	Status	Status	VarChar	1	0	O
188	RPD5	Goods Return - Withholding Tax Data	24	Status	Status	VarChar	1	0	O
189	RPD6	Goods Return - Installments	6	Status	Installment Status	VarChar	1	0	O
190	WDD1	Documents for Approval - Authorizers	4	Status	Status	VarChar	1	0	W	N=Not Approved, W=Pending, Y=Approved
TOPMRP
191	ORCM	Recommendation Data	14	Status	Order Status	VarChar	1	0	O
TOPReports
192	OEJB	Wizard Run Details for ERV-JAb	8	Status	Status	VarChar	1	0	O	C=Closed, O=Open
193	OLLR	Electronic Report Generation Result	6	Status	Status	VarChar	1	0	C	C=Cancelled, E=Executed, F=Failed
194	RDOC	Document	56	Status	Status	VarChar	1	0	A
195	SRA2	Scheduled Report Run Output	4	Status	Status	VarChar	1	0	0
TOPSales Opportunities
196	OOPR	Sales Opportunity	21	Status	Status	VarChar	1	0	O	L=Lost, O=Open, W=Won
197	OPR1	Sales Opportunity - Rows	14	Status	Status	VarChar	1	0	O	C=Closed, O=Open
TOPService
198	AINS	Customer Equipment Card - History	43	status	Status	VarChar	1	0	A	A=Active, I=In Repair Lab, L=Loaned, R=Returned, T=Terminated
199	ASCL	History	18	status	Status	Int	6	0	-3
200	OCTR	Service Contracts	6	Status	Contract Status	VarChar	1	0	D	A=Approved, D=Draft, F=On Hold, T=Terminated
201	OINS	Customer Equipment Card	43	status	Status	VarChar	1	0	A	A=Active, I=In Repair Lab, L=Loaned, R=Returned, T=Terminated
202	OISR	Service Calls	10	Status	Call Status	VarChar	1	0	O	C=Closed, O=Open
203	OMDC	Master Data Cleanup	5	Status	Status	VarChar	1	0
204	OREQ	External System Call Request	3	Status	Request Status	VarChar	1	0	N	C=Comfirmed, F=Failed, N=New, P=In Process, S=Completed
205	OSCL	Service Calls	18	status	Status	Int	6	0	-3
206	REQ1	External System Call Request - Message List	6	Status	Message Status	VarChar	1	0	U	R=Read, U=Unread

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

206 columns | B1 8.82 | STATUS