1. SAP Tutorial
  2. Real Estate Management

VIBDBU SAP table for – Building

Here we would like to draw your attention to VIBDBU table in SAP. As we know it is being mainly used with the SAP RE-FX (Flexible Real Estate Management in RE) component which is coming under RE module (Real Estate Management). VIBDBU is a SAP standard transp table used for storing Building related data in SAP. It comes under the package RE_BD_BU.

SAP VIBDBU table

Table VIBDBU technical data

TableVIBDBU
Data storingBuilding
ModuleRE
Sub ModuleRE-FX-BD
SAP PackageRE_BD_BU
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIBDBU Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VIBDBU table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INTRENO : Internal Key of Real Estate Object
    Its a key field. Its data type is CHAR (Character String) with field length 13
  • .INCLUDE : Building: Key Fields
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • SWENR : Business Entity Number
    Its data type is CHAR (Character String) with field length 8
  • SGENR : Number of Building
    Its data type is CHAR (Character String) with field length 8
  • .INCLUDE : Building: Non-Key Fields
  • OBJNR : Object Number
    Its data type is CHAR (Character String) with field length 22
  • IMKEY : Internal Key of Real Estate Object (FI)
    Its data type is CHAR (Character String) with field length 8
  • CREATIONTYPE : How the Object Was Created
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Field String for Maintenance of User Data
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • RESPONSIBLE : Person Responsible
    Its data type is CHAR (Character String) with field length 12
  • USEREXCLUSIVE : User with Exclusive Change Authorization
    Its data type is CHAR (Character String) with field length 12
  • AUTHGRP : Authorization Group
    Its data type is CHAR (Character String) with field length 40
  • VALIDFROM : Date: Object Valid From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALIDTO : Date: Object Valid To
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XGETXT : Description of Building
    Its data type is CHAR (Character String) with field length 60
  • RGEBART : Type of building
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • JERBBAU : Heritable building right indicator
    Its data type is CHAR (Character String) with field length 1
  • RGEBZUST : General condition of building
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • YBAUJAHR : ConstYr
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • YMODERN : Year of modernization
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • YAUFBAU : Year of reconstruction
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBAUBEGI : Construction start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BBAUW13 : OBSOLETE: Replaced by BBAUWX – See SAP Note 1771933
    Its data type is CURR (Currency Field) with field length 11
  • BBAUWX : Building Value
    Its data type is CURR (Currency Field) with field length 15
  • BBAUWAKT : OBSOLETE: Replaced by BBAUWAKTX – See SAP Note 1771933
    Its data type is CURR (Currency Field) with field length 11
  • BBAUWAKTX : Current Building Value
    Its data type is CURR (Currency Field) with field length 15
  • BDMCBMRA : Amount per volume unit
    Its data type is CURR (Currency Field) with field length 11
  • DBAUGENE : Building permit
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XBAUGENE : Note on building permit
    Its data type is CHAR (Character String) with field length 30
  • DBEZUGSF : Ready for occupancy
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFERTIG : Completion
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DSCHLUSS : Final Inspection
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • JDENKMAL : Protection of Historical Sites
    Its data type is CHAR (Character String) with field length 1
  • DBAUVOR : Date of planning inquiry
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DVORBES : Date of prior notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DANTBAU : Application for building permit
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BEINHEITW : OBSOLETE: Replaced by BEINHEITWX – See SAP Note 1771933
    Its data type is CURR (Currency Field) with field length 11
  • BEINHEITWX : Assessed Value of Building
    Its data type is CURR (Currency Field) with field length 15
  • NEINHEITW : Assessed value base year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BVERSWRT : OBSOLETE: Replaced by BVERSWRTX – See SAP Note 1771933
    Its data type is CURR (Currency Field) with field length 11
  • BVERSWRTX : Insurable Value Amount
    Its data type is CURR (Currency Field) with field length 15
  • RVERSWRT : Type of insurance value
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • DWIRTUB : Transfer usage / charges
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DVERKAUF : Sale date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DVRKPLAN : Planned sale
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DNUTZEND : End of usage
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFRDVON : Public funding from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFRDBIS : Public funding to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BANZGE : Number of floors
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SUNUTZA : Main usage type
    Its data type is CHAR (Character String) with field length 8
  • JUNUTZA : OBSOLETE: Main Usage Type
    Its data type is CHAR (Character String) with field length 1
  • SSTCKBIS : Uppermost Floor of a Building
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SLIFTBIS : Elevator to Floor in Building
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • AUGESCH : Number of basements
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • JANLHIE : OBSOLETE: Asset Assignment Also Applies for Subord. Building
    Its data type is CHAR (Character String) with field length 1
  • RLRALOC : Location Class
    Its data type is CHAR (Character String) with field length 6
  • USESRLRA : Representative List of Rents Is Used
    Its data type is CHAR (Character String) with field length 1
  • GEMEINDE : Municipality key
    Its data type is CHAR (Character String) with field length 8
  • REINS : Unit for cubic volume
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • HASCOP : Uses Current Occupancy Principle
    Its data type is CHAR (Character String) with field length 1
  • USGFUNCTION : Function of Object
    Its data type is CHAR (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Country specific fields (CI) for Switzerland – BU
  • .INCLUDE : Building Customer fields
  • OBJCOND : Code of Building Status
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • OBJCAT : Building Category Code
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • YEARDECONSTR : Year of Demolition
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AREAVALUE : Floor Area of Building in Square Meters
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • HEATINGTYPE : Code of Heating Type
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ENERGYHEAT : Energy Carrier of Heating
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ENERGYWATER : Energy Carrier of Hot Water
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • HOTWATERSUPPLY : Central Hot Water Supply
    Its data type is CHAR (Character String) with field length 1
  • POWERCONSUM : Power Consumption of Building (in kWh)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • GLAZING : Glazing Type
    Its data type is CHAR (Character String) with field length 15
  • ADMINNO : Administrative Building Number
    Its data type is CHAR (Character String) with field length 12
  • ADMINXGETXT : Building Name
    Its data type is CHAR (Character String) with field length 60
  • GEMEINDECH : Land Register District
    Its data type is CHAR (Character String) with field length 6
  • BANZGECH : Number of floors
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SSTCKBISCH : Uppermost Floor of a Building
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SLIFTBISCH : Elevator to Floor in Building
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • AUGESCHCH : Number of basements
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 2
  • .INCLU–AP : Country specific fields for India – BU
  • SECCO : Section Code
    Its data type is CHAR (Character String) with field length 4
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • .INCLU–AP : Localization Japan: Additional fields Building
  • .INCLUDE : Country Specific Fields for Japan
  • REPKOCH : Kind of Change
    Its data type is CHAR (Character String) with field length 1
  • BDCONSTR : Construction Status
    Its data type is CHAR (Character String) with field length 1
  • BDFIREPREV : Fire Fighting Method Number
    Its data type is CHAR (Character String) with field length 8
  • BDOTHOW : Number of Another Owners in the Same Building
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • BDOWNSHIP : Building Ownership Status
    Its data type is CHAR (Character String) with field length 1
  • KOCHDATE : Date of Change in Kind of Change
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLU–AP : Country-Specific fields for Portugal – Building
  • .INCLUDE : Country-Specific Fields for Portugal – Building
  • VPT : Property Taxable Value
    Its data type is CURR (Currency Field) with field length 15
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CONDK : Conservation Level
    Its data type is CHAR (Character String) with field length 4

    • VIBDBU related tables

    • VIBDBU : Building

    VIBDBU related transaction codes under SAP package RE_BD_BU

    • REBDBU0104 : BU: Screen Configuration
    • REBDBU0014 : BU: Role Category Groupings
    • REBDBU0001 : BU: Applications
    • REBDBU0006 : BU: Screen Sequences
    • REBDBU0107 : BU: Where-Used List: Views
    • REBDBU0002 : BU: Field Groups
    • REBDBU0017 : BU: External Applications
    • REBDBU0102 : BU: Authorization Types
    • REBDBU0100 : BU: Field Modification per Activity
    • REBDBU0103 : BU: Field Groups for Authorization
    • REBDBU : Process Building
    • REBDBU0003 : BU: Views
    • REBDBU0013 : BU: Role Categories
    • REBDBU0011 : BU: Assgmt Screen Field->DB Field
    • REBDBU0106 : BU:Assignment Obj Part –> Notice ID
    • REBDBU0007 : BU: Events
    • REBDBU0016 : BU: Tables
    • REBDBU0008 : BU: CUA Standard Functions
    • REBDBU0022 : BU: Where-Used List: Structure
    • REBDBU0012 : BU: Field Modification Criteria

    Related References

    Related Tutorials

    VIXCITICIDBUD SAP table for – ICI parameter for D-Building

    VIXCITICIDBUD table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    TIVAJRLRAAGE SAP table for – Building Age Category

    TIVAJRLRAAGE table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIRAADVPAYSPLIT SAP table for – Split Advance Payments

    VIRAADVPAYSPLIT table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIEXCFCNDNS SAP table for – Cash Flow Summarization

    VIEXCFCNDNS table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VIRAINVITEM SAP table for – RE Invoice Item

    VIRAINVITEM table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISCRECEIVABLE SAP table for – Receivables from Settlement

    VISCRECEIVABLE table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    VISCCRSPLIT SAP table for – Split Receivable

    VISCCRSPLIT table in SAP RE (Flexible Real Estate Management in RE) module. This table is used for storing data of...

    «
    »