SAP ABAP Table M_SHFLA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_SHFLA	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	DGUELBIS1	☑	VIGWSGUELBIS	DDAT	DATS	8	0	Date: Valid To
5	VERSION	☑	VIGWSVERSION	VIGWVERSION	NUMC	4	0	Version Indicator
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	SWENR	☐	SWENR	SWENR	CHAR	8	0	Business Entity Number	VIOB01
8	SGRNR	☐	SGRNR	SGRNR	CHAR	8	0	Land Number for BE	VIOB02
9	SGENR	☐	SGENR	SGENR	CHAR	8	0	Building Number	VIOB03
10	FLID	☐	VIGWASPID	VIGWFFLID	CHAR	13	0
11	DGUELAB	☐	VIGWGUELAB	DDAT	DATS	8	0	Valid-from date
12	SGEBT	☐	SGEBT	SGEBT	CHAR	2	0	Part of Building	TIV12
13	SSTOCKW	☐	VVSSTOCKW	VVSSTOCKW	NUMC	3	0	Floor	TIV37
14	FLLBEZ	☐	VIGWFFLBEZ	XTEXT30	CHAR	30	0	Flächenbezeichnung einer Mietfläche
15	FLOT	☐	VIGWSFFLOT	VIGWFLOT	NUMC	4	0	Flächentyp	TIG03

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	M_SHFLA	BUKRS	T001	BUKRS	KEY	1	CN
2	M_SHFLA	FLOT	TIG03	FLOT	KEY	1	CN
3	M_SHFLA	MANDT	T000	MANDT	KEY	1	CN
4	M_SHFLA	SGEBT	TIV12	SGEBT	KEY	1	CN
5	M_SHFLA	SGENR	VIOB03	SGENR	KEY	1	CN
6	M_SHFLA	SGRNR	VIOB02	SGRNR	KEY	1	CN
7	M_SHFLA	SSTOCKW	TIV37	SSTOCKW	KEY	1	CN
8	M_SHFLA	SWENR	VIOB01	SWENR	KEY

History

Last changed by/on	SAP	20100310
SAP Release Created in