SAP ABAP Table M_SHMRZ (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

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	INTRENO	☑	VVINTRENO	VVINTRENO	CHAR	13	0	Internal Real Estate Master Data Code
3	DGUELBIS	☑	VIGWSGUELBIS	DDAT	DATS	8	0	Date: Valid To
4	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
6	SGENR	☑	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
7	SRAUMEXT	☑	VIGWRAUMEXT	VIGWRAUMEXT	CHAR	13	0
8	FLID	☑	VIGWRAZID	CHAR13	CHAR	13	0	Raumzonen-ID für externe Darstellung
9	DGUELAB	☑	VIGWGUELAB	DDAT	DATS	8	0	Valid-from date
10	SSTOCKW	☑	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
11	SGEBT	☑	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
12	XRBEZ	☑	VIGWRBEZ	XMBEZ	CHAR	30	0	Name of Room
13	SRAART	☑	SRAART	SRAART	NUMC	2	0	Room type	TIV09

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	M_SHMRZ	BUKRS	T001	BUKRS	KEY	1	CN
2	M_SHMRZ	MANDT	T000	MANDT	KEY	1	CN
3	M_SHMRZ	SGEBT	TIV12	SGEBT	KEY	1	CN
4	M_SHMRZ	SGENR	VIOB03	SGENR	KEY	1	CN
5	M_SHMRZ	SRAART	TIV09	SRAART	KEY	1	CN
6	M_SHMRZ	SSTOCKW	TIV37	SSTOCKW	KEY	1	CN
7	M_SHMRZ	SWENR	VIOB01	SWENR	KEY	1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in