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