SAP ABAP View V_VIBDMEASBU_DS (Measurements for Building)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BD (Application Component) Basic Data
     ⤷ RE_DS_BD (Package) RE: Dev. Support - Master Data

Basic Data

View Type	D	Database View
Database View	V_VIBDMEASBU_DS
Short Description	Measurements for Building
Root table	VIBDMEAS	Measurement

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VIBDMEAS	MANDT	JL	EQ				0	0
2	VIBDBU	MANDT	JR	EQ			AND	0	0
3	VIBDMEAS	INTRENO	JL	EQ				0	0
4	VIBDBU	INTRENO	JR	EQ			AND	0	0
5	VIBDMEAS	INTRENO		LK	'IB%'			0	0

View Fields

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

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	500