SAP ABAP Table VIBDBU_TAB (Building: Non-Key Fields)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ RE-FX-BD (Application Component) Basic Data
     ⤷ RE_BD_BU (Package) RE: Building (Master Data)

Basic Data

Table Category	INTTAB	Structure
Structure	VIBDBU_TAB	Table Relationship Diagram
Short Description	Building: Non-Key Fields

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	OBJNR	☐	RECAOBJNR	J_OBJNR	CHAR	22	0	Object Number	*
2	IMKEY	☐	RECAIMKEY	IMKEY	CHAR	8	0	Internal Key of Real Estate Object (FI)
3	CREATIONTYPE	☐	RECACREATIONTYPE	RECACREATIONTYPE	CHAR	1	0	How the Object Was Created
4	.INCLUDE	☐				0	0	Field String for Maintenance of User Data
5	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
6	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
7	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
8	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
9	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
13	RESPONSIBLE	☐	RECARESPONSIBLE	XUBNAME	CHAR	12	0	Person Responsible	USR02
14	USEREXCLUSIVE	☐	RECAUSEREXCLUSIVE	XUBNAME	CHAR	12	0	User with Exclusive Change Authorization	USR02
15	AUTHGRP	☐	RECAAUTHGRP	RECAAUTHGRP	CHAR	40	0	Authorization Group
16	VALIDFROM	☐	REBDOBJVALIDFROM	RECADATEBEG	DATS	8	0	Date: Object Valid From
17	VALIDTO	☐	REBDOBJVALIDTO	RECADATEEND	DATS	8	0	Date: Object Valid To
18	XGETXT	☐	REBDXBU	RECAXLDESCRIPTION	CHAR	60	0	Description of Building
19	RGEBART	☐	RGEBART	SOBJART	NUMC	2	0	Type of building	TIV5A
20	JERBBAU	☐	JERBBAU	SOBJERBBAU	CHAR	1	0	Heritable building right indicator	TDO9
21	RGEBZUST	☐	RGEBZUST	VVRZUSTAND	NUMC	2	0	General condition of building	TIV83
22	YBAUJAHR	☐	VVYBAUJAHR	DATUM	DATS	8	0	ConstYr
23	YMODERN	☐	VVYMODERN	DATUM	DATS	8	0	Year of modernization
24	YAUFBAU	☐	VVYAUFBAU	DATUM	DATS	8	0	Year of reconstruction
25	DBAUBEGI	☐	DBAUBEGI	DDAT	DATS	8	0	Construction start date
26	BBAUW13	☐	BBAUWXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933
27	BBAUWX	☐	BBAUWX	RECACURR	CURR	15	2	Building Value
28	BBAUWAKT	☐	BBAUWAKTXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933
29	BBAUWAKTX	☐	BBAUWAKTX	RECACURR	CURR	15	2	Current Building Value
30	BDMCBMRA	☐	BDMCBMRA	WRBTR	CURR	11	2	Amount per volume unit
31	DBAUGENE	☐	DBAUGENE	DDAT	DATS	8	0	Building permit
32	XBAUGENE	☐	XBAUGENE	XMBEZ	CHAR	30	0	Note on building permit
33	DBEZUGSF	☐	DBEZUGSF	DDAT	DATS	8	0	Ready for occupancy
34	DFERTIG	☐	DFERTIG	DDAT	DATS	8	0	Completion
35	DSCHLUSS	☐	DSCHLUSS	DDAT	DATS	8	0	Final Inspection
36	JDENKMAL	☐	JDENKMAL	JANE	CHAR	1	0	Protection of Historical Sites
37	DBAUVOR	☐	DBAUVOR	DDAT	DATS	8	0	Date of planning inquiry
38	DVORBES	☐	DVORBES	DDAT	DATS	8	0	Date of prior notice
39	DANTBAU	☐	DANTBAU	DATUM	DATS	8	0	Application for building permit
40	BEINHEITW	☐	BEINHEITWXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933
41	BEINHEITWX	☐	BEINHEITWX	RECACURR	CURR	15	2	Assessed Value of Building
42	NEINHEITW	☐	NEINHEITW	GJAHR	NUMC	4	0	Assessed value base year
43	BVERSWRT	☐	BVERSWRTXOLD	WRBTR	CURR	11	2	OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933
44	BVERSWRTX	☐	BVERSWRTX	RECACURR	CURR	15	2	Insurable Value Amount
45	RVERSWRT	☐	RVERSWRT	RVERSWRT	NUMC	1	0	Type of insurance value
46	DWIRTUB	☐	VVDWIRTUB	DATUM	DATS	8	0	Transfer usage / charges
47	DVERKAUF	☐	VVDVERKAUF	DATUM	DATS	8	0	Sale date
48	DVRKPLAN	☐	VVDVRKPLAN	DATUM	DATS	8	0	Planned sale
49	DNUTZEND	☐	VVDNUTZEND	DATUM	DATS	8	0	End of usage
50	DFRDVON	☐	VVDFRDVON	DATUM	DATS	8	0	Public funding from
51	DFRDBIS	☐	VVDFRDBIS	DATUM	DATS	8	0	Public funding to
52	BANZGE	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
53	SUNUTZA	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
54	JUNUTZA	☐	REBDJUNUTZAOBS	CHAR1	CHAR	1	0	OBSOLETE: Main Usage Type
55	SSTCKBIS	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	*
56	SLIFTBIS	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	*
57	AUGESCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
58	JANLHIE	☐	REBDJANLHIEOBS	CHAR1	CHAR	1	0	OBSOLETE: Asset Assignment Also Applies for Subord. Building
59	RLRALOC	☐	REAJRLRALOC	REAJRLRALOC	CHAR	6	0	Location Class	TIVAJRLRALOC
60	USESRLRA	☐	REAJUSESRLRA	RECABOOL	CHAR	1	0	Representative List of Rents Is Used
61	GEMEINDE	☐	VVGEMEINDE	VVGEMEINDE	CHAR	8	0	Municipality key	TIVG1
62	REINS	☐	REINS	MEINS	UNIT	3	0	Unit for cubic volume	T006
63	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
64	HASCOP	☐	RESCHASCOP	RECABOOL	CHAR	1	0	Uses Current Occupancy Principle
65	USGFUNCTION	☐	REBDUSGFUNCTION	REBDUSGFUNCTION	CHAR	4	0	Function of Object	TIVBDUSGFUNC
66	.INCLUDE	☐				0	0
67	.INCLU--AP	☐				0	0	Country specific fields (CI) for Switzerland - BU
68	.INCLUDE	☐				0	0	Building Customer fields
69	OBJCOND	☐	REXCCHBUCOND	REXCCHBUCOND	NUMC	4	0	Code of Building Status	TIVXCCHCOND
70	OBJCAT	☐	REXCCHBUCATEGORY	REXCCHBUCATEGORY	NUMC	4	0	Building Category Code	TIVXCCHKAT
71	YEARDECONSTR	☐	REXCCHBUDECONYEAR	DATUM	DATS	8	0	Year of Demolition
72	AREAVALUE	☐	REXCCHBUAREA	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Floor Area of Building in Square Meters
73	HEATINGTYPE	☐	REXCCHBUHEATINGTYPE	REXCCHBUHEATINGTYPE	NUMC	4	0	Code of Heating Type	TIVXCCHHEAT
74	ENERGYHEAT	☐	REXCCHBUENERGYSOURCEH	REXCCHBUENERGYSOURCE	NUMC	4	0	Energy Carrier of Heating	TIVXCCHGENSRC
75	ENERGYWATER	☐	REXCCHBUENERGYSOURCEW	REXCCHBUENERGYSOURCE	NUMC	4	0	Energy Carrier of Hot Water	TIVXCCHGENSRC
76	HOTWATERSUPPLY	☐	REXCCHBUHOTWATER	RECABOOL	CHAR	1	0	Central Hot Water Supply
77	POWERCONSUM	☐	REXCCHBUPOWERCONSUMPTION	REXCCHGWRFORMATUNITFIELD	DEC	10	2	Power Consumption of Building (in kWh)
78	GLAZING	☐	REXCCHBUGLAZING	TEXT15	CHAR	15	0	Glazing Type
79	ADMINNO	☐	REXCCHBUADMINNO	REXCCHBUADMINNO	CHAR	12	0	Administrative Building Number
80	ADMINXGETXT	☐	REXCCHBUADMINXBU	RECAXLDESCRIPTION	CHAR	60	0	Building Name
81	GEMEINDECH	☐	RELMLRDISTRICT	RELMLRDISTRICT	CHAR	6	0	Land Register District	*
82	BANZGECH	☐	VVBANZGE	DEC3_1	DEC	4	1	Number of floors
83	SSTCKBISCH	☐	VVSTCKBIS	VVSSTOCKW	NUMC	3	0	Uppermost Floor of a Building	*
84	SLIFTBISCH	☐	VVLIFTBIS	VVSSTOCKW	NUMC	3	0	Elevator to Floor in Building	*
85	AUGESCHCH	☐	AUGESCH	DEC2	DEC	2	0	Number of basements
86	.INCLU--AP	☐				0	0	Country specific fields for India - BU
87	SECCO	☐	SECCO	SECCO	CHAR	4	0	Section Code	*
88	BUPLA	☐	BUPLA	J_1BBRANCH	CHAR	4	0	Business Place	*
89	.INCLU--AP	☐				0	0	Localization Japan: Additional fields Building
90	.INCLUDE	☐				0	0	Country Specific Fields for Japan
91	REPKOCH	☐	REXCJPREPKOCH	REXCJPREPKOCH	CHAR	1	0	Kind of Change
92	BDCONSTR	☐	REXCJPBDCONSTR	REXCJPBDCONST	CHAR	1	0	Construction Status
93	BDFIREPREV	☐	REXCJPBDFIREPREV	CHAR8	CHAR	8	0	Fire Fighting Method Number
94	BDOTHOW	☐	REXCJPBDOTHOW	INT4	INT4	10	0	Number of Another Owners in the Same Building
95	BDOWNSHIP	☐	REXCJPBDOWNSHIP	REXCJPBDOWNSH	CHAR	1	0	Building Ownership Status
96	KOCHDATE	☐	REXCJPKOCHDATE	RECADATE	DATS	8	0	Date of Change in Kind of Change
97	.INCLU--AP	☐				0	0	Country-Specific fields for Portugal - Building
98	.INCLUDE	☐				0	0	Country-Specific Fields for Portugal - Building
99	VPT	☐	REXCPTVPT_NOSIGN	REXCPTVPT_NOSIGN	CURR	15	2	Property Taxable Value
100	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
101	CONDK	☐	REXCPTRACONS		CHAR	4	0	Conservation Level	TIVXCPTRACONS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIBDBU_TAB	CONDK	TIVXCPTRACONS	CONSLEVEL
2	VIBDBU_TAB	CURRENCY	TCURC	WAERS
3	VIBDBU_TAB	ENERGYHEAT	TIVXCCHGENSRC	ENERGYSRC	KEY
4	VIBDBU_TAB	ENERGYWATER	TIVXCCHGENSRC	ENERGYSRC	KEY
5	VIBDBU_TAB	GEMEINDE	TIVG1	GEMEINDE	REF	C	CN
6	VIBDBU_TAB	HEATINGTYPE	TIVXCCHHEAT	HEATINGTYPE	KEY
7	VIBDBU_TAB	JERBBAU	TDO9	SOBJERBBAU	REF	1	CN
8	VIBDBU_TAB	OBJCAT	TIVXCCHKAT	BCATEGORY	KEY
9	VIBDBU_TAB	OBJCOND	TIVXCCHCOND	BCOND	KEY
10	VIBDBU_TAB	REINS	T006	MSEHI	REF	C	CN
11	VIBDBU_TAB	RESPONSIBLE	USR02	BNAME	REF	1	CN
12	VIBDBU_TAB	RGEBART	TIV5A	SOBJART	REF	C	CN
13	VIBDBU_TAB	RGEBZUST	TIV83	RZUSTAND	REF	C	CN
14	VIBDBU_TAB	RLRALOC	TIVAJRLRALOC	RLRALOC	REF	C	CN
15	VIBDBU_TAB	SUNUTZA	TIV36	SUNART	REF	C	CN
16	VIBDBU_TAB	USEREXCLUSIVE	USR02	BNAME	REF	C	CN
17	VIBDBU_TAB	USGFUNCTION	TIVBDUSGFUNC	USGFUNCTION	REF	C	CN
18	VIBDBU_TAB	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	200