USRMM - User settings: material master
User settings: material master information is stored in SAP table USRMM.
It is part of development package MG in software component LO-MD-MM. This development package consists of objects that can be grouped under "Application development R/3 material master prior to 3.0".
It is part of development package MG in software component LO-MD-MM. This development package consists of objects that can be grouped under "Application development R/3 material master prior to 3.0".
Fields for table USRMM
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| UNAME | User Name | X | UNAME | CHAR | 24 | |
| MBRSH | Industry Sector | MBRSH | CHAR | 2 | T137 | |
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| REF_WERKS | Reference plant | REF_WERKS | CHAR | 8 | T001W | |
| LGORT | Storage location | LGORT_D | CHAR | 8 | T001L | |
| REF_LGORT | Reference Storage Location | REF_LGORT | CHAR | 8 | T001L | |
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| REF_BUKRS | Reference Company Code | REF_BUKRS | CHAR | 8 | T001 | |
| BWKEY | Valuation area | BWKEY | CHAR | 8 | T001K | |
| REF_BWKEY | Reference valuation area | REF_BWKEY | CHAR | 8 | T001K | |
| BWTAR | Valuation Type | BWTAR_D | CHAR | 20 | T149D | |
| REF_BWTAR | Reference valuation type | REF_BWTAR | CHAR | 20 | T149D | |
| VKORG | Sales Organization | VKORG | CHAR | 8 | TVKO | |
| REF_VKORG | Reference sales organization | REF_VKORG | CHAR | 8 | TVKO | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 4 | TVTW | |
| REF_VTWEG | Reference distribution channel | REF_VTWEG | CHAR | 4 | TVTW | |
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 6 | T300 | |
| REF_LGNUM | Reference warehouse number | REF_LGNUM | CHAR | 6 | T300 | |
| LGTYP | Storage Type | LGTYP | CHAR | 6 | T301 | |
| REF_LGTYP | Reference storage type | REF_LGTYP | CHAR | 6 | T301 | |
| DISPR | Material: MRP profile | DISPR | CHAR | 8 | MDIP | |
| PROPR | Forecast profile | PROPR | CHAR | 8 | MPRP | |
| XEIA1 | Indicator: include first Work Scheduling view | XBIA1 | CHAR | 2 | ||
| XEIB1 | Include Accounting View | XBIB1 | CHAR | 2 | ||
| XEID1 | Indicator: consider MRP 1 view | XBID1 | CHAR | 2 | ||
| XEID2 | Indicator: consider "MRP 2" | XBID2 | CHAR | 2 | ||
| XEIE1 | Indicator: Consider Purchasing view | XBIE1 | CHAR | 2 | ||
| XEIE2 | Indicator: consider Purchase Order Text view | XBIE2 | CHAR | 2 | ||
| XEIK1 | Include Basic Data View | XBIK1 | CHAR | 2 | ||
| XEIL1 | Indicator: consider "Storage" view | XBIL1 | CHAR | 2 | ||
| XEIP1 | Indicator: consider "forecasting" view | XBIP1 | CHAR | 2 | ||
| XEIQ1 | Indicator: consider "quality assurance" view | XBIQ1 | CHAR | 2 | ||
| XEIS1 | Include "Warehouse Management" View | XBIS1 | CHAR | 2 | ||
| XEIV1 | Indicator: consider Sales 1 view | XBIV1 | CHAR | 2 | ||
| XEIV2 | Indicator: consider Sales 2 view | XBIV2 | CHAR | 2 | ||
| XEIV3 | Indicator: consider Sales Text view | XBIV3 | CHAR | 2 | ||
| XEIV4 | Indicator: consider Sales/Plant Data view | XBIV4 | CHAR | 2 | ||
| XEIX1 | Indicator: consider Plant Stock view | XBIX1 | CHAR | 2 | ||
| XEIZ1 | Indicator: include Storage Location Stock view | XBIZ1 | CHAR | 2 | ||
| AAUSW | Indicator: view selection only on request | AAUSW | CHAR | 2 | ||
| ASCHL | Indicator: org. levels/profiles only on request | ASCHL | CHAR | 2 | ||
| ABRSH | Indicator: hide industry sector on initial screen | ABRSH | CHAR | 2 | ||
| XEIC1 | Indicator: take Classification view into account | XBIC1 | CHAR | 2 | ||
| XEIF1 | Indicator: take Production Resources/Tools view into account | XBIF1 | CHAR | 2 | ||
| XEIG1 | Indicator: Take "Costing" view into account | XBIG1 | CHAR | 2 | ||
| XEID3 | Indicator: Take "MRP 3" view into account | XBID3 | CHAR | 2 | ||
| XEIA2 | Indicator: Take "Work Scheduling 2" View into Account | XBIA2 | CHAR | 2 | ||
| BDREF | Screen reference depending on the user | BDREF | CHAR | 4 | ||
| XEIVE | Indicator: consider "Foreign trade" view | XBIVE | CHAR | 2 |