SAP ABAP Table MVRD (Storage Location Data for Material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGVERS (Package) Material version in material master

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MVRD	Table Relationship Diagram
Short Description	Storage Location Data for Material

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MARA
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
4	LGORT	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
5	.INCLUDE	☐				0	0	Data Division MARD
6	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
7	LVORM	☐	LVOLG	XFELD	CHAR	1	0	Flag Material for Deletion at Storage Location Level
8	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
9	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
10	SPERR	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
11	LABST	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
12	UMLME	☐	UMLMD	MENG13V	QUAN	13	3	Stock in transfer (from one storage location to another)
13	INSME	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
14	EINME	☐	EINME	MENG13V	QUAN	13	3	Total Stock of All Restricted Batches
15	SPEME	☐	SPEME	MENG13V	QUAN	13	3	Blocked stock
16	RETME	☐	RETME	MENG13V	QUAN	13	3	Blocked Stock Returns
17	VMLAB	☐	VMLAB	MENG13V	QUAN	13	3	Valuated unrestricted-use stock in previous period
18	VMUML	☐	VMUML	MENG13V	QUAN	13	3	Stock in transfer, previous period
19	VMINS	☐	VMINS	MENG13V	QUAN	13	3	Stock in quality inspection from previous period
20	VMEIN	☐	VMEIN	MENG13V	QUAN	13	3	Restricted-use stock in previous period
21	VMSPE	☐	VMSPE	MENG13V	QUAN	13	3	Blocked stock of previous period
22	VMRET	☐	VMRET	MENG13V	QUAN	13	3	Blocked stock returns, previous period
23	KZILL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
24	KZILQ	☐	KZILQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in current year
25	KZILE	☐	KZILE	INVKZ	CHAR	3	0	Physical inventory indicator for restricted-use stock
26	KZILS	☐	KZILS	INVKZ	CHAR	3	0	Physical inventory indicator for blocked stock
27	KZVLL	☐	KZVLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in previous year
28	KZVLQ	☐	KZVLQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in prev. period
29	KZVLE	☐	KZVLE	INVKZ	CHAR	3	0	Physical inventory ind. for restricted-use stock, prev.pd
30	KZVLS	☐	KZVLS	INVKZ	CHAR	3	0	Phys. inventory indicator for blocked stock in prev. period
31	DISKZ	☐	DISKZ	DISKZ	CHAR	1	0	Storage location MRP indicator
32	LSOBS	☐	LSOBS	SOBSL	CHAR	2	0	Special procurement type at storage location level	T460A
33	LMINB	☐	LMINB	MENG13	QUAN	13	3	Reorder point for storage location MRP
34	LBSTF	☐	LBSTF	MENG13	QUAN	13	3	Replenishment quantity for storage location MRP
35	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
36	EXPPG	☐	EXPPG	EXPPG	CHAR	1	0	Preference indicator (deactivated)
37	EXVER	☐	EXVER	EXVER	CHAR	2	0	Export indicator (deactivated)
38	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
39	KLABS	☐	KLABS	MENG13V	QUAN	13	3	Unrestricted-use consignment stock
40	KINSM	☐	KINSM	MENG13V	QUAN	13	3	Consignment stock in quality inspection
41	KEINM	☐	KEINM	MENG13V	QUAN	13	3	Restricted-use consignment stock
42	KSPEM	☐	KSPEM	MENG13V	QUAN	13	3	Blocked consignment stock
43	DLINL	☐	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
44	PRCTL	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
45	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
46	VKLAB	☐	VKLAB	WERT13N	CURR	13	2	Stock value of a value-only material at sales price
47	VKUML	☐	VKUML	WERT13N	CURR	13	2	Sales value in stock transfer (SLOc to SLoc)
48	LWMKB	☐	MARD_KOBER	KOBER	CHAR	3	0	Picking area for lean WM	*
49	BSKRF	☐	BSKRF	FLTP	FLTP	16	16	Inventory correction factor
50	MDRUE	☐	MDRUE	XFELD	CHAR	1	0	MARDH rec. already exists for per. before last of MARD per.
51	MDJIN	☐	GJINV	GJAHR	NUMC	4	0	Fiscal year of current physical inventory indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MVRD	HERKL	T005	LAND1	REF	C	CN
2	MVRD	LGORT	T001L	LGORT	KEY	1	CN
3	MVRD	LSOBS	T460A	SOBSL
4	MVRD	MANDT	T000	MANDT	KEY	1	CN
5	MVRD	MATNR	MARA	MATNR	KEY	1	CN
6	MVRD	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in