SAP Table MALG
Assignment of Layout Modules to Materials
MALG (Assignment of Layout Modules to Materials) 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 MALG to other SAP tables.
MALG table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||
| MEINH | Unit of Measure for Display | MEINH | MARM | UNIT | 3 | 0 | ||||||||
| LAYGR | Layout Module | LAYGR | TWML | CHAR | 10 | 0 | ||||||||
| LMNUM | Sequence number in the layout module | LAYMOD_NUM | NUMC | 6 | 0 | |||||||||
| SORF1 | Sort sequence number in layout module | SORF1 | NUMC | 10 | 0 | |||||||||
| HPLGR | Indicator: Main layout module | HPLGR | CHAR | 1 | 0 |
Possible values
|
||||||||
| FACIN | Number of materials placed next to one another | FACING | QUAN | 13 | 3 | |||||||||
| SHELF | Shelf Section | SHELF_NO | NUMC | 10 | 0 | |||||||||
| LMVER | Layout Module Version | LAYMOD_VER | WLMV | NUMC | 4 | 0 | ||||||||
| FRONT | Number of materials positioned over one another | FACING_VERT | QUAN | 13 | 3 | |||||||||
| SHQNM | Maximum shelf quantity | SHF_QNT_MAX | QUAN | 13 | 3 | |||||||||
| SHQNO | Optimum shelf quantity | SHF_QNT_OPT | QUAN | 13 | 3 | |||||||||
| PREQN | Presentation quantity | PRES_QNT | QUAN | 13 | 3 | |||||||||
| EXFLG | Exclusion Flag | EX_FLAG | CHAR | 1 | 0 |
Possible values
|
||||||||
| LMVAR | Variant for Layout Module Version | LAYMOD_VAR | CHAR | 4 | 0 | |||||||||
| TISTP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | 0 | |||||||||
| OSPSK | OAPC Flag | WRF_OAPC_FLAG | CHAR | 1 | 0 |
Possible values
|
||||||||
| LABEL_TYPE_CODE | Label type | ETIAR | T6WP3 | CHAR | 2 | 0 | ||||||||
| LABEL_NUM_VALUE | Number of labels | WRF_NUMBER_LABEL | NUMC | 2 | 0 | |||||||||
MALG foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MALG | LABEL_TYPE_CODE | MALG | LABEL_TYPE_CODE | T6WP3 | Check Table for Labelling Type | ETIAR |
| MALG | LABEL_TYPE_CODE | MALG | MANDT | T6WP3 | Check Table for Labelling Type | MANDT |
| MALG | LAYGR | MALG | MANDT | TWML | Layout module | MANDT |
| MALG | LAYGR | MALG | LAYGR | TWML | Layout module | LAYGR |
| MALG | LMVER | MALG | LMVER | WLMV | Validity and Status of Layout Module Versions | LAYMOD_VER |
| MALG | LMVER | MALG | MANDT | WLMV | Validity and Status of Layout Module Versions | MANDT |
| MALG | LMVER | MALG | LAYGR | WLMV | Validity and Status of Layout Module Versions | LAYGR |
| MALG | MANDT | MALG | MANDT | T000 | Clients | MANDT |
| MALG | MATNR | MALG | MANDT | MARA | General Material Data | MANDT |
| MALG | MATNR | MALG | MATNR | MARA | General Material Data | MATNR |
| MALG | MEINH | MALG | MANDT | MARM | Units of Measure for Material | MANDT |
| MALG | MEINH | MALG | MATNR | MARM | Units of Measure for Material | MATNR |
| MALG | MEINH | MALG | MEINH | MARM | Units of Measure for Material | MEINH |
