SAP ABAP View MAPOV (Material view RL-VAS)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

View Type	D	Database View
Database View	MAPOV
Short Description	Material view RL-VAS
Root table	MARA	General Material Data

Table

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

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			AND	0	0
5	MARA	MANDT	JL	EQ				0	0
6	MVKE	MANDT	JR	EQ			AND	0	0
7	MARA	MATNR	JL	EQ				0	0
8	MVKE	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	VKORG	MVKE	VKORG		☐	VKORG	☐	Sales Organization
5	VTWEG	MVKE	VTWEG		☐	VTWEG	☐	Distribution Channel
6	ZIEME	MVKE	VRKME		☐	VRKME	☐	Sales unit
7	BRGEW	MARA	BRGEW		☐	BRGEW	☐	Gross weight
8	NTGEW	MARA	NTGEW		☐	NTGEW	☐	Net weight
9	GEWEI	MARA	GEWEI		☐	GEWEI	☐	Weight Unit
10	VOLUM	MARA	VOLUM		☐	VOLUM	☐	Volume
11	VOLEH	MARA	VOLEH		☐	VOLEH	☐	Volume unit
12	RAUBE	MARA	RAUBE		☐	RAUBE	☐	Storage conditions
13	TEMPB	MARA	TEMPB		☐	TEMPB	☐	Temperature conditions indicator
14	DISST	MARA	DISST		☐	DISST	☐	Low-level code
15	EAN11	MARA	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
16	NUMTP	MARA	NUMTP		☐	NUMTP	☐	Category of International Article Number (EAN)
17	LAENG	MARA	LAENG		☐	LAENG	☐	Length
18	BREIT	MARA	BREIT		☐	BREIT	☐	Width
19	HOEHE	MARA	HOEHE		☐	HOEHE	☐	Height
20	MEABM	MARA	MEABM		☐	MEABM	☐	Unit of Dimension for Length/Width/Height
21	PRDHA	MARA	PRDHA		☐	PRODH_D	☐	Product Hierarchy
22	KUNNR	MARA	KUNNR		☐	WETTB	☐	Competitor
23	VERSG	MVKE	VERSG		☐	STGMA	☐	Material statistics group
24	BONUS	MVKE	BONUS		☐	BONUS	☐	Volume rebate group
25	PROVG	MVKE	PROVG		☐	PROVG	☐	Commission group
26	SKTOF	MVKE	SKTOF		☐	SKTOF	☐	Cash discount indicator
27	VMSTA	MVKE	VMSTA		☐	VMSTA	☐	Distribution-chain-specific material status
28	VMSTD	MVKE	VMSTD		☐	VMSTD	☐	Date from which distr.-chain-spec. material status is valid
29	AUMNG	MVKE	AUMNG		☐	MINAU	☐	Minimum order quantity in base unit of measure
30	LFMNG	MVKE	LFMNG		☐	MINLF	☐	Minimum delivery quantity in delivery note processing
31	EFMNG	MVKE	EFMNG		☐	MINEF	☐	Minimum make-to-order quantity
32	SCHME	MVKE	SCHME		☐	SCHME	☐	Unit of measure of delivery unit
33	SCMNG	MVKE	SCMNG		☐	SCHRT	☐	Delivery unit
34	VRKME	MVKE	VRKME		☐	VRKME	☐	Sales unit
35	SPART	MARA	SPART		☐	SPART	☐	Division
36	ARKTX	MAKT	MAKTX		☐	MAKTX	☐	Material description
37	PRODH	MVKE	PRODH		☐	PRODH_D	☐	Product Hierarchy
38	PMATN	MVKE	PMATN		☐	PMATN	☐	Pricing Reference Material
39	MTPOS	MVKE	MTPOS		☐	MTPOS	☐	Item category group from material master
40	DWERK	MVKE	DWERK		☐	DWERK_EXT	☐	Delivering Plant (Own or External)
41	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
42	TRAGR	MARA	TRAGR		☐	TRAGR	☐	Transportation Group
43	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
44	MTART	MARA	MTART		☐	MTART	☐	Material type
45	KTGRM	MVKE	KTGRM		☐	KTGRM	☐	Account assignment group for this material
46	KONDM	MVKE	KONDM		☐	KONDM	☐	Material Pricing Group
47	LVORM	MVKE	LVORM		☐	LVOVK	☐	Ind.: Flag material for deletion at distribution chain level
48	MVGR1	MVKE	MVGR1		☐	MVGR1	☐	Material group 1
49	MVGR2	MVKE	MVGR2		☐	MVGR2	☐	Material group 2
50	MVGR3	MVKE	MVGR3		☐	MVGR3	☐	Material group 3
51	MVGR4	MVKE	MVGR4		☐	MVGR4	☐	Material group 4
52	MVGR5	MVKE	MVGR5		☐	MVGR5	☐	Material group 5
53	VHART	MARA	VHART		☐	VHIART	☐	Shipping material type
54	FUELG	MARA	FUELG		☐	FUELG	☐	Filling level (by volume)
55	STFAK	MARA	STFAK		☐	STFAK	☐	Stacking factor
56	MAGRV	MARA	MAGRV		☐	MAGRV	☐	Material Group: Packaging Materials
57	ERGEI	MARA	ERGEI		☐	ERGEI	☐	Unit of weight (allowed packaging weight)
58	ERGEW	MARA	ERGEW		☐	ERGEW	☐	Allowed packaging weight
59	ERVOE	MARA	ERVOE		☐	ERVOE	☐	Volume unit (allowed packaging volume)
60	ERVOL	MARA	ERVOL		☐	ERVOL	☐	Allowed packaging volume
61	GEWTO	MARA	GEWTO		☐	GEWTO	☐	Excess weight tolerance for shipping unit
62	VOLTO	MARA	VOLTO		☐	VOLTO	☐	Excess volume tolerance limit during packing
63	PRAT1	MVKE	PRAT1		☐	PRAT1	☐	ID for product attribute 1
64	PRAT2	MVKE	PRAT2		☐	PRAT2	☐	ID for product attribute 2
65	PRAT3	MVKE	PRAT3		☐	PRAT3	☐	ID for product attribute 3
66	PRAT4	MVKE	PRAT4		☐	PRAT4	☐	ID for product attribute 4
67	PRAT5	MVKE	PRAT5		☐	PRAT5	☐	ID for product attribute 5
68	PRAT6	MVKE	PRAT6		☐	PRAT6	☐	ID for product attribute 6
69	PRAT7	MVKE	PRAT7		☐	PRAT7	☐	ID for product attribute 7
70	PRAT8	MVKE	PRAT8		☐	PRAT8	☐	ID for product attribute 8
71	PRAT9	MVKE	PRAT9		☐	PRAT9	☐	ID for product attribute 9
72	PRATA	MVKE	PRATA		☐	PRATA	☐	ID for product attribute 10
73	MLGUT	MARA	MLGUT		☐	W_MITLEERG	☐	Empties Bill of Material
74	KZUMW	MARA	KZUMW		☐	KZUMW	☐	Indicator: Environmentally relevant
75	KOSCH	MARA	KOSCH		☐	KOSCH	☐	Product allocation determination procedure
76	MBRSH	MARA	MBRSH		☐	MBRSH	☐	Industry sector
77	ATTYP	MARA	ATTYP		☐	ATTYP	☐	Material Category
78	KZGVH	MARA	KZGVH		☐	KZGVH	☐	Shipping material is closed packaging
79	MSTAV	MARA	MSTAV		☐	MSTAV	☐	Cross-distribution-chain material status
80	MSTDV	MARA	MSTDV		☐	MSTDV	☐	Date from which the X-distr.-chain material status is valid
81	KZWSM	MARA	KZWSM		☐	KZWSO	☐	Units of measure usage
82	PROFL	MARA	PROFL		☐	ADGE_PROFL	☐	Dangerous goods indicator profile
83	MPROF	MARA	MPROF		☐	MPROF	☐	Mfr part profile
84	SATNR	MARA	SATNR		☐	SATNR	☐	Cross-Plant Configurable Material
85	KZKFG	MARA	KZKFG		☐	KZKFG	☐	Configurable Material
86	MTPOS_MARA	MARA	MTPOS_MARA		☐	MTPOS_MARA	☐	General item category group
87	VAVME	MVKE	VAVME		☐	VAVME	☐	Variable Sales Unit Not Allowed
88	BFLME	MARA	BFLME		☐	BFLME	☐	Generic Material with Logistical Variants
89	PVMSO	MVKE	PVMSO		☐	PVMSO	☐	Material sorting in product proposal

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