SAP ABAP Table USRM1 (Material Master User Settings: Organizational Levels)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	USRM1	Table Relationship Diagram
Short Description	Material Master User Settings: Organizational Levels

Delivery and Maintenance

Pool/cluster
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	☑	USERN	XUBNAME	CHAR	12	0	User name	USR02
3	BILDS	☑	BILDSQ	BILDSQ	CHAR	2	0	Screen Sequence Number	T133S
4	MBRSH	☐	DUMMYMBRSH	CHAR1	CHAR	1	0	Deactivated
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
6	REF_WERKS	☐	REF_WERKS	WERKS	CHAR	4	0	Reference plant	T001W
7	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
8	REF_LGORT	☐	REF_LGORT	LGORT	CHAR	4	0	Reference Storage Location	T001L
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	REF_BUKRS	☐	REF_BUKRS	BUKRS	CHAR	4	0	Reference Company Code	T001
11	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
12	REF_BWKEY	☐	REF_BWKEY	BWKEY	CHAR	4	0	Reference valuation area	T001K
13	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
14	REF_BWTAR	☐	REF_BWTAR	BWTAR	CHAR	10	0	Reference valuation type	T149D
15	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
16	REF_VKORG	☐	REF_VKORG	VKORG	CHAR	4	0	Reference sales organization	TVKO
17	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
18	REF_VTWEG	☐	REF_VTWEG	VTWEG	CHAR	2	0	Reference distribution channel	TVTW
19	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
20	REF_LGNUM	☐	REF_LGNUM	LGNUM	CHAR	3	0	Reference warehouse number	T300
21	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
22	REF_LGTYP	☐	REF_LGTYP	LGTYP	CHAR	3	0	Reference storage type	T301
23	DISPR	☐	DISPR	DISPR	CHAR	4	0	Material: MRP profile	MDIP
24	PROPR	☐	PROPR	PROPR	CHAR	4	0	Forecast profile	MPRP
25	AAUSW	☐	AAUSW	XFELD	CHAR	1	0	Indicator: view selection only on request
26	ASCHL	☐	ASCHL	XFELD	CHAR	1	0	Indicator: org. levels/profiles only on request
27	ABRSH	☐	ABRSH	XFELD	CHAR	1	0	Indicator: hide industry sector on initial screen
28	BDREF	☐	BDREFINAKT	BDREF	CHAR	2	0	Inactive: no longer used
29	SISEL	☐	SISEL	XFELD	CHAR	1	0	Create Views Selected

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in