SAP table MALG (Assignment of Layout Modules to Materials)

SAP table MALG has 5 primary key fields being MANDT,MATNR,MEINH,LAYGR,LMNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
MEINH Unit of Measure for Display UNIT 3 0 MARM MEINH
LAYGR Layout Module CHAR 10 0 TWML LAYGR
LMNUM Sequence number in the layout module NUMC 6 0 LAYMOD_NUM
SORF1 Sort sequence number in layout module NUMC 10 0 SORF1
HPLGR Indicator: Main layout module CHAR 1 0 HPLGR
FACIN Number of materials placed next to one another QUAN 13 3 FACING
SHELF Shelf Section NUMC 10 0 SHELF_NO
LMVER Layout Module Version NUMC 4 0 WLMV LAYMOD_VER
FRONT Number of materials positioned over one another QUAN 13 3 FACING_VERT
SHQNM Maximum shelf quantity QUAN 13 3 SHF_QNT_MAX
SHQNO Optimum shelf quantity QUAN 13 3 SHF_QNT_OPT
PREQN Presentation quantity QUAN 13 3 PRES_QNT
EXFLG Exclusion Flag CHAR 1 0 EX_FLAG
No exclusion
X Exclusion
LMVAR Variant for Layout Module Version CHAR 4 0 LAYMOD_VAR
TISTP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TIMESTAMP
OSPSK OAPC Flag CHAR 1 0 WRF_OAPC_FLAG
LABEL_TYPE_CODE Label type CHAR 2 0 T6WP3 ETIAR
LABEL_NUM_VALUE Number of labels NUMC 2 0 WRF_NUMBER_LABEL

MALG foreign key relationships

Table Field Check Table Check Field
0 MALG LABEL_TYPE_CODE T6WP3 Check Table for Labelling Type ETIAR
1 MALG LAYGR TWML Layout module MANDT
1 MALG LAYGR TWML Layout module LAYGR
0 MALG LMVER WLMV Validity and Status of Layout Module Versions MANDT
0 MALG LMVER WLMV Validity and Status of Layout Module Versions LAYGR
1 MALG MANDT T000 Clients MANDT
0 MALG MATNR MARA General Material Data MANDT
0 MALG MATNR MARA General Material Data MATNR
1 MALG MEINH MARM Units of Measure for Material MANDT
1 MALG MEINH MARM Units of Measure for Material MEINH