SAP ABAP Table USRMM (User settings: material master)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

Table Category	POOL	Pooled table
Pooled table	USRMM	Table Relationship Diagram
Short Description	User settings: material master

Delivery and Maintenance

Pool/cluster	UTAB
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	UNAME	☑	UNAME	UNAME	CHAR	12	0	User Name
3	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
4	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	REF_WERKS	☐	REF_WERKS	WERKS	CHAR	4	0	Reference plant	T001W
6	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
7	REF_LGORT	☐	REF_LGORT	LGORT	CHAR	4	0	Reference Storage Location	T001L
8	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
9	REF_BUKRS	☐	REF_BUKRS	BUKRS	CHAR	4	0	Reference Company Code	T001
10	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
11	REF_BWKEY	☐	REF_BWKEY	BWKEY	CHAR	4	0	Reference valuation area	T001K
12	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
13	REF_BWTAR	☐	REF_BWTAR	BWTAR	CHAR	10	0	Reference valuation type	T149D
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
15	REF_VKORG	☐	REF_VKORG	VKORG	CHAR	4	0	Reference sales organization	TVKO
16	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
17	REF_VTWEG	☐	REF_VTWEG	VTWEG	CHAR	2	0	Reference distribution channel	TVTW
18	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
19	REF_LGNUM	☐	REF_LGNUM	LGNUM	CHAR	3	0	Reference warehouse number	T300
20	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
21	REF_LGTYP	☐	REF_LGTYP	LGTYP	CHAR	3	0	Reference storage type	T301
22	DISPR	☐	DISPR	DISPR	CHAR	4	0	Material: MRP profile	MDIP
23	PROPR	☐	PROPR	PROPR	CHAR	4	0	Forecast profile	MPRP
24	XEIA1	☐	XBIA1	XFELD	CHAR	1	0	Indicator: include first Work Scheduling view
25	XEIB1	☐	XBIB1	XFELD	CHAR	1	0	Include Accounting View
26	XEID1	☐	XBID1	XFELD	CHAR	1	0	Indicator: consider MRP 1 view
27	XEID2	☐	XBID2	XFELD	CHAR	1	0	Indicator: consider "MRP 2"
28	XEIE1	☐	XBIE1	XFELD	CHAR	1	0	Indicator: Consider Purchasing view
29	XEIE2	☐	XBIE2	XFELD	CHAR	1	0	Indicator: consider Purchase Order Text view
30	XEIK1	☐	XBIK1	XFELD	CHAR	1	0	Include Basic Data View
31	XEIL1	☐	XBIL1	XFELD	CHAR	1	0	Indicator: consider "Storage" view
32	XEIP1	☐	XBIP1	XFELD	CHAR	1	0	Indicator: consider "forecasting" view
33	XEIQ1	☐	XBIQ1	XFELD	CHAR	1	0	Indicator: consider "quality assurance" view
34	XEIS1	☐	XBIS1	XFELD	CHAR	1	0	Include "Warehouse Management" View
35	XEIV1	☐	XBIV1	XFELD	CHAR	1	0	Indicator: consider Sales 1 view
36	XEIV2	☐	XBIV2	XFELD	CHAR	1	0	Indicator: consider Sales 2 view
37	XEIV3	☐	XBIV3	XFELD	CHAR	1	0	Indicator: consider Sales Text view
38	XEIV4	☐	XBIV4	XFELD	CHAR	1	0	Indicator: consider Sales/Plant Data view
39	XEIX1	☐	XBIX1	XFELD	CHAR	1	0	Indicator: consider Plant Stock view
40	XEIZ1	☐	XBIZ1	XFELD	CHAR	1	0	Indicator: include Storage Location Stock view
41	AAUSW	☐	AAUSW	XFELD	CHAR	1	0	Indicator: view selection only on request
42	ASCHL	☐	ASCHL	XFELD	CHAR	1	0	Indicator: org. levels/profiles only on request
43	ABRSH	☐	ABRSH	XFELD	CHAR	1	0	Indicator: hide industry sector on initial screen
44	XEIC1	☐	XBIC1	XFELD	CHAR	1	0	Indicator: take Classification view into account
45	XEIF1	☐	XBIF1	XFELD	CHAR	1	0	Indicator: take Production Resources/Tools view into account
46	XEIG1	☐	XBIG1	XFELD	CHAR	1	0	Indicator: Take "Costing" view into account
47	XEID3	☐	XBID3	XFELD	CHAR	1	0	Indicator: Take "MRP 3" view into account
48	XEIA2	☐	XBIA2	XFELD	CHAR	1	0	Indicator: Take "Work Scheduling 2" View into Account
49	BDREF	☐	BDREF	BDREF	CHAR	2	0	Screen reference depending on the user
50	XEIVE	☐	XBIVE	XFELD	CHAR	1	0	Indicator: consider "Foreign trade" view

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	USRMM	BUKRS	T001	BUKRS	REF	C	CN
2	USRMM	BWKEY	T001K	BWKEY	REF	C	CN
3	USRMM	BWTAR	T149D	BWTAR
4	USRMM	DISPR	MDIP	DISPR	REF	C	CN
5	USRMM	LGNUM	T300	LGNUM	REF	C	CN
6	USRMM	LGORT	T001L	LGORT	REF	C	CN
7	USRMM	LGTYP	T301	LGTYP	REF	C	CN
8	USRMM	MANDT	T000	MANDT	KEY	1	CN
9	USRMM	MBRSH	T137	MBRSH	REF	C	CN
10	USRMM	PROPR	MPRP	PROPR	REF	C	CN
11	USRMM	REF_BUKRS	T001	BUKRS	REF	C	CN
12	USRMM	REF_BWKEY	T001K	BWKEY	REF	C	CN
13	USRMM	REF_BWTAR	T149D	BWTAR
14	USRMM	REF_LGNUM	T300	LGNUM	REF	C	CN
15	USRMM	REF_LGORT	T001L	LGORT	REF	C	CN
16	USRMM	REF_LGTYP	T301	LGTYP	REF	C	CN
17	USRMM	REF_VKORG	TVKO	VKORG	REF	C	CN
18	USRMM	REF_VTWEG	TVTW	VTWEG	REF	C	CN
19	USRMM	REF_WERKS	T001W	WERKS	REF	C	CN
20	USRMM	VKORG	TVKO	VKORG	REF	C	CN
21	USRMM	VTWEG	TVTW	VTWEG	REF	C	CN
22	USRMM	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	19971007
SAP Release Created in