SAP VIBDBE Business Entity Table
Overview
VIBDBE is a standard SAP S/4HANA table that stores Business Entity data. There are total 41 fields in the VIBDBE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VIBDBE belongs to Basic Data (RE-FX-BD) module and is located in the package RE: Business Entity (Master Data) (RE_BD_BE).
In addition, following links provide an overview of foreign key relationships, if any, that link VIBDBE to other SAP tables and standard CDS views available based on VIBDBE table in S/4HANA 2020.
Techincal Settings of VIBDBE
Below are technical details of the table VIBDBE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VIBDBE Fields
The following table gives you an overview of the fields available in VIBDBE
| 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 | |
| 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 | |
| XWETEXT | Business Entity Name | REBDXBE | CHAR | 60 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| FEINS | Area Unit | FEINS | T006 | UNIT | 3 |
| REINS | Unit for cubic volume | REINS | T006 | UNIT | 3 |
| VVLEN | Unit of length | VVLEN | T006 | UNIT | 3 |
| SINSTBEZ | Maintenance district | SINSTBEZ | TIV16 | NUMC | 5 |
| SSTDORT | Regional location | VVSSTDORT | TIV35 | CHAR | 10 |
| SVERKEHR | Transport Connections of Business Entity | SVERKEHR | TIV44 | CHAR | 1 |
| SLAGEWE | Business entity location number | SLAGEWE | TIV10 | NUMC | 4 |
| SOBJLAGE | Indicator: District Location of Object | RESOBJLAGE | TIV45 | NUMC | 2 |
| SMIETR | Tenancy law | SMIETR | TIV03 | CHAR | 5 |
| RLRA | Representative List of Rents | REAJRLRA | TIVAJRLRA | CHAR | 6 |
| VORBK | Predefined operating costs settlement variant | VORBK | TIA01 | CHAR | 4 |
| VORHK | Predefined heating expenses settlement variant | VORHK | TIA01 | CHAR | 4 |
| XNOTPL | No automatic creation of functional location allowed | VVXNOTPL | CHAR | 1 | |
| NEIGHBORH1 | Neighborhood | REBDNEIGHBORHOOD | TIVBDNEIGHBORH | CHAR | 30 |
| NEIGHBORH2 | Neighborhood | REBDNEIGHBORHOOD | TIVBDNEIGHBORH | CHAR | 30 |
| NEIGHBORH3 | Neighborhood | REBDNEIGHBORHOOD | TIVBDNEIGHBORH | CHAR | 30 |
| USGFUNCTION | Function of Object | REBDUSGFUNCTION | TIVBDUSGFUNC | CHAR | 4 |
| SECCO | Section Code | SECCO | CHAR | 4 | |
| BUPLA | Business Place | BUPLA | * | CHAR | 4 |
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 VIBDBE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VIBDBE | BUKRS | 1: CN | T001 |
| VIBDBE | FEINS | 1: CN | T006 |
| VIBDBE | NEIGHBORH1 | : | TIVBDNEIGHBORH |
| VIBDBE | NEIGHBORH2 | : | TIVBDNEIGHBORH |
| VIBDBE | NEIGHBORH3 | : | TIVBDNEIGHBORH |
| VIBDBE | OBJNR | 1: CN | * |
| VIBDBE | REINS | 1: CN | T006 |
| VIBDBE | RESPONSIBLE | 1: CN | USR02 |
| VIBDBE | RLRA | C: CN | TIVAJRLRA |
| VIBDBE | SINSTBEZ | C: CN | TIV16 |
| VIBDBE | SLAGEWE | C: CN | TIV10 |
| VIBDBE | SMIETR | 1: CN | TIV03 |
| VIBDBE | SOBJLAGE | C: CN | TIV45 |
| VIBDBE | SSTDORT | C: CN | TIV35 |
| VIBDBE | SVERKEHR | C: CN | TIV44 |
| VIBDBE | USEREXCLUSIVE | C: CN | USR02 |
| VIBDBE | USGFUNCTION | C: CN | TIVBDUSGFUNC |
| VIBDBE | VORBK | C: CN | TIA01 |
| VIBDBE | VORHK | C: CN | TIA01 |
| VIBDBE | VVLEN | 1: CN | T006 |
| VIBDBE | WAERS | 1: CN | TCURC |
| VIBDBE | ZZOPS_CODE | : | ZOPS_CLUST_TAB |