USRMM SAP (User settings: material master) Pooled Table details
Dictionary Type: Pooled Table
Description: User settings: material master
Description: User settings: material master
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 custDisplay/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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
UNAME | User Name | UNAME | CHAR | 12 | UNAME | ||||
MBRSH | Industry sector | MBRSH | CHAR | 1 | T137 | MBRSH | MTP | ||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
REF_WERKS | Reference plant | REF_WERKS | CHAR | 4 | T001W | WERKS | RWK | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
REF_LGORT | Reference Storage Location | REF_LGORT | CHAR | 4 | T001L | LGORT | RLG | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
REF_BUKRS | Reference Company Code | REF_BUKRS | CHAR | 4 | T001 | BUKRS | RBU | ||
BWKEY | Valuation Area | BWKEY | CHAR | 4 | T001K | BWKEY | BWK | ||
REF_BWKEY | Reference valuation area | REF_BWKEY | CHAR | 4 | T001K | BWKEY | RBK | ||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
REF_BWTAR | Reference valuation type | REF_BWTAR | CHAR | 10 | T149D | BWTAR | RBA | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
REF_VKORG | Reference sales organization | REF_VKORG | CHAR | 4 | TVKO | VKORG | RVK | ||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
REF_VTWEG | Reference distribution channel | REF_VTWEG | CHAR | 2 | TVTW | VTWEG | RVT | ||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | T300 | LGNUM | LGN | ||
REF_LGNUM | Reference warehouse number | REF_LGNUM | CHAR | 3 | T300 | LGNUM | RLN | ||
LGTYP | Storage Type | LGTYP | CHAR | 3 | T301 | LGTYP | LGT | H_T301 | |
REF_LGTYP | Reference storage type | REF_LGTYP | CHAR | 3 | T301 | LGTYP | RLT | ||
DISPR | Material: MRP profile | DISPR | CHAR | 4 | MDIP | DISPR | DPR | ||
PROPR | Forecast profile | PROPR | CHAR | 4 | MPRP | PROPR | PPR | ||
XEIA1 | Indicator: include first Work Scheduling view | XBIA1 | CHAR | 1 | XFELD | ||||
XEIB1 | Include Accounting View | XBIB1 | CHAR | 1 | XFELD | ||||
XEID1 | Indicator: consider MRP 1 view | XBID1 | CHAR | 1 | XFELD | ||||
XEID2 | Indicator: consider 'MRP 2' | XBID2 | CHAR | 1 | XFELD | ||||
XEIE1 | Indicator: Consider Purchasing view | XBIE1 | CHAR | 1 | XFELD | ||||
XEIE2 | Indicator: consider Purchase Order Text view | XBIE2 | CHAR | 1 | XFELD | ||||
XEIK1 | Include Basic Data View | XBIK1 | CHAR | 1 | XFELD | ||||
XEIL1 | Indicator: consider 'Storage' view | XBIL1 | CHAR | 1 | XFELD | ||||
XEIP1 | Indicator: consider 'forecasting' view | XBIP1 | CHAR | 1 | XFELD | ||||
XEIQ1 | Indicator: consider 'quality assurance' view | XBIQ1 | CHAR | 1 | XFELD | ||||
XEIS1 | Include 'Warehouse Management' View | XBIS1 | CHAR | 1 | XFELD | ||||
XEIV1 | Indicator: consider Sales 1 view | XBIV1 | CHAR | 1 | XFELD | ||||
XEIV2 | Indicator: consider Sales 2 view | XBIV2 | CHAR | 1 | XFELD | ||||
XEIV3 | Indicator: consider Sales Text view | XBIV3 | CHAR | 1 | XFELD | ||||
XEIV4 | Indicator: consider Sales/Plant Data view | XBIV4 | CHAR | 1 | XFELD | ||||
XEIX1 | Indicator: consider Plant Stock view | XBIX1 | CHAR | 1 | XFELD | ||||
XEIZ1 | Indicator: include Storage Location Stock view | XBIZ1 | CHAR | 1 | XFELD | ||||
AAUSW | Indicator: view selection only on request | AAUSW | CHAR | 1 | XFELD | MAU | |||
ASCHL | Indicator: org. levels/profiles only on request | ASCHL | CHAR | 1 | XFELD | MSL | |||
ABRSH | Indicator: hide industry sector on initial screen | ABRSH | CHAR | 1 | XFELD | MBR | |||
XEIC1 | Indicator: take Classification view into account | XBIC1 | CHAR | 1 | XFELD | ||||
XEIF1 | Indicator: take Production Resources/Tools view into account | XBIF1 | CHAR | 1 | XFELD | ||||
XEIG1 | Indicator: Take 'Costing' view into account | XBIG1 | CHAR | 1 | XFELD | ||||
XEID3 | Indicator: Take 'MRP 3' view into account | XBID3 | CHAR | 1 | XFELD | ||||
XEIA2 | Indicator: Take 'Work Scheduling 2' View into Account | XBIA2 | CHAR | 1 | XFELD | ||||
BDREF | Screen reference depending on the user | BDREF | CHAR | 2 | BDREF | ||||
XEIVE | Indicator: consider 'Foreign trade' view | XBIVE | CHAR | 1 | XFELD |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects