VIBDBE SAP (Business Entity) Table details

Dictionary Type: Table
Description: Business Entity




ABAP Code to SELECT data from VIBDBE
Related tables to VIBDBE
Access table VIBDBE




Table field list including key, data, relationships and ABAP select examples

VIBDBE is a standard SAP Table which is used to store Business Entity data and is available within R/3 SAP systems depending on the version and release level.

The VIBDBE table consists of various fields, each holding specific information or linking keys about Business Entity data available in SAP. These include INTRENO (Internal Key of Real Estate Object), BUKRS (Company Code), SWENR (Site Number), OBJNR (Object Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VIBDBE table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
SWENRSite Number REBDBENOCHAR8Assigned to domainSWENRREBDBENOREBDBENOREBDBENO
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
IMKEYInternal Key of Real Estate Object (FI) RECAIMKEYCHAR8IMKEYIMKEYRECLFXCAIMKEY
CREATIONTYPEHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
RESPONSIBLEPerson Responsible RECARESPONSIBLECHAR12USR02XUBNAMEUSER_COMP
USEREXCLUSIVEUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12USR02XUBNAMEUSER_COMP
AUTHGRPAuthorization Group RECAAUTHGRPCHAR40RECAAUTHGRP
VALIDFROMDate: Object Valid From REBDOBJVALIDFROMDATS8RECADATEBEG
VALIDTODate: Object Valid To REBDOBJVALIDTODATS8REDATRECADATEEND
XWETEXTSite Name REBDXBECHAR60RECAXLDESCRIPTION
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
FEINSArea unit FEINSUNIT3T006CUNITMEINSFEH
REINSUnit for cubic volume REINSUNIT3T006CUNITMEINS
VVLENUnit of length VVLENUNIT3T006CUNITMEINS
SINSTBEZMaintenance district SINSTBEZNUMC5TIV16SINSTBEZ
SSTDORTRegional location VVSSTDORTCHAR10TIV35VVSSTDORT
SVERKEHRTransport Connections of Business Entity SVERKEHRCHAR1TIV44SVERKEHR
SLAGEWEBusiness entity location number SLAGEWENUMC4TIV10SLAGEWE
SOBJLAGEIndicator: District Location of Object RESOBJLAGENUMC2TIV45RESOBJLAGE
SMIETRTenancy law SMIETRCHAR5TIV03SMIETR
RLRARepresentative List of Rents REAJRLRACHAR6TIVAJRLRAALPHAREAJRLRA
VORBKPredefined operating costs settlement variant VORBKCHAR4TIA01ABRVAR
VORHKPredefined heating expenses settlement variant VORHKCHAR4TIA01ABRVAR
XNOTPLNo automatic creation of functional location allowed VVXNOTPLCHAR1XFELD
NEIGHBORH1Neighborhood REBDNEIGHBORHOODCHAR30TIVBDNEIGHBORHREBDNEIGHBORHOOD
NEIGHBORH2Neighborhood REBDNEIGHBORHOODCHAR30TIVBDNEIGHBORHREBDNEIGHBORHOOD
NEIGHBORH3Neighborhood REBDNEIGHBORHOODCHAR30TIVBDNEIGHBORHREBDNEIGHBORHOOD
USGFUNCTIONFunction of Object REBDUSGFUNCTIONCHAR4TIVBDUSGFUNCALPHAREBDUSGFUNCTIONREBDUSGFUNC
.INCLU--AP 0
SECCOSection Code SECCOCHAR4Assigned to domainSECCOSECCO_ABA
BUPLABusiness Place BUPLACHAR4Assigned to domainJ_1BBRANCH
.INCLU--AP 0
REYCRELEVANTRelevant to CAM REYCRELEVANTCHAR1RECABOOL
REYCPERIODLENDefault Length of CAM Period in Months REYCPERIODLENNUMC2REYCPERIODLEN
REYC1STPERIODStart Date of First CAM Recovery Period REYC1STPERIODDATS8RECADATEBEG

Key field Non-key field



How do I retrieve data from SAP table VIBDBE using ABAP code

The following ABAP code Example will allow you to do a basic selection on VIBDBE to SELECT all data from the table
DATA: WA_VIBDBE TYPE VIBDBE.

SELECT SINGLE *
FROM VIBDBE
INTO CORRESPONDING FIELDS OF WA_VIBDBE
WHERE...

How to access SAP table VIBDBE

Within an ECC or HANA version of SAP you can also view further information about VIBDBE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!