SAP ABAP Table VCM_USRM1 (Generated Table for View)

Basic Data

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

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	☑	USERN	XUBNAME	CHAR	12	0	User name	USR02
3	BILDS	☑	BILDSQ	BILDSQ	CHAR	2	0	Screen Sequence Number	T133S
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	AAUSW	☐	AAUSW	XFELD	CHAR	1	0	Indicator: view selection only on request
25	ASCHL	☐	ASCHL	XFELD	CHAR	1	0	Indicator: org. levels/profiles only on request
26	BDREF	☐	BDREFINAKT	BDREF	CHAR	2	0	Inactive: no longer used

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in