	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

181 columns | B1 9.3 | BASEREF

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPFinance
1	AFAD	Asset Document - History	39	BaseRef	Base Reference	nVarChar	11	0
2	AJD1	Journal Entry - History - Rows	26	BaseRef	Base Reference	nVarChar	11	0
3	AJD2	Withholding Tax - History	23	BaseRef	Base Document Reference	Int	11	0
4	AJDT	Journal Entry - History	5	BaseRef	Origin No.	nVarChar	11	0
5	BTF1	Journal Voucher - Rows	26	BaseRef	Base Reference	nVarChar	11	0
6	BTF2	Journal Voucher Withholding Tax - History	23	BaseRef	Base Document Reference	Int	11	0
7	JDT1	Journal Entry - Rows	26	BaseRef	Base Reference	nVarChar	11	0
8	JDT2	Withholding Tax - History	23	BaseRef	Base Document Reference	Int	11	0
9	OACD	Credit Memo	39	BaseRef	Base Reference	nVarChar	11	0
10	OACQ	Capitalization	39	BaseRef	Base Reference	nVarChar	11	0
11	OBTF	Journal Voucher Entry	5	BaseRef	Origin No.	nVarChar	11	0
12	OCFT	Cash Flow Transactions - Rows	15	BaseRef	Base Reference	nVarChar	11	0
13	OFTR	Transfer	39	BaseRef	Base Reference	nVarChar	11	0
14	OJDT	Journal Entry	5	BaseRef	Origin No.	nVarChar	11	0
15	OMDP	Manual Depreciation	39	BaseRef	Base Reference	nVarChar	11	0
16	ORTI	Retirement	39	BaseRef	Base Reference	nVarChar	11	0
17	RTM1	Rate Differences - Rows	13	BaseRef	Base Reference	nVarChar	11	0
TOPInventory and Production
18	AQR1	Inventory Posting - Rows	33	BaseRef	Base Document Reference	nVarChar	16	0
19	IGE1	Goods Issue - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
20	IGE13	Goods Issue Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
21	IGE3	Goods Issue - Freight	42	BaseRef	Base Document Reference	Int	11	0
22	IGE5	Goods Issue - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
23	IGN1	Goods Receipt - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
24	IGN13	Goods Receipt Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
25	IGN3	Goods Receipt - Freight	42	BaseRef	Base Document Reference	Int	11	0
26	IGN5	Goods Receipt - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
27	IPD1	Inventory Posting Draft - Rows	33	BaseRef	Base Document Reference	nVarChar	16	0
28	IQR1	Inventory Posting - Rows	33	BaseRef	Base Document Reference	nVarChar	16	0
29	WTQ1	Inventory Transfer Request - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
30	WTQ13	Inventory Transfer Request Rows - Distributed Freights	42	BaseRef	Base Document Reference	Int	11	0
31	WTQ3	Inventory Transfer Request - Freight	42	BaseRef	Base Document Reference	Int	11	0
32	WTQ5	Inventory Transfer Request - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
33	WTR1	Inventory Transfer - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
34	WTR13	Inventory Transfer Rows - Distributed Freights	42	BaseRef	Base Document Reference	Int	11	0
35	WTR3	Inventory Transfer - Freight	42	BaseRef	Base Document Reference	Int	11	0
36	WTR5	Inventory Transfer - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
TOPMarketing Documents
37	ADO1	A/R Invoice (Rows) - History	5	BaseRef	Base Document Reference	nVarChar	16	0
38	ADO13	A/R Invoice Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
39	ADO20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
40	ADO3	A/R Invoice - Freight - History	42	BaseRef	Base Document Reference	Int	11	0
41	ADO5	Withholding Tax - History	23	BaseRef	Base Document Reference	Int	11	0
42	CIN1	Correction Invoice - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
43	CIN13	Correction Invoice Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
44	CIN20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
45	CIN3	A/R Correction Invoice - Freight	42	BaseRef	Base Document Reference	Int	11	0
46	CIN5	AR Correction Invoice - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
47	CPI1	A/P Correction Invoice - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
48	CPI13	A/P Correction Invoice Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
49	CPI20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
50	CPI3	A/P Correction Invoice - Freight	42	BaseRef	Base Document Reference	Int	11	0
51	CPI5	Withholding Tax Data	23	BaseRef	Base Document Reference	Int	11	0
52	CPV1	A/P Correction Invoice Reversal - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
53	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
54	CPV20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
55	CPV3	A/P Correction Invoice Reversal - Freight	42	BaseRef	Base Document Reference	Int	11	0
56	CPV5	A/P Correction Invoice Reversal - WTax	23	BaseRef	Base Document Reference	Int	11	0
57	CSI1	A/R Correction Invoice - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
58	CSI13	A/R Correction Invoice Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
59	CSI20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
60	CSI3	A/R Correction Invoice - Freight	42	BaseRef	Base Document Reference	Int	11	0
61	CSI5	A/R Correction Invoice - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
62	CSV1	A/R Correction Invoice Reversal - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
63	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
64	CSV20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
65	CSV3	A/R Correction Invoice Reversal - Freight	42	BaseRef	Base Document Reference	Int	11	0
66	CSV5	A/R Correction Invoice Reversal - WTax	23	BaseRef	Base Document Reference	Int	11	0
67	DLN1	Delivery - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
68	DLN13	Delivery Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
69	DLN20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
70	DLN3	Delivery Notes - Freight	42	BaseRef	Base Document Reference	Int	11	0
71	DLN5	Delivery - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
72	DOC20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
73	DPI1	A/R Down Payment - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
74	DPI13	A/R Down Payment Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
75	DPI20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
76	DPI3	A/R Down Payment - Freight	42	BaseRef	Base Document Reference	Int	11	0
77	DPI5	A/R Down Payment - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
78	DPO1	A/P Down Payment - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
79	DPO13	A/P Down Payment Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
80	DPO20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
81	DPO3	A/P Down Payment - Freight	42	BaseRef	Base Document Reference	Int	11	0
82	DPO5	A/P Down Payment - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
83	DRF1	Draft - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
84	DRF13	Draft Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
85	DRF20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
86	DRF3	Draft - Freight	42	BaseRef	Base Document Reference	Int	11	0
87	DRF5	Draft Documents - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
88	IEI1	Incoming Excise Invoice - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
89	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
90	IEI20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
91	IEI3	IEI - Freight	42	BaseRef	Base Document Reference	Int	11	0
92	IEI5	Incoming Excise Invoice - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
93	IGE20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
94	IGN20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
95	INV1	A/R Invoice - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
96	INV13	A/R Invoice Rows - Distributed Freights	42	BaseRef	Base Document Reference	Int	11	0
97	INV20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
98	INV3	A/R Invoice - Freight	42	BaseRef	Base Document Reference	Int	11	0
99	INV5	A/R Invoice - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
100	OEI1	Outgoing Excise Invoice - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
101	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
102	OEI20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
103	OEI3	OEI - Freight	42	BaseRef	Base Document Reference	Int	11	0
104	OEI5	Outgoing Excise Invoice - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
105	PCH1	A/P Invoice - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
106	PCH13	A/P Invoice Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
107	PCH20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
108	PCH3	A/P Invoice - Freight	42	BaseRef	Base Document Reference	Int	11	0
109	PCH5	A/P Invoice - Withholding Tax Data	23	BaseRef	Base Document Reference	Int	11	0
110	PDN1	Goods Receipt PO - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
111	PDN13	Goods Receipt PO Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
112	PDN20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
113	PDN3	Goods Receipt PO - Freight	42	BaseRef	Base Document Reference	Int	11	0
114	PDN5	Goods Reciept PO - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
115	POR1	Purchase Order - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
116	POR13	Purchase Order Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
117	POR20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
118	POR3	Purchase Order - Freight	42	BaseRef	Base Document Reference	Int	11	0
119	POR5	Purchase Order - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
120	PQT1	Purchase Quotation - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
121	PQT13	Purchase Quotation Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
122	PQT20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
123	PQT3	Purchase Quotation - Freight	42	BaseRef	Base Document Reference	Int	11	0
124	PQT5	Purchase Quotation - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
125	PRQ1	Purchase Request - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
126	PRQ13	Purchase Request Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
127	PRQ20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
128	PRQ3	Purchase Request - Freight	42	BaseRef	Base Document Reference	Int	11	0
129	PRQ5	Purchase Request - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
130	PRR1	A/P Return Request - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
131	PRR13	A/P Return Request - Distributed Freights	42	BaseRef	Base Document Reference	Int	11	0
132	PRR20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
133	PRR3	A/P Return Request - Freight	42	BaseRef	Base Document Reference	Int	11	0
134	PRR5	A/P Return Request - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
135	QUT1	Sales Quotation - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
136	QUT13	Sales Quotation Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
137	QUT20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
138	QUT3	Sales Quotation - Freight	42	BaseRef	Base Document Reference	Int	11	0
139	QUT5	Sales Quotation - Tax	23	BaseRef	Base Document Reference	Int	11	0
140	RDN1	Returns - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
141	RDN13	Returns Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
142	RDN20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
143	RDN3	Return - Freight	42	BaseRef	Base Document Reference	Int	11	0
144	RDN5	Returns - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
145	RDR1	Sales Order - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
146	RDR13	Sales Order Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
147	RDR20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
148	RDR3	Sales Order - Freight	42	BaseRef	Base Document Reference	Int	11	0
149	RDR5	Sales Order - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
150	RIN1	A/R Credit Memo - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
151	RIN13	A/R Credit Memo Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
152	RIN20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
153	RIN3	A/R Credit Memo - Freight	42	BaseRef	Base Document Reference	Int	11	0
154	RIN5	A/R Credit Memo - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
155	RPC1	A/P Credit Memo - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
156	RPC13	A/P Credit Memo Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
157	RPC20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
158	RPC3	A/P Credit Memo - Freight	42	BaseRef	Base Document Reference	Int	11	0
159	RPC5	A/P Credit Memo - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
160	RPD1	Goods Return - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
161	RPD13	Goods Returns Rows - Distributed Expenses	42	BaseRef	Base Document Reference	Int	11	0
162	RPD20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
163	RPD3	Goods Return - Freight	42	BaseRef	Base Document Reference	Int	11	0
164	RPD5	Goods Return - Withholding Tax Data	23	BaseRef	Base Document Reference	Int	11	0
165	RRR1	A/R Return Request - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
166	RRR13	A/R Return Request - Distributed Freights	42	BaseRef	Base Document Reference	Int	11	0
167	RRR20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
168	RRR3	A/R Return Request - Freight	42	BaseRef	Base Document Reference	Int	11	0
169	RRR5	A/R Return Request - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
170	SFC1	Self Credit Memo - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
171	SFC13	Self Credit Memo Rows - Distributed Freights	42	BaseRef	Base Document Reference	Int	11	0
172	SFC20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
173	SFC3	Self Credit Memo - Freight	42	BaseRef	Base Document Reference	Int	11	0
174	SFC5	Self Credit Memo - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
175	SFI1	Self Invoice - Rows	5	BaseRef	Base Document Reference	nVarChar	16	0
176	SFI13	Self Invoice Rows - Distributed Freights	42	BaseRef	Base Document Reference	Int	11	0
177	SFI20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
178	SFI3	Self Invoice - Freight	42	BaseRef	Base Document Reference	Int	11	0
179	SFI5	Self Invoice - Withholding Tax	23	BaseRef	Base Document Reference	Int	11	0
180	WTQ20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	0
181	WTR20	Intrastat Expenses	13	BaseRef	Base Document Reference	Int	11	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

181 columns | B1 9.3 | BASEREF