SAP Table MLGT
Material Data for Each Storage Type
MLGT (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 MLGT to other SAP tables.
MLGT 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 | |||||||
MLGT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MLGT | KOBER | SYST | MANDT | T30A | WM Picking Areas | MANDT |
| MLGT | KOBER | MLGT | LGNUM | T30A | WM Picking Areas | LGNUM |
| MLGT | KOBER | MLGT | LGTYP | T30A | WM Picking Areas | LGTYP |
| MLGT | KOBER | MLGT | KOBER | T30A | WM Picking Areas | KOBER |
| MLGT | LGNUM | MLGT | MATNR | MLGN | Material Data for Each Warehouse Number | MATNR |
| MLGT | LGNUM | MLGT | LGNUM | MLGN | Material Data for Each Warehouse Number | LGNUM |
| MLGT | LGNUM | MLGT | MANDT | MLGN | Material Data for Each Warehouse Number | MANDT |
| MLGT | LGPLA | MLGT | LGTYP | LAGP | Storage bins | LGTYP |
| MLGT | LGPLA | MLGT | LGPLA | LAGP | Storage bins | LGPLA |
| MLGT | LGPLA | MLGT | MANDT | LAGP | Storage bins | MANDT |
| MLGT | LGPLA | MLGN | LGNUM | LAGP | Storage bins | LGNUM |
| MLGT | LGTYP | MLGT | LGTYP | T301 | WM Storage Types | LGTYP |
| MLGT | LGTYP | MLGT | MANDT | T301 | WM Storage Types | MANDT |
| MLGT | LGTYP | MLGT | LGNUM | T301 | WM Storage Types | LGNUM |
| MLGT | MANDT | MLGT | MANDT | T000 | Clients | MANDT |
| MLGT | MATNR | MLGT | MANDT | MARA | General Material Data | MANDT |
| MLGT | MATNR | MLGT | MATNR | MARA | General Material Data | MATNR |
