SAP ABAP View MAWEV (Material/Plant/Sales View)

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	MAWEV
Short Description	Material/Plant/Sales View
Root table	MARA	General Material Data

Table

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

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	MLAN	MANDT	JR	EQ			AND	0	0
7	MARA	MATNR	JL	EQ				0	0
8	MLAN	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	WERKS	MARC	WERKS		☐	WERKS_D	☐	Plant
4	ALAND	MLAN	ALAND		☐	ALAND	☐	Departure country (country from which the goods are sent)
5	TRAGR	MARA	TRAGR		☐	TRAGR	☐	Transportation Group
6	DISMM	MARC	DISMM		☐	DISMM	☐	MRP Type
7	ATPKZ	MARC	ATPKZ		☐	ATPKZ	☐	Replacement part
8	LADGR	MARC	LADGR		☐	LADGR	☐	Loading Group
9	VBAMG	MARC	VBAMG		☐	VBAMG	☐	Base quantity for capacity planning in shipping
10	VBEAZ	MARC	VBEAZ		☐	VBEAZ	☐	Shipping processing time
11	VRVEZ	MARC	VRVEZ		☐	VRVEZ	☐	Shipping setup time
12	XCHAR	MARC	XCHAR		☐	XCHAR	☐	Batch management indicator (internal)
13	XCHPF	MARC	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
14	APOKZ	MARC	APOKZ		☐	APOKZ	☐	Indicator: Is material relevant for APO
15	MTVFP	MARC	MTVFP		☐	MTVFP	☐	Checking Group for Availability Check
16	BESKZ	MARC	BESKZ		☐	BESKZ	☐	Procurement Type
17	EISBE	MARC	EISBE		☐	EISBE	☐	Safety stock
18	UMLMC	MARC	UMLMC		☐	UMLME	☐	Stock in transfer (plant to plant)
19	PLIFZ	MARC	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
20	WEBAZ	MARC	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
21	WZEIT	MARC	WZEIT		☐	WZEIT	☐	Total replenishment lead time (in workdays)
22	DZEIT	MARC	DZEIT		☐	DZEIT	☐	In-house production time
23	BEARZ	MARC	BEARZ		☐	BEARZ	☐	Processing time
24	RUEZT	MARC	RUEZT		☐	RUEZT	☐	Setup and teardown time
25	TRANZ	MARC	TRANZ		☐	TRANZ	☐	Interoperation time
26	BWTTY	MARC	BWTTY		☐	BWTTY_D	☐	Valuation Category
27	LVORM	MARC	LVORM		☐	LVOWK	☐	Flag Material for Deletion at Plant Level
28	MINBE	MARC	MINBE		☐	MINBE	☐	Reorder point
29	STAWN	MARC	STAWN		☐	STAWN	☐	Commodity Code/Import Code Number for Foreign Trade
30	HERKL	MARC	HERKL		☐	HERKL	☐	Country of origin of the material
31	HERKR	MARC	HERKR		☐	HERKR	☐	Region of origin of material (non-preferential origin)
32	MTVER	MARC	MTVER		☐	MTVER	☐	Export/import material group
33	PRCTR	MARC	PRCTR		☐	PRCTR	☐	Profit Center
34	MISKZ	MARC	MISKZ		☐	MISKZ	☐	Mixed MRP indicator
35	VRMOD	MARC	VRMOD		☐	VRMOD	☐	Consumption mode
36	VINT1	MARC	VINT1		☐	VINT1	☐	Consumption period: backward
37	VINT2	MARC	VINT2		☐	VINT2	☐	Consumption period: forward
38	SOBSL	MARC	SOBSL		☐	SOBSL	☐	Special procurement type
39	DISGR	MARC	DISGR		☐	DISGR	☐	MRP Group
40	DIBER	MARC	DIBER		☐	DIBER	☐	Indicator: MRP area exists
41	STRGR	MARC	STRGR		☐	STRGR	☐	Planning strategy group
42	SBDKZ	MARC	SBDKZ		☐	SBDKZ	☐	Dependent requirements ind. for individual and coll. reqmts
43	TAXM1	MLAN	TAXM1		☐	TAKLM	☐	Tax Classification of Material
44	TAXM2	MLAN	TAXM2		☐	TAKLM	☐	Tax Classification of Material
45	TAXM3	MLAN	TAXM3		☐	TAKLM	☐	Tax Classification of Material
46	TAXM4	MLAN	TAXM4		☐	TAKLM	☐	Tax Classification of Material
47	TAXM5	MLAN	TAXM5		☐	TAKLM	☐	Tax Classification of Material
48	TAXM6	MLAN	TAXM6		☐	TAKLM	☐	Tax Classification of Material
49	TAXM7	MLAN	TAXM7		☐	TAKLM	☐	Tax Classification of Material
50	TAXM8	MLAN	TAXM8		☐	TAKLM	☐	Tax Classification of Material
51	TAXM9	MLAN	TAXM9		☐	TAKLM	☐	Tax Classification of Material
52	SERNP	MARC	SERNP		☐	SERAIL	☐	Serial Number Profile
53	STDPD	MARC	STDPD		☐	STDPD	☐	Configurable material
54	CUOBJ	MARC	CUOBJ		☐	CUOBM	☐	Internal object number
55	VHART	MARA	VHART		☐	VHIART	☐	Shipping material type
56	FUELG	MARA	FUELG		☐	FUELG	☐	Filling level (by volume)
57	STFAK	MARA	STFAK		☐	STFAK	☐	Stacking factor
58	MAGRV	MARA	MAGRV		☐	MAGRV	☐	Material Group: Packaging Materials
59	KZUMW	MARA	KZUMW		☐	KZUMW	☐	Indicator: Environmentally relevant
60	QMATV	MARC	QMATV		☐	QMATV	☐	Inspection Setup Exists for Material/Plant
61	MFRGR	MARC	MFRGR		☐	MFRGR	☐	Material freight group
62	BASMG	MARC	BASMG		☐	BASMG	☐	Base quantity
63	SERLV	MARA	SERLV		☐	SERLV	☐	Level of Explicitness for Serial Number
64	KZWSM	MARA	KZWSM		☐	KZWSO	☐	Units of measure usage
65	EPRIO	MARC	EPRIO		☐	BF_GROUP	☐	Stock determination group
66	KZEFF	MARA	KZEFF		☐	CC_MTEFF	☐	Assign effectivity parameter values/ override change numbers
67	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
68	UCHKZ	MARC	UCHKZ		☐	UCHKZ	☐	Indicator for Original Batch Management

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