	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

125 columns | B1 8.8 | PAIDTODATE

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

125 columns | B1 8.8 | PAIDTODATE