SAP ABAP Table MARAV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MARAV	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MARAV	BEHVO	T144	BEHVO	REF	C	CN
2	MARAV	BMATN	MARA	MATNR
3	MARAV	BSTME	T006	MSEHI	REF	C	CN
4	MARAV	BWSCL	TMBW1	BWSCL	REF	1	CN
5	MARAV	COMMODITY	TBAC_PHYSCOMM	COMMODITY	REF
6	MARAV	COMPL	TCSCP_COMP_LVL	COMP_LEVEL
7	MARAV	EKWSL	T405	EKWSL	REF	C	CN
8	MARAV	ERGEI	T006	MSEHI	REF	C	CN
9	MARAV	ERVOE	T006	MSEHI	REF	C	CN
10	MARAV	ETIAG	TWEA	ARTGR
11	MARAV	ETIAR	T6WP3	ETIAR	REF	C	CN
12	MARAV	ETIFO	T6WP4	ETIFO	REF	C	CN
13	MARAV	EXTWG	TWEW	EXTWG
14	MARAV	GENNR	MARA	MATNR
15	MARAV	GEWEI	T006	MSEHI	REF	C	CN
16	MARAV	INHME	T006	MSEHI
17	MARAV	KOSCH	T190S	KOSCH
18	MARAV	KUNNR	V_KNA1WETT	KUNNR	REF	C	CN
19	MARAV	LABOR	T024L	LABOR	REF	C	CN
20	MARAV	MAGRV	TVEGR	MAGRV
21	MARAV	MANDT	T000	MANDT	KEY	1	CN
22	MARAV	MATKL	T023	MATKL	REF	C	CN
23	MARAV	MBRSH	T137	MBRSH	REF	C	CN
24	MARAV	MEABM	T006	MSEHI	REF	C	CN
25	MARAV	MEDIUM	T372M	MEDIU
26	MARAV	MEINS	T006	MSEHI	REF	1	CN
27	MARAV	MFRNR	LFA1	LIFNR
28	MARAV	MPROF	TMPPF	MPROF
29	MARAV	MSTAE	T141	MMSTA
30	MARAV	MSTAV	TVMS	VMSTA
31	MARAV	MTART	T134	MTART	REF	1	CN
32	MARAV	MTPOS_MARA	TPTM	MTPOS
33	MARAV	NUMTP	TNTP	NUMTP	REF	C	CN
34	MARAV	PLGTP	TWPT	PLGTP
35	MARAV	PMATA	MARA	MATNR
36	MARAV	PRDHA	T179	PRODH	REF	C	CN
37	MARAV	PROFL	TDG41	PROFL
38	MARAV	RAUBE	T142	RAUBE	REF	C	CN
39	MARAV	RBNRM	T352B	RBNR
40	MARAV	RMATP	MARA	MATNR
41	MARAV	SAITY	T6WSA	SAITY
42	MARAV	SATNR	MARA	MATNR
43	MARAV	SPART	TSPA	SPART	REF	C	CN
44	MARAV	SPRAS	T002	SPRAS	KEY	1	CN
45	MARAV	STOFF	MGEF	STOFF
46	MARAV	TAKLV	TSKM	TAXKM
47	MARAV	TEMPB	T143	TEMPB	REF	C	CN
48	MARAV	TRAGR	TTGR	TRAGR	REF	C	CN
49	MARAV	VHART	TVTY	TRATY
50	MARAV	VOLEH	T006	MSEHI	REF	C	CN
51	MARAV	WRKST	TWSPR	WRKST

History

Last changed by/on	SAP	20140121
SAP Release Created in