SAP ABAP View VIGW_V_ARRAZ (View for VIGWARRA and VIGWARRAZ)

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_ARRAZ
Short Description	View for VIGWARRA and VIGWARRAZ
Root table	VIGWARRA	Immobilien gew.: Architektonischer Raum (statischer Teil)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIGWARRA	VIGWARRA
2	VIGWARRAZ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VIGWARRA	MANDT	JL	EQ				0	0
2	VIGWARRAZ	MANDT	JR	EQ			AND	0	0
3	VIGWARRA	ARRANO	JL	EQ				0	0
4	VIGWARRAZ	ARRANO	JR	EQ			AND	0	0
5	VIGWARRA	VERSION	JL	EQ				0	0
6	VIGWARRAZ	VERSION	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	VIGWARRAZ	*		☐		☐
2	MANDT	VIGWARRAZ	MANDT		☐	MANDT	☐	Client
3	ARRANO	VIGWARRAZ	ARRANO		☐	VIGWARRANO	☐	Interne Objektnummer für architektonische Räume
4	VERSION	VIGWARRAZ	VERSION		☐	VIGWSVERSION	☐	Version Indicator
5	DGUELBIS	VIGWARRAZ	DGUELBIS		☐	VIGWSGUELBIS	☐	Date: Valid To
6	DGUELAB	VIGWARRAZ	DGUELAB		☐	VIGWGUELAB	☐	Valid-from date
7	XRBEZ	VIGWARRAZ	XRBEZ		☐	VIGWRBEZ	☐	Name of Room
8	SRAART	VIGWARRAZ	SRAART		☐	SRAART	☐	Room type
9	FLOT	VIGWARRAZ	FLOT		☐	VIGWARFLOT	☐	Arch. Flächentyp
10	DRENOV	VIGWARRAZ	DRENOV		☐	DRENOV	☐	Date of last redecoration
11	XDOORBEZ	VIGWARRAZ	XDOORBEZ		☐	XDOORBEZ	☐	Door-Plate Description
12	DTRAGFKT	VIGWARRAZ	DTRAGFKT		☐	VIGWFTRAGFKT	☐	Durchschnittliche Tragfähigkeit der Bodenfläche
13	TFEINHT	VIGWARRAZ	TFEINHT		☐	VIGWFTFEINHT	☐
14	DRAUMHOE	VIGWARRAZ	DRAUMHOE		☐	VIGWFRAHOEHE	☐
15	RHEINHT	VIGWARRAZ	RHEINHT		☐	VIGWFRHEINHT	☐
16	UMBRAUM	VIGWARRAZ	UMBRAUM		☐	VIGWFUMBRAUM	☐
17	REINHT	VIGWARRAZ	REINHT		☐	VIGWFREINHT	☐
18	RAAA	VIGWARRAZ	RAAA		☐	VIGWARFLAA	☐
19	*	VIGWARRA	*		☐		☐
20	-	VIGWARRA	MANDT		☐	MANDT	☐	Client
21	-	VIGWARRA	ARRANO		☐	VIGWARRANO	☐	Interne Objektnummer für architektonische Räume
22	-	VIGWARRA	VERSION		☐	VIGWSVERSION	☐	Version Indicator
23	OBJNR	VIGWARRA	OBJNR		☐	SNKS	☐	Service Charge Collector Number
24	RERF	VIGWARRA	RERF		☐	RERF	☐	Entered by
25	DERF	VIGWARRA	DERF		☐	DERF	☐	First Entered on
26	TERF	VIGWARRA	TERF		☐	TERF	☐	Time of Initial Entry
27	REHER	VIGWARRA	REHER		☐	REHER	☐	Source of initial entry
28	RBEAR	VIGWARRA	RBEAR		☐	RBEAR	☐	Employee ID
29	DBEAR	VIGWARRA	DBEAR		☐	DBEAR	☐	Last Edited on
30	TBEAR	VIGWARRA	TBEAR		☐	TBEAR	☐	Last Edited at
31	RBHER	VIGWARRA	RBHER		☐	RBHER	☐	Editing Source
32	JLOESCH	VIGWARRA	JLOESCH		☐	JLOESCH	☐	Real Estate Deletion Indicator/Flag
33	BUKRS	VIGWARRA	BUKRS		☐	BUKRS	☐	Company Code
34	SWENR	VIGWARRA	SWENR		☐	SWENR	☐	Business Entity Number
35	SGENR	VIGWARRA	SGENR		☐	SGENR	☐	Building Number
36	SGEBT	VIGWARRA	SGEBT		☐	SGEBT	☐	Part of Building
37	SRAUMEXT	VIGWARRA	SRAUMEXT		☐	VIGWRAUMEXT	☐
38	SSTOCKW	VIGWARRA	SSTOCKW		☐	VVSSTOCKW	☐	Floor
39	BERGRP	VIGWARRA	BERGRP		☐	VVBERGRP	☐	Authorization group

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