SAP ABAP Table M_SHRAD (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_SHRAD	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	VERSION	☑	VIGWSVERSION	VIGWVERSION	NUMC	4	0	Version Indicator
5	SMENR	☑	SMENR	SMENR	CHAR	8	0	Number of Rental Unit
6	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	SWENR	☑	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
8	SGENR	☑	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
9	SRAUMEXT	☑	VIGWRAUMEXT	VIGWRAUMEXT	CHAR	13	0
10	DGUELAB	☑	VIGWGUELAB	DDAT	DATS	8	0	Valid-from date
11	SGEBT	☑	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
12	SSTOCKW	☑	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
13	XRBEZ	☑	VIGWRBEZ	XMBEZ	CHAR	30	0	Name of Room
14	SRAART	☑	SRAART	SRAART	NUMC	2	0	Room type	TIV09
15	SNUNR	☑	SNUNR	SNUNR	NUMC	4	0	Rental unit external usage type	TIV01
16	DBEZU	☑	DBEZU	DDAT	DATS	8	0	Date of initial usage
17	XMETXT	☑	VVXMETXT2	XMBEZ	CHAR	30	0	Text for rental unit

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in