SAP ABAP View VIGW_V_FLRAME (View Room Zone Areas for Rental Unit)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-MI (Application Component) Migration
     ⤷ RE_MI_CR (Package) RE: Migration CRE (Data Dictionary Only)

Basic Data

View Type	D	Database View
Database View	VIGW_V_FLRAME
Short Description	View Room Zone Areas for Rental Unit
Root table	VIGWOBJZU	Immobilien gew.: zeitabh. Zuordnungen ME - Fläche/Raumzone

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIGWOBJZU	VIGWOBJZU
2	VIGWFLOBJ
3	VIGWFLRAZU
4	VIGWRAZU
5	VIGWRAGEZU

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VIGWOBJZU	MANDT	JL	EQ				0	0
2	VIGWFLOBJ	MANDT	JR	EQ			AND	0	0
3	VIGWOBJZU	INTRENO	JL	EQ				0	0
4	VIGWFLOBJ	INTRENO	JR	EQ			AND	0	0
5	VIGWFLRAZU	MANDT	JL	EQ				0	0
6	VIGWOBJZU	MANDT	JR	EQ			AND	0	0
7	VIGWFLRAZU	INTRENO	JL	EQ				0	0
8	VIGWOBJZU	INTRENO	JR	EQ			AND	0	0
9	VIGWFLRAZU	VERSION	JL	EQ				0	0
10	VIGWOBJZU	VERSION	JR	EQ			AND	0	0
11	VIGWRAZU	MANDT	JL	EQ				0	0
12	VIGWFLRAZU	MANDT	JR	EQ			AND	0	0
13	VIGWRAZU	INTRENO	JL	EQ				0	0
14	VIGWFLRAZU	INTRENO2	JR	EQ			AND	0	0
15	VIGWRAZU	VERSION	JL	EQ				0	0
16	VIGWFLRAZU	VERSION	JR	EQ			AND	0	0
17	VIGWRAGEZU	MANDT	JL	EQ				0	0
18	VIGWRAZU	MANDT	JR	EQ			AND	0	0
19	VIGWRAGEZU	INTRENO	JL	EQ				0	0
20	VIGWRAZU	INTRENO	JR	EQ			AND	0	0
21	VIGWRAGEZU	VERSION	JL	EQ				0	0
22	VIGWRAZU	VERSION	JR	EQ			AND	0	0
23	VIGWOBJZU	IAZUORD		EQ	'03'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	VIGWOBJZU	*		☐		☐
2	MANDT	VIGWOBJZU	MANDT		☐	MANDT	☐	Client
3	IAZUORD	VIGWOBJZU	IAZUORD		☐	VIGWSIAZUORD	☐
4	INTRENO	VIGWOBJZU	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
5	INTRENO2	VIGWOBJZU	INTRENO2		☐	VIGWINTRENO2	☐
6	VERSION	VIGWOBJZU	VERSION		☐	VIGWSVERSION	☐	Version Indicator
7	FLG_LME	VIGWOBJZU	FLG_LME		☐	VIGWFLGLME	☐	Flag zugeordnete Mieteinheit ist eine Leerstands-ME
8	GFLNMZ	VIGWOBJZU	GFLNMZ		☐	VIGWGFLNMZ	☐	Nutzungsmaßzahl je Mieter bei Gemeinsch.-Räumen u.-Flächen
9	GNMZEH	VIGWOBJZU	GNMZEH		☐	VIGWGFNMZEH	☐
10	GFLFAK	VIGWOBJZU	GFLFAK		☐	VIGWGFLNUFAK	☐	Nutzungsanteil(%%) je Mieter bei Gemeinsch.Räumen u.-Flächen
11	GFAKEH	VIGWOBJZU	GFAKEH		☐	VIGWGFNFAKEH	☐
12	AUTOTYP	VIGWOBJZU	AUTOTYP		☐	VIGWGFAUTOTYP	☐	Rolle der Zuordnung bei autom. Kalkulation Nutzungsfaktoren
13	DBIS_OBJZU	VIGWOBJZU	DGUELBIS		☐	VIGWZUBIS	☐
14	DAB_OBJZU	VIGWOBJZU	DGUELAB		☐	VIGWZUAB	☐
15	*	VIGWFLOBJ	*		☐		☐
16	-	VIGWFLOBJ	MANDT		☐	MANDT	☐	Client
17	-	VIGWFLOBJ	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
18	OBJNR	VIGWFLOBJ	OBJNR		☐	SNKS	☐	Service Charge Collector Number
19	IMKEY	VIGWFLOBJ	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
20	RERF	VIGWFLOBJ	RERF		☐	RERF	☐	Entered by
21	DERF	VIGWFLOBJ	DERF		☐	DERF	☐	First Entered on
22	TERF	VIGWFLOBJ	TERF		☐	TERF	☐	Time of Initial Entry
23	REHER	VIGWFLOBJ	REHER		☐	REHER	☐	Source of initial entry
24	RBEAR	VIGWFLOBJ	RBEAR		☐	RBEAR	☐	Employee ID
25	DBEAR	VIGWFLOBJ	DBEAR		☐	DBEAR	☐	Last Edited on
26	TBEAR	VIGWFLOBJ	TBEAR		☐	TBEAR	☐	Last Edited at
27	RBHER	VIGWFLOBJ	RBHER		☐	RBHER	☐	Editing Source
28	JLOESCH	VIGWFLOBJ	JLOESCH		☐	JLOESCH	☐	Real Estate Deletion Indicator/Flag
29	*	VIGWFLRAZU	*		☐		☐
30	-	VIGWFLRAZU	MANDT		☐	MANDT	☐	Client
31	-	VIGWFLRAZU	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
32	DGUELBIS	VIGWFLRAZU	DGUELBIS		☐	VIGWSGUELBIS	☐	Date: Valid To
33	-	VIGWFLRAZU	VERSION		☐	VIGWSVERSION	☐	Version Indicator
34	DGUELAB	VIGWFLRAZU	DGUELAB		☐	VIGWGUELAB	☐	Valid-from date
35	FLID	VIGWFLRAZU	FLID		☐	VIGWRAZID	☐	Raumzonen-ID für externe Darstellung
36	BASE	VIGWFLRAZU	BASE		☐	VIGWRAZBASE	☐	Flag Basis-Raumzone
37	INTRENO_RA	VIGWFLRAZU	INTRENO2		☐	VIGWINTRENORA	☐	Schlüssel des übergeordneten Raumes (zeitabh.Zuordng.)
38	*	VIGWRAZU	*		☐		☐
39	-	VIGWRAZU	MANDT		☐	MANDT	☐	Client
40	-	VIGWRAZU	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
41	-	VIGWRAZU	VERSION		☐	VIGWSVERSION	☐	Version Indicator
42	XRBEZ	VIGWRAZU	XRBEZ		☐	VIGWRBEZ	☐	Name of Room
43	SRAART	VIGWRAZU	SRAART		☐	SRAART	☐	Room type
44	DRENOV	VIGWRAZU	DRENOV		☐	DRENOV	☐	Date of last redecoration
45	XDOORBEZ	VIGWRAZU	XDOORBEZ		☐	XDOORBEZ	☐	Door-Plate Description
46	BERGRP	VIGWRAZU	BERGRP		☐	VVBERGRP	☐	Authorization group
47	DBIS_RAZU	VIGWRAZU	DGUELBIS		☐	VIGWSGUELBIS	☐	Date: Valid To
48	DAB_RAZU	VIGWRAZU	DGUELAB		☐	VIGWGUELAB	☐	Valid-from date
49	*	VIGWRAGEZU	*		☐		☐
50	-	VIGWRAGEZU	MANDT		☐	MANDT	☐	Client
51	-	VIGWRAGEZU	INTRENO		☐	VVINTRENO	☐	Internal Real Estate Master Data Code
52	-	VIGWRAGEZU	VERSION		☐	VIGWSVERSION	☐	Version Indicator
53	BUKRS	VIGWRAGEZU	BUKRS		☐	BUKRS	☐	Company Code
54	SWENR	VIGWRAGEZU	SWENR		☐	SWENR	☐	Business Entity Number
55	SGENR	VIGWRAGEZU	SGENR		☐	SGENR	☐	Building Number
56	SGEBT	VIGWRAGEZU	SGEBT		☐	SGEBT	☐	Part of Building
57	SRAUMEXT	VIGWRAGEZU	SRAUMEXT		☐	VIGWRAUMEXT	☐
58	SSTOCKW	VIGWRAGEZU	SSTOCKW		☐	VVSSTOCKW	☐	Floor
59	DBIS_RAGEZU	VIGWRAGEZU	DGUELBIS		☐	VIGWSGUELBIS	☐	Date: Valid To
60	DAB_RAGEZU	VIGWRAGEZU	DGUELAB		☐	VIGWGUELAB	☐	Valid-from date

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20100310
SAP Release Created in