SAP Table MARD
Storage Location Data for Material
MARD (Storage Location Data for Material) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link MARD to other SAP tables.
MARD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||
|
WERKS
Plant
|
WERKS_D | MARC |
CHAR
|
4 | 0 | |||||||||
|
LGORT
Storage Location
|
LGORT_D | T001L |
CHAR
|
4 | 0 | |||||||||
|
PSTAT
Maintenance status
|
PSTAT_D |
CHAR
|
15 | 0 | ||||||||||
|
LVORM
Flag Material for Deletion at Storage Location Level
|
LVOLG |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LFGJA
Fiscal Year of Current Period
|
LFGJA |
NUMC
|
4 | 0 | ||||||||||
|
LFMON
Current period (posting period)
|
LFMON |
NUMC
|
2 | 0 | ||||||||||
|
SPERR
Physical Inventory Blocking Indicator
|
SPERR |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LABST
Valuated Unrestricted-Use Stock
|
LABST |
QUAN
|
13 | 3 | ||||||||||
|
UMLME
Stock in transfer (from one storage location to another)
|
UMLMD |
QUAN
|
13 | 3 | ||||||||||
|
INSME
Stock in Quality Inspection
|
INSME |
QUAN
|
13 | 3 | ||||||||||
|
EINME
Total Stock of All Restricted Batches
|
EINME |
QUAN
|
13 | 3 | ||||||||||
|
SPEME
Blocked Stock
|
SPEME |
QUAN
|
13 | 3 | ||||||||||
|
RETME
Blocked Stock Returns
|
RETME |
QUAN
|
13 | 3 | ||||||||||
|
VMLAB
Valuated unrestricted-use stock in previous period
|
VMLAB |
QUAN
|
13 | 3 | ||||||||||
|
VMUML
Stock in Transfer in Previous Period
|
VMUML |
QUAN
|
13 | 3 | ||||||||||
|
VMINS
Stock in Quality Inspection in Previous Period
|
VMINS |
QUAN
|
13 | 3 | ||||||||||
|
VMEIN
Restricted-Use Stock in Previous Period
|
VMEIN |
QUAN
|
13 | 3 | ||||||||||
|
VMSPE
Blocked stock of previous period
|
VMSPE |
QUAN
|
13 | 3 | ||||||||||
|
VMRET
Blocked Stock Returns in Previous Period
|
VMRET |
QUAN
|
13 | 3 | ||||||||||
|
KZILL
Physical inventory indicator for whse stock in current year
|
KZILL |
CHAR
|
3 | 0 | ||||||||||
|
KZILQ
Phys. inventory ind. f. stock in qual. insp. in current year
|
KZILQ |
CHAR
|
3 | 0 | ||||||||||
|
KZILE
Physical inventory indicator for restricted-use stock
|
KZILE |
CHAR
|
3 | 0 | ||||||||||
|
KZILS
Physical inventory indicator for blocked stock
|
KZILS |
CHAR
|
3 | 0 | ||||||||||
|
KZVLL
Physical inventory indicator for stock in previous year
|
KZVLL |
CHAR
|
3 | 0 | ||||||||||
|
KZVLQ
Phys. inventory ind. f. stock in qual. insp. in prev. period
|
KZVLQ |
CHAR
|
3 | 0 | ||||||||||
|
KZVLE
Physical inventory ind. for restricted-use stock, prev.pd
|
KZVLE |
CHAR
|
3 | 0 | ||||||||||
|
KZVLS
Phys. inventory indicator for blocked stock in prev. period
|
KZVLS |
CHAR
|
3 | 0 | ||||||||||
|
DISKZ
Storage location MRP indicator
|
DISKZ |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
LSOBS
Special procurement type at storage location level
|
LSOBS | T460A |
CHAR
|
2 | 0 | |||||||||
|
LMINB
Reorder point for storage location MRP
|
LMINB |
QUAN
|
13 | 3 | ||||||||||
|
LBSTF
Replenishment quantity for storage location MRP
|
LBSTF |
QUAN
|
13 | 3 | ||||||||||
|
HERKL
Country of origin of the material
|
HERKL | T005 |
CHAR
|
3 | 0 | |||||||||
|
EXPPG
Preference indicator (deactivated)
|
EXPPG |
CHAR
|
1 | 0 | ||||||||||
|
EXVER
Export indicator (deactivated)
|
EXVER |
CHAR
|
2 | 0 | ||||||||||
|
LGPBE
Storage Bin
|
LGPBE |
CHAR
|
10 | 0 | ||||||||||
|
KLABS
Unrestricted-Use Consignment Stock
|
KLABS |
QUAN
|
13 | 3 | ||||||||||
|
KINSM
Consignment Stock in Quality Inspection
|
KINSM |
QUAN
|
13 | 3 | ||||||||||
|
KEINM
Restricted-Use Consignment Stock
|
KEINM |
QUAN
|
13 | 3 | ||||||||||
|
KSPEM
Blocked Consignment Stock
|
KSPEM |
QUAN
|
13 | 3 | ||||||||||
|
DLINL
Date of Last Posted Count for Unrestricted-Use Stock
|
DLINL |
DATS
|
8 | 0 | ||||||||||
|
PRCTL
Profit Center
|
PRCTR |
CHAR
|
10 | 0 | ||||||||||
|
ERSDA
Created On
|
ERSDA |
DATS
|
8 | 0 | ||||||||||
|
VKLAB
Stock value of a value-only material at sales price
|
VKLAB |
CURR
|
13 | 2 | ||||||||||
|
VKUML
Sales value in stock transfer (SLOc to SLoc)
|
VKUML |
CURR
|
13 | 2 | ||||||||||
|
LWMKB
Picking area for lean WM
|
MARD_KOBER |
CHAR
|
3 | 0 | ||||||||||
|
BSKRF
Inventory correction factor
|
BSKRF |
FLTP
|
16 | 16 | ||||||||||
|
MDRUE
MARDH rec. already exists for per. before last of MARD per.
|
MDRUE |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
MDJIN
Fiscal year of current physical inventory indicator
|
GJINV |
NUMC
|
4 | 0 | ||||||||||
MARD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MARD | HERKL | MARD | MANDT |
T005
Countries
|
MANDT |
| MARD | HERKL | MARD | HERKL |
T005
Countries
|
LAND1 |
| MARD | LGORT | MARD | MANDT |
T001L
Storage Locations
|
MANDT |
| MARD | LGORT | MARD | WERKS |
T001L
Storage Locations
|
WERKS |
| MARD | LGORT | MARD | LGORT |
T001L
Storage Locations
|
LGORT |
| MARD | LSOBS | MARD | MANDT |
T460A
Special procurement key
|
MANDT |
| MARD | LSOBS | MARD | WERKS |
T460A
Special procurement key
|
WERKS |
| MARD | LSOBS | MARD | LSOBS |
T460A
Special procurement key
|
SOBSL |
| MARD | MANDT | MARD | MANDT |
T000
Clients
|
MANDT |
| MARD | MATNR | MARD | MANDT |
MARA
General Material Data
|
MANDT |
| MARD | MATNR | MARD | MATNR |
MARA
General Material Data
|
MATNR |
| MARD | WERKS | MARD | MANDT |
MARC
Plant Data for Material
|
MANDT |
| MARD | WERKS | MARD | MATNR |
MARC
Plant Data for Material
|
MATNR |
| MARD | WERKS | MARD | WERKS |
MARC
Plant Data for Material
|
WERKS |