SAP ABAP View ENT5270 (Product group)

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	ENT5270
Short Description	Product group
Root table	MARA	General Material Data

Entity Type	DM02L
Short text	Product group

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	MARC
3	MARM

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	MARC	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MARC	MATNR	JR	EQ			AND	0	0
5	MARA	MANDT	JL	EQ				0	0
6	MARM	MANDT	JR	EQ			AND	0	0
7	MARA	MATNR	JL	EQ				0	0
8	MARM	MATNR	JR	EQ				0	0

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	ERSDA	MARA	ERSDA		☐	ERSDA	☐	Created On
4	ERNAM	MARA	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
5	LAEDA	MARA	LAEDA		☐	LAEDA	☐	Date of Last Change
6	AENAM	MARA	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
7	VPSTA	MARA	VPSTA		☐	VPSTA	☐	Maintenance status of complete material
8	PSTAT	MARA	PSTAT		☐	PSTAT_D	☐	Maintenance status
9	LVORM	MARA	LVORM		☐	LVOMA	☐	Flag Material for Deletion at Client Level
10	MTART	MARA	MTART		☐	MTART	☐	Material type
11	MBRSH	MARA	MBRSH		☐	MBRSH	☐	Industry sector
12	PRDHA	MARA	PRDHA		☐	PRODH_D	☐	Product Hierarchy
13	DISMM	MARC	DISMM		☐	DISMM	☐	MRP Type
14	DISPO	MARC	DISPO		☐	DISPO	☐	MRP controller
15	PERKZ	MARC	PERKZ		☐	PERKZ	☐	Period indicator
16	GPMKZ	MARC	GPMKZ		☐	GPMKZ	☐	Indicator: material included in rough-cut planning
17	PERIV	MARC	PERIV		☐	PERIV	☐	Fiscal Year Variant
18	MEINH	MARM	MEINH		☐	LRMEI	☐	Alternative Unit of Measure for Stockkeeping Unit
19	UMREZ	MARM	UMREZ		☐	UMREZ	☐	Numerator for Conversion to Base Units of Measure
20	UMREN	MARM	UMREN		☐	UMREN	☐	Denominator for conversion to base units of measure
21	EANNR	MARM	EANNR		☐	EANNR	☐	European Article Number (EAN) - obsolete!!!!!
22	EAN11	MARM	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
23	NUMTP	MARM	NUMTP		☐	NUMTP	☐	Category of International Article Number (EAN)
24	LAENG	MARM	LAENG		☐	LAENG	☐	Length
25	BREIT	MARM	BREIT		☐	BREIT	☐	Width
26	HOEHE	MARM	HOEHE		☐	HOEHE	☐	Height
27	MEABM	MARM	MEABM		☐	MEABM	☐	Unit of Dimension for Length/Width/Height
28	VOLUM	MARM	VOLUM		☐	VOLUM	☐	Volume
29	VOLEH	MARM	VOLEH		☐	VOLEH	☐	Volume unit
30	BRGEW	MARM	BRGEW		☐	BRGEW	☐	Gross weight
31	GEWEI	MARM	GEWEI		☐	GEWEI	☐	Weight Unit
32	WERKS	MARC	WERKS		☐	WERKS_D	☐	Plant

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