SAP ABAP Table V_USRMM (Generated Table for View V_USRMM)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_USRMM	Table Relationship Diagram
Short Description	Generated Table for View V_USRMM

Delivery and Maintenance

Pool/cluster
Delivery Class
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

Foreign Keys

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

History

Last changed by/on	SAP	20010122
SAP Release Created in