SAP VIBDRO Rental Object Table
Overview
VIBDRO is a standard SAP S/4HANA table that stores Rental Object data. There are total 80 fields in the VIBDRO table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIBDRO belongs to Basic Data (RE-FX-BD) module and is located in the package RE: Rental Object Master Data (RE_BD_RO).
In addition, following links provide an overview of foreign key relationships, if any, that link VIBDRO to other SAP tables and standard CDS views available based on VIBDRO table in S/4HANA 2020.
Techincal Settings of VIBDRO
Below are technical details of the table VIBDRO
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIBDRO Fields
The following table gives you an overview of the fields available in VIBDRO
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| INTRENO | Internal Key of Real Estate Object | RECAINTRENO | CHAR | 13 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| SWENR | Business Entity Number | REBDBENO | * | CHAR | 8 |
| SMENR | Number of Rental Object | REBDRONO | CHAR | 8 | |
| OBJNR | Object Number | RECAOBJNR | * | CHAR | 22 |
| IMKEY | Internal Key of Real Estate Object (FI) | RECAIMKEY | CHAR | 8 | |
| CREATIONTYPE | How the Object Was Created | RECACREATIONTYPE | CHAR | 1 | |
| RERF | Entered By | RERF | CHAR | 12 | |
| DERF | First Entered On | DERF | DATS | 8 | |
| TERF | Time of Creation | TERF | TIMS | 6 | |
| REHER | Source of Initial Entry | REHER | CHAR | 10 | |
| RBEAR | Employee ID | RBEAR | CHAR | 12 | |
| DBEAR | Last Edited On | DBEAR | DATS | 8 | |
| TBEAR | Last Edited At | TBEAR | TIMS | 6 | |
| RBHER | Editing Source | RBHER | CHAR | 10 | |
| RESPONSIBLE | Person Responsible | RECARESPONSIBLE | USR02 | CHAR | 12 |
| USEREXCLUSIVE | User with Exclusive Change Authorization | RECAUSEREXCLUSIVE | USR02 | CHAR | 12 |
| AUTHGRP | Authorization Group | RECAAUTHGRP | CHAR | 40 | |
| VALIDFROM | Date: Object Valid From | REBDOBJVALIDFROM | DATS | 8 | |
| VALIDTO | Date: Object Valid To | REBDOBJVALIDTO | DATS | 8 | |
| ROTYPE | Rental Object Type | REBDROTYPE | CHAR | 2 | |
| SNUNR | Usage Type of Rental Object | REBDUSAGETYPE | TIV01 | NUMC | 4 |
| XMETXT | Rental Object Name | REBDXRO | CHAR | 60 | |
| SGRNR | Number of Land | REBDPRNO | CHAR | 8 | |
| SGENR | Number of Building | REBDBUNO | CHAR | 8 | |
| SALTNR | Number of rental unit in existing real estate system | SALTNR | CHAR | 20 | |
| CANBECOMMON | Common Usage Possible | REBDCANBECOMMON | CHAR | 1 | |
| FIRSTPOSTING | Cash Flow Generated Starting On | RECDCFSTARTFROM | DATS | 8 | |
| DBEZU | Date of initial usage | DBEZU | DATS | 8 | |
| DWTVERM | Date: Subsequent rental | DWTVERM | DATS | 8 | |
| DRESAB | Date: Reserved from | DRESA | DATS | 8 | |
| DRESBIS | Date: Reserved upto | DRESB | DATS | 8 | |
| SGEBT | Part of Building | SGEBT | TIV12 | CHAR | 2 |
| RLRAFIXFITCATE | Fixtures and Fittings Category | REAJRLRAFIXFITCATE | TIVAJRLRAFFCT | CHAR | 6 |
| RLRALOC | Location Class | REAJRLRALOC | TIVAJRLRALOC | CHAR | 6 |
| PZUABSP | Increase or Reduction for Representative List of Rents | REBDSUREPERCENT | DEC | 4 | |
| SPOSINMSP | Method for Calculating Base Rent of Rep. List of Rents | REBDRLRABASEIND | CHAR | 1 | |
| PPOSINMSP | Percentage for Positioning RU in RLR Spread | REBDRLRAPERCENT | DEC | 5 | |
| PERHOE | Percentage rate increase | PERHOE | DEC | 5 | |
| RPROZGRD | Reason for variance in rate of percentage increase | RPROZGRD | TIV43 | CHAR | 2 |
| RLGESCH | Location on Floor | RLGESCH | TIV38 | CHAR | 2 |
| XSTANDNR | Number of garage / parking space | VVXSTANDNR | CHAR | 5 | |
| JEIGWOHN | Rental Unit in Separate Ownership (COA) | VVJEIGWOHN | CHAR | 1 | |
| SSTOCKW | Floor | VVSSTOCKW | TIV37 | NUMC | 3 |
| SSTCKBIS | For RUs with Multiple Floors: Top Floor of RU | VVSSTCKBIS | TIV37 | NUMC | 3 |
| DRESTAUR | Date of reconstruction/extensive modernization | VVDRESTAUR | DATS | 8 | |
| CFARCHIVEDTO | Date Up to Which the Cash Flow Is Archived | RECDCFARCHIVEDTO | DATS | 8 | |
| CFLOCKEDTO | Date Until Which the Cash Flow Is Locked | RECDCFLOCKEDTO | DATS | 8 | |
| CFPOSTINGFROM | First Posting From | RECDCFPOSTINGFROM | DATS | 8 | |
| HASCOP | Uses Current Occupancy Principle | RESCHASCOP | CHAR | 1 | |
| RLRA | Representative List of Rents | REAJRLRA | TIVAJRLRA | CHAR | 6 |
| USESRLRA | Representative List of Rents Is Used | REAJUSESRLRA | CHAR | 1 | |
| BUILDYEAR | ConstYr | VVYBAUJAHR | DATS | 8 | |
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 |
| COMMONOWNED | Rental Object Is Common Property | REBDCOMMONOWNED | CHAR | 1 | |
| OOLOCK | Do Not Consider Object for Real Estate Search | REOROOLOCK | CHAR | 1 | |
| NEIGHBORH1 | Neighborhood | REBDNEIGHBORHOOD | TIVBDNEIGHBORH | CHAR | 30 |
| NEIGHBORH2 | Neighborhood | REBDNEIGHBORHOOD | TIVBDNEIGHBORH | CHAR | 30 |
| NEIGHBORH3 | Neighborhood | REBDNEIGHBORHOOD | TIVBDNEIGHBORH | CHAR | 30 |
| EDID | Federal Building Entrance Identification Number (EDID) | REXCCHEDID | NUMC | 2 | |
| EGID | Federal Building Identification Number (EGID) | REXCCHEGID | NUMC | 9 | |
| FLOOR | Code of Floor | REXCCHROFLOOR | NUMC | 4 | |
| FLOORLOC | Location of Dwelling on a Floor | REXCCHROFLOORLOC | CHAR | 40 | |
| EWID | Federal Dwelling Identification Number (EWID) | REXCCHEWID | NUMC | 3 | |
| KITCHEN | Code of Cooking Facilities | REXCCHROKITCHEN | NUMC | 4 | |
| ADMINNO | Administrative Dwelling Number | REXCCHROADMINNO | CHAR | 12 | |
| DOORNO | Door Number of Dwelling | REXCCHRODOORNO | CHAR | 8 | |
| OBJCOND | Code of Dwelling Status | REXCCHROCOND | NUMC | 4 | |
| YEARDECONSTR | Year of Demolition | REXCCHBUDECONYEAR | DATS | 8 | |
| NUMROOMS | Number of Rooms in the Dwelling | REXCCHRONUMROOMS | NUMC | 4 | |
| LIVINGAREA | Floor Area of Dwelling in M2 | REXCCHROAREA | DEC | 10 | |
| USAGETYPE | Code of Usage Type | REXCCHROUSAGETYPE | NUMC | 4 | |
| GEMEINDECH | Land Register District | RELMLRDISTRICT | CHAR | 6 | |
| PROTCV | Protected City View (Conservation Law 1988 Article 1g) | REXCNLPROTCV | CHAR | 1 | |
| LLPMON | Conservation Paid by Landlord | REXCNLLLPMON | CHAR | 1 | |
| CAREHOME | Care Home | REXCNLCAREHOME | CHAR | 1 | |
| STATMON | State Monument (Conservation Law 1988 Article 1d) | REXCNLSTATMON | CHAR | 1 | |
| VPT | Property Taxable Value | REXCPTVPT_NOSIGN | CURR | 15 | |
| VPTCURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VIBDRO
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIBDRO | BUKRS | 1: CN | T001 |
| VIBDRO | CONDK | : | TIVXCPTRACONS |
| VIBDRO | CURRENCY | 1: CN | TCURC |
| VIBDRO | NEIGHBORH1 | : | TIVBDNEIGHBORH |
| VIBDRO | NEIGHBORH2 | : | TIVBDNEIGHBORH |
| VIBDRO | NEIGHBORH3 | : | TIVBDNEIGHBORH |
| VIBDRO | OBJNR | 1: CN | * |
| VIBDRO | RESPONSIBLE | 1: CN | USR02 |
| VIBDRO | RLGESCH | C: CN | TIV38 |
| VIBDRO | RLRA | 1: CN | TIVAJRLRA |
| VIBDRO | RLRAFIXFITCATE | C: CN | TIVAJRLRAFFCT |
| VIBDRO | RLRALOC | C: CN | TIVAJRLRALOC |
| VIBDRO | RPROZGRD | 1: CN | TIV43 |
| VIBDRO | SGEBT | C: CN | TIV12 |
| VIBDRO | SGENR | C: CN | * |
| VIBDRO | SGRNR | C: CN | * |
| VIBDRO | SNUNR | : | TIV01 |
| VIBDRO | SSTCKBIS | C: CN | TIV37 |
| VIBDRO | SSTOCKW | C: CN | TIV37 |
| VIBDRO | USEREXCLUSIVE | C: CN | USR02 |
| VIBDRO | VPTCURRENCY | : | TCURC |