0RT_AVRSPRD_ATTR

Product Assignment to Assortment Version | #ATTR | Extraction method: F2 | Delta: AIE | Component: Master Data Retail
Tables used: MALG, WRF_LMVF_ASGMT → show details
Column Name Description
MANDT FK Client
MATNR FK Material Number
MEINH FK Unit of Measure for Display
LAYGR FK Layout Module
LMNUM Sequence number in the layout module
Column Name Description
Column Name Description
📏 Unit of Measure for Display (MEINH):
FACIN Number of materials placed next to one another
FRONT Number of materials positioned over one another
SHQNM Maximum shelf quantity
SHQNO Optimum shelf quantity
PREQN Presentation quantity
Column Name Description
Column Name Description
Column Name Description Domain name
ASORT Assortment ASORT
TISTP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
SORF1 Sort sequence number in layout module NUMC10
SHELF Shelf Section NUMC10
FIX_ID Fixture ID CHAR10
LABEL_NUM_VALUE Number of labels WRF_NUMBER_LABEL
Master Data Relations Join Conditions
Label Type Check
  • Label type
  • Client
  • 0RT_AVRSPRD_ATTR.LABEL_TYPE_CODE == T6WP3.ETIAR
  • 0RT_AVRSPRD_ATTR.MANDT == T6WP3.MANDT
Layout Module
  • Layout Module
  • Client
  • 0RT_AVRSPRD_ATTR.LAYGR == TWML.LAYGR
  • 0RT_AVRSPRD_ATTR.MANDT == TWML.MANDT
Layout Module Version
  • Layout Module
  • Layout Module Version
  • Client
  • 0RT_AVRSPRD_ATTR.LAYGR == WLMV.LAYGR
  • 0RT_AVRSPRD_ATTR.LMVER == WLMV.LAYMOD_VER
  • 0RT_AVRSPRD_ATTR.MANDT == WLMV.MANDT
Client 0RT_AVRSPRD_ATTR.MANDT == T000.MANDT
Material Number
  • 0RT_AVRSPRD_ATTR.MANDT == MARA.MANDT
  • 0RT_AVRSPRD_ATTR.MATNR == MARA.MATNR
Units of measure
  • Material Number
  • Unit of Measure for Display
  • 0RT_AVRSPRD_ATTR.MANDT == MARM.MANDT
  • 0RT_AVRSPRD_ATTR.MATNR == MARM.MATNR
  • 0RT_AVRSPRD_ATTR.MEINH == MARM.MEINH