	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

147 columns | ERP 6.0 | MTART

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/CPLM/SWCONF_POS	SW configs : relation POSTP <--> MTART	2	MTART	Material Type	nvarchar	4	0
2	/SCRM/MTART_FIL	Material Type Filter	2	MTART	Material Type	nvarchar	4	0
3	/SMD/MD_____00C3	SID-Tabelle fuer Material Type	3	MTART	Material Type	nvarchar	4	0
4	/SMD/MD_____00U0	SID-Tabelle fuer MRP group	4	MTART	MRP Group	nvarchar	4	0
5	/SMERP/STG_MM001	Data staging - Material master plant view complex table	10	MTART	Material Type	nvarchar	4	0
6	/SMERP/STG_MM002	Data staging - Material storage location view complex table	10	MTART	Material Type	nvarchar	4	0
7	/SMERP/STG_MM003	Data staging - Material UoM view complex table	11	MTART	Material Type	nvarchar	4	0
8	/SMERP/STG_MM004	Data staging - Material warehouse view complex table	10	MTART	Material Type	nvarchar	4	0
9	/SMERP/STG_MM005	Data staging - Material batch view complex table	10	MTART	Material Type	nvarchar	4	0
10	CNV_20551_MATNR	Material numbers scheduled for deletion	5	MTART	Material Type	nvarchar	4	0
11	J_1UF_TAXDEC_SEL	Selections for tax declaration	16	MTART	Material Type	nvarchar	4	0
12	MDG_BS_MAT_MTART	MDG: Pricing Auditing, Filter by Material Type	2	MTART	Material Type	nvarchar	4	0
13	S610E	S610 - Structural information	3	MTART	Material Type	nvarchar	4	0
14	T064S	Stock Mngmt Levels for Inventory Sampling	4	MTART	Material Type	nvarchar	4	0
15	T134W	Initial Status of Batch	3	MTART	Material Type	nvarchar	4	0
16	T258F	CO-PA access control for Product Costing	5	MTART	Material Type	nvarchar	4	0
17	T409	Relationships between task list types and material types	3	MTART	Material Type	nvarchar	4	0
18	T449U	Settings for Collective Display of MRP List	54	MTART	Material Type	nvarchar	4	0
19	TAPOL	Automatic Allocation of Materials to LIFO Pools	3	MTART	Material Type	nvarchar	4	0
20	TMVFU	Scope of Availability Check (Default Values)	2	MTART	Material Type	nvarchar	4	0
21	TNIW5	Lowest Value: Deval. by Rge of Coverage	3	MTART	Material Type	nvarchar	4	0
22	TNIW6	Lowest Value: Deval. for Reasons of Slow/Non-Movement	3	MTART	Material Type	nvarchar	4	0
23	TPTMZ	Item Category Groups per Material Type	2	MTART	Material Type	nvarchar	4	0
24	ZEIMMARA	USING FOR STORING EIM MARA DATAS	10	MTART	Material Type	nvarchar	4	0
25	ZEIMT134T	USING FOR EIM T134T(Material Type Descriptions)	3	MTART	Material Type	nvarchar	4	0
26	ZEIM_LIPS	SD document: Delivery: Item data	59	MTART	Material Type	nvarchar	4	0
27	ZGWPAM_INVENTORY	GWPAM Demo Material Inventory	10	MTART	Material Type	nvarchar	4	0
28	ZSMAT	Materialschlüssel der Fluggesellschaften	4	MTART	Materialart	nvarchar	4	0
TOPAccounting Interface
29	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	237	MTART	Material Type	nvarchar	4	0
30	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	237	MTART	Material Type	nvarchar	4	0
TOPActual CostingMaterial Ledger
31	CKMLMV011	Costing run: Object list	7	MTART	Material Type	nvarchar	4	0
32	CKMLMV011F	Costing Run: Filter Table for Object List	7	MTART	Material Type	nvarchar	4	0
33	CKMVFM_OUT	Output for the Value_Flow_Monitor, see SAP Note 912984	23	MTART	Material Type	nvarchar	4	0
34	FCML_MAT	ML Characteristics for Material (Selection Criteria)	23	MTART	Material Type	nvarchar	4	0
TOPAdditional Material Functions
35	WSDT_MAT_LAYOUT	Customizing for Material Creation	2	MTART	Material Type	nvarchar	4	0
36	WSDT_MAT_MTART	Material Type available in Material Creation	2	MTART	Material Type	nvarchar	4	0
37	WSD_REF_MATERIAL	Reference Materials	2	MTART	Material Type	nvarchar	4	0
TOPAdvertising Management
38	JJTDIEN	IS-M/AM: Service	6	MTART	Material Type	nvarchar	4	0
TOPAgency Business Global Trade
39	WBRP	Agency business: Item	26	MTART	Material Type	nvarchar	4	0
TOPAssortment
40	WRFT_APC_GEN	Operational APC: General Customizing	11	MTART	Default Material Type (Operational APC)	nvarchar	4	0
41	WRF_APC_PABD	Planned Article Basic Data	3	MTART	Material Type	nvarchar	4	0
TOPBalance Sheet Valuation Procedures
42	TNIW5N	Lowest Value: Devaluation by Range of Coverage (w. Version)	5	MTART	Material Type	nvarchar	4	0
43	TNIW5W	Lowest Value: Devaluatn by Range of Cov. for Each Val. Area	3	MTART	Material Type	nvarchar	4	0
44	TNIW6N	Lowest Value: Devaluation by Slow/Non-Movement (w. Version)	5	MTART	Material Type	nvarchar	4	0
45	TNIW6W	Lowest Value: Devaluation for Slow/Non-movement by Val.Area	3	MTART	Material Type	nvarchar	4	0
TOPBasis Components
46	ZMATERIAL_IDES	Material Master(IDES Demo)	4	MTART	Material Type	nvarchar	4	0
TOPBatches
47	TCUDB_PRODUCT	Documentary Batch - Product (Material Type)	2	MTART	Material Type	nvarchar	4	0
TOPClinical System
48	TN2MATKLAS	IS-H*MED: Classification of the Materials	4	MTART	Material Type	nvarchar	4	0
TOPConditions
49	A043	Purchasing Organization/Material Type	5	MTART	Material Type	nvarchar	4	0
TOPConstruction Equipment Management
50	/SAPCEM/EMTLADMA	Default Activity Type for Material	3	MTART	Material Type	nvarchar	4	0
51	J_3GABRMTART	Settlement Indicator in CEM/MM per Material Type	2	MTART	Material Type	nvarchar	4	0
52	J_3GBAMTART	Allowed Material Types per Document Type	3	MTART	Material Type	nvarchar	4	0
53	J_3GBELAMA	Assign Sale/Repurchase for Material Deliveries	3	MTART	Material Type	nvarchar	4	0
54	J_3GERLMTART	Allowed Material Types	2	MTART	Material Type	nvarchar	4	0
55	J_3GLAMTART	Activity Types per Material Type	2	MTART	Material Type	nvarchar	4	0
56	J_3GMTART	CEM/MM Inventory Mgmt per Material Type and Recipient Type	2	MTART	Material Type	nvarchar	4	0
TOPCross-Application Components
57	MMARA	General material data	10	MTART	Material Type	nvarchar	4	0
58	YTSS_MTART_LEIH	TSS: Materialarten ohne Bestellung	2	MTART	Materialart	nvarchar	4	0
TOPData Collection
59	S032	Statistics: Current Stock and Grouping Terms	11	MTART	Material Type	nvarchar	4	0
60	S039	Statistics: Inventory Controlling	13	MTART	Material Type	nvarchar	4	0
61	S039E	S039 - Structural Information	8	MTART	Material Type	nvarchar	4	0
62	S117	Receipt/article	23	MTART	Material Type	nvarchar	4	0
63	S610	BC610 Example info structure	8	MTART	Material Type	nvarchar	4	0
64	S953	BW Vorl.für BON/Artikel S117	23	MTART	Materialart	nvarchar	4	0
TOPData Retention Tool
65	TXW_S_EKPO	Retrieve EKPO from archive	13	MTART	Material Type	nvarchar	4	0
66	TXW_S_LIPS	Retrieve LIPS from archive	22	MTART	Material Type	nvarchar	4	0
TOPDSD Connector
67	/DSD/ME_MAT_TYPE	DSD CN: Material Types	3	MTART	Material Type	nvarchar	4	0
TOPEmpties Management
68	/BEV1/EMMTART	Material Types That Determine Empties	2	MTART	Material Type	nvarchar	4	0
TOPFinancial Accounting
69	/CCEE/SIFIDDVEX	Material types for Exclude	2	MTART	Material Type	nvarchar	4	0
70	ACCTIT	Compressed Data from FI/CO Document	96	MTART	Material Type	nvarchar	4	0
TOPForeign Trade
71	/SAPSLL/TBTCMR3	GTS: BOM Transfer: Exclusion of Material Type - Country	5	MTART	Material Type for Global Trade Services	nvarchar	4	0
72	/SAPSLL/TBTGMR3	GTS: BOM Transfer: Exclusion of Material Type - Global	4	MTART	Material Type for Global Trade Services	nvarchar	4	0
73	/SAPSLL/TBTPMR3	GTS: BOM Transfer: Exclusion of Material Type - Plant	6	MTART	Material Type for Global Trade Services	nvarchar	4	0
TOPIndustry Solution Catch Weight Management
74	/CWM/IDGT_MATTY	Assign Material Types to UoM	2	MTART	Material Type	nvarchar	4	0
75	/CWM/TAB_T134	CWM Material Types	2	MTART	Material Type	nvarchar	4	0
TOPInterface to Terminal Automation System
76	OIKTPIRD	TPI: SD doc. - obsolete - but needed for XPRA ROIKXTPIREL	12	MTART	Material Type	nvarchar	4	0
77	TOIKTRV	LID TAS relevance determination	11	MTART	Material Type	nvarchar	4	0
TOPInventory Management
78	MWXVM07M	Fields: Update Control of Module Pool SAPMM07M	64	MTART	Material Type	nvarchar	4	0
79	MWZVM07M	Fields: Update Control of Module Pool SAPMM07M	64	MTART	Material Type	nvarchar	4	0
80	SBSE	Stock Mngmt Levels for Inventory Sampling	10	MTART	Material Type	nvarchar	4	0
81	T134M	Control of Qty/Value Update	3	MTART	Material Type	nvarchar	4	0
TOPLocalization
82	IDGT_UOM_CONV	UoM Conversion	2	MTART	Material Type	nvarchar	4	0
TOPLogistics - General
83	IVPH_MTART	Pharma IView - material type table	2	MTART	Material Type	nvarchar	4	0
TOPLogistics Basic Data
84	DMF_D_MTART	Relevant Article Types	3	MTART	Material Type	nvarchar	4	0
TOPMaintenance Orders
85	/CUM/CUTYPE	CU: Compatible Unit Type	5	MTART	CU: Material Type for Compatible Units	nvarchar	4	0
86	T418V	Item category proposal for component assignment	2	MTART	Material Type	nvarchar	4	0
TOPMaster Data
87	EWATSPCMPNTWASTE	Service Product Component - Waste	4	MTART	Material Type	nvarchar	4	0
88	MDCOV	Table with Range of Coverage Information	9	MTART	Material Type	nvarchar	4	0
89	MDKP	Header Data for MRP Document	20	MTART	Material Type	nvarchar	4	0
90	MDKPDB	Header Data for MRP Document	21	MTART	Material Type	nvarchar	4	0
91	T438M	Control Parameter for MRP -Material Level-	3	MTART	MRP Group	nvarchar	4	0
92	T444B	Settings for Flexible Transaction Calls	16	MTART	Condition for material type	nvarchar	4	0
93	TMW00	MRP Default Values per Material Type	2	MTART	Material Type	nvarchar	4	0
94	U444B	User Settings for Flexible Transaction Calls	19	MTART	Condition for material type	nvarchar	4	0
TOPMaterial Categories
95	/ISDFPS/CMATNRP	Name Prefix for Automatically Generated Material Masters	2	MTART	Material Type	nvarchar	4	0
96	/ISDFPS/CMTART	Material Types That Are Not Loaded as Models for MPO	2	MTART	Material Type	nvarchar	4	0
97	/ISDFPS/CNODMART	Assignment of iPPE Node Types to Material Types	3	MTART	Material Type	nvarchar	4	0
TOPMaterial Master
98	MARA	General Material Data	10	MTART	Material Type	nvarchar	4	0
99	MARA_TMP	File for Incorrect Data in Direct Input	17	MTART	Material Type	nvarchar	4	0
100	MOFF	Outstanding Material Master Records	13	MTART	Material Type	nvarchar	4	0
101	MVRA	Cross-version fields for MARA	10	MTART	Material Type	nvarchar	4	0
102	T134	Material Types	2	MTART	Material Type	nvarchar	4	0
103	T134K	Configurable Material Types	3	MTART	Material Type	nvarchar	4	0
104	T134T	Material Type Descriptions	3	MTART	Material Type	nvarchar	4	0
105	USRM3	Material Master User Settings: Retail Organizational Levels	4	MTART	Material Type	nvarchar	4	0
106	WRF_DISCONT_POS	Worklist Items: Discontinuation for Seasonal Procurement	10	MTART	Material Type	nvarchar	4	0
TOPMaterials Management
107	J_1GVL_WHB003	Valid Materials	2	MTART	Material Type	nvarchar	4	0
108	J_1GVL_WHB013	Analytical ledger material postings after valuation	5	MTART	Material Type	nvarchar	4	0
TOPMedia Product
109	TJPMATTYPLEVEL	IS-M: Assignment of Material Type to Hierarchy Level	2	MTART	Material Type	nvarchar	4	0
110	TJPMATTYPSYNCHRO	IS-M: Material Type Relevant for Product Synchronization	2	MTART	Material Type	nvarchar	4	0
111	TJP_VAL_DATA	Valuation Template for Unit Costs Transfer	2	MTART	Material Type	nvarchar	4	0
TOPMedia Product Sales and Distribution
112	JVSDT134MIX	IS-M: Cross-Plant Mix for Material Type	2	MTART	Material Type	nvarchar	4	0
113	TJKSDSTATHORIZON	IS-M: Horizon for Calculating Statistical Key Figures	2	MTART	Material Type	nvarchar	4	0
114	TJVSD134W	Initial Status of Batch	3	MTART	Material Type	nvarchar	4	0
TOPMerchandise and Assortment Planning
115	TWISPC_MARA	Retail Planning: Materials for Provisional Planning	24	MTART	Material Type	nvarchar	4	0
TOPNetWeaver Enterprise Search
116	ESH_TST_EMP2MART	ES Test Object Employee to MTART Mapping	4	MTART	Material Type	nvarchar	4	0
117	ESH_TST_MAT	ES Test Object Material - Main Data	5	MTART	Material Type	nvarchar	4	0
118	ESH_TST_T134	Test Object Material Type and Authorization Group	3	MTART	Material Type	nvarchar	4	0
TOPPatient Accounting
119	TNM04	IS-H MM: Determine Materials for CO Reposting	4	MTART	Material Type	nvarchar	4	0
TOPPersonnel Administration
120	T5H3G	Assign material type and class to material group	3	MTART	Material type	nvarchar	4	0
TOPProduct Cost Planning
121	KALM	Costing Run: Costing Objects	69	MTART	Material Type	nvarchar	4	0
122	KALO	Costing Run: Costing Objects (KVMK)	64	MTART	Material Type	nvarchar	4	0
TOPProfit Center Accounting
123	KE1_WU_MAT	PCA Where-Used List: Material	8	MTART	Material Type	nvarchar	4	0
124	T8A00	Account Determination for Profit Center Accounting	3	MTART	Material Type	nvarchar	4	0
TOPProfitability Analysis
125	TKEVA03M	Costing Key for Material Type	6	MTART	Material Type	nvarchar	4	0
TOPPurchasing
126	EKPO	Purchasing Document Item	152	MTART	Material Type	nvarchar	4	0
127	T024W_CCP	Plant/Supplying Plant Assignment for Extended Source Determ.	5	MTART	Material Type	nvarchar	4	0
TOPR2-R3 Link
128	LDK05	Communication Record 05 Decentr. WMS: (R/2-ERP): Mat. Master	10	MTART	Material Type	nvarchar	4	0
TOPRecycling Administration Core Functions
129	J_7LC05	REA Data Filter: Material Types	3	MTART	Material Type	nvarchar	4	0
130	J_7LC29	REA Data Filter: Packaging Material Type	3	MTART	Material Type	nvarchar	4	0
131	J_7LV1P	REA Document: Item Data	63	MTART	Material Type	nvarchar	4	0
TOPRemaining Beverage - Obsolete Objects
132	/BEV3/CHCIMATART	CI: Material Type CH	3	MTART	Material Type	nvarchar	4	0
TOPSales Plan
133	RMCP8	Archive Materials	4	MTART	Material Type	nvarchar	4	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
134	NWCHGALDAT	IS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat)	4	MTART	Tipo di materiale	nvarchar	4	0
TOPShipping
135	DVM01	R/2-R/3 Link: R/3 Input Data for Material Master	12	MTART	Material Type	nvarchar	4	0
136	LIPS	SD document: Delivery: Item data	59	MTART	Material Type	nvarchar	4	0
TOPSoftware Management
137	KOTG402	IS-SW Product List Exclusion	4	MTART	Material Type	nvarchar	4	0
138	TPGAC	GG enhancement: Material types representing Product Groups	2	MTART	Material Type	nvarchar	4	0
TOPTariffs, Duties and Permits
139	OIH40	Excise Duty defaulting table GI/GR for production orders	5	MTART	Material Type	nvarchar	4	0
TOPTraders and Schedulers Workbench
140	TOI0_REL_MM	Relevance customizing for MM Documents	17	MTART	Material Type	nvarchar	4	0
141	TOI0_REL_SD	IS-OIL: Relevance customizing for SD Documents	14	MTART	Material Type	nvarchar	4	0
142	TOI0_REL_TC	TSW relevance table for trading contract	18	MTART	Material Type	nvarchar	4	0
TOPWaste Management
143	EHSWAC_EAIMMCAT	Waste-Relevant Material Types	2	MTART	Material Type	nvarchar	4	0
144	TEEWA_BULK_CUSTZ	Bulk Refuse Order Types	5	MTART	Material Type	nvarchar	4	0
145	TEWABEHGRPSD	Allocation of Group Types to Material Types	3	MTART	Material Type	nvarchar	4	0
146	TEWAIBASESD	Allocation of IBASE Categories to Material Types	3	MTART	Material Type	nvarchar	4	0
147	TEWA_EL_006	Allocation: Material Types --> Waste	2	MTART	Material Type	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

147 columns | ERP 6.0 | MTART