USRM3 SAP table for – Material Master User Settings: Retail Organizational Levels

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

SAP USRM3 table

Table USRM3 technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • FIWRK
    Its data type is C (Character String) with field length 4
  • VZWRK
    Its data type is C (Character String) with field length 4
  • ASCHL
    Its data type is C (Character String) with field length 1
  • UNAME : User Name
    Its a key field. Its data type is C (Character String) with field length 12
  • BILDS
    Its a key field. Its data type is C (Character String) with field length 2
  • MTART : Material type
    Its data type is C (Character String) with field length 4
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • LTSNR : Vendor Subrange
    Its data type is C (Character String) with field length 6
  • VKORG : Sales Organization
    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