USRMM SAP table for – User settings: material master

Here we would like to draw your attention to USRMM table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). USRMM is a SAP standard pooled table used for storing User settings: material master related data in SAP. It comes under the package MG.

SAP USRMM table

Table USRMM technical data

TableUSRMM
Data storingUser settings: material master
ModuleLO
ComponentLO-MD
SAP PackageMG
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryPOOLED

SAP USRMM Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in USRMM table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • BWKEY : Valuation area
    Its data type is C (Character String) with field length 4
  • REF_BWKEY
    Its data type is C (Character String) with field length 4
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • REF_BWTAR
    Its data type is C (Character String) with field length 10
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • REF_VKORG
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • REF_VTWEG
    Its data type is C (Character String) with field length 2
  • LGNUM : Warehouse Number / Warehouse Complex
    Its data type is C (Character String) with field length 3
  • REF_LGNUM
    Its data type is C (Character String) with field length 3
  • UNAME : User Name
    Its a key field. Its data type is C (Character String) with field length 12
  • LGTYP : Storage Type
    Its data type is C (Character String) with field length 3
  • REF_LGTYP
    Its data type is C (Character String) with field length 3
  • DISPR
    Its data type is C (Character String) with field length 4
  • PROPR
    Its data type is C (Character String) with field length 4
  • XEIA1
    Its data type is C (Character String) with field length 1
  • XEIB1
    Its data type is C (Character String) with field length 1
  • XEID1
    Its data type is C (Character String) with field length 1
  • XEID2
    Its data type is C (Character String) with field length 1
  • XEIE1
    Its data type is C (Character String) with field length 1
  • XEIE2
    Its data type is C (Character String) with field length 1
  • MBRSH
    Its data type is C (Character String) with field length 1
  • XEIK1
    Its data type is C (Character String) with field length 1
  • XEIL1
    Its data type is C (Character String) with field length 1
  • XEIP1
    Its data type is C (Character String) with field length 1
  • XEIQ1
    Its data type is C (Character String) with field length 1
  • XEIS1
    Its data type is C (Character String) with field length 1
  • XEIV1
    Its data type is C (Character String) with field length 1
  • XEIV2
    Its data type is C (Character String) with field length 1
  • XEIV3
    Its data type is C (Character String) with field length 1
  • XEIV4
    Its data type is C (Character String) with field length 1
  • XEIX1
    Its data type is C (Character String) with field length 1
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • XEIZ1
    Its data type is C (Character String) with field length 1
  • AAUSW
    Its data type is C (Character String) with field length 1
  • ASCHL
    Its data type is C (Character String) with field length 1
  • ABRSH
    Its data type is C (Character String) with field length 1
  • XEIC1
    Its data type is C (Character String) with field length 1
  • XEIF1
    Its data type is C (Character String) with field length 1
  • XEIG1
    Its data type is C (Character String) with field length 1
  • XEID3
    Its data type is C (Character String) with field length 1
  • XEIA2
    Its data type is C (Character String) with field length 1
  • BDREF
    Its data type is C (Character String) with field length 2
  • REF_WERKS
    Its data type is C (Character String) with field length 4
  • XEIVE
    Its data type is C (Character String) with field length 1
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • REF_LGORT
    Its data type is C (Character String) with field length 4
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • REF_BUKRS
    Its data type is C (Character String) with field length 4