USRMM

User settings: material master | #masterdata | Component: Material Master

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates
☰ Categorical (26)
Other (1)
🔗 Relations (22)

Column Name	Description
MANDT FK	Client
UNAME	User Name

Column Name	Description

Column Name	Description

Column Name	Description

Column Name	Description
XEIA1	Indicator: include first Work Scheduling view	Show values
XEIB1	Include Accounting View	Show values
XEID1	Indicator: consider MRP 1 view	Show values
XEID2	Indicator: consider "MRP 2"	Show values
XEIE1	Indicator: Consider Purchasing view	Show values
XEIE2	Indicator: consider Purchase Order Text view	Show values
XEIK1	Include Basic Data View	Show values
XEIL1	Indicator: consider "Storage" view	Show values
XEIP1	Indicator: consider "forecasting" view	Show values
XEIQ1	Indicator: consider "quality assurance" view	Show values
XEIS1	Include "Warehouse Management" View	Show values
XEIV1	Indicator: consider Sales 1 view	Show values
XEIV2	Indicator: consider Sales 2 view	Show values
XEIV3	Indicator: consider Sales Text view	Show values
XEIV4	Indicator: consider Sales/Plant Data view	Show values
XEIX1	Indicator: consider Plant Stock view	Show values
XEIZ1	Indicator: include Storage Location Stock view	Show values
AAUSW	Indicator: view selection only on request	Show values
ASCHL	Indicator: org. levels/profiles only on request	Show values
ABRSH	Indicator: hide industry sector on initial screen	Show values
XEIC1	Indicator: take Classification view into account	Show values
XEIF1	Indicator: take Production Resources/Tools view into account	Show values
XEIG1	Indicator: Take "Costing" view into account	Show values
XEID3	Indicator: Take "MRP 3" view into account	Show values
XEIA2	Indicator: Take "Work Scheduling 2" View into Account	Show values
XEIVE	Indicator: consider "Foreign trade" view	Show values

Column Name	Description	Domain name
BDREF	Screen reference depending on the user	BDREF

Master Data Relations	Join Conditions
Company code	`USRMM.MANDT == T001.MANDT` `USRMM.BUKRS == T001.BUKRS`
Valuation area Valuation area Client	`USRMM.BWKEY == T001K.BWKEY` `USRMM.MANDT == T001K.MANDT`
Valuation type	`USRMM.MANDT == T149D.MANDT` `USRMM.BWTAR == T149D.BWTAR`
MRP profiles	`USRMM.MANDT == MDIP.MANDT` `USRMM.DISPR == MDIP.DISPR`
Warehouse number Warehouse Number / Warehouse Complex Client	`USRMM.LGNUM == T300.LGNUM` `USRMM.MANDT == T300.MANDT`
Storage location Storage location Client Plant	`USRMM.LGORT == T001L.LGORT` `USRMM.MANDT == T001L.MANDT` `USRMM.WERKS == T001L.WERKS`
Storage Type Warehouse Number / Warehouse Complex Client Storage Type	`USRMM.LGNUM == T301.LGNUM` `USRMM.MANDT == T301.MANDT` `USRMM.LGTYP == T301.LGTYP`
Client	`USRMM.MANDT == T000.MANDT`
Industry sector	`USRMM.MANDT == T137.MANDT` `USRMM.MBRSH == T137.MBRSH`
Forecast profiles	`USRMM.MANDT == MPRP.MANDT` `USRMM.PROPR == MPRP.PROPR`
Company code	`USRMM.MANDT == T001.MANDT` `USRMM.REF_BUKRS == T001.BUKRS`
Valuation area Reference valuation area Client	`USRMM.REF_BWKEY == T001K.BWKEY` `USRMM.MANDT == T001K.MANDT`
Reference valuation type	`USRMM.MANDT == T149D.MANDT` `USRMM.REF_BWTAR == T149D.BWTAR`
Warehouse number Reference warehouse number Client	`USRMM.REF_LGNUM == T300.LGNUM` `USRMM.MANDT == T300.MANDT`
Storage location Reference Storage Location Client Reference plant	`USRMM.REF_LGORT == T001L.LGORT` `USRMM.MANDT == T001L.MANDT` `USRMM.REF_WERKS == T001L.WERKS`
Storage type Reference warehouse number Client Reference storage type	`USRMM.REF_LGNUM == T301.LGNUM` `USRMM.MANDT == T301.MANDT` `USRMM.REF_LGTYP == T301.LGTYP`
Sales organization	`USRMM.MANDT == TVKO.MANDT` `USRMM.REF_VKORG == TVKO.VKORG`
Distribution channel Reference distribution channel Client	`USRMM.REF_VTWEG == TVTW.VTWEG` `USRMM.MANDT == TVTW.MANDT`
Plant	`USRMM.MANDT == T001W.MANDT` `USRMM.REF_WERKS == T001W.WERKS`
Sales organization	`USRMM.MANDT == TVKO.MANDT` `USRMM.VKORG == TVKO.VKORG`
Distribution channel Distribution Channel Client	`USRMM.VTWEG == TVTW.VTWEG` `USRMM.MANDT == TVTW.MANDT`
Plant	`USRMM.MANDT == T001W.MANDT` `USRMM.WERKS == T001W.WERKS`