	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

52 columns | ERP 6.0 | MADAT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000165000	PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta	23	MADAT		nvarchar	8	0
2	/BIC/B0000166000	PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta	23	MADAT		nvarchar	8	0
3	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	33	MADAT		nvarchar	8	0
4	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	33	MADAT		nvarchar	8	0
5	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	39	MADAT		nvarchar	8	0
6	BSAD_BAK	Accounting: Secondary index for customers (cleared items)	64	MADAT	Last dunned on	nvarchar	8	0
7	BSAK_BAK	Accounting: Secondary Index for Vendors (Cleared Items)	67	MADAT	Last dunned on	nvarchar	8	0
8	BSEG	Accounting Document Segment	157	MADAT	Last dunned on	nvarchar	8	0
9	BSID_BAK	Accounting: Secondary Index for Customers	64	MADAT	Last dunned on	nvarchar	8	0
10	BSIK_BAK	Accounting: Secondary index for vendors	67	MADAT	Last dunned on	nvarchar	8	0
11	BSSEG	Accounting Document Segment	146	MADAT	Last dunned on	nvarchar	8	0
12	FUDT_VDOCBSEG	Verification Document Item with Additional Info	146	MADAT	Last dunned on	nvarchar	8	0
13	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	146	MADAT	Last dunned on	nvarchar	8	0
14	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	146	MADAT	Last dunned on	nvarchar	8	0
15	GLPOS_C_CT	FI Document: Entry View	169	MADAT	Last dunned on	nvarchar	8	0
16	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	169	MADAT	Last dunned on	nvarchar	8	0
17	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	169	MADAT	Last dunned on	nvarchar	8	0
18	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	169	MADAT	Last dunned on	nvarchar	8	0
19	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	172	MADAT	Last dunned on	nvarchar	8	0
20	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	172	MADAT	Last dunned on	nvarchar	8	0
21	MHND	Dunning Data	30	MADAT	Last dunned on	nvarchar	8	0
TOPAccounting
22	VDDUNN_DISP	Dunning run data per loan and dunning run	6	MADAT	Last dunned on	nvarchar	8	0
TOPAccounting Interface
23	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	120	MADAT	Last dunned on	nvarchar	8	0
24	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	120	MADAT	Last dunned on	nvarchar	8	0
TOPCross-Application Components
25	BBSID	Accounting: Secondary index for customers	64	MADAT	Last dunned on	nvarchar	8	0
TOPFinancial Accounting
26	BSAD	Accounting: Secondary Index for Customers (Cleared Items)	64	MADAT	Last dunned on	nvarchar	8	0
27	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)	67	MADAT	Last dunned on	nvarchar	8	0
28	BSID	Accounting: Secondary Index for Customers	64	MADAT	Last dunned on	nvarchar	8	0
29	BSIK	Accounting: Secondary Index for Vendors	67	MADAT	Last dunned on	nvarchar	8	0
30	KNB5	Customer master (dunning data)	7	MADAT	Last dunned on	nvarchar	8	0
31	LFB5	Vendor master (dunning data)	7	MADAT	Last dunned on	nvarchar	8	0
32	VBSEGD	Document Segment for Customer Document Parking	88	MADAT	Last dunned on	nvarchar	8	0
33	VBSEGK	Document Segment for Vendor Document Parking	104	MADAT	Last dunned on	nvarchar	8	0
TOPFunds Management-Specific Postings
34	PSOSEGD	Document Segment: Recurring Request, Customer	89	MADAT	Last dunned on	nvarchar	8	0
35	PSOSEGK	Recurring Request Document Segment, Vendors	105	MADAT	Last dunned on	nvarchar	8	0
TOPInformation System
36	BWPOS	Valuations for Open Items	30	MADAT	Last dunned on	nvarchar	8	0
TOPLoans Management
37	MZDAT	Dunning and interest data for batch input	13	MADAT	Last dunned on	nvarchar	8	0
38	TTONFTVDARL	Test neue Fima: Grunddaten und VDARL	85	MADAT	Datum der letzten Mahnung	nvarchar	8	0
39	VDARL	Loans	71	MADAT	Last dunned on	nvarchar	8	0
40	VDDUNN	Dunning run data per loan and dunning run	6	MADAT	Last dunned on	nvarchar	8	0
TOPLocalization
41	J_3RFTAX_EXTRD	Tax Extract Detail Lines	42	MADAT	Last dunned on	nvarchar	8	0
42	RFITEMAP_NO_ITEM	Item wise detail for the Vendor Transactions	40	MADAT	Last dunned on	nvarchar	8	0
43	RFITEMAR_NO_ITEM	Item wise detail for the Customer Transactions	40	MADAT	Last dunned on	nvarchar	8	0
44	RFITEMGL_NO_ITEM	Item wise detail for the GL Account Transactions	40	MADAT	Last dunned on	nvarchar	8	0
TOPPatient Management
45	NKSK	IS-H: Insurance verification/certificate - Header data	24	MADAT	IS-H: Date of Last Reminder for IV/Certificate	nvarchar	8	0
TOPReal Estate Management
46	S407	Rental agreements	110	MADAT	Date of last dunning letter	nvarchar	8	0
47	VIAKBSEG	Document Line Item from SCS for Interface	138	MADAT	Last dunned on	nvarchar	8	0
48	VIMI04	Old. replaced in 3.0 with VIMIMV	81	MADAT	Last dunned on	nvarchar	8	0
49	VIMIEV	Supplementary lease-outs	7	MADAT	Last dunned on	nvarchar	8	0
50	VIMIMV	Lease-Out	61	MADAT	Last dunned on	nvarchar	8	0
51	VIRPS407	Rental agreements	110	MADAT	Date of last dunning letter	nvarchar	8	0
TOPRemaining Beverage - Obsolete Objects
52	/BEV3/CH1030BSG1	Document Segment CH Event Ledger Part1	148	MADAT	Last dunned on	nvarchar	8	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

52 columns | ERP 6.0 | MADAT