SAP ABAP View MAT1 (Find Material Number)

Basic Data

View Type
	MAT1
Short Description	Find Material Number
Root table	MARA	General Material Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	MAKT	MARA	MATNR	I
3	MVKE	MARA	MATNR	I
4	MBEW	MARA	MATNR	I
5	MARC	MARA	MATNR	I
6	MLGN	MARA	MATNR	I
7	MAPL	MARA	MATNR	I
8	MAST	MARA	MATNR	I
9	MEAN	MARA	MATNR	I
10	CRVM_B	MARC	WERKS	I
11	CRID	CRVM_B	OBJID	E
12	CRFH	CRID	OBJID	I
13	PKHD	MARA	MATNR	I
14	EINA	MARA	MATNR	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MARA	MANDT		☐	MANDT	☐	Client
2	MATNR	MARA	MATNR		☐	MATNR	☐	Material Number
3	SPRAS	MAKT	SPRAS		☐	SPRAS	☐	Language Key
4	VKORG	MVKE	VKORG		☐	VKORG	☐	Sales Organization
5	VTWEG	MVKE	VTWEG		☐	VTWEG	☐	Distribution Channel
6	BWKEY	MBEW	BWKEY		☐	BWKEY	☐	Valuation area
7	BWTAR	MBEW	BWTAR		☐	BWTAR_D	☐	Valuation type
8	WERKS	MARC	WERKS		☐	WERKS_D	☐	Plant
9	LGNUM	MLGN	LGNUM		☐	LGNUM	☐	Warehouse Number / Warehouse Complex
10	MAPL_WERKS	MAPL	WERKS		☐	WERKS_D	☐	Plant
11	PLNTY	MAPL	PLNTY		☐	PLNTY	☐	Task List Type
12	PLNNR	MAPL	PLNNR		☐	PLNNR	☐	Key for Task List Group
13	PLNAL	MAPL	PLNAL		☐	PLNAL	☐	Group Counter
14	ZKRIZ	MAPL	ZKRIZ		☐	DZKRIZ	☐	Counter for additional criteria
15	ZAEHL	MAPL	ZAEHL		☐	CIM_COUNT	☐	Internal counter
16	MAST_WERKS	MAST	WERKS		☐	WERKS_D	☐	Plant
17	STLAN	MAST	STLAN		☐	STLAN	☐	BOM Usage
18	STLNR	MAST	STLNR		☐	STNUM	☐	Bill of Material
19	STLAL	MAST	STLAL		☐	STALT	☐	Alternative BOM
20	MEINH	MEAN	MEINH		☐	MEINH	☐	Unit of Measure for Display
21	LFNUM	MEAN	LFNUM		☐	LFNUM	☐	Consecutive number
22	FHM_OBJTY	CRVM_B	OBJTY		☐	CR_OBJTY	☐	Object types of the CIM resource
23	FHM_OBJID	CRVM_B	OBJID		☐	CR_OBJID	☐	Object ID of the resource
24	FHM_ZAEHL	CRFH	ZAEHL		☐	CIM_COUNT	☐	Internal counter
25	PKNUM	PKHD	PKNUM		☐	PKNUM	☐	Control cycle number
26	INFNR	EINA	INFNR		☐	INFNR	☐	Number of purchasing info record
27	MAKTX	MAKT	MAKTX		☐	MAKTX	☐	Material description
28	PRODH	MVKE	PRODH		☐	PRODH_D	☐	Product Hierarchy
29	LVOMA	MARA	LVORM		☐	LVOMA	☐	Flag Material for Deletion at Client Level
30	MTART	MARA	MTART		☐	MTART	☐	Material type
31	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
32	BISMT	MARA	BISMT		☐	BISMT	☐	Old material number
33	GROES	MARA	GROES		☐	GROES	☐	Size/dimensions
34	WRKST	MARA	WRKST		☐	WRKST	☐	Basic Material
35	LABOR	MARA	LABOR		☐	LABOR	☐	Laboratory/design office
36	STOFF	MARA	STOFF		☐	STOFF	☐	Hazardous material number
37	SPART	MARA	SPART		☐	SPART	☐	Division
38	TRAGR	MARA	TRAGR		☐	TRAGR	☐	Transportation Group
39	LVOVK	MVKE	LVORM		☐	LVOVK	☐	Ind.: Flag material for deletion at distribution chain level
40	VERSG	MVKE	VERSG		☐	STGMA	☐	Material statistics group
41	BONUS	MVKE	BONUS		☐	BONUS	☐	Volume rebate group
42	PROVG	MVKE	PROVG		☐	PROVG	☐	Commission group
43	PMATN	MVKE	PMATN		☐	PMATN	☐	Pricing Reference Material
44	KONDM	MVKE	KONDM		☐	KONDM	☐	Material Pricing Group
45	KTGRM	MVKE	KTGRM		☐	KTGRM	☐	Account assignment group for this material
46	LVOBA	MBEW	LVORM		☐	LVOBA	☐	Deletion flag for all material data of a valuation type
47	BKLAS	MBEW	BKLAS		☐	BKLAS	☐	Valuation Class
48	BWTTY	MBEW	BWTTY		☐	BWTTY_D	☐	Valuation Category
49	MYPOL	MBEW	MYPOL		☐	MYPOOL	☐	Pool number for LIFO valuation
50	LVOWK	MARC	LVORM		☐	LVOWK	☐	Flag Material for Deletion at Plant Level
51	MAABC	MARC	MAABC		☐	MAABC	☐	ABC indicator
52	EKGRP	MARC	EKGRP		☐	EKGRP	☐	Purchasing group
53	DISMM	MARC	DISMM		☐	DISMM	☐	MRP Type
54	DISPO	MARC	DISPO		☐	DISPO	☐	MRP controller
55	FEVOR	MARC	FEVOR		☐	FEVOR	☐	Production Supervisor
56	LADGR	MARC	LADGR		☐	LADGR	☐	Loading Group
57	LVOLN	MLGN	LVORM		☐	LVOLN	☐	Deletion flag for all material data of a warehouse number
58	KUNNR	MARA	KUNNR		☐	WETTB	☐	Competitor
59	PRDHA	MARA	PRDHA		☐	PRODH_D	☐	Product Hierarchy
60	CADKZ	MARA	CADKZ		☐	CADKZ	☐	CAD Indicator
61	MBRSH	MARA	MBRSH		☐	MBRSH	☐	Industry sector
62	DISGR	MARC	DISGR		☐	DISGR	☐	MRP Group
63	PRCTR	MARC	PRCTR		☐	PRCTR	☐	Profit Center
64	STAWN	MARC	STAWN		☐	STAWN	☐	Commodity Code/Import Code Number for Foreign Trade
65	EAN11	MEAN	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
66	HPEAN	MEAN	HPEAN		☐	HPEAN	☐	Indicator: Main EAN
67	DATUV	MAPL	DATUV		☐	DATUV	☐	Valid-From Date
68	LOEKZ	MAPL	LOEKZ		☐	LKENZ	☐	Deletion Indicator
69	MAKTG	MAKT	MAKTG		☐	MAKTG	☐	Material description in upper case for matchcodes
70	FHM_FGRU1	CRFH	FGRU1		☐	FGRUA	☐	Grouping key 1 for production resources/tools
71	FHM_FGRU2	CRFH	FGRU2		☐	FGRUB	☐	Grouping key 2 for production resources/tools
72	PRVBE	PKHD	PRVBE		☐	PRVBE	☐	Production Supply Area
73	IDNLF	EINA	IDNLF		☐	IDNLF	☐	Material Number Used by Vendor
74	LIFNR	EINA	LIFNR		☐	ELIFN	☐	Vendor's account number
75	ATTYP	MARA	ATTYP		☐	ATTYP	☐	Material Category

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	19971007
SAP Release Created in