SAP ABAP View MARAV (View Table for Logical DB MGM)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

View Type	D	Database View
Database View	MARAV
Short Description	View Table for Logical DB MGM
Root table	MARA	General Material Data

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		☐	MANDT	☐	Client
2	MATNR	MARA	MATNR		☐	MATNR	☐	Material Number
3	SPRAS	MAKT	SPRAS		☐	SPRAS	☐	Language Key
4	ERSDA	MARA	ERSDA		☐	ERSDA	☐	Created On
5	ERNAM	MARA	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
6	LAEDA	MARA	LAEDA		☐	LAEDA	☐	Date of Last Change
7	AENAM	MARA	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
8	VPSTA	MARA	VPSTA		☐	VPSTA	☐	Maintenance status of complete material
9	PSTAT	MARA	PSTAT		☐	PSTAT_D	☐	Maintenance status
10	LVORM	MARA	LVORM		☐	LVOMA	☐	Flag Material for Deletion at Client Level
11	MTART	MARA	MTART		☐	MTART	☐	Material type
12	MBRSH	MARA	MBRSH		☐	MBRSH	☐	Industry sector
13	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
14	BISMT	MARA	BISMT		☐	BISMT	☐	Old material number
15	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
16	BSTME	MARA	BSTME		☐	BSTME	☐	Order unit
17	ZEINR	MARA	ZEINR		☐	DZEINR	☐	Document number (without document management system)
18	ZEIAR	MARA	ZEIAR		☐	DZEIAR	☐	Document type (without Document Management system)
19	ZEIVR	MARA	ZEIVR		☐	DZEIVR	☐	Document version (without Document Management system)
20	ZEIFO	MARA	ZEIFO		☐	DZEIFO	☐	Page format of document (without Document Management system)
21	AESZN	MARA	AESZN		☐	AESZN	☐	Document change number (without document management system)
22	BLATT	MARA	BLATT		☐	BLATT	☐	Page number of document (without Document Management system)
23	BLANZ	MARA	BLANZ		☐	BLANZ	☐	Number of sheets (without Document Management system)
24	FERTH	MARA	FERTH		☐	FERTH	☐	Production/inspection memo
25	FORMT	MARA	FORMT		☐	FORMT	☐	Page Format of Production Memo
26	GROES	MARA	GROES		☐	GROES	☐	Size/dimensions
27	WRKST	MARA	WRKST		☐	WRKST	☐	Basic Material
28	NORMT	MARA	NORMT		☐	NORMT	☐	Industry Standard Description (such as ANSI or ISO)
29	LABOR	MARA	LABOR		☐	LABOR	☐	Laboratory/design office
30	EKWSL	MARA	EKWSL		☐	EKWSL	☐	Purchasing Value Key
31	BRGEW	MARA	BRGEW		☐	BRGEW	☐	Gross weight
32	NTGEW	MARA	NTGEW		☐	NTGEW	☐	Net weight
33	GEWEI	MARA	GEWEI		☐	GEWEI	☐	Weight Unit
34	VOLUM	MARA	VOLUM		☐	VOLUM	☐	Volume
35	VOLEH	MARA	VOLEH		☐	VOLEH	☐	Volume unit
36	BEHVO	MARA	BEHVO		☐	BEHVO	☐	Container requirements
37	RAUBE	MARA	RAUBE		☐	RAUBE	☐	Storage conditions
38	TEMPB	MARA	TEMPB		☐	TEMPB	☐	Temperature conditions indicator
39	DISST	MARA	DISST		☐	DISST	☐	Low-level code
40	TRAGR	MARA	TRAGR		☐	TRAGR	☐	Transportation Group
41	STOFF	MARA	STOFF		☐	STOFF	☐	Hazardous material number
42	SPART	MARA	SPART		☐	SPART	☐	Division
43	EAN11	MARA	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
44	NUMTP	MARA	NUMTP		☐	NUMTP	☐	Category of International Article Number (EAN)
45	LAENG	MARA	LAENG		☐	LAENG	☐	Length
46	BREIT	MARA	BREIT		☐	BREIT	☐	Width
47	HOEHE	MARA	HOEHE		☐	HOEHE	☐	Height
48	MEABM	MARA	MEABM		☐	MEABM	☐	Unit of Dimension for Length/Width/Height
49	PRDHA	MARA	PRDHA		☐	PRODH_D	☐	Product Hierarchy
50	KUNNR	MARA	KUNNR		☐	WETTB	☐	Competitor
51	AEKLK	MARA	AEKLK		☐	CK_AEKLK	☐	Stock transfer net change costing
52	CADKZ	MARA	CADKZ		☐	CADKZ	☐	CAD Indicator
53	QMPUR	MARA	QMPUR		☐	QMPUR	☐	QM in procurement is active
54	ETIFO	MARA	ETIFO		☐	ETIFO	☐	Label form
55	ETIAR	MARA	ETIAR		☐	ETIAR	☐	Label type
56	ERGEW	MARA	ERGEW		☐	ERGEW	☐	Allowed packaging weight
57	ERGEI	MARA	ERGEI		☐	ERGEI	☐	Unit of weight (allowed packaging weight)
58	ERVOL	MARA	ERVOL		☐	ERVOL	☐	Allowed packaging volume
59	ERVOE	MARA	ERVOE		☐	ERVOE	☐	Volume unit (allowed packaging volume)
60	GEWTO	MARA	GEWTO		☐	GEWTO	☐	Excess weight tolerance for shipping unit
61	VOLTO	MARA	VOLTO		☐	VOLTO	☐	Excess volume tolerance limit during packing
62	VABME	MARA	VABME		☐	VABME	☐	Variable Purchase Order Unit Active
63	MAKTX	MAKT	MAKTX		☐	MAKTX	☐	Material description
64	MAKTG	MAKT	MAKTG		☐	MAKTG	☐	Material description in upper case for matchcodes
65	KZREV	MARA	KZREV		☐	KZREV	☐	Indicator: revision level has been assigned to the material
66	KZKFG	MARA	KZKFG		☐	KZKFG	☐	Configurable Material
67	XCHPF	MARA	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
68	VHART	MARA	VHART		☐	VHIART	☐	Shipping material type
69	FUELG	MARA	FUELG		☐	FUELG	☐	Filling level (by volume)
70	STFAK	MARA	STFAK		☐	STFAK	☐	Stacking factor
71	MAGRV	MARA	MAGRV		☐	MAGRV	☐	Material Group: Packaging Materials
72	BEGRU	MARA	BEGRU		☐	BEGRU	☐	Authorization Group
73	MLGUT	MARA	MLGUT		☐	W_MITLEERG	☐	Empties Bill of Material
74	KZKUP	MARA	KZKUP		☐	KZKUPMAT	☐	Indicator: Material can be co-product
75	KZNFM	MARA	KZNFM		☐	KZNFM	☐	Indicator: The material has a follow-up material
76	TAKLV	MARA	TAKLV		☐	TAKLV	☐	Tax Classification of Material
77	RBNRM	MARA	RBNRM		☐	RBNR	☐	Report layout
78	MHDRZ	MARA	MHDRZ		☐	MHDRZ	☐	Minimum Remaining Shelf Life
79	MHDHB	MARA	MHDHB		☐	MHDHB	☐	Total shelf life
80	MHDLP	MARA	MHDLP		☐	MHDLP	☐	Storage percentage
81	DATAB	MARA	DATAB		☐	DATAB	☐	Valid-From Date
82	LIQDT	MARA	LIQDT		☐	LIQDT	☐	Deletion date
83	SAISJ	MARA	SAISJ		☐	SAISJ	☐	Season Year
84	PLGTP	MARA	PLGTP		☐	PLGTP	☐	Price band category
85	EXTWG	MARA	EXTWG		☐	EXTWG	☐	External material group
86	SATNR	MARA	SATNR		☐	SATNR	☐	Cross-Plant Configurable Material
87	ATTYP	MARA	ATTYP		☐	ATTYP	☐	Material Category
88	PMATA	MARA	PMATA		☐	PMATN	☐	Pricing Reference Material
89	MSTAE	MARA	MSTAE		☐	MSTAE	☐	Cross-Plant Material Status
90	MSTAV	MARA	MSTAV		☐	MSTAV	☐	Cross-distribution-chain material status
91	MSTDE	MARA	MSTDE		☐	MSTDE	☐	Date from which the cross-plant material status is valid
92	MSTDV	MARA	MSTDV		☐	MSTDV	☐	Date from which the X-distr.-chain material status is valid
93	INHME	MARA	INHME		☐	INHME	☐	Content unit
94	INHAL	MARA	INHAL		☐	INHAL	☐	Net contents
95	VPREH	MARA	VPREH		☐	VPREH	☐	Comparison price unit
96	ETIAG	MARA	ETIAG		☐	ETIAG	☐	IS-R Labeling: material grouping (deactivated in 4.0)
97	INHBR	MARA	INHBR		☐	INHBR	☐	Gross contents
98	BWSCL	MARA	BWSCL		☐	BWSCL	☐	Source of Supply
99	KZUMW	MARA	KZUMW		☐	KZUMW	☐	Indicator: Environmentally relevant
100	KOSCH	MARA	KOSCH		☐	KOSCH	☐	Product allocation determination procedure
101	CUOBF	MARA	CUOBF		☐	CUOBM	☐	Internal object number
102	SPROF	MARA	SPROF		☐	SPROF	☐	Pricing profile for variants
103	NRFHG	MARA	NRFHG		☐	NRFHG	☐	Material qualifies for discount in kind
104	MFRPN	MARA	MFRPN		☐	MFRPN	☐	Manufacturer Part Number
105	MFRNR	MARA	MFRNR		☐	MFRNR	☐	Manufacturer number
106	BMATN	MARA	BMATN		☐	MPMAT	☐	Number of firm's own (internal) inventory-managed material
107	MPROF	MARA	MPROF		☐	MPROF	☐	Mfr part profile
108	KZWSM	MARA	KZWSM		☐	KZWSO	☐	Units of measure usage
109	SAITY	MARA	SAITY		☐	SAITY	☐	Categories of seasonal materials
110	PROFL	MARA	PROFL		☐	ADGE_PROFL	☐	Dangerous goods indicator profile
111	IHIVI	MARA	IHIVI		☐	ADGE_IHIVI	☐	Indicator: Highly viscous
112	ILOOS	MARA	ILOOS		☐	ADGE_ILOOS	☐	Indicator: In bulk/liquid
113	SERLV	MARA	SERLV		☐	SERLV	☐	Level of Explicitness for Serial Number
114	KZGVH	MARA	KZGVH		☐	KZGVH	☐	Shipping material is closed packaging
115	XGCHP	MARA	XGCHP		☐	XGCHP	☐	Indicator: Approved batch record required
116	KZEFF	MARA	KZEFF		☐	CC_MTEFF	☐	Assign effectivity parameter values/ override change numbers
117	COMPL	MARA	COMPL		☐	CSCP_COMP_LVL	☐	Material completion level
118	IPRKZ	MARA	IPRKZ		☐	DATTP	☐	Period Indicator for Shelf Life Expiration Date
119	RDMHD	MARA	RDMHD		☐	RDMHD	☐	Rounding rule for calculation of SLED
120	PRZUS	MARA	PRZUS		☐	PRZUS	☐	Indicator: Product composition printed on packaging
121	MTPOS_MARA	MARA	MTPOS_MARA		☐	MTPOS_MARA	☐	General item category group
122	BFLME	MARA	BFLME		☐	BFLME	☐	Generic Material with Logistical Variants
123	MATFI	MARA	MATFI		☐	MATFI	☐	Material Is Locked
124	CMREL	MARA	CMREL		☐	DE_CM_RELEVANCE_FLAG	☐	Relevant for Configuration Management
125	SLED_BBD	MARA	SLED_BBD		☐	SLED_BBD	☐	Expiration Date
126	GTIN_VARIANT	MARA	GTIN_VARIANT		☐	GTIN_VARIANT	☐	Global Trade Item Number Variant
127	GENNR	MARA	GENNR		☐	WSTR_SATNR_PP	☐	Material Number of the Generic Material in Prepack Materials
128	RMATP	MARA	RMATP		☐	PL_RMATP	☐	Reference material for materials packed in same way
129	GDS_RELEVANT	MARA	GDS_RELEVANT		☐	GDS_RELEVANT	☐	Indicator: Global Data Synchronization-Relevant
130	MCOND	MARA	MCOND		☐	DFPS_MCOND	☐	Material Condition Management
131	RETDELC	MARA	RETDELC		☐	DFPS_RETDELC	☐	Return Code
132	LOGLEV_RETO	MARA	LOGLEV_RETO		☐	DFPS_LOGLEV_RETO	☐	Return to Logistics Level
133	NSNID	MARA	NSNID		☐	DFPS_NSNID	☐	NATO Stock Number
134	WEORA	MARA	WEORA		☐	WEORA	☐	Acceptance At Origin
135	IPMIPPRODUCT	MARA	IPMIPPRODUCT		☐	CRM_PRODUCT_ID_IP	☐	ID for an Intellectual Property (CRM Product)
136	MEDIUM	MARA	MEDIUM		☐	MEDIU	☐	Medium
137	COMMODITY	MARA	COMMODITY		☐	TBA_STOEFFCHEN	☐	Physical Commodity

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