REBD_BUILDING_X SAP (Building + Additional Fields (VIBDBU)) Structure details
Dictionary Type: Structure
Description: Building + Additional Fields (VIBDBU)
Description: Building + Additional Fields (VIBDBU)
ABAP Code to SELECT data from REBD_BUILDING_X
Related tables to REBD_BUILDING_X
Access table REBD_BUILDING_X
Related tables to REBD_BUILDING_X
Access table REBD_BUILDING_X
Structure field list including key, data, relationships and ABAP select examples
REBD_BUILDING_X is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Building + Additional Fields (VIBDBU)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_REBD_BUILDING_X TYPE REBD_BUILDING_X.
The REBD_BUILDING_X table consists of various fields, each holding specific information or linking keys about Building + Additional Fields (VIBDBU) data available in SAP. These include MANDT (Client), INTRENO (Internal Key of Real Estate Object), BUKRS (Company Code), SWENR (Site Number).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP REBD_BUILDING_X structure 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 | ||||
| BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | TEXT25 | ||||
| XWETEXT | Site Name | REBDXBE | CHAR | 60 | RECAXLDESCRIPTION | ||||
| XUNART | Main usage type | VVXUNART | CHAR | 35 | XTEXT35 | ||||
| KTEXT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
| XGEBART | Type of building | XGEBART | CHAR | 50 | XTEXT50 | ||||
| XGEBZUST | Description of condition of building | XGEBZUST | CHAR | 50 | XTEXT50 | ||||
| XGEMEINDE | Name of municipality | VVXGEMEINDE | CHAR | 50 | VVXGEMEINDE | ||||
| XKREIS | Name of district | VVXKREIS | CHAR | 30 | VVXKREIS | ||||
| XREGIO | Name of federal state | VVXREGIO | CHAR | 30 | VVXREGIO | ||||
| RLRA | Representative List of Rents | REAJRLRA | CHAR | 6 | TIVAJRLRA | ALPHA | REAJRLRA | ||
| XRLRA | Description of Representative List of Rents | REAJXRLRA | CHAR | 60 | RECAXLDESCRIPTION | ||||
| XRLRALOC | Name of Location Class | REAJXRLRALOC | CHAR | 60 | RECAXLDESCRIPTION | ||||
| XDAZUST | Description of condition of a real estate object | VVXZUSTTXT | CHAR | 50 | XTEXT50 | ||||
| XFAZUST | Description of condition of a real estate object | VVXZUSTTXT | CHAR | 50 | XTEXT50 | ||||
| XADDRESS | Compact Display of Address | REBPXADDRESS | CHAR | 80 | REBPXADDRESS | ||||
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| REALVALIDFROM | Date: Valid from (Effective) | REBDREALVALIDFROM | DATS | 8 | RECADATEBEG | ||||
| REALVALIDTO | Date: Valid to (Effective) | REBDREALVALIDTO | DATS | 8 | REDAT | RECADATEEND | |||
| XSTOCKO | Top Floor (Floor Name) | REBDXSTOCKO | CHAR | 15 | XKBEZ | ||||
| XSTOCKL | Elevator to (Floor Name) | REBDXSTOCKL | CHAR | 15 | XKBEZ | ||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
| XAUTHGRP | Description of Authorization Group | RECAXAUTHGRP | CHAR | 60 | RECAXLDESCRIPTION | ||||
| XMUSGFUNCTION | Name of Function of Object (Medium) | REBDXMUSGFUNCTION | CHAR | 30 | RECAXMDESCRIPTION | ||||
| XJERBBAUK | Name | XTEXT15 | CHAR | 15 | TEXT15 | ||||
| XJERBBAUL | Name | XTEXT30 | CHAR | 30 | TEXT30 |
| Key field | Non-key field |
How do I retrieve data from SAP structure REBD_BUILDING_X using ABAP code?
As REBD_BUILDING_X is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on REBD_BUILDING_X as there is no data to select.How to access SAP table REBD_BUILDING_X
Within an ECC or HANA version of SAP you can also view further information about REBD_BUILDING_X 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