SAP ABAP Table M_SHRAC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_SHRAC	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	DGBISFLAT	☑	VIGWSGUELBIS	DDAT	DATS	8	0	Date: Valid To
5	DGBISRAGEZU	☑	VIGWSGUELBIS	DDAT	DATS	8	0	Date: Valid To
6	VERSION	☑	VIGWSVERSION	VIGWVERSION	NUMC	4	0	Version Indicator
7	DGUELAB	☑	VIGWGUELAB	DDAT	DATS	8	0	Valid-from date
8	SSTOCKW	☑	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
9	XRBEZ	☑	VIGWRBEZ	XMBEZ	CHAR	30	0	Name of Room
10	SRAART	☑	SRAART	SRAART	NUMC	2	0	Room type	TIV09
11	HCOUNT_P	☑	VIGWHCNTP	VIGWHCNT	NUMC	4	0	Personenbelegung (theoretisch)
12	HCOUNT_I	☑	VIGWHCNTI	VIGWHCNT	NUMC	4	0	Personenbelegung (Ist)
13	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
15	SGENR	☑	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
16	SGEBT	☑	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
17	SRAUMEXT	☑	VIGWRAUMEXT	VIGWRAUMEXT	CHAR	13	0

Foreign Keys

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

History

Last changed by/on	SAP	20100310
SAP Release Created in