	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

67 columns | B1 9.3 | MYFTYPE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals	Constraints
TOPFinance
1	AJD1	Journal Entry - History - Rows	129	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
2	BTF1	Journal Voucher - Rows	129	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
3	JDT1	Journal Entry - Rows	129	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
TOPInventory and Production
4	IGE1	Goods Issue - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
5	IGN1	Goods Receipt - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
6	OIGE	Goods Issue	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
7	OIGN	Goods Receipt	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
8	OWTQ	Inventory Transfer Request	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
9	OWTR	Inventory Transfer	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
10	WTQ1	Inventory Transfer Request - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
11	WTR1	Inventory Transfer - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
TOPMarketing Documents
12	ADO1	A/R Invoice (Rows) - History	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
13	ADOC	Invoice - History	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
14	CIN1	Correction Invoice - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
15	CPI1	A/P Correction Invoice - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
16	CPV1	A/P Correction Invoice Reversal - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
17	CSI1	A/R Correction Invoice - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
18	CSV1	A/R Correction Invoice Reversal - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
19	DLN1	Delivery - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
20	DPI1	A/R Down Payment - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
21	DPO1	A/P Down Payment - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
22	DRF1	Draft - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
23	IEI1	Incoming Excise Invoice - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
24	INV1	A/R Invoice - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
25	OCIN	A/R Correction Invoice	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
26	OCPI	A/P Correction Invoice	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
27	OCPV	A/P Correction Invoice Reversal	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
28	OCSI	A/R Correction Invoice	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
29	OCSV	A/R Correction Invoice Reversal	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
30	ODLN	Delivery	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
31	ODPI	A/R Down Payment	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
32	ODPO	A/P Down Payment	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
33	ODRF	Drafts	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
34	OEI1	Outgoing Excise Invoice - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
35	OIEI	Incoming Excise Invoice	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
36	OINV	A/R Invoice	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
37	OOEI	Outgoing Excise Invoice	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
38	OPCH	A/P Invoice	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
39	OPDN	Goods Receipt PO	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
40	OPOR	Purchase Order	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
41	OPQT	Purchase Quotation	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
42	OPRQ	Purchase Request	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
43	OPRR	Goods Return Request	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
44	OQUT	Sales Quotation	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
45	ORDN	Returns	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
46	ORDR	Sales Order	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
47	ORIN	A/R Credit Memo	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
48	ORPC	A/P Credit Memo	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
49	ORPD	Goods Return	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
50	ORRR	Return Request	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
51	OSFC	Self Credit Memo	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
52	OSFI	Self Invoice	391	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
53	PCH1	A/P Invoice - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
54	PDN1	Goods Receipt PO - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
55	POR1	Purchase Order - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
56	PQT1	Purchase Quotation - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
57	PRQ1	Purchase Request - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
58	PRR1	A/P Return Request - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
59	QUT1	Sales Quotation - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
60	RDN1	Returns - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
61	RDR1	Sales Order - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
62	RIN1	A/R Credit Memo - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
63	RPC1	A/P Credit Memo - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
64	RPD1	Goods Return - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
65	RRR1	A/R Return Request - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
66	SFC1	Self Credit Memo - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales
67	SFI1	Self Invoice - Rows	272	MYFtype	MYF type	nVarChar	2	0	P1=MYF purchase, P3=Other expense, S1=MYF sales, S2=Retail sales

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

67 columns | B1 9.3 | MYFTYPE