SGT_MLGT

Segmentation dependent Material Data for Each Storage Type | #masterdata | Component: Segmentation related data maintenance
Column Name Description
MANDT Client
MATNR FK Material Number
LGNUM FK Warehouse Number / Warehouse Complex
LGTYP FK Storage Type
SGT_SCAT Stock Segment
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
LPMAX Maximum storage bin quantity
LPMIN Minimum storage bin quantity
MAMNG Control quantity
NSMNG Replenishment quantity
RDMNG Rounding qty
Column Name Description
Column Name Description
LVORM Deletion flag for all material data of a storage type Show values
Column Name Description Domain name
Master Data Relations Join Conditions
Picking area
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • Picking Area
  • SGT_MLGT.MANDT == T30A.MANDT
  • SGT_MLGT.LGNUM == T30A.LGNUM
  • SGT_MLGT.LGTYP == T30A.LGTYP
  • SGT_MLGT.KOBER == T30A.KOBER
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • SGT_MLGT.LGNUM == T300.LGNUM
  • SGT_MLGT.MANDT == T300.MANDT
Storage bin
  • Storage Bin
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • SGT_MLGT.MANDT == LAGP.MANDT
  • SGT_MLGT.LGPLA == LAGP.LGPLA
  • SGT_MLGT.LGNUM == LAGP.LGNUM
  • SGT_MLGT.LGTYP == LAGP.LGTYP
Storage Type
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Type
  • SGT_MLGT.LGNUM == T301.LGNUM
  • SGT_MLGT.MANDT == T301.MANDT
  • SGT_MLGT.LGTYP == T301.LGTYP
Material Number
  • Material Number
  • Client
  • SGT_MLGT.MATNR == MARA.MATNR
  • SGT_MLGT.MANDT == MARA.MANDT