MOFF

Outstanding Material Master Records | #masterdata | Component: Material Master
Column Name Description
MANDT Client
STATM FK Maintenance Status of Material Master Record
ERSDA Created On
WERKS FK Plant
VKORG FK Sales Organization
VTWEG FK Distribution Channel
EKORG FK Purchasing organization
BWKEY FK Valuation area
MATNR FK Material Number
LGORT FK Storage location
LGNUM FK Warehouse Number / Warehouse Complex
LGTYP FK Storage Type
Column Name Description
Column Name Description
Column Name Description
ERSDA Created On
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Valuation area
  • Valuation area
  • Client
  • MOFF.BWKEY == T001K.BWKEY
  • MOFF.MANDT == T001K.MANDT
Purchasing organization
  • MOFF.MANDT == T024E.MANDT
  • MOFF.EKORG == T024E.EKORG
Warehouse number
  • Warehouse Number / Warehouse Complex
  • Client
  • MOFF.LGNUM == T300.LGNUM
  • MOFF.MANDT == T300.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • MOFF.LGORT == T001L.LGORT
  • MOFF.MANDT == T001L.MANDT
  • MOFF.WERKS == T001L.WERKS
Storage type
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Type
  • MOFF.LGNUM == T301.LGNUM
  • MOFF.MANDT == T301.MANDT
  • MOFF.LGTYP == T301.LGTYP
Material No.
  • Material Number
  • Client
  • MOFF.MATNR == MARA.MATNR
  • MOFF.MANDT == MARA.MANDT
Industry sector
  • MOFF.MANDT == T137.MANDT
  • MOFF.MBRSH == T137.MBRSH
Material type
  • MOFF.MANDT == T134.MANDT
  • MOFF.MTART == T134.MTART
Material master maintenance status
  • MOFF.MANDT == T132.MANDT
  • MOFF.STATM == T132.STATM
Sales Organization
  • MOFF.MANDT == TVKO.MANDT
  • MOFF.VKORG == TVKO.VKORG
Distribution channel
  • Distribution Channel
  • Client
  • MOFF.VTWEG == TVTW.VTWEG
  • MOFF.MANDT == TVTW.MANDT
Plant
  • MOFF.MANDT == T001W.MANDT
  • MOFF.WERKS == T001W.WERKS