USRMM SAP (User settings: material master) Pooled Table details

Dictionary Type: Pooled Table
Description: User settings: material master




ABAP Code to SELECT data from USRMM
Related tables to USRMM
Access table USRMM




Pooled Table field list including key, data, relationships and ABAP select examples

USRMM is a standard SAP Pooled Table which is used to store User settings: material master data and is available within R/3 SAP systems depending on the version and release level.

The USRMM table consists of various fields, each holding specific information or linking keys about User settings: material master data available in SAP. These include UNAME (User Name), MBRSH (Industry sector), WERKS (Plant), REF_WERKS (Reference plant).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP USRMM pooled table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
UNAMEUser Name UNAMECHAR12UNAME
MBRSHIndustry sector MBRSHCHAR1T137MBRSHMTP
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
REF_WERKSReference plant REF_WERKSCHAR4T001WWERKSRWK
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
REF_LGORTReference Storage Location REF_LGORTCHAR4T001LLGORTRLG
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
REF_BUKRSReference Company Code REF_BUKRSCHAR4T001BUKRSRBU
BWKEYValuation Area BWKEYCHAR4T001KBWKEYBWK
REF_BWKEYReference valuation area REF_BWKEYCHAR4T001KBWKEYRBK
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
REF_BWTARReference valuation type REF_BWTARCHAR10T149DBWTARRBA
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
REF_VKORGReference sales organization REF_VKORGCHAR4TVKOVKORGRVK
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
REF_VTWEGReference distribution channel REF_VTWEGCHAR2TVTWVTWEGRVT
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
REF_LGNUMReference warehouse number REF_LGNUMCHAR3T300LGNUMRLN
LGTYPStorage Type LGTYPCHAR3T301LGTYPLGTH_T301
REF_LGTYPReference storage type REF_LGTYPCHAR3T301LGTYPRLT
DISPRMaterial: MRP profile DISPRCHAR4MDIPDISPRDPR
PROPRForecast profile PROPRCHAR4MPRPPROPRPPR
XEIA1Indicator: include first Work Scheduling view XBIA1CHAR1XFELD
XEIB1Include Accounting View XBIB1CHAR1XFELD
XEID1Indicator: consider MRP 1 view XBID1CHAR1XFELD
XEID2Indicator: consider 'MRP 2' XBID2CHAR1XFELD
XEIE1Indicator: Consider Purchasing view XBIE1CHAR1XFELD
XEIE2Indicator: consider Purchase Order Text view XBIE2CHAR1XFELD
XEIK1Include Basic Data View XBIK1CHAR1XFELD
XEIL1Indicator: consider 'Storage' view XBIL1CHAR1XFELD
XEIP1Indicator: consider 'forecasting' view XBIP1CHAR1XFELD
XEIQ1Indicator: consider 'quality assurance' view XBIQ1CHAR1XFELD
XEIS1Include 'Warehouse Management' View XBIS1CHAR1XFELD
XEIV1Indicator: consider Sales 1 view XBIV1CHAR1XFELD
XEIV2Indicator: consider Sales 2 view XBIV2CHAR1XFELD
XEIV3Indicator: consider Sales Text view XBIV3CHAR1XFELD
XEIV4Indicator: consider Sales/Plant Data view XBIV4CHAR1XFELD
XEIX1Indicator: consider Plant Stock view XBIX1CHAR1XFELD
XEIZ1Indicator: include Storage Location Stock view XBIZ1CHAR1XFELD
AAUSWIndicator: view selection only on request AAUSWCHAR1XFELDMAU
ASCHLIndicator: org. levels/profiles only on request ASCHLCHAR1XFELDMSL
ABRSHIndicator: hide industry sector on initial screen ABRSHCHAR1XFELDMBR
XEIC1Indicator: take Classification view into account XBIC1CHAR1XFELD
XEIF1Indicator: take Production Resources/Tools view into account XBIF1CHAR1XFELD
XEIG1Indicator: Take 'Costing' view into account XBIG1CHAR1XFELD
XEID3Indicator: Take 'MRP 3' view into account XBID3CHAR1XFELD
XEIA2Indicator: Take 'Work Scheduling 2' View into Account XBIA2CHAR1XFELD
BDREFScreen reference depending on the user BDREFCHAR2BDREF
XEIVEIndicator: consider 'Foreign trade' view XBIVECHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table USRMM using ABAP code

The following ABAP code Example will allow you to do a basic selection on USRMM to SELECT all data from the table
DATA: WA_USRMM TYPE USRMM.

SELECT SINGLE *
FROM USRMM
INTO CORRESPONDING FIELDS OF WA_USRMM
WHERE...

How to access SAP table USRMM

Within an ECC or HANA version of SAP you can also view further information about USRMM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!