USRM1 SAP table for – Material Master User Settings: Organizational Levels

Here we would like to draw your attention to USRM1 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). USRM1 is a SAP standard transparent table used for storing Material Master User Settings: Organizational Levels related data in SAP. It comes under the package MGA.

SAP USRM1 table

Table USRM1 technical data

TableUSRM1
Data storingMaterial Master User Settings: Organizational Levels
ModuleLO
ComponentLO-MD
SAP PackageMGA
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP USRM1 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 USRM1 table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • REF_BUKRS
    Its data type is C (Character String) with field length 4
  • 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
  • UNAME : User Name
    Its a key field. Its data type is C (Character String) with field length 12
  • REF_LGNUM
    Its data type is C (Character String) with field length 3
  • 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
  • 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
  • BDREF
    Its data type is C (Character String) with field length 2
  • SISEL
    Its data type is C (Character String) with field length 1
  • BILDS
    Its a key field. Its data type is C (Character String) with field length 2
  • MBRSH
    Its data type is C (Character String) with field length 1
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • REF_WERKS
    Its data type is C (Character String) with field length 4
  • 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