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 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
BLOCK | Bulk storage indicator | LVS_BLOCK2 | T338 | CHAR | 2 | 0 | ||||||||||||||||
KZMBF | Indicator: Message to inventory management | KZMBF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
L2SKR | Material relevance for 2-step picking | MLGN_L2SKR | CHAR | 1 | 0 |
Possible values
|
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 |