SAP ABAP Table MLVSV (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MLVSV	AUSME	T006	MSEHI	REF	C	CN
2	MLVSV	BEZME	T006	MSEHI
3	MLVSV	BLOCK	T338	BLOCK	REF	C	CN
4	MLVSV	BSSKZ	T306	BSSKZ	REF	C	CN
5	MLVSV	BSTME	T006	MSEHI	REF	C	CN
6	MLVSV	BWTTY	T149C	BWTTY	REF	C	CN
7	MLVSV	EPRIO	T434G	EPRIO
8	MLVSV	GEWEI	T006	MSEHI	REF	C	CN
9	MLVSV	LETY1	T307	LETYP	REF	C	CN
10	MLVSV	LETY2	T307	LETYP	REF	C	CN
11	MLVSV	LETY3	T307	LETYP	REF	C	CN
12	MLVSV	LGBKZ	T304	LGBKZ	REF	C	CN
13	MLVSV	LGNUM	T300	LGNUM	KEY	1	CN
14	MLVSV	LHME1	T006	MSEHI	REF	C	CN
15	MLVSV	LHME2	T006	MSEHI	REF	C	CN
16	MLVSV	LHME3	T006	MSEHI	REF	C	CN
17	MLVSV	LTKZA	T305	LGTKZ	REF	C	CN
18	MLVSV	LTKZE	T305	LGTKZ	REF	C	CN
19	MLVSV	LVSME	T006	MSEHI	REF	C	CN
20	MLVSV	MAGRV	TVEGR	MAGRV
21	MLVSV	MANDT	T000	MANDT	KEY	1	CN
22	MLVSV	MEINS	T006	MSEHI	REF	1	CN
23	MLVSV	MMSTA	T141	MMSTA	REF	C	CN
24	MLVSV	MSTAE	T141	MMSTA
25	MLVSV	MTART	T134	MTART	REF	1	CN
26	MLVSV	PLKPT	T301	LGTYP
27	MLVSV	STOFF	MGEF	STOFF
28	MLVSV	VOLEH	T006	MSEHI	REF	C	CN
29	MLVSV	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in