SAP ABAP View V_BUILDING (Rental Object With Criteria From Superior Tables)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX (Application Component) Flexible Real Estate Management
     ⤷ RE_LD_LD (Package) RE: Logical Databases

Basic Data

View Type	D	Database View
Database View	V_BUILDING
Short Description	Rental Object With Criteria From Superior Tables
Root table	VIBDBU	Building

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VIBDBU	VIBDBU
2	VIBDBE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VIBDBE	MANDT	JL	EQ				0	0
2	VIBDBU	MANDT	JR	EQ			AND	0	0
3	VIBDBE	BUKRS	JL	EQ				0	0
4	VIBDBU	BUKRS	JR	EQ			AND	0	0
5	VIBDBE	SWENR	JL	EQ				0	0
6	VIBDBU	SWENR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	VIBDBU	*		☐		☐
2	MANDT	VIBDBU	MANDT		☐	MANDT	☐	Client
3	INTRENO	VIBDBU	INTRENO		☐	RECAINTRENO	☐	Internal Key of Real Estate Object
4	BUKRS	VIBDBU	BUKRS		☐	BUKRS	☐	Company Code
5	SWENR	VIBDBU	SWENR		☐	REBDBENO	☐	Business Entity Number
6	SGENR	VIBDBU	SGENR		☐	REBDBUNO	☐	Number of Building
7	OBJNR	VIBDBU	OBJNR		☐	RECAOBJNR	☐	Object Number
8	IMKEY	VIBDBU	IMKEY		☐	RECAIMKEY	☐	Internal Key of Real Estate Object (FI)
9	CREATIONTYPE	VIBDBU	CREATIONTYPE		☐	RECACREATIONTYPE	☐	How the Object Was Created
10	RERF	VIBDBU	RERF		☐	RERF	☐	Entered by
11	DERF	VIBDBU	DERF		☐	DERF	☐	First Entered on
12	TERF	VIBDBU	TERF		☐	TERF	☐	Time of Initial Entry
13	REHER	VIBDBU	REHER		☐	REHER	☐	Source of initial entry
14	RBEAR	VIBDBU	RBEAR		☐	RBEAR	☐	Employee ID
15	DBEAR	VIBDBU	DBEAR		☐	DBEAR	☐	Last Edited on
16	TBEAR	VIBDBU	TBEAR		☐	TBEAR	☐	Last Edited at
17	RBHER	VIBDBU	RBHER		☐	RBHER	☐	Editing Source
18	RESPONSIBLE	VIBDBU	RESPONSIBLE		☐	RECARESPONSIBLE	☐	Person Responsible
19	USEREXCLUSIVE	VIBDBU	USEREXCLUSIVE		☐	RECAUSEREXCLUSIVE	☐	User with Exclusive Change Authorization
20	AUTHGRP	VIBDBU	AUTHGRP		☐	RECAAUTHGRP	☐	Authorization Group
21	VALIDFROM	VIBDBU	VALIDFROM		☐	REBDOBJVALIDFROM	☐	Date: Object Valid From
22	VALIDTO	VIBDBU	VALIDTO		☐	REBDOBJVALIDTO	☐	Date: Object Valid To
23	XGETXT	VIBDBU	XGETXT		☐	REBDXBU	☐	Description of Building
24	RGEBART	VIBDBU	RGEBART		☐	RGEBART	☐	Type of building
25	JERBBAU	VIBDBU	JERBBAU		☐	JERBBAU	☐	Heritable building right indicator
26	RGEBZUST	VIBDBU	RGEBZUST		☐	RGEBZUST	☐	General condition of building
27	YBAUJAHR	VIBDBU	YBAUJAHR		☐	VVYBAUJAHR	☐	ConstYr
28	YMODERN	VIBDBU	YMODERN		☐	VVYMODERN	☐	Year of modernization
29	YAUFBAU	VIBDBU	YAUFBAU		☐	VVYAUFBAU	☐	Year of reconstruction
30	DBAUBEGI	VIBDBU	DBAUBEGI		☐	DBAUBEGI	☐	Construction start date
31	BBAUW13	VIBDBU	BBAUW13		☐	BBAUWXOLD	☐	OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933
32	BBAUWX	VIBDBU	BBAUWX		☐	BBAUWX	☐	Building Value
33	BBAUWAKT	VIBDBU	BBAUWAKT		☐	BBAUWAKTXOLD	☐	OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933
34	BBAUWAKTX	VIBDBU	BBAUWAKTX		☐	BBAUWAKTX	☐	Current Building Value
35	BDMCBMRA	VIBDBU	BDMCBMRA		☐	BDMCBMRA	☐	Amount per volume unit
36	DBAUGENE	VIBDBU	DBAUGENE		☐	DBAUGENE	☐	Building permit
37	XBAUGENE	VIBDBU	XBAUGENE		☐	XBAUGENE	☐	Note on building permit
38	DBEZUGSF	VIBDBU	DBEZUGSF		☐	DBEZUGSF	☐	Ready for occupancy
39	DFERTIG	VIBDBU	DFERTIG		☐	DFERTIG	☐	Completion
40	DSCHLUSS	VIBDBU	DSCHLUSS		☐	DSCHLUSS	☐	Final Inspection
41	JDENKMAL	VIBDBU	JDENKMAL		☐	JDENKMAL	☐	Protection of Historical Sites
42	DBAUVOR	VIBDBU	DBAUVOR		☐	DBAUVOR	☐	Date of planning inquiry
43	DVORBES	VIBDBU	DVORBES		☐	DVORBES	☐	Date of prior notice
44	DANTBAU	VIBDBU	DANTBAU		☐	DANTBAU	☐	Application for building permit
45	BEINHEITW	VIBDBU	BEINHEITW		☐	BEINHEITWXOLD	☐	OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933
46	BEINHEITWX	VIBDBU	BEINHEITWX		☐	BEINHEITWX	☐	Assessed Value of Building
47	NEINHEITW	VIBDBU	NEINHEITW		☐	NEINHEITW	☐	Assessed value base year
48	BVERSWRT	VIBDBU	BVERSWRT		☐	BVERSWRTXOLD	☐	OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933
49	BVERSWRTX	VIBDBU	BVERSWRTX		☐	BVERSWRTX	☐	Insurable Value Amount
50	RVERSWRT	VIBDBU	RVERSWRT		☐	RVERSWRT	☐	Type of insurance value
51	DWIRTUB	VIBDBU	DWIRTUB		☐	VVDWIRTUB	☐	Transfer usage / charges
52	DVERKAUF	VIBDBU	DVERKAUF		☐	VVDVERKAUF	☐	Sale date
53	DVRKPLAN	VIBDBU	DVRKPLAN		☐	VVDVRKPLAN	☐	Planned sale
54	DNUTZEND	VIBDBU	DNUTZEND		☐	VVDNUTZEND	☐	End of usage
55	DFRDVON	VIBDBU	DFRDVON		☐	VVDFRDVON	☐	Public funding from
56	DFRDBIS	VIBDBU	DFRDBIS		☐	VVDFRDBIS	☐	Public funding to
57	BANZGE	VIBDBU	BANZGE		☐	VVBANZGE	☐	Number of floors
58	SUNUTZA	VIBDBU	SUNUTZA		☐	VVSUNART	☐	Main usage type
59	JUNUTZA	VIBDBU	JUNUTZA		☐	REBDJUNUTZAOBS	☐	OBSOLETE: Main Usage Type
60	SSTCKBIS	VIBDBU	SSTCKBIS		☐	VVSTCKBIS	☐	Uppermost Floor of a Building
61	SLIFTBIS	VIBDBU	SLIFTBIS		☐	VVLIFTBIS	☐	Elevator to Floor in Building
62	AUGESCH	VIBDBU	AUGESCH		☐	AUGESCH	☐	Number of basements
63	JANLHIE	VIBDBU	JANLHIE		☐	REBDJANLHIEOBS	☐	OBSOLETE: Asset Assignment Also Applies for Subord. Building
64	RLRALOC	VIBDBU	RLRALOC		☐	REAJRLRALOC	☐	Location Class
65	USESRLRA	VIBDBU	USESRLRA		☐	REAJUSESRLRA	☐	Representative List of Rents Is Used
66	GEMEINDE	VIBDBU	GEMEINDE		☐	VVGEMEINDE	☐	Municipality key
67	REINS	VIBDBU	REINS		☐	REINS	☐	Unit for cubic volume
68	WAERS	VIBDBU	WAERS		☐	WAERS	☐	Currency Key
69	HASCOP	VIBDBU	HASCOP		☐	RESCHASCOP	☐	Uses Current Occupancy Principle
70	USGFUNCTION	VIBDBU	USGFUNCTION		☐	REBDUSGFUNCTION	☐	Function of Object
71	OBJCOND	VIBDBU	OBJCOND		☐	REXCCHBUCOND	☐	Code of Building Status
72	OBJCAT	VIBDBU	OBJCAT		☐	REXCCHBUCATEGORY	☐	Building Category Code
73	YEARDECONSTR	VIBDBU	YEARDECONSTR		☐	REXCCHBUDECONYEAR	☐	Year of Demolition
74	AREAVALUE	VIBDBU	AREAVALUE		☐	REXCCHBUAREA	☐	Floor Area of Building in Square Meters
75	HEATINGTYPE	VIBDBU	HEATINGTYPE		☐	REXCCHBUHEATINGTYPE	☐	Code of Heating Type
76	ENERGYHEAT	VIBDBU	ENERGYHEAT		☐	REXCCHBUENERGYSOURCEH	☐	Energy Carrier of Heating
77	ENERGYWATER	VIBDBU	ENERGYWATER		☐	REXCCHBUENERGYSOURCEW	☐	Energy Carrier of Hot Water
78	HOTWATERSUPPLY	VIBDBU	HOTWATERSUPPLY		☐	REXCCHBUHOTWATER	☐	Central Hot Water Supply
79	POWERCONSUM	VIBDBU	POWERCONSUM		☐	REXCCHBUPOWERCONSUMPTION	☐	Power Consumption of Building (in kWh)
80	GLAZING	VIBDBU	GLAZING		☐	REXCCHBUGLAZING	☐	Glazing Type
81	ADMINNO	VIBDBU	ADMINNO		☐	REXCCHBUADMINNO	☐	Administrative Building Number
82	ADMINXGETXT	VIBDBU	ADMINXGETXT		☐	REXCCHBUADMINXBU	☐	Building Name
83	GEMEINDECH	VIBDBU	GEMEINDECH		☐	RELMLRDISTRICT	☐	Land Register District
84	BANZGECH	VIBDBU	BANZGECH		☐	VVBANZGE	☐	Number of floors
85	SSTCKBISCH	VIBDBU	SSTCKBISCH		☐	VVSTCKBIS	☐	Uppermost Floor of a Building
86	SLIFTBISCH	VIBDBU	SLIFTBISCH		☐	VVLIFTBIS	☐	Elevator to Floor in Building
87	AUGESCHCH	VIBDBU	AUGESCHCH		☐	AUGESCH	☐	Number of basements
88	SECCO	VIBDBU	SECCO		☐	SECCO	☐	Section Code
89	BUPLA	VIBDBU	BUPLA		☐	BUPLA	☐	Business Place
90	REPKOCH	VIBDBU	REPKOCH		☐	REXCJPREPKOCH	☐	Kind of Change
91	BDCONSTR	VIBDBU	BDCONSTR		☐	REXCJPBDCONSTR	☐	Construction Status
92	BDFIREPREV	VIBDBU	BDFIREPREV		☐	REXCJPBDFIREPREV	☐	Fire Fighting Method Number
93	BDOTHOW	VIBDBU	BDOTHOW		☐	REXCJPBDOTHOW	☐	Number of Another Owners in the Same Building
94	BDOWNSHIP	VIBDBU	BDOWNSHIP		☐	REXCJPBDOWNSHIP	☐	Building Ownership Status
95	KOCHDATE	VIBDBU	KOCHDATE		☐	REXCJPKOCHDATE	☐	Date of Change in Kind of Change
96	VPT	VIBDBU	VPT		☐	REXCPTVPT_NOSIGN	☐	Property Taxable Value
97	CURRENCY	VIBDBU	CURRENCY		☐	WAERS	☐	Currency Key
98	CONDK	VIBDBU	CONDK		☐	REXCPTRACONS	☐	Conservation Level
99	INTRENOBE	VIBDBE	INTRENO		☐	RECAINTRENO	☐	Internal Key of Real Estate Object
100	SINSTBEZ	VIBDBE	SINSTBEZ		☐	SINSTBEZ	☐	Maintenance district
101	SVERKEHR	VIBDBE	SVERKEHR		☐	SVERKEHR	☐	Transport Connections of Business Entity
102	XWETEXT	VIBDBE	XWETEXT		☐	REBDXBE	☐	Business Entity Name
103	SLAGEWE	VIBDBE	SLAGEWE		☐	SLAGEWE	☐	Business entity location number
104	SOBJLAGE	VIBDBE	SOBJLAGE		☐	RESOBJLAGE	☐	Indicator: District Location of Object
105	RLRA	VIBDBE	RLRA		☐	REAJRLRA	☐	Representative List of Rents

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	20130529
SAP Release Created in	110