USRM1

Material Master User Settings: Organizational Levels | #masterdata | Component: Material Master
Column Name Description
MANDT FK Client
UNAME FK User name
BILDS FK Screen Sequence Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
AAUSW Indicator: view selection only on request Show values
ASCHL Indicator: org. levels/profiles only on request Show values
ABRSH Indicator: hide industry sector on initial screen Show values
SISEL Create Views Selected Show values
Column Name Description Domain name
MBRSH Deactivated CHAR1
BDREF Inactive: no longer used BDREF
Master Data Relations Join Conditions
Screen sequence number
  • Screen Sequence Number
  • Client
  • USRM1.BILDS == T133S.BILDS
  • USRM1.MANDT == T133S.MANDT
Company code
  • USRM1.MANDT == T001.MANDT
  • USRM1.BUKRS == T001.BUKRS
Valuation area
  • Valuation area
  • Client
  • USRM1.BWKEY == T001K.BWKEY
  • USRM1.MANDT == T001K.MANDT
Valuation type
  • USRM1.MANDT == T149D.MANDT
  • USRM1.BWTAR == T149D.BWTAR
MRP profiles
  • USRM1.MANDT == MDIP.MANDT
  • USRM1.DISPR == MDIP.DISPR
Warehouse number
  • Warehouse Number / Warehouse Complex
  • Client
  • USRM1.LGNUM == T300.LGNUM
  • USRM1.MANDT == T300.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • USRM1.LGORT == T001L.LGORT
  • USRM1.MANDT == T001L.MANDT
  • USRM1.WERKS == T001L.WERKS
Storage type
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Type
  • USRM1.LGNUM == T301.LGNUM
  • USRM1.MANDT == T301.MANDT
  • USRM1.LGTYP == T301.LGTYP
Client USRM1.MANDT == T000.MANDT
Forecast profiles
  • USRM1.MANDT == MPRP.MANDT
  • USRM1.PROPR == MPRP.PROPR
Company code
  • USRM1.MANDT == T001.MANDT
  • USRM1.REF_BUKRS == T001.BUKRS
Valuation area
  • Reference valuation area
  • Client
  • USRM1.REF_BWKEY == T001K.BWKEY
  • USRM1.MANDT == T001K.MANDT
Reference valuation type
  • USRM1.MANDT == T149D.MANDT
  • USRM1.REF_BWTAR == T149D.BWTAR
Warehouse number
  • Reference warehouse number
  • Client
  • USRM1.REF_LGNUM == T300.LGNUM
  • USRM1.MANDT == T300.MANDT
Storage location
  • Reference Storage Location
  • Client
  • Reference plant
  • USRM1.REF_LGORT == T001L.LGORT
  • USRM1.MANDT == T001L.MANDT
  • USRM1.REF_WERKS == T001L.WERKS
Storage type
  • Reference warehouse number
  • Client
  • Reference storage type
  • USRM1.REF_LGNUM == T301.LGNUM
  • USRM1.MANDT == T301.MANDT
  • USRM1.REF_LGTYP == T301.LGTYP
Sales organization
  • USRM1.MANDT == TVKO.MANDT
  • USRM1.REF_VKORG == TVKO.VKORG
Distribution channel
  • Reference distribution channel
  • Client
  • USRM1.REF_VTWEG == TVTW.VTWEG
  • USRM1.MANDT == TVTW.MANDT
Plant
  • USRM1.MANDT == T001W.MANDT
  • USRM1.REF_WERKS == T001W.WERKS
User name
  • USRM1.MANDT == USR02.MANDT
  • USRM1.UNAME == USR02.BNAME
Sales organization
  • USRM1.MANDT == TVKO.MANDT
  • USRM1.VKORG == TVKO.VKORG
Distribution channel
  • Distribution Channel
  • Client
  • USRM1.VTWEG == TVTW.VTWEG
  • USRM1.MANDT == TVTW.MANDT
Plant
  • USRM1.MANDT == T001W.MANDT
  • USRM1.WERKS == T001W.WERKS