VIBDRO SAP table for – Rental Object

Here we would like to draw your attention to VIBDRO 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). VIBDRO is a SAP standard transp table used for storing Rental Object related data in SAP. It comes under the package RE_BD_RO.

SAP VIBDRO table

Table VIBDRO technical data

TableVIBDRO
Data storingRental Object
ModuleRE
Sub ModuleRE-FX-BD
SAP PackageRE_BD_RO
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIBDRO 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 VIBDRO 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 : Rental Object: 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
  • SMENR : Number of Rental Object
    Its data type is CHAR (Character String) with field length 8
  • .INCLUDE : Rental Object: 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
  • ROTYPE : Rental Object Type
    Its data type is CHAR (Character String) with field length 2
  • SNUNR : Usage Type of Rental Object
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • XMETXT : Rental Object Name
    Its data type is CHAR (Character String) with field length 60
  • SGRNR : Number of Land
    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
  • SALTNR : Number of rental unit in existing real estate system
    Its data type is CHAR (Character String) with field length 20
  • CANBECOMMON : Common Usage Possible
    Its data type is CHAR (Character String) with field length 1
  • FIRSTPOSTING : Cash Flow Generated Starting On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DBEZU : Date of initial usage
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DWTVERM : Date: Subsequent rental
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DRESAB : Date: Reserved from
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DRESBIS : Date: Reserved upto
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SGEBT : Part of Building
    Its data type is CHAR (Character String) with field length 2
  • RLRAFIXFITCATE : Fixtures and Fittings Category
    Its data type is CHAR (Character String) with field length 6
  • RLRALOC : Location Class
    Its data type is CHAR (Character String) with field length 6
  • PZUABSP : Increase or Reduction for Representative List of Rents
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • SPOSINMSP : Method for Calculating Base Rent of Rep. List of Rents
    Its data type is CHAR (Character String) with field length 1
  • PPOSINMSP : Percentage for Positioning RU in RLR Spread
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • PERHOE : Percentage rate increase
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • RPROZGRD : Reason for variance in rate of percentage increase
    Its data type is CHAR (Character String) with field length 2
  • RLGESCH : Location on Floor
    Its data type is CHAR (Character String) with field length 2
  • XSTANDNR : Number of garage / parking space
    Its data type is CHAR (Character String) with field length 5
  • JEIGWOHN : Rental Unit in Separate Ownership (COA)
    Its data type is CHAR (Character String) with field length 1
  • SSTOCKW : Floor
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SSTCKBIS : For RUs with Multiple Floors: Top Floor of RU
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DRESTAUR : Date of reconstruction/extensive modernization
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CFARCHIVEDTO : Date Up to Which the Cash Flow Is Archived
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CFLOCKEDTO : Date Until Which the Cash Flow Is Locked
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CFPOSTINGFROM : First Posting From
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • HASCOP : Uses Current Occupancy Principle
    Its data type is CHAR (Character String) with field length 1
  • RLRA : Representative List of Rents
    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
  • BUILDYEAR : ConstYr
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • COMMONOWNED : Rental Object Is Common Property
    Its data type is CHAR (Character String) with field length 1
  • OOLOCK : Do Not Consider Object for Real Estate Search
    Its data type is CHAR (Character String) with field length 1
  • NEIGHBORH1 : Neighborhood
    Its data type is CHAR (Character String) with field length 30
  • NEIGHBORH2 : Neighborhood
    Its data type is CHAR (Character String) with field length 30
  • NEIGHBORH3 : Neighborhood
    Its data type is CHAR (Character String) with field length 30
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Country Specific fields for Switzerland
  • .INCLUDE : Rental Object Customer fields
  • EDID : Federal Building Entrance Identification Number (EDID)
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • EGID : Federal Building Identification Number (EGID)
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • FLOOR : Code of Floor
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FLOORLOC : Location of Dwelling on a Floor
    Its data type is CHAR (Character String) with field length 40
  • EWID : Federal Dwelling Identification Number (EWID)
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • KITCHEN : Code of Cooking Facilities
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • ADMINNO : Administrative Dwelling Number
    Its data type is CHAR (Character String) with field length 12
  • DOORNO : Door Number of Dwelling
    Its data type is CHAR (Character String) with field length 8
  • OBJCOND : Code of Dwelling Status
    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
  • NUMROOMS : Number of Rooms in the Dwelling
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • LIVINGAREA : Floor Area of Dwelling in M2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • USAGETYPE : Code of Usage Type
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • GEMEINDECH : Land Register District
    Its data type is CHAR (Character String) with field length 6
  • .INCLU–AP : Country-Specific fields for Portugal
  • .INCLUDE : Country-Specific Fields for Portugal – Rental Object
  • VPT : Property Taxable Value
    Its data type is CURR (Currency Field) with field length 15
  • VPTCURRENCY : 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