VIBDBE SAP table for – Business Entity

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

SAP VIBDBE table

Table VIBDBE technical data

TableVIBDBE
Data storingBusiness Entity
ModuleRE
Sub ModuleRE-FX-BD
SAP PackageRE_BD_BE
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FIN
Table CategoryTRANSP

SAP VIBDBE 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 VIBDBE 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 : Business Entity: 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
  • .INCLUDE : Business Entity: 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
  • XWETEXT : Business Entity Name
    Its data type is CHAR (Character String) with field length 60
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FEINS : Area unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • REINS : Unit for cubic volume
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • VVLEN : Unit of length
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • SINSTBEZ : Maintenance district
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • SSTDORT : Regional location
    Its data type is CHAR (Character String) with field length 10
  • SVERKEHR : Transport Connections of Business Entity
    Its data type is CHAR (Character String) with field length 1
  • SLAGEWE : Business entity location number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • SOBJLAGE : Indicator: District Location of Object
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SMIETR : Tenancy law
    Its data type is CHAR (Character String) with field length 5
  • RLRA : Representative List of Rents
    Its data type is CHAR (Character String) with field length 6
  • VORBK : Predefined operating costs settlement variant
    Its data type is CHAR (Character String) with field length 4
  • VORHK : Predefined heating expenses settlement variant
    Its data type is CHAR (Character String) with field length 4
  • XNOTPL : No automatic creation of functional location allowed
    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
  • 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 for India – BE
  • 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