SAP Table MVGT
Material Data for Each Storage Type
MVGT (Material Data for Each Storage Type) 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 MVGT to other SAP tables.
MVGT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | MLGN | CHAR | 3 | 0 | ||||||
| LGTYP | Storage Type | LGTYP | T301 | CHAR | 3 | 0 | ||||||
| LVORM | Deletion flag for all material data of a storage type | LVOLT | CHAR | 1 | 0 |
Possible values
|
||||||
| LGPLA | Storage Bin | LGPLA | LAGP | CHAR | 10 | 0 | ||||||
| LPMAX | Maximum storage bin quantity | MLGT_LPMAX | QUAN | 13 | 3 | |||||||
| LPMIN | Minimum storage bin quantity | MLGT_LPMIN | QUAN | 13 | 3 | |||||||
| MAMNG | Control quantity | MLGT_MAMNG | QUAN | 13 | 3 | |||||||
| NSMNG | Replenishment quantity | MLGT_NSMNG | QUAN | 13 | 3 | |||||||
| KOBER | Picking Area | KOBER | T30A | CHAR | 3 | 0 | ||||||
| RDMNG | Rounding qty | MLGT_RDMNG | QUAN | 13 | 3 | |||||||
MVGT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MVGT | KOBER | SYST | MANDT | T30A | WM Picking Areas | MANDT |
| MVGT | KOBER | MLGT | LGNUM | T30A | WM Picking Areas | LGNUM |
| MVGT | KOBER | MLGT | LGTYP | T30A | WM Picking Areas | LGTYP |
| MVGT | KOBER | MVGT | KOBER | T30A | WM Picking Areas | KOBER |
| MVGT | LGNUM | MVGT | MANDT | MLGN | Material Data for Each Warehouse Number | MANDT |
| MVGT | LGNUM | MVGT | MATNR | MLGN | Material Data for Each Warehouse Number | MATNR |
| MVGT | LGNUM | MVGT | LGNUM | MLGN | Material Data for Each Warehouse Number | LGNUM |
| MVGT | LGPLA | MLGN | LGNUM | LAGP | Storage bins | LGNUM |
| MVGT | LGPLA | MVGT | LGTYP | LAGP | Storage bins | LGTYP |
| MVGT | LGPLA | MVGT | LGPLA | LAGP | Storage bins | LGPLA |
| MVGT | LGPLA | MVGT | MANDT | LAGP | Storage bins | MANDT |
| MVGT | LGTYP | MVGT | LGTYP | T301 | WM Storage Types | LGTYP |
| MVGT | LGTYP | MVGT | MANDT | T301 | WM Storage Types | MANDT |
| MVGT | LGTYP | MVGT | LGNUM | T301 | WM Storage Types | LGNUM |
| MVGT | MANDT | MVGT | MANDT | T000 | Clients | MANDT |
| MVGT | MATNR | MVGT | MANDT | MARA | General Material Data | MANDT |
| MVGT | MATNR | MVGT | MATNR | MARA | General Material Data | MATNR |
