	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

133 columns | B1 9.3 | CURRENCY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPBanking
1	ABOE	Bill of Exchange for Payment - History	20	Currency	Bill of Exchange Currency	nVarChar	3	0
2	ACHO	Checks for Payment - History	17	Currency	Check Currency	nVarChar	3	0
3	ADS1	House Bank Accounts	79	Currency	Currency	nVarChar	3	0
4	ARC1	Incoming Payment - Checks - History	11	Currency	Check Currency	nVarChar	3	0
5	DSC1	House Bank Accounts	79	Currency	Currency	nVarChar	3	0
6	MTH1V	Journal Entries of External Reconciliation	17	Currency	Currency	nVarChar	3	0
7	OBNH	Bank Statement Header	9	Currency	Currency	nVarChar	3	0
8	OBOE	Bill of Exchange for Payment	20	Currency	Bill of Exchange Currency	nVarChar	3	0
9	OCHD	Checks for Payment Drafts	17	Currency	Check Currency	nVarChar	3	0
10	OCHH	Check Register	21	Currency	Check Currency	nVarChar	3	0
11	OCHO	Checks for Payment	17	Currency	Check Currency	nVarChar	3	0
12	OPEX	Payment Results Table	32	Currency	Main Currency	nVarChar	3	0
13	PDF1	Payment Draft - Checks	11	Currency	Check Currency	nVarChar	3	0
14	PWZ5	Payment Wizard - Rows 5	13	Currency	Currency	nVarChar	3	0
15	RCT1	Incoming Payment - Checks	11	Currency	Check Currency	nVarChar	3	0
16	VPM1	Outgoing Payments - Check Rows	11	Currency	Check Currency	nVarChar	3	0
TOPBusiness Partners
17	ACRD	Business Partners - History	44	Currency	BP Currency	nVarChar	3	0
18	AOA1	Blanket Agreement - Rows	8	Currency	Price Currency	nVarChar	3	0
19	OAT1	Blanket Agreement - Rows	8	Currency	Price Currency	nVarChar	3	0
20	OCRD	Business Partner	44	Currency	BP Currency	nVarChar	3	0
TOPFinance
21	AFAD	Asset Document - History	13	Currency	Currency	nVarChar	3	0
22	GBI6	GBI Row 6 - G/L Account Balance	4	Currency	Account Currency	nVarChar	3	0
23	GBI7	GBI Row 7 - Accounting Vouchers	9	Currency	Transaction Currency	nVarChar	3	0
24	OACD	Credit Memo	13	Currency	Currency	nVarChar	3	0
25	OACQ	Capitalization	13	Currency	Currency	nVarChar	3	0
26	OFTR	Transfer	13	Currency	Currency	nVarChar	3	0
27	OGBI	GB Interface: Common Info	5	Currency	Currency Unit	nVarChar	10	0
28	OMDP	Manual Depreciation	13	Currency	Currency	nVarChar	3	0
29	ORTI	Retirement	13	Currency	Currency	nVarChar	3	0
30	ORTS	CPI and FC Rates for Reports	2	Currency	Currency Code	nVarChar	3	0
31	ORTT	CPI and FC Rates	2	Currency	Currency Code	nVarChar	3	0
32	RCR1	Recurring Postings - Rows	7	Currency	Currency	nVarChar	3	0
33	SLM1	Special Ledger - Analytical Accounting Report Lines: Material	23	Currency	Foreign Currency	nVarChar	3	0
34	SLR1	Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses	23	Currency	Foreign Currency	nVarChar	3	0
TOPGeneral
35	ARSC2	Resources - Prices - Log	4	Currency	Currency for List Price	nVarChar	3	0
36	OPMX	Payroll	3	Currency	Currency	nVarChar	3	0
37	RSC2	Resources - Prices	4	Currency	Currency for List Price	nVarChar	3	0
TOPInventory and Production
38	AIT1	Item - Prices - History	4	Currency	Price List Currency	nVarChar	3	0
39	AIT9	Item - UoM Prices	6	Currency	Currency for UoM Price	nVarChar	3	0
40	AQI1	Inventory Opening Balance - Rows	9	Currency	Price Currency	nVarChar	3	0
41	AQR1	Inventory Posting - Rows	9	Currency	Price Currency	nVarChar	3	0
42	ASP1	Special Prices - Data Areas	5	Currency	Price Currency	nVarChar	3	0
43	ASP2	Special Prices - Quantity Areas	7	Currency	Price Currency	nVarChar	3	0
44	ASPP	Special Prices	4	Currency	Price Currency	nVarChar	3	0
45	ATT1	Bill of Materials - Components - History	8	Currency	Currency	nVarChar	3	0
46	IGE1	Goods Issue - Rows	16	Currency	Price Currency	nVarChar	3	0
47	IGN1	Goods Receipt - Rows	16	Currency	Price Currency	nVarChar	3	0
48	IOD1	Inventory Opening Balance Draft - Rows	9	Currency	Price Currency	nVarChar	3	0
49	IPD1	Inventory Posting Draft - Rows	9	Currency	Price Currency	nVarChar	3	0
50	IPF1	Landed Costs - Rows	9	Currency	Price Currency	nVarChar	3	0
51	IQI1	Inventory Opening Balance - Rows	9	Currency	Price Currency	nVarChar	3	0
52	IQR1	Inventory Posting - Rows	9	Currency	Price Currency	nVarChar	3	0
53	ITM1	Items - Prices	4	Currency	Currency for List Price	nVarChar	3	0
54	ITM9	Item - UoM Prices	6	Currency	Currency for UoM Price	nVarChar	3	0
55	ITT1	Bill of Materials - Components	8	Currency	Currency	nVarChar	3	0
56	OAIM	Archive Inventory Message	13	Currency	Document Currency	nVarChar	3	0
57	OILM	Inventory Log Message	15	Currency	Doc Currency	nVarChar	3	0
58	OIVL	Whse Journal	11	Currency	Price Currency	nVarChar	3	0
59	OSPP	Special Prices	4	Currency	Price Currency	nVarChar	3	0
60	SIVL	Whse Journal	11	Currency	Price Currency	nVarChar	3	0
61	SPP1	Special Prices - Data Areas	5	Currency	Price Currency	nVarChar	3	0
62	SPP2	Special Prices - Quantity Areas	7	Currency	Price Currency	nVarChar	3	0
63	UILM	IVI Inventory Log Message	15	Currency	Doc Currency	nVarChar	3	0
64	UIVL	Whse Journal	11	Currency	Price Currency	nVarChar	3	0
65	UWKO1	Production Instructions - Rows	7	Currency	Price Currency	nVarChar	3	0
66	WKO1	Production Instructions - Rows	7	Currency	Price Currency	nVarChar	3	0
67	WTQ1	Inventory Transfer Request - Rows	16	Currency	Price Currency	nVarChar	3	0
68	WTR1	Inventory Transfer - Rows	16	Currency	Price Currency	nVarChar	3	0
TOPMarketing Documents
69	ADO1	A/R Invoice (Rows) - History	16	Currency	Price Currency	nVarChar	3	0
70	ADO25	Mktg Docs - Amt Per VAT Grp - History	11	Currency	Price Currency	nVarChar	3	0
71	CIN1	Correction Invoice - Rows	16	Currency	Price Currency	nVarChar	3	0
72	CIN25	Correction Invoice - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
73	CPI1	A/P Correction Invoice - Rows	16	Currency	Price Currency	nVarChar	3	0
74	CPI25	A/P Correction Invoice - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
75	CPV1	A/P Correction Invoice Reversal - Rows	16	Currency	Price Currency	nVarChar	3	0
76	CPV25	A/P Correction Invoice Reversal - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
77	CSI1	A/R Correction Invoice - Rows	16	Currency	Price Currency	nVarChar	3	0
78	CSI25	A/R Correction Invoice - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
79	CSV1	A/R Correction Invoice Reversal - Rows	16	Currency	Price Currency	nVarChar	3	0
80	CSV25	A/R Correction Invoice Reversal - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
81	DLN1	Delivery - Rows	16	Currency	Price Currency	nVarChar	3	0
82	DLN25	Delivery - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
83	DPI1	A/R Down Payment - Rows	16	Currency	Price Currency	nVarChar	3	0
84	DPI25	A/R Down Payment - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
85	DPO1	A/P Down Payment - Rows	16	Currency	Price Currency	nVarChar	3	0
86	DPO25	A/P Down Payment - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
87	DRF1	Draft - Rows	16	Currency	Price Currency	nVarChar	3	0
88	DRF25	Draft - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
89	IEI1	Incoming Excise Invoice - Rows	16	Currency	Price Currency	nVarChar	3	0
90	IEI25	Incoming Excise Invoice - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
91	IGE25	Goods Issue - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
92	IGN25	Goods Receipt - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
93	INV1	A/R Invoice - Rows	16	Currency	Price Currency	nVarChar	3	0
94	INV25	A/R Invoice - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
95	OEI1	Outgoing Excise Invoice - Rows	16	Currency	Price Currency	nVarChar	3	0
96	OEI25	Outgoing Excise Invoice - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
97	OMIN	A/R Monthly Invoice	6	Currency	Currency of Monthly Invoice	nVarChar	3	0
98	OMIV	A/P Monthly Invoice	6	Currency	Currency	nVarChar	3	0
99	PCH1	A/P Invoice - Rows	16	Currency	Price Currency	nVarChar	3	0
100	PCH25	A/P Invoice - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
101	PDN1	Goods Receipt PO - Rows	16	Currency	Price Currency	nVarChar	3	0
102	PDN25	Goods Receipt PO - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
103	POR1	Purchase Order - Rows	16	Currency	Price Currency	nVarChar	3	0
104	POR25	Purchase Order - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
105	PQT1	Purchase Quotation - Rows	16	Currency	Price Currency	nVarChar	3	0
106	PQT25	Purchase Quotation - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
107	PRQ1	Purchase Request - Rows	16	Currency	Price Currency	nVarChar	3	0
108	PRQ25	Purchase Request - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
109	PRR1	A/P Return Request - Rows	16	Currency	Price Currency	nVarChar	3	0
110	PRR25	Goods Return Request - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
111	QUT1	Sales Quotation - Rows	16	Currency	Price Currency	nVarChar	3	0
112	QUT25	Sales Quotation - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
113	RDN1	Returns - Rows	16	Currency	Price Currency	nVarChar	3	0
114	RDN25	Returns - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
115	RDR1	Sales Order - Rows	16	Currency	Price Currency	nVarChar	3	0
116	RDR25	Sales Order - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
117	RIN1	A/R Credit Memo - Rows	16	Currency	Price Currency	nVarChar	3	0
118	RIN25	A/R Credit Memo - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
119	RPC1	A/P Credit Memo - Rows	16	Currency	Price Currency	nVarChar	3	0
120	RPC25	A/P Credit Memo - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
121	RPD1	Goods Return - Rows	16	Currency	Price Currency	nVarChar	3	0
122	RPD25	Goods Return - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
123	RRR1	A/R Return Request - Rows	16	Currency	Price Currency	nVarChar	3	0
124	RRR25	Return Request - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
125	SFC1	Self Credit Memo - Rows	16	Currency	Price Currency	nVarChar	3	0
126	SFC25	Self Credit Memo - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
127	SFI1	Self Invoice - Rows	16	Currency	Price Currency	nVarChar	3	0
128	SFI25	Self Invoice - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
129	VRT2	Tax Invoice Report Grid Info	18	Currency	Currency	nVarChar	3	0
130	WTQ25	Inventory Transfer Request - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
131	WTR25	Inventory Transfer - Amt Per VAT Grp	11	Currency	Price Currency	nVarChar	3	0
TOPMRP
132	ORCM	Recommendation Data	12	Currency	Price Currency	nVarChar	3	0
TOPReports
133	SOI5	Statement of Import - Lines	13	Currency	Currency	nVarChar	3	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

133 columns | B1 9.3 | CURRENCY