SAP ABAP View ENT1034 (Material - engineering and design)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ UUDM (Package) EDM: Data Modeler (General)

Basic Data

View Type	D	Database View
Database View	ENT1034
Short Description	Material - engineering and design
Root table	MARA	General Material Data

Entity Type	DM02L
Short text	Material - engineering and design

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	MAKT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	MAKT	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MAKT	MATNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	MARA	MANDT	1	☑	MANDT	☐	Client
2	MATNR	MARA	MATNR	1	☑	MATNR	☐	Material Number
3	MTART	MARA	MTART	1	☑	MTART	☐	Material type
4	MBRSH	MARA	MBRSH	1	☑	MBRSH	☐	Industry sector
5	MATKL	MARA	MATKL	1	☑	MATKL	☐	Material Group
6	MEINS	MARA	MEINS	1	☑	MEINS	☐	Base Unit of Measure
7	LVORM	MARA	LVORM	1	☑	LVOMA	☐	Flag Material for Deletion at Client Level
8	LAEDA	MARA	LAEDA	1	☑	LAEDA	☐	Date of Last Change
9	AENAM	MARA	AENAM	1	☑	AENAM	☐	Name of Person Who Changed Object
10	ERSDA	MARA	ERSDA	1	☑	ERSDA	☐	Created On
11	ERNAM	MARA	ERNAM	1	☑	ERNAM	☐	Name of Person who Created the Object
12	VPSTA	MARA	VPSTA	1	☑	VPSTA	☐	Maintenance status of complete material
13	PSTAT	MARA	PSTAT	1	☑	PSTAT_D	☐	Maintenance status
14	SPRAS	MAKT	SPRAS	1	☑	SPRAS	☐	Language Key
15	MAKTX	MAKT	MAKTX	1	☑	MAKTX	☐	Material description
16	BREIT	MARA	BREIT	1	☑	BREIT	☐	Width
17	HOEHE	MARA	HOEHE	1	☑	HOEHE	☐	Height
18	LAENG	MARA	LAENG	1	☑	LAENG	☐	Length
19	MEABM	MARA	MEABM	1	☑	MEABM	☐	Unit of Dimension for Length/Width/Height
20	BRGEW	MARA	BRGEW	1	☑	BRGEW	☐	Gross weight
21	GEWEI	MARA	GEWEI	1	☑	GEWEI	☐	Weight Unit
22	VOLUM	MARA	VOLUM	1	☑	VOLUM	☐	Volume
23	VOLEH	MARA	VOLEH	1	☑	VOLEH	☐	Volume unit
24	AESZN	MARA	AESZN		☐	AESZN	☐	Document change number (without document management system)
25	BISMT	MARA	BISMT		☐	BISMT	☐	Old material number
26	BLANZ	MARA	BLANZ		☐	BLANZ	☐	Number of sheets (without Document Management system)
27	BLATT	MARA	BLATT		☐	BLATT	☐	Page number of document (without Document Management system)
28	CADKZ	MARA	CADKZ		☐	CADKZ	☐	CAD Indicator
29	FERTH	MARA	FERTH		☐	FERTH	☐	Production/inspection memo
30	FORMT	MARA	FORMT		☐	FORMT	☐	Page Format of Production Memo
31	GROES	MARA	GROES		☐	GROES	☐	Size/dimensions
32	KUNNR	MARA	KUNNR		☐	WETTB	☐	Competitor
33	LABOR	MARA	LABOR		☐	LABOR	☐	Laboratory/design office
34	NORMT	MARA	NORMT		☐	NORMT	☐	Industry Standard Description (such as ANSI or ISO)
35	NTGEW	MARA	NTGEW		☐	NTGEW	☐	Net weight
36	PRDHA	MARA	PRDHA		☐	PRODH_D	☐	Product Hierarchy
37	SPART	MARA	SPART		☐	SPART	☐	Division
38	WRKST	MARA	WRKST		☐	WRKST	☐	Basic Material
39	ZEIAR	MARA	ZEIAR		☐	DZEIAR	☐	Document type (without Document Management system)
40	ZEIFO	MARA	ZEIFO		☐	DZEIFO	☐	Page format of document (without Document Management system)
41	ZEINR	MARA	ZEINR		☐	DZEINR	☐	Document number (without document management system)
42	ZEIVR	MARA	ZEIVR		☐	DZEIVR	☐	Document version (without Document Management system)

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	20140121
SAP Release Created in