SAP Table MLGN
Material Data for Each Warehouse Number
MLGN (Material Data for Each Warehouse Number) 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 MLGN to other SAP tables.
MLGN 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 | |||||||||||||||||
|
LGNUM
Warehouse Number / Warehouse Complex
|
LGNUM | T300 |
CHAR
|
3 | 0 | |||||||||||||||||
|
LVORM
Deletion flag for all material data of a warehouse number
|
LVOLN |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
LGBKZ
Storage Section Indicators
|
LVS_LGBKZ | T304 |
CHAR
|
3 | 0 | |||||||||||||||||
|
LTKZE
Storage type indicator for stock placement
|
MLGN_LTKZE | T305 |
CHAR
|
3 | 0 | |||||||||||||||||
|
LTKZA
Storage type indicator for stock removal
|
MLGN_LTKZA | T305 |
CHAR
|
3 | 0 | |||||||||||||||||
|
LHMG1
Loading equipment quantity 1
|
LVS_LHMNG1 |
QUAN
|
13 | 3 | ||||||||||||||||||
|
LHMG2
Loading equipment quantity 2
|
LVS_LHMNG2 |
QUAN
|
13 | 3 | ||||||||||||||||||
|
LHMG3
Loading equipment quantity 3
|
LVS_LHMNG3 |
QUAN
|
13 | 3 | ||||||||||||||||||
|
LHME1
Unit of measure for loading equipment quantity 1
|
LHMEH1 | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
LHME2
Unit of measure for loading equipment quantity 2
|
LHMEH2 | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
LHME3
Unit of measure for loading equipment quantity 3
|
LHMEH3 | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
LETY1
1st storage unit type
|
LVS_LETYP1 | T307 |
CHAR
|
3 | 0 | |||||||||||||||||
|
LETY2
2nd storage unit type
|
LVS_LETYP2 | T307 |
CHAR
|
3 | 0 | |||||||||||||||||
|
LETY3
3rd storage unit type
|
LVS_LETYP3 | T307 |
CHAR
|
3 | 0 | |||||||||||||||||
|
LVSME
Warehouse Management Unit of Measure
|
LVS_LVSME | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
KZZUL
Indicator: Allow addition to existing stock
|
MLGN_KZZUL |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
BLOCK
Bulk storage indicator
|
LVS_BLOCK2 | T338 |
CHAR
|
2 | 0 | |||||||||||||||||
|
KZMBF
Indicator: Message to inventory management
|
KZMBF |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
BSSKZ
Special movement indicator for warehouse management
|
LVS_BSSKZ | T306 |
CHAR
|
1 | 0 | |||||||||||||||||
|
MKAPV
Capacity usage
|
MLGN_MKAPV |
DEC
|
11 | 3 | ||||||||||||||||||
|
BEZME
Unit of measure for capacity consumption
|
MLGN_BEZME | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
PLKPT
Picking storage type for rough-cut and detailed planning
|
MLGN_PLKPT | T301 |
CHAR
|
3 | 0 | |||||||||||||||||
|
VOMEM
Default for unit of measure from material master record
|
MLGN_VOMEM |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
L2SKR
Material relevance for 2-step picking
|
MLGN_L2SKR |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
MLGN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MLGN | BEZME | SY | MANDT |
T006
Units of Measurement
|
MANDT |
| MLGN | BEZME | MLGN | BEZME |
T006
Units of Measurement
|
MSEHI |
| MLGN | BLOCK | MLGN | MANDT |
T338
Bulk Storage Indicators
|
MANDT |
| MLGN | BLOCK | MLGN | LGNUM |
T338
Bulk Storage Indicators
|
LGNUM |
| MLGN | BLOCK | MLGN | BLOCK |
T338
Bulk Storage Indicators
|
BLOCK |
| MLGN | BSSKZ | MLGN | MANDT |
T306
Special Movement Indicators
|
MANDT |
| MLGN | BSSKZ | MLGN | LGNUM |
T306
Special Movement Indicators
|
LGNUM |
| MLGN | BSSKZ | MLGN | BSSKZ |
T306
Special Movement Indicators
|
BSSKZ |
| MLGN | LETY1 | MLGN | LETY1 |
T307
Storage Unit Types
|
LETYP |
| MLGN | LETY1 | MLGN | MANDT |
T307
Storage Unit Types
|
MANDT |
| MLGN | LETY1 | MLGN | LGNUM |
T307
Storage Unit Types
|
LGNUM |
| MLGN | LETY2 | MLGN | MANDT |
T307
Storage Unit Types
|
MANDT |
| MLGN | LETY2 | MLGN | LGNUM |
T307
Storage Unit Types
|
LGNUM |
| MLGN | LETY2 | MLGN | LETY2 |
T307
Storage Unit Types
|
LETYP |
| MLGN | LETY3 | MLGN | LETY3 |
T307
Storage Unit Types
|
LETYP |
| MLGN | LETY3 | MLGN | MANDT |
T307
Storage Unit Types
|
MANDT |
| MLGN | LETY3 | MLGN | LGNUM |
T307
Storage Unit Types
|
LGNUM |
| MLGN | LGBKZ | MLGN | MANDT |
T304
Storage Section Indicators
|
MANDT |
| MLGN | LGBKZ | MLGN | LGNUM |
T304
Storage Section Indicators
|
LGNUM |
| MLGN | LGBKZ | MLGN | LGBKZ |
T304
Storage Section Indicators
|
LGBKZ |
| MLGN | LGNUM | MLGN | MANDT |
T300
WM Warehouse Numbers
|
MANDT |
| MLGN | LGNUM | MLGN | LGNUM |
T300
WM Warehouse Numbers
|
LGNUM |
| MLGN | LHME1 | MLGN | LHME1 |
T006
Units of Measurement
|
MSEHI |
| MLGN | LHME1 | MLGN | MANDT |
T006
Units of Measurement
|
MANDT |
| MLGN | LHME2 | MLGN | MANDT |
T006
Units of Measurement
|
MANDT |
| MLGN | LHME2 | MLGN | LHME2 |
T006
Units of Measurement
|
MSEHI |
| MLGN | LHME3 | MLGN | MANDT |
T006
Units of Measurement
|
MANDT |
| MLGN | LHME3 | MLGN | LHME3 |
T006
Units of Measurement
|
MSEHI |
| MLGN | LTKZA | MLGN | LGNUM |
T305
Storage Type Indicators
|
LGNUM |
| MLGN | LTKZA | MLGN | LTKZA |
T305
Storage Type Indicators
|
LGTKZ |
| MLGN | LTKZA | MLGN | MANDT |
T305
Storage Type Indicators
|
MANDT |
| MLGN | LTKZE | MLGN | MANDT |
T305
Storage Type Indicators
|
MANDT |
| MLGN | LTKZE | MLGN | LGNUM |
T305
Storage Type Indicators
|
LGNUM |
| MLGN | LTKZE | MLGN | LTKZE |
T305
Storage Type Indicators
|
LGTKZ |
| MLGN | LVSME | MLGN | MANDT |
T006
Units of Measurement
|
MANDT |
| MLGN | LVSME | MLGN | LVSME |
T006
Units of Measurement
|
MSEHI |
| MLGN | MANDT | MLGN | MANDT |
T000
Clients
|
MANDT |
| MLGN | MATNR | MLGN | MANDT |
MARA
General Material Data
|
MANDT |
| MLGN | MATNR | MLGN | MATNR |
MARA
General Material Data
|
MATNR |
| MLGN | PLKPT | MLGN | LGNUM |
T301
WM Storage Types
|
LGNUM |
| MLGN | PLKPT | MLGN | PLKPT |
T301
WM Storage Types
|
LGTYP |
| MLGN | PLKPT | SYST | MANDT |
T301
WM Storage Types
|
MANDT |