	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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

96 columns | ERP 6.0 | LFGJA

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SMERP/STG_MM001	Data staging - Material master plant view complex table	394	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
2	/SMERP/STG_MM002	Data staging - Material storage location view complex table	203	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
3	FIEUD_MMINV_I	SAFT:MM: Item Details for XML Purchase Invoice	36	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
4	ZEIM_LIPS	SD document: Delivery: Item data	231	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPBalance Sheet Valuation Procedures
5	MYMP1R	Storage for Invoice Differences (LIFO/FIFO)	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPBatches
6	WBEW	Active Ingredient Valuation	30	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPCross-Application Components
7	MMARC	Plant Data for Material	198	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPFinancial Accounting
8	VBSEGS	Document Segment for Document Parking - G/L Account Database	60	LFGJA	Material Document Year	nvarchar	4	0
TOPFunds Management-Specific Postings
9	FMFUNDTRANSYEAR	Additional Documents for Funds Transfer to Diff. Years	59	LFGJA	Material Document Year	nvarchar	4	0
10	PSOSEGS	Recurring Request Document Segment, G/L Accounts	58	LFGJA	Material Document Year	nvarchar	4	0
TOPHydrocarbon Product Management
11	MARCHO1	MARCH: Additional quantities appendix	4	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
12	MARDHO1	MARDH: Aditional quantities appendix	5	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
13	MCHBHO1	MCHBH: Additional quantities appendix	6	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
14	MKOLHO1	MKOLH: Additional quantities appendix	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
15	MSKAHO1	MSKAH: Additional quantities appendix	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
16	MSKUHO1	MSKUH: Additional quantities appendix	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
17	MSLBHO1	MSLB: Additional quantities appendix	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
18	MSPRHO1	MSPRH: Additional quantities appendix	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
19	MSPRO1	Project Stock additional quantities	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPInventory Management
20	MMINKON_UP	Corrections due to Technical Problems with Stock	18	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
21	MSTB	Stock in Transit	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
22	MSTBH	Stock in Transit - History	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
23	MSTE	Stock in Transit to Sales and Distribution Document	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
24	MSTEH	SiT to Sales and Distribution Document - History	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
25	MSTQ	Stock in Transit for Project	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
26	MSTQH	Stock in Transit for Project - History	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
27	MWXVM07M	Fields: Update Control of Module Pool SAPMM07M	29	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
28	MWZVM07M	Fields: Update Control of Module Pool SAPMM07M	29	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPInvoice Verification
29	RBDRSEG	Batch IV: Invoice Document Items	24	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
30	RSEG	Document Item: Incoming Invoice	49	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPLocalization
31	IDEU_VAT	EU VAT Posting	20	LFGJA	Fiscal Year of a Reference Document	nvarchar	4	0
TOPMaterial Master
32	EBEW	Sales Order Stock Valuation	32	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
33	EBEWH	Valuation of Sales Order Stock: History	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
34	MARC	Plant Data for Material	198	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
35	MARCH	Material Master C Segment: History	4	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
36	MARC_TMP	File for Incorrect Data in Direct Input	201	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
37	MARD	Storage Location Data for Material	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
38	MARDH	Material Master Storage Location Segment: History	5	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
39	MARD_TMP	File for Incorrect Data in Direct Input	10	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
40	MARV	Material Control Record	3	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
41	MARVCD	Change Document: Period Initialization when System in Op.	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
42	MBEW	Material Valuation	30	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
43	MBEWH	Material Valuation: History	5	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
44	MBEW_TMP	File for Incorrect Data in Direct Input	33	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
45	MCHB	Batch Stocks	11	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
46	MCHBH	Batch Stocks: History	6	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
47	MKOL	Special Stocks from Vendor	13	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
48	MKOLH	Special Stocks from Vendor: History	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
49	MSCA	Sales Orders on Hand with Vendor	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
50	MSCAH	Sales Order Stock at Vendor: History	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
51	MSKA	Sales Order Stock	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
52	MSKAH	Sales Order Stock: History	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
53	MSKU	Special Stocks with Customer	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
54	MSKUH	Special Stocks at Customer: History	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
55	MSLB	Special Stocks with Vendor	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
56	MSLBH	Special Stocks at Vendor: History	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
57	MSOA	Total Sales Orders on Hand with Vendor	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
58	MSPR	Project Stock	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
59	MSPRH	Project Stock: History	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
60	MSSA	Total Customer Orders on Hand	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
61	MSSAH	Total Sales Order Stocks: History	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
62	MSSL	Total Special Stocks with Vendor	6	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
63	MSSQ	Project Stock Total	6	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
64	MSSQH	Total Project Stocks: History	6	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
65	MVEW	Material Valuation	30	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
66	MVEWH	Material Valuation: History	5	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
67	MVRC	Cross-version fields for MARC	198	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
68	MVRD	Storage Location Data for Material	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
69	OBEW	Valuated Stock with Subcontractor	31	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
70	OBEWH	Valuated Stock with Subcontractor: History	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
71	QBEW	Project Stock Valuation	31	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
72	QBEWH	Valuation of Project Stock: History	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPPurchasing
73	EKBE	History per Purchasing Document	24	LFGJA	Fiscal Year of a Reference Document	nvarchar	4	0
74	EKBEH	Removed PO History Records	24	LFGJA	Fiscal Year of a Reference Document	nvarchar	4	0
75	EKBEH_MA	Removed PO History Records at Account Assignment Level	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
76	EKBE_MA	History of Purchasing Document at Account Assignment Level	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
77	EKBE_SC	Component Consumption History for Subcontracting	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
78	EKDF	Document Flow for Logistics Differential Invoice	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
79	EKRS	ERS Procedure: Goods (Merchandise) Movements to be Invoiced	11	LFGJA	Fiscal Year of a Reference Document	nvarchar	4	0
TOPShipping
80	LIPS	SD document: Delivery: Item data	231	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
TOPSpare Part Sharing and Stock Providede by Customer
81	MCSD	Customer Stock	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
82	MCSDH	Customer Stock: History	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
83	MCSS	Total Customer Stock	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
84	MCSSH	Kundenbeistellbestand - Historie - Summe	6	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
85	MSCD	Customer stock with vendor	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
86	MSCDH	Customer stock with vendor - History	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
87	MSCS	Customer stock with vendor - Total	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
88	MSFD	Sales Order Stock with Vendor	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
89	MSFDH	Sales Order Stock at Vendor: History	9	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
90	MSFS	Sales Order Stock with Vendor - Total	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
91	MSID	Vendor Stock with Vendor	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
92	MSIDH	Vendor Stock with Vendor - History	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
93	MSIS	Vendor Stock with Vendor - Total	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
94	MSRD	Project Stock with Vendor	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
95	MSRDH	Project Stock with Vendor - History	8	LFGJA	Fiscal Year of Current Period	nvarchar	4	0
96	MSRS	Project Stock with Vendor - Total	7	LFGJA	Fiscal Year of Current Period	nvarchar	4	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

96 columns | ERP 6.0 | LFGJA