VIBDBU SAP (Building) Table details
Dictionary Type: Table
Description: Building
Description: Building
Table field list including key, data, relationships and ABAP select examples
VIBDBU is a standard SAP Table which is used to store Building data and is available within R/3 SAP systems depending on the version and release level.
The VIBDBU table consists of various fields, each holding specific information or linking keys about Building data available in SAP. These include INTRENO (Internal Key of Real Estate Object), BUKRS (Company Code), SWENR (Site Number), SGENR (Number of Building).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VIBDBU table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | RECAINTRENO | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
SWENR | Site Number | REBDBENO | CHAR | 8 | Assigned to domain | SWENR | REBDBENO | REBDBENO | REBDBENO |
SGENR | Number of Building | REBDBUNO | CHAR | 8 | SGENR | REBDBUNO | REBDBUNO | REBDBUNO | |
OBJNR | Object Number | RECAOBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
IMKEY | Internal Key of Real Estate Object (FI) | RECAIMKEY | CHAR | 8 | IMKEY | IMKEY | RECLFXCAIMKEY | ||
CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | RECACREATIONTYPE | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
RESPONSIBLE | Person Responsible | RECARESPONSIBLE | CHAR | 12 | USR02 | XUBNAME | USER_COMP | ||
USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | CHAR | 12 | USR02 | XUBNAME | USER_COMP | ||
AUTHGRP | Authorization Group | RECAAUTHGRP | CHAR | 40 | RECAAUTHGRP | ||||
VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | RECADATEBEG | ||||
VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | REDAT | RECADATEEND | |||
XGETXT | Description of Building | REBDXBU | CHAR | 60 | RECAXLDESCRIPTION | ||||
RGEBART | Type of building | RGEBART | NUMC | 2 | TIV5A | SOBJART | |||
JERBBAU | Heritable building right indicator | JERBBAU | CHAR | 1 | TDO9 | SOBJERBBAU | |||
RGEBZUST | General condition of building | RGEBZUST | NUMC | 2 | TIV83 | VVRZUSTAND | |||
YBAUJAHR | ConstYr | VVYBAUJAHR | DATS | 8 | DATUM | ||||
YMODERN | Year of modernization | VVYMODERN | DATS | 8 | DATUM | ||||
YAUFBAU | Year of reconstruction | VVYAUFBAU | DATS | 8 | DATUM | ||||
DBAUBEGI | Construction start date | DBAUBEGI | DATS | 8 | DDAT | ||||
BBAUW13 | OBSOLETE: Replaced by BBAUWX - See SAP Note 1771933 | BBAUWXOLD | CURR | 11(2) | WRBTR | ||||
BBAUWX | Building Value | BBAUWX | CURR | 15(2) | RECACURR | ||||
BBAUWAKT | OBSOLETE: Replaced by BBAUWAKTX - See SAP Note 1771933 | BBAUWAKTXOLD | CURR | 11(2) | WRBTR | ||||
BBAUWAKTX | Current Building Value | BBAUWAKTX | CURR | 15(2) | RECACURR | ||||
BDMCBMRA | Amount per volume unit | BDMCBMRA | CURR | 11(2) | WRBTR | ||||
DBAUGENE | Building permit | DBAUGENE | DATS | 8 | DDAT | ||||
XBAUGENE | Note on building permit | XBAUGENE | CHAR | 30 | XMBEZ | ||||
DBEZUGSF | Ready for occupancy | DBEZUGSF | DATS | 8 | DDAT | ||||
DFERTIG | Completion | DFERTIG | DATS | 8 | DDAT | ||||
DSCHLUSS | Final Inspection | DSCHLUSS | DATS | 8 | DDAT | ||||
JDENKMAL | Protection of Historical Sites | JDENKMAL | CHAR | 1 | JANE | ||||
DBAUVOR | Date of planning inquiry | DBAUVOR | DATS | 8 | DDAT | ||||
DVORBES | Date of prior notice | DVORBES | DATS | 8 | DDAT | ||||
DANTBAU | Application for building permit | DANTBAU | DATS | 8 | DATUM | ||||
BEINHEITW | OBSOLETE: Replaced by BEINHEITWX - See SAP Note 1771933 | BEINHEITWXOLD | CURR | 11(2) | WRBTR | ||||
BEINHEITWX | Assessed Value of Building | BEINHEITWX | CURR | 15(2) | RECACURR | ||||
NEINHEITW | Assessed value base year | NEINHEITW | NUMC | 4 | GJAHR | GJAHR | |||
BVERSWRT | OBSOLETE: Replaced by BVERSWRTX - See SAP Note 1771933 | BVERSWRTXOLD | CURR | 11(2) | WRBTR | ||||
BVERSWRTX | Insurable Value Amount | BVERSWRTX | CURR | 15(2) | RECACURR | ||||
RVERSWRT | Type of insurance value | RVERSWRT | NUMC | 1 | RVERSWRT | ||||
DWIRTUB | Transfer usage / charges | VVDWIRTUB | DATS | 8 | DATUM | ||||
DVERKAUF | Sale date | VVDVERKAUF | DATS | 8 | DATUM | ||||
DVRKPLAN | Planned sale | VVDVRKPLAN | DATS | 8 | DATUM | ||||
DNUTZEND | End of usage | VVDNUTZEND | DATS | 8 | DATUM | ||||
DFRDVON | Public funding from | VVDFRDVON | DATS | 8 | DATUM | ||||
DFRDBIS | Public funding to | VVDFRDBIS | DATS | 8 | DATUM | ||||
BANZGE | Number of floors | VVBANZGE | DEC | 4(1) | DEC3_1 | ||||
SUNUTZA | Main usage type | VVSUNART | CHAR | 8 | TIV36 | VVSUNART | |||
JUNUTZA | OBSOLETE: Main Usage Type | REBDJUNUTZAOBS | CHAR | 1 | CHAR1 | ||||
SSTCKBIS | Uppermost Floor of a Building | VVSTCKBIS | NUMC | 3 | Assigned to domain | VVSSTOCKW | |||
SLIFTBIS | Elevator to Floor in Building | VVLIFTBIS | NUMC | 3 | Assigned to domain | VVSSTOCKW | |||
AUGESCH | Number of basements | AUGESCH | DEC | 2 | DEC2 | ||||
JANLHIE | OBSOLETE: Asset Assignment Also Applies for Subord. Building | REBDJANLHIEOBS | CHAR | 1 | CHAR1 | ||||
RLRALOC | Location Class | REAJRLRALOC | CHAR | 6 | TIVAJRLRALOC | ALPHA | REAJRLRALOC | ||
USESRLRA | Representative List of Rents Is Used | REAJUSESRLRA | CHAR | 1 | RECABOOL | ||||
GEMEINDE | Municipality key | VVGEMEINDE | CHAR | 8 | TIVG1 | VVGEMEINDE | |||
REINS | Unit for cubic volume | REINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
HASCOP | Uses Current Occupancy Principle | RESCHASCOP | CHAR | 1 | RECABOOL | ||||
USGFUNCTION | Function of Object | REBDUSGFUNCTION | CHAR | 4 | TIVBDUSGFUNC | ALPHA | REBDUSGFUNCTION | REBDUSGFUNC | |
.INCLU--AP | 0 | ||||||||
OBJCOND | Code of Building Status | REXCCHBUCOND | NUMC | 4 | TIVXCCHCOND | REXCCHBUCOND | |||
OBJCAT | Building Category Code | REXCCHBUCATEGORY | NUMC | 4 | TIVXCCHKAT | REXCCHBUCATEGORY | |||
YEARDECONSTR | Year of Demolition | REXCCHBUDECONYEAR | DATS | 8 | DATUM | ||||
AREAVALUE | Floor Area of Building in Square Meters | REXCCHBUAREA | DEC | 10(2) | REXCCHGWRFORMATUNITFIELD | ||||
HEATINGTYPE | Code of Heating Type | REXCCHBUHEATINGTYPE | NUMC | 4 | TIVXCCHHEAT | REXCCHBUHEATINGTYPE | |||
ENERGYHEAT | Energy Carrier of Heating | REXCCHBUENERGYSOURCEH | NUMC | 4 | TIVXCCHGENSRC | REXCCHBUENERGYSOURCE | |||
ENERGYWATER | Energy Carrier of Hot Water | REXCCHBUENERGYSOURCEW | NUMC | 4 | TIVXCCHGENSRC | REXCCHBUENERGYSOURCE | |||
HOTWATERSUPPLY | Central Hot Water Supply | REXCCHBUHOTWATER | CHAR | 1 | RECABOOL | ||||
POWERCONSUM | Power Consumption of Building (in kWh) | REXCCHBUPOWERCONSUMPTION | DEC | 10(2) | REXCCHGWRFORMATUNITFIELD | ||||
GLAZING | Glazing Type | REXCCHBUGLAZING | CHAR | 15 | TEXT15 | ||||
ADMINNO | Administrative Building Number | REXCCHBUADMINNO | CHAR | 12 | ALPHA | REXCCHBUADMINNO | |||
ADMINXGETXT | Building Name | REXCCHBUADMINXBU | CHAR | 60 | RECAXLDESCRIPTION | ||||
GEMEINDECH | Land Register District | RELMLRDISTRICT | CHAR | 6 | Assigned to domain | RELMLRDISTRICT | RELMLRDISTRICT | RELMLRDIST | |
BANZGECH | Number of floors | VVBANZGE | DEC | 4(1) | DEC3_1 | ||||
SSTCKBISCH | Uppermost Floor of a Building | VVSTCKBIS | NUMC | 3 | Assigned to domain | VVSSTOCKW | |||
SLIFTBISCH | Elevator to Floor in Building | VVLIFTBIS | NUMC | 3 | Assigned to domain | VVSSTOCKW | |||
AUGESCHCH | Number of basements | AUGESCH | DEC | 2 | DEC2 | ||||
.INCLU--AP | 0 | ||||||||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
BUPLA | Business Place | BUPLA | CHAR | 4 | Assigned to domain | J_1BBRANCH | |||
.INCLU--AP | 0 | ||||||||
REPKOCH | Kind of Change | REXCJPREPKOCH | CHAR | 1 | REXCJPREPKOCH | ||||
BDCONSTR | Construction Status | REXCJPBDCONSTR | CHAR | 1 | REXCJPBDCONST | ||||
BDFIREPREV | Fire Fighting Method Number | REXCJPBDFIREPREV | CHAR | 8 | CHAR8 | ||||
BDOTHOW | Number of Another Owners in the Same Building | REXCJPBDOTHOW | INT4 | 10 | INT4 | ||||
BDOWNSHIP | Building Ownership Status | REXCJPBDOWNSHIP | CHAR | 1 | REXCJPBDOWNSH | ||||
KOCHDATE | Date of Change in Kind of Change | REXCJPKOCHDATE | DATS | 8 | RECADATE | ||||
.INCLU--AP | 0 | ||||||||
VPT | Property Taxable Value | REXCPTVPT_NOSIGN | CURR | 15(2) | REXCPTVPT_NOSIGN | ||||
CURRENCY | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
CONDK | Conservation Level | REXCPTRACONS | CHAR | 4 | TIVXCPTRACONS |
Key field | Non-key field |
How do I retrieve data from SAP table VIBDBU using ABAP code
The following ABAP code Example will allow you to do a basic selection on VIBDBU to SELECT all data from the tableDATA: WA_VIBDBU TYPE VIBDBU.
SELECT SINGLE *
FROM VIBDBU
INTO CORRESPONDING FIELDS OF WA_VIBDBU
WHERE...
How to access SAP table VIBDBU
Within an ECC or HANA version of SAP you can also view further information about VIBDBU and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects