SAP ABAP View MLVSV (Material Master: DB View on WM)

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	MLVSV
Short Description	Material Master: DB View on WM
Root table	MARA	General Material Data

Table

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

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	MLGN	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MLGN	MATNR	JR	EQ			AND	0	0
5	MARA	MANDT	JL	EQ				0	0
6	MARC	MANDT	JR	EQ			AND	0	0
7	MARA	MATNR	JL	EQ				0	0
8	MARC	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	LGNUM	MLGN	LGNUM		☐	LGNUM	☐	Warehouse Number / Warehouse Complex
4	WERKS	MARC	WERKS		☐	WERKS_D	☐	Plant
5	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
6	BSTME	MARA	BSTME		☐	BSTME	☐	Order unit
7	BRGEW	MARA	BRGEW		☐	BRGEW	☐	Gross weight
8	GEWEI	MARA	GEWEI		☐	GEWEI	☐	Weight Unit
9	STOFF	MARA	STOFF		☐	STOFF	☐	Hazardous material number
10	LVOR2	MARC	LVORM		☐	LVOWK	☐	Flag Material for Deletion at Plant Level
11	AUSME	MARC	AUSME		☐	AUSME	☐	Unit of issue
12	XCHPF	MARC	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
13	LVORM	MLGN	LVORM		☐	LVOLN	☐	Deletion flag for all material data of a warehouse number
14	LGBKZ	MLGN	LGBKZ		☐	LVS_LGBKZ	☐	Storage Section Indicators
15	LTKZE	MLGN	LTKZE		☐	MLGN_LTKZE	☐	Storage type indicator for stock placement
16	LTKZA	MLGN	LTKZA		☐	MLGN_LTKZA	☐	Storage type indicator for stock removal
17	LHMG1	MLGN	LHMG1		☐	LVS_LHMNG1	☐	Loading equipment quantity 1
18	LHMG2	MLGN	LHMG2		☐	LVS_LHMNG2	☐	Loading equipment quantity 2
19	LHMG3	MLGN	LHMG3		☐	LVS_LHMNG3	☐	Loading equipment quantity 3
20	LETY1	MLGN	LETY1		☐	LVS_LETYP1	☐	1st storage unit type
21	LETY2	MLGN	LETY2		☐	LVS_LETYP2	☐	2nd storage unit type
22	LETY3	MLGN	LETY3		☐	LVS_LETYP3	☐	3rd storage unit type
23	LVSME	MLGN	LVSME		☐	LVS_LVSME	☐	Warehouse Management Unit of Measure
24	KZZUL	MLGN	KZZUL		☐	MLGN_KZZUL	☐	Indicator: Allow addition to existing stock
25	BLOCK	MLGN	BLOCK		☐	LVS_BLOCK2	☐	Bulk storage indicator
26	KZMBF	MLGN	KZMBF		☐	KZMBF	☐	Indicator: Message to inventory management
27	BSSKZ	MLGN	BSSKZ		☐	LVS_BSSKZ	☐	Special movement indicator for warehouse management
28	XCHAR	MARC	XCHAR		☐	XCHAR	☐	Batch management indicator (internal)
29	MMSTA	MARC	MMSTA		☐	MMSTA	☐	Plant-Specific Material Status
30	MKAPV	MLGN	MKAPV		☐	MLGN_MKAPV	☐	Capacity usage
31	BEZME	MLGN	BEZME		☐	MLGN_BEZME	☐	Unit of measure for capacity consumption
32	MHDRZ	MARA	MHDRZ		☐	MHDRZ	☐	Minimum Remaining Shelf Life
33	MHDHB	MARA	MHDHB		☐	MHDHB	☐	Total shelf life
34	MHDLP	MARA	MHDLP		☐	MHDLP	☐	Storage percentage
35	MLGUT	MARA	MLGUT		☐	W_MITLEERG	☐	Empties Bill of Material
36	PLKPT	MLGN	PLKPT		☐	MLGN_PLKPT	☐	Picking storage type for rough-cut and detailed planning
37	VOLUM	MARA	VOLUM		☐	VOLUM	☐	Volume
38	VOLEH	MARA	VOLEH		☐	VOLEH	☐	Volume unit
39	VOMEM	MLGN	VOMEM		☐	MLGN_VOMEM	☐	Default for unit of measure from material master record
40	L2SKR	MLGN	L2SKR		☐	MLGN_L2SKR	☐	Material relevance for 2-step picking
41	EPRIO	MARC	EPRIO		☐	BF_GROUP	☐	Stock determination group
42	KZWSM	MARA	KZWSM		☐	KZWSO	☐	Units of measure usage
43	MTART	MARA	MTART		☐	MTART	☐	Material type
44	BWTTY	MARC	BWTTY		☐	BWTTY_D	☐	Valuation Category
45	LHME1	MLGN	LHME1		☐	LHMEH1	☐	Unit of measure for loading equipment quantity 1
46	LHME2	MLGN	LHME2		☐	LHMEH2	☐	Unit of measure for loading equipment quantity 2
47	LHME3	MLGN	LHME3		☐	LHMEH3	☐	Unit of measure for loading equipment quantity 3
48	MAGRV	MARA	MAGRV		☐	MAGRV	☐	Material Group: Packaging Materials
49	MSTAE	MARA	MSTAE		☐	MSTAE	☐	Cross-Plant Material Status
50	IPRKZ	MARA	IPRKZ		☐	DATTP	☐	Period Indicator for Shelf Life Expiration Date

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