	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

140 columns | B1 9.2 | PAIDTODATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPInventory and Production
1	IGE13	Goods Issue Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
2	IGE2	Goods Issue - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
3	IGE3	Goods Issue - Freight	6	PaidToDate	Paid to Date	Num	19	6
4	IGE6	Goods Issue - Installments	11	PaidToDate	Paid to Date	Num	19	6
5	IGN13	Goods Receipt Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
6	IGN2	Goods Receipt - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
7	IGN3	Goods Receipt - Freight	6	PaidToDate	Paid to Date	Num	19	6
8	IGN6	Goods Receipt- Installments	11	PaidToDate	Paid to Date	Num	19	6
9	OIGE	Goods Issue	27	PaidToDate	Paid to Date	Num	19	6
10	OIGN	Goods Receipt	27	PaidToDate	Paid to Date	Num	19	6
11	OWTQ	Inventory Transfer Request	27	PaidToDate	Paid to Date	Num	19	6
12	OWTR	Inventory Transfer	27	PaidToDate	Paid to Date	Num	19	6
13	WTQ13	Inventory Transfer Request Rows - Distributed Freights	8	PaidToDate	Paid to Date	Num	19	6
14	WTQ2	Inventory Transfer Request - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
15	WTQ3	Inventory Transfer Request - Freight	6	PaidToDate	Paid to Date	Num	19	6
16	WTQ6	Inventory Transfer Request - Installments	11	PaidToDate	Paid to Date	Num	19	6
17	WTR13	Inventory Transfer Rows - Distributed Freights	8	PaidToDate	Paid to Date	Num	19	6
18	WTR2	Inventory Transfer - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
19	WTR3	Inventory Transfer - Freight	6	PaidToDate	Paid to Date	Num	19	6
20	WTR6	Inventory Transfer - Installments	11	PaidToDate	Paid to Date	Num	19	6
TOPMarketing Documents
21	ADO13	A/R Invoice Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
22	ADO2	A/R Invoice - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
23	ADO3	A/R Invoice - Freight - History	6	PaidToDate	Paid to Date	Num	19	6
24	ADO6	Documents History - Installments	11	PaidToDate	Paid to Date	Num	19	6
25	ADOC	Invoice - History	27	PaidToDate	Paid to Date	Num	19	6
26	CIN13	Correction Invoice Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
27	CIN2	A/R Correction Invoice - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
28	CIN3	A/R Correction Invoice - Freight	6	PaidToDate	Paid to Date	Num	19	6
29	CIN6	Correction Invoice - Installments	11	PaidToDate	Paid to Date	Num	19	6
30	CPI13	A/P Correction Invoice Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
31	CPI2	A/P Correction Invoice - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
32	CPI3	A/P Correction Invoice - Freight	6	PaidToDate	Paid to Date	Num	19	6
33	CPI6	Documents History - Installments	11	PaidToDate	Paid to Date	Num	19	6
34	CPV13	A/P Correction Invoice Reversal Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
35	CPV2	A/P Correction Invoice Reversal - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
36	CPV3	A/P Correction Invoice Reversal - Freight	6	PaidToDate	Paid to Date	Num	19	6
37	CPV6	A/P Correction Invoice Reversal - Installments	11	PaidToDate	Paid to Date	Num	19	6
38	CSI13	A/R Correction Invoice Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
39	CSI2	A/R Corr Inv - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
40	CSI3	A/R Correction Invoice - Freight	6	PaidToDate	Paid to Date	Num	19	6
41	CSI6	A/R Corr. Inv. - Installments	11	PaidToDate	Paid to Date	Num	19	6
42	CSV13	A/R Correction Invoice Reversal Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
43	CSV2	A/R Correction Invoice Reversal - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
44	CSV3	A/R Correction Invoice Reversal - Freight	6	PaidToDate	Paid to Date	Num	19	6
45	CSV6	A/R Correction Invoice Reversal - Installments	11	PaidToDate	Paid to Date	Num	19	6
46	DLN13	Delivery Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
47	DLN2	Delivery Notes - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
48	DLN3	Delivery Notes - Freight	6	PaidToDate	Paid to Date	Num	19	6
49	DLN6	Delivery - Installments	11	PaidToDate	Paid to Date	Num	19	6
50	DPI13	A/R Down Payment Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
51	DPI2	A/R Down Payment - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
52	DPI3	A/R Down Payment - Freight	6	PaidToDate	Paid to Date	Num	19	6
53	DPI6	A/R Down Payment - Installments	11	PaidToDate	Paid to Date	Num	19	6
54	DPO13	A/P Down Payment Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
55	DPO2	A/P Down Payment - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
56	DPO3	A/P Down Payment - Freight	6	PaidToDate	Paid to Date	Num	19	6
57	DPO6	Down Payment Out - Installments	11	PaidToDate	Paid to Date	Num	19	6
58	DRF13	Draft Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
59	DRF2	Draft - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
60	DRF3	Draft - Freight	6	PaidToDate	Paid to Date	Num	19	6
61	DRF6	Document Drafts - Installments	11	PaidToDate	Paid to Date	Num	19	6
62	IEI13	Incoming Excise Invoice Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
63	IEI2	Incoming Excise Invoice - Freight - History - Rows	8	PaidToDate	Paid to Date	Num	19	6
64	IEI3	IEI - Freight	6	PaidToDate	Paid to Date	Num	19	6
65	IEI6	IEI - Installments	11	PaidToDate	Paid to Date	Num	19	6
66	INV13	A/R Invoice Rows - Distributed Freights	8	PaidToDate	Paid to Date	Num	19	6
67	INV2	A/R Invoice - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
68	INV3	A/R Invoice - Freight	6	PaidToDate	Paid to Date	Num	19	6
69	INV6	A/R Invoice - Installments	11	PaidToDate	Paid to Date	Num	19	6
70	OCIN	A/R Correction Invoice	27	PaidToDate	Paid to Date	Num	19	6
71	OCPI	A/P Correction Invoice	27	PaidToDate	Paid to Date	Num	19	6
72	OCPV	A/P Correction Invoice Reversal	27	PaidToDate	Paid to Date	Num	19	6
73	OCSI	A/R Correction Invoice	27	PaidToDate	Paid to Date	Num	19	6
74	OCSV	A/R Correction Invoice Reversal	27	PaidToDate	Paid to Date	Num	19	6
75	ODLN	Delivery	27	PaidToDate	Paid to Date	Num	19	6
76	ODPI	A/R Down Payment	27	PaidToDate	Paid to Date	Num	19	6
77	ODPO	A/P Down Payment	27	PaidToDate	Paid to Date	Num	19	6
78	ODRF	Drafts	27	PaidToDate	Paid to Date	Num	19	6
79	OEI13	Outgoing Excise Invoice Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
80	OEI2	OEI - Freight Rows	8	PaidToDate	Paid to Date	Num	19	6
81	OEI3	OEI - Freight	6	PaidToDate	Paid to Date	Num	19	6
82	OEI6	Outgoing Excise Invoice - Installments	11	PaidToDate	Paid to Date	Num	19	6
83	OIEI	Incoming Excise Invoice	27	PaidToDate	Paid to Date	Num	19	6
84	OINV	A/R Invoice	27	PaidToDate	Paid to Date	Num	19	6
85	OOEI	Outgoing Excise Invoice	27	PaidToDate	Paid to Date	Num	19	6
86	OPCH	A/P Invoice	27	PaidToDate	Paid to Date	Num	19	6
87	OPDN	Goods Receipt PO	27	PaidToDate	Paid to Date	Num	19	6
88	OPOR	Purchase Order	27	PaidToDate	Paid to Date	Num	19	6
89	OPQT	Purchase Quotation	27	PaidToDate	Paid to Date	Num	19	6
90	OPRQ	Purchase Request	27	PaidToDate	Paid to Date	Num	19	6
91	OQUT	Sales Quotation	27	PaidToDate	Paid to Date	Num	19	6
92	ORDN	Returns	27	PaidToDate	Paid to Date	Num	19	6
93	ORDR	Sales Order	27	PaidToDate	Paid to Date	Num	19	6
94	ORIN	A/R Credit Memo	27	PaidToDate	Paid to Date	Num	19	6
95	ORPC	A/P Credit Memo	27	PaidToDate	Paid to Date	Num	19	6
96	ORPD	Goods Return	27	PaidToDate	Paid to Date	Num	19	6
97	PCH13	A/P Invoice Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
98	PCH2	A/P Invoice - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
99	PCH3	A/P Invoice - Freight	6	PaidToDate	Paid to Date	Num	19	6
100	PCH6	A/P Invoice - Installments	11	PaidToDate	Paid to Date	Num	19	6
101	PDN13	Goods Receipt PO Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
102	PDN2	Goods Receipt PO - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
103	PDN3	Goods Receipt PO - Freight	6	PaidToDate	Paid to Date	Num	19	6
104	PDN6	Goods Receipt PO - Installments	11	PaidToDate	Paid to Date	Num	19	6
105	POR13	Purchase Order Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
106	POR2	Purchase Order - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
107	POR3	Purchase Order - Freight	6	PaidToDate	Paid to Date	Num	19	6
108	POR6	Purchase Order - Installments	11	PaidToDate	Paid to Date	Num	19	6
109	PQT13	Purchase Quotation Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
110	PQT2	Purchase Quotation - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
111	PQT3	Purchase Quotation - Freight	6	PaidToDate	Paid to Date	Num	19	6
112	PQT6	Purchase Quotation - Installments	11	PaidToDate	Paid to Date	Num	19	6
113	PRQ13	Purchase Request Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
114	PRQ2	Purchase Request - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
115	PRQ3	Purchase Request - Freight	6	PaidToDate	Paid to Date	Num	19	6
116	PRQ6	Purchase Request - Installments	11	PaidToDate	Paid to Date	Num	19	6
117	QUT13	Sales Quotation Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
118	QUT2	Sales Quotation - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
119	QUT3	Sales Quotation - Freight	6	PaidToDate	Paid to Date	Num	19	6
120	QUT6	Sales Quotation - Installments	11	PaidToDate	Paid to Date	Num	19	6
121	RDN13	Returns Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
122	RDN2	Return - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
123	RDN3	Return - Freight	6	PaidToDate	Paid to Date	Num	19	6
124	RDN6	Returns - Installments	11	PaidToDate	Paid to Date	Num	19	6
125	RDR13	Sales Order Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
126	RDR2	Sales Order - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
127	RDR3	Sales Order - Freight	6	PaidToDate	Paid to Date	Num	19	6
128	RDR6	Sales Order - Installments	11	PaidToDate	Paid to Date	Num	19	6
129	RIN13	A/R Credit Memo Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
130	RIN2	A/R Credit Memo - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
131	RIN3	A/R Credit Memo - Freight	6	PaidToDate	Paid to Date	Num	19	6
132	RIN6	A/R Credit Memo - Installments	11	PaidToDate	Paid to Date	Num	19	6
133	RPC13	A/P Credit Memo Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
134	RPC2	A/P Credit Memo Rows - Expenses	8	PaidToDate	Paid to Date	Num	19	6
135	RPC3	A/P Credit Memo - Freight	6	PaidToDate	Paid to Date	Num	19	6
136	RPC6	A/P Credit Memo - Installments	11	PaidToDate	Paid to Date	Num	19	6
137	RPD13	Goods Returns Rows - Distributed Expenses	8	PaidToDate	Paid to Date	Num	19	6
138	RPD2	Goods Return - Freight - Rows	8	PaidToDate	Paid to Date	Num	19	6
139	RPD3	Goods Return - Freight	6	PaidToDate	Paid to Date	Num	19	6
140	RPD6	Goods Return - Installments	11	PaidToDate	Paid to Date	Num	19	6

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

140 columns | B1 9.2 | PAIDTODATE