	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

161 columns | ERP 6.0 | MJAHR

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/GBTINT/EVHUS	GBT: Handling Units related to MDoc / WM TO	5	MJAHR	Material Document Year	nvarchar	4	0
2	ARBERP_D_RCTTRIG	Trigger Table: Send Receipt Request cXML Messages	6	MJAHR	Material Document Year	nvarchar	4	0
3	ARBERP_D_SO_RCPT	Receipt Request Message Payload ID For Outbound Messages	3	MJAHR	Material Document Year	nvarchar	4	0
4	CNVTDMS_05_MDOC	Fill Header for Material Documents (IS-OIL)	4	MJAHR	Material Document Year	nvarchar	4	0
5	CNV_20551_MBLNR	Material documents selected for deletion	4	MJAHR	Material doc. year	nvarchar	4	0
6	FIEUD_GOODSCNT	SAFT:MM: XML Goods movement Transaction Count and Summary	3	MJAHR	Material Document Year	nvarchar	4	0
7	FIEUD_GOODS_H	SAFT:XML:Goods Movement Header	4	MJAHR	Material Document Year	nvarchar	4	0
8	FIEUD_GOODS_I	SAFT-XML:Goods Movement Line Items	4	MJAHR	Material Document Year	nvarchar	4	0
9	FIEUD_SBINV_I	SAFT: Self Billing Invoices ( Line Items)	40	MJAHR	Material Document Year	nvarchar	4	0
10	J_3RF_RGTORG_IN	Incoming Journal of Acceptance Documents	9	MJAHR	Material Document Year	nvarchar	4	0
11	MWOFF_CL		3	MJAHR		nvarchar	4	0
12	WSPT_LIKP	Documents For Portugal Webservice	7	MJAHR	Material Document Year	nvarchar	4	0
TOPActual CostingMaterial Ledger
13	CKMLDUVCO	Usage Differences for Each Account Assignment Object	11	MJAHR	Fiscal Year of the Document	nvarchar	4	0
14	MLITMB	Material valuation document row information	6	MJAHR	Material Document Year	nvarchar	4	0
TOPAdditionals Management
15	WTADAB	Additionals: Documents	9	MJAHR	Material Document Year	nvarchar	4	0
TOPBalance Sheet Valuation Procedures
16	MYML1	LIFO: Transaction-Related Material Layer	6	MJAHR	Material Document Year	nvarchar	4	0
17	MYML1Q	LIFO: Transaction-Related Material Layer (Quantity)	6	MJAHR	Material Document Year	nvarchar	4	0
18	MYML1V	LIFO: Transaction-Related Material Layer (Values)	6	MJAHR	Material Document Year	nvarchar	4	0
19	MYMP1	Receipt Data LFIO/FIFO Valuation	7	MJAHR	Material Document Year	nvarchar	4	0
20	MYSEG_EXTRACT	Document Segment: Material	6	MJAHR	Material Document Year	nvarchar	4	0
TOPBasic functions
21	HUINV_ITEM	Handling Unit: Physical Inventory Document Item	30	MJAHR	Material Document Year	nvarchar	4	0
22	HUMSEG	Reference-HU-Item for Material Doc.Item that was Posted Last	6	MJAHR	Material Document Year	nvarchar	4	0
TOPBasic Functions
23	VBFA	Sales Document Flow	41	MJAHR	Material Document Year	nvarchar	4	0
TOPClinical System
24	N1BCPMAT_RD_MM	Services: Material Integration for Additional Data	4	MJAHR	Material Document Year	nvarchar	4	0
25	N1DRUGDOC	IS-H*MED: Drug Documentation	19	MJAHR	Medication: Material Document Year	nvarchar	4	0
26	N1EDRUG	IS-H*MED: Drug Event - Drug Assignment	21	MJAHR	Year for which levy is to be carried out	nvarchar	4	0
27	N1OLDDOC	IS-H*MED: Medication; History for N1DRUGDOC	6	MJAHR	Material Document Year	nvarchar	4	0
TOPConfirmations
28	AFFW	Goods Movements with Errors from Confirmations	60	MJAHR	Material Document Year	nvarchar	4	0
29	AFWI	Subsequently posted goods movements for confirmations	5	MJAHR	Material Document Year	nvarchar	4	0
TOPConstruction Equipment Management
30	J_3GBELK	Document File - Header Data	150	MJAHR	Material Document Year	nvarchar	4	0
TOPConsumer Products for Food Beverage
31	CFB_WEIGH_LIST	Database of Weigh List	3	MJAHR	Material Document Year	nvarchar	4	0
TOPCross-Application Components
32	/OPT/S_GR_HDR	VSS Staging Table: GR Header	3	MJAHR	Material Document Year	nvarchar	4	0
33	/OPT/S_GR_LIN	VSS Stageing Table: GR Line	3	MJAHR	Material Document Year	nvarchar	4	0
TOPData Retention Tool
34	TXW_S_MKPF	Retrieve MKPF from archive	10	MJAHR	Material Document Year	nvarchar	4	0
35	TXW_S_MSEG	Retrieve MSEG from archive	9	MJAHR	Material Document Year	nvarchar	4	0
TOPDistribution of Usage Variances
36	CKMLDUVNCO	Usage Differences for Each Account Assignment Object	11	MJAHR	Fiscal Year of the Document	nvarchar	4	0
37	DUVMSEG_EXTRACT	duv mseg extract for performance	3	MJAHR	Material Document Year	nvarchar	4	0
TOPExchanges
38	OIA08	LIA Document: Item Data	3	MJAHR	Material Document Year	nvarchar	4	0
39	OIA08H	LIA Document: Header Data	3	MJAHR	Material Document Year	nvarchar	4	0
40	OIA11	Exchange assignment for deliveries	16	MJAHR	Material Document Year	nvarchar	4	0
41	OIA12	Exchange assignment for bulk shipments	17	MJAHR	Material Document Year	nvarchar	4	0
42	OIA12I	Movement Based Netting document item	10	MJAHR	Material Document Year	nvarchar	4	0
43	OIAQB	Exchange Movements Index	15	MJAHR	Material Document Year	nvarchar	4	0
TOPExcise Duty
44	/BEV2/CS_HD	EMCS Process: Header Data	7	MJAHR	Material Document Year	nvarchar	4	0
45	/BEV2/CS_HD_H	EMCS Process: Header Data - History	8	MJAHR	Material Document Year	nvarchar	4	0
46	/BEV2/CS_MEMORY	EMCS Process: Table for Shared Buffer	7	MJAHR	Material Document Year	nvarchar	4	0
47	/BEV2/CS_MSEGARC	EMCS Process: ARC in Material Document Items	3	MJAHR	Material Document Year	nvarchar	4	0
48	/BEV2/CS_MSEGA_H	EMCS Process: ARC in Material Document Items - History	3	MJAHR	Material Document Year	nvarchar	4	0
49	/BEV2/EDMSE	Excise Duty Document Table	2	MJAHR	Material Document Year	nvarchar	4	0
50	/BEV2/EDMSS	Material Documents Whose Processing Flags Have to Be Reset	2	MJAHR	Material Document Year	nvarchar	4	0
51	/BEV2/EDMST	Document Texts for Manual Corrections	2	MJAHR	Material Document Year	nvarchar	4	0
52	/BEV2/ED_LDS_HDR	AAD: France: AAD Header	2	MJAHR	Material Document Year	nvarchar	4	0
53	/BEV2/ED_LDS_MNT	LDS: AAD Management Table	2	MJAHR	Material Document Year	nvarchar	4	0
54	/BEV2/ED_LDS_POS	AAD: France: AAD Header	2	MJAHR	Material Document Year	nvarchar	4	0
TOPFinancial Accounting
55	/CCEE/SIFIDDV	Special Tax Table	5	MJAHR	Material Document Year	nvarchar	4	0
56	/CCEE/SIFIPE17	Temporary import of goods	3	MJAHR	Material Document Year	nvarchar	4	0
TOPForeign Trade
57	/SAPSLL/BWHSTR3	Customs WH-Relevant Data for Two-Step Stock Transfer Process	8	MJAHR	Material Document Year	nvarchar	4	0
58	/SAPSLL/CUWLAR3	Relevant Goods Issues for Transfer to SAP GTS	3	MJAHR	Material Document Year	nvarchar	4	0
TOPHydrocarbon Product Management
59	MSEGO1	Quantity Conversion Parameters for Material Documents	3	MJAHR	Material Document Year	nvarchar	4	0
60	MSEGO2	Material Document Quantities in Additional Units of Measure	3	MJAHR	Material Document Year	nvarchar	4	0
61	OIB09	Log for missing MSEGO1 and MSEGO2 documents	3	MJAHR	Material Document Year	nvarchar	4	0
62	OIB_MIGO_HQCI	Store the QCI-GOITEM for MIGOs hold/restore feature	6	MJAHR	Material Document Year	nvarchar	4	0
63	OIB_MIGO_HTST	Store the TST-GOITEM for MIGOs hold/restore feature	5	MJAHR	Material Document Year	nvarchar	4	0
TOPInspection Lot Completion
64	QAMB	QM: Link Between Inspection Lot and Material Document	6	MJAHR	Material Document Year	nvarchar	4	0
TOPInterface to Terminal Automation System
65	OIK02B	IS-OIL/TAS: Status of processed functions - messages	25	MJAHR	Material Document Year	nvarchar	4	0
TOPInventory Management
66	CHVW	Table CHVW for Batch Where-Used List	13	MJAHR	Material Document Year	nvarchar	4	0
67	IMEXT	Enhancement Fields for Goods Receipt	3	MJAHR	Material Document Year	nvarchar	4	0
68	ISEG	Physical Inventory Document Items	36	MJAHR	Material Document Year	nvarchar	4	0
69	MARI	Short document: material movement	3	MJAHR	Material Document Year	nvarchar	4	0
70	MIGO_BADI_EXAMP2	BADI in MIGO: Example Table (Header)	3	MJAHR	Material Document Year	nvarchar	4	0
71	MIGO_BADI_EXAMPL	BADI in MIGO: Example Table	3	MJAHR	Material Document Year	nvarchar	4	0
72	MKPF	Header: Material Document	3	MJAHR	Material Document Year	nvarchar	4	0
73	MKPF_ARIDX	Index table for single doc. access to archive MM_MATBEL	3	MJAHR	Material Document Year	nvarchar	4	0
74	MMINKON_UP	Corrections due to Technical Problems with Stock	36	MJAHR	Material Document Year	nvarchar	4	0
75	MSEG	Document Segment: Material	3	MJAHR	Material Document Year	nvarchar	4	0
76	MWMKPF	Header Table for the Interface	5	MJAHR	Material Document Year	nvarchar	4	0
77	MWXMSEG	ZMSEG: Interface for Posting of Value	3	MJAHR	Material Document Year	nvarchar	4	0
78	MWXVM07M	Fields: Update Control of Module Pool SAPMM07M	3	MJAHR	Material Document Year	nvarchar	4	0
79	MWYMBUZ	Line Assignment	3	MJAHR	Material Document Year	nvarchar	4	0
80	MWZDM07M1	ZDM07M1	3	MJAHR	Material Document Year	nvarchar	4	0
81	MWZDM07M2	ZDM07M2	3	MJAHR	Material Document Year	nvarchar	4	0
82	MWZMBUZ	ZMBUZ	3	MJAHR	Material Document Year	nvarchar	4	0
83	MWZMSEG	ZMSEG:Interface for Posting of Value	3	MJAHR	Material Document Year	nvarchar	4	0
84	MWZVM07M	Fields: Update Control of Module Pool SAPMM07M	3	MJAHR	Material Document Year	nvarchar	4	0
TOPInvoice Verification
85	RBDRSEG	Batch IV: Invoice Document Items	74	MJAHR	Material Document Year	nvarchar	4	0
86	RKWA	Consignment Withdrawals	3	MJAHR	Material Document Year	nvarchar	4	0
TOPJoint Venture und Production Sharing Accounting
87	CRP_MIGO_BADI_TB	BADI in MIGO: Example Table	3	MJAHR	Material Document Year	nvarchar	4	0
TOPJust-In-Time Processing
88	JITOGR	Goods Receipts for JIT Outbound Calls	5	MJAHR	Material Document Year	nvarchar	4	0
TOPLocalization
89	J_1BFIFOIN	Incoming FIFO relevant Consignment movements (BRAZIL)	6	MJAHR	Material Document Year	nvarchar	4	0
90	J_1BFIFOOUT	Outgoing FIFO relevant Consignment movements (BRAZIL)	6	MJAHR	Material Document Year	nvarchar	4	0
91	J_1BPOSCOUPONS	POS-Database Coupons (Brazilian)	24	MJAHR	Material Document Year	nvarchar	4	0
92	J_1ICALOC	Allocation of materials to assets	6	MJAHR	Material Document Year	nvarchar	4	0
93	J_1IGRXREF	Goods Receipt to Excise Invoice Coss Reference	3	MJAHR	Material Document Year	nvarchar	4	0
94	J_1IGRXSUB	GR reference to subcontracting challans	2	MJAHR	Material Document Year	nvarchar	4	0
95	J_1IITMDTL	Item Details - for Capital goods and subcontracting	3	MJAHR	Material Document Year	nvarchar	4	0
96	J_1IPART1	Excise part I detials	7	MJAHR	Material Document Year	nvarchar	4	0
97	J_1IRAINDTL	Article Inward Note Detail	28	MJAHR	Material Document Year	nvarchar	4	0
98	J_1IRAINHDR	Article Inward Note Header	18	MJAHR	Material Document Year	nvarchar	4	0
99	J_1IRG1	Excise RG1 details	7	MJAHR	Material Document Year	nvarchar	4	0
100	J_1IRG23D	RG23D register for the depot	9	MJAHR	Material Document Year	nvarchar	4	0
101	J_3RFGTDMAT	GTD usage in material documents	10	MJAHR	Material Document Year	nvarchar	4	0
102	J_3RMWOIN	Material issues without invoices.	3	MJAHR	Material Document Year	nvarchar	4	0
103	J_3RSCCDSUBITM	Cargo Customs Declaration Subitems	12	MJAHR	Material Document Year	nvarchar	4	0
TOPMaintenance Notifications
104	QMEL	Quality Notification	73	MJAHR	Material Document Year	nvarchar	4	0
TOPMaintenance Orders
105	AUFM	Goods movements for order	3	MJAHR	Material Document Year	nvarchar	4	0
TOPManufacturer Part Number
106	ADPIC_HOLD_MIGO	Store BADI goitem for MIGO hold / restore functionality	6	MJAHR	Material Document Year	nvarchar	4	0
TOPMaterials Management
107	/SAPNEA/ROWA	Chargeable component consumptions	3	MJAHR	Material Document Year	nvarchar	4	0
108	J_1GMM2GV	End year inventory	3	MJAHR	Material Document Year	nvarchar	4	0
109	J_1GVL_ML	Material Ledger	31	MJAHR	Material Document Year	nvarchar	4	0
110	ROWA	Index table : Chargeable component consumptions	3	MJAHR	Material Document Year	nvarchar	4	0
111	RPOD_IDX	Goods Movement Synchronized with a SUS/ICH System	3	MJAHR	Material Document Year	nvarchar	4	0
TOPMaterials Management MM enhancements
112	/SAPMP/MIGOBPMNG	BAdI in MIGO: Cumulated Order Price Quantity	3	MJAHR	Material Document Year	nvarchar	4	0
TOPMeasuring Points and Counters
113	EAM_IFCU	Goods Movement for Technical Object	6	MJAHR	Material Document Year	nvarchar	4	0
TOPMedia Product Sales and Distribution
114	JKSDUNSOLDGRFLOW	IS-M: Goods Receipt Document Flow for Unsold Copies	5	MJAHR	Material Document Year	nvarchar	4	0
TOPPatient Accounting
115	NMATP	IS-H: Material planned for case	9	MJAHR	IS-H MM: Material Document Year	nvarchar	4	0
116	NMATV	IS-H: Material Entered for Case	11	MJAHR	IS-H MM: Material Document Year	nvarchar	4	0
TOPPegging, Grouping, and Distribution
117	PEG_CNSMPTN2WBS	Pegging: Consumption Posting to WBS element details	3	MJAHR	Material Document Year	nvarchar	4	0
118	PEG_TGTG_EXC	A&D GPD: Group to group initial peg	9	MJAHR	Material Document Year	nvarchar	4	0
TOPProduct Safety
119	CCRCT_PULO	EHS: Reference to Confirmed Purchased Quantities	5	MJAHR	Material Document Year	nvarchar	4	0
120	CCRCT_SOLO	EHS: Reference to Confirmed Sold Quantities (CCRCT_SO)	5	MJAHR	Material Document Year	nvarchar	4	0
TOPProduction Orders
121	COWIPB_CHVW	WIP Batches with Where-Used List	22	MJAHR	Material Document Year	nvarchar	4	0
TOPProduction Planning and Control PP enhancements
122	MILL_PBWU	Mill: Process Batches with Usage	21	MJAHR	Material Document Year	nvarchar	4	0
TOPQuality Certificates
123	QCPR	QM quality certificates in procurement	13	MJAHR	Material Document Year	nvarchar	4	0
TOPQuality Inspection
124	QALS	Inspection lot record	117	MJAHR	Material Document Year	nvarchar	4	0
125	QAPP	Inspection point	41	MJAHR	Material Document Year	nvarchar	4	0
TOPR2-R3 Link
126	LDK01	Communication Record 01 Decentralized WMS: GR/GI R/2 -> ERP	25	MJAHR	Material Document Year	nvarchar	4	0
127	LDK02	Communicat.Record 02 Decentralized WMS: Transfer R/2 -> ERP	30	MJAHR	Material Document Year	nvarchar	4	0
128	LDK06	Communic.Record 06 Decentr.WMS (R/2-ERP):Batch Status Change	15	MJAHR	Material Document Year	nvarchar	4	0
TOPRepetitive Manufacturing
129	AFWIS	Table of Reprocessing Records Already Reposted	4	MJAHR	Material Document Year	nvarchar	4	0
130	COMPMOVE	Goods Movement of Components	219	MJAHR	Material Document Year	nvarchar	4	0
TOPReturnable Packaging Logistics
131	RLACPOIT	Account Posting Record	13	MJAHR	Material Document Year	nvarchar	4	0
132	RLREPROC	Reprocessing Record for Returnable Packaging Acct Postings	20	MJAHR	Material Document Year	nvarchar	4	0
TOPSample Management
133	QPRN	Sample drawing of phys. samples	13	MJAHR	Material Document Year	nvarchar	4	0
TOPSAP Retail Store
134	WSTI_ART_REL	Physical Inventory During Open Time: Material Assignment	3	MJAHR	Material Document Year	nvarchar	4	0
135	WSTI_MKPF_INDEX	Phys. Inventory During Open Time: Material Doc. Index	6	MJAHR	Material Document Year	nvarchar	4	0
136	WSTI_POS_EVENT	Physical Inventory in an Opened Store: POS Trans by Receipt	9	MJAHR	Material Document Year	nvarchar	4	0
TOPSerial Numbers
137	SER03	Document Header for Serial Numbers for Goods Movements	4	MJAHR	Material Document Year	nvarchar	4	0
138	SER07	Document Header for Serial Numbers in Physical Inventory	5	MJAHR	Fiscal Year	nvarchar	4	0
139	T377X	Documents Allowed for Serial Number Management	25	MJAHR	Optionality of Parameter Transfer	nvarchar	1	0
TOPStock Visibility
140	/DSD/SV_MM_DOC	DSD SV Stock Transfer Documents per Tour	4	MJAHR	Material Document Year	nvarchar	4	0
TOPTariffs, Duties and Permits
141	OIH30I	Tracking item	8	MJAHR	Material Document Year	nvarchar	4	0
142	OIHLTR	Excise license tracking pointer file	5	MJAHR	Material Document Year	nvarchar	4	0
143	OIH_J_1BMSEG_NF	Link between Gain and Losses Movements and Nota Fiscal	4	MJAHR	Material Document Year	nvarchar	4	0
TOPTraders and Schedulers Workbench
144	OIGSV	TD Vehicles in Transport/Shipment	55	MJAHR	Material Document Year	nvarchar	4	0
145	OIJ03_LOV	TSW: Table for Left on Vehicle Entries	26	MJAHR	Material Document Year	nvarchar	4	0
146	OIJ03_LOVGLREF	TSW Gain loss/LOV Reference table	10	MJAHR	Material Document Year	nvarchar	4	0
147	OIJ_EL_DFLOW_SUB	TSW - Document flow for sub items	8	MJAHR	Material Document Year	nvarchar	4	0
148	OIJ_EL_DOC_FLOW	OIL TSW: Document flow	10	MJAHR	Material Document Year	nvarchar	4	0
149	OIJ_EL_ELOG_SUB	TSW: Error log for ticketing process at sub item	9	MJAHR	Material Document Year	nvarchar	4	0
150	OIJ_EL_ERROR_LOG	OIL-TSW: Error log for ticketing process	13	MJAHR	Material Document Year	nvarchar	4	0
TOPTransaction Manager
151	VTBMMOR	MM: open requests	3	MJAHR	Material Document Year	nvarchar	4	0
TOPTransportation and Distribution
152	OIGSH	TD Shipment History	13	MJAHR	Material Document Year	nvarchar	4	0
153	OIGSMV	TD Material Balance on Vehicle	9	MJAHR	Material Document Year	nvarchar	4	0
TOPVehicle Management System
154	VLCGISSUE	VELO : Material Document /Goods Issue	6	MJAHR	Material Document Year	nvarchar	4	0
155	VLCGMOVEM	VELO : Material Documents (Other)	6	MJAHR	Material Document Year	nvarchar	4	0
156	VLCGRECEIPT	VELO : Material Document / Goods Receipt	6	MJAHR	Material Document Year	nvarchar	4	0
TOPWarehouse Management
157	LTAK	WM transfer order header	18	MJAHR	Material Document Year	nvarchar	4	0
158	LTBK	Transfer requirement header	24	MJAHR	Material Document Year	nvarchar	4	0
159	LUBU	Posting Change Document	5	MJAHR	Material Document Year	nvarchar	4	0
TOPWaste Management
160	EWA_ORDER_WEIGH	Weighing Data for Waste Disposal Order	7	MJAHR	Material Document Year	nvarchar	4	0
161	EWA_WA_WEIGHPROC	Weighing Transaction	72	MJAHR	Material Document Year	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

161 columns | ERP 6.0 | MJAHR