VDHOBJ SAP (Collateral Objects) Table details

Dictionary Type: Table
Description: Collateral Objects




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




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

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

The VDHOBJ table consists of various fields, each holding specific information or linking keys about Collateral Objects data available in SAP. These include ROBJNR (Collateral object number), RERF (Entered by), DERF (First Entered on), TERF (Time of Initial Entry).. 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 VDHOBJ 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 MANDTCLNT3T000MANDT
ROBJNRCollateral object number ROBJNRNUMC10SBOBJNRBOB
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
SGRUNDBLand register number SGRUNDBNUMC8Assigned to domainSGRUNDBGBS
SOBJARTObject type SOBJARTNUMC2TIV5ASOBJART
SNUTZARTMain usage type of object VVSNUTZNUMC4TIV01SNUNR
SOBJBAUObject building method indicator SOBJBAUNUMC2TDO1SOBJBAU
SOBJGEBIndicator: Area Description for Object SOBJGEBNUMC2TDO12SOBJGEB
SOBJLAGEIndicator - District of Object SOBJLAGENUMC2TIV45RESOBJLAGE
SVERKEHRTransport Connections of Business Entity SVERKEHRCHAR1TIV44SVERKEHR
SOBJZUSTIndicator for Condition of Object SOBJZUSTNUMC2TDO10SOBJZUST
SOBJAUSTObject fixtures/fittings indicator SOBJAUSTNUMC2TDO11SOBJAUST
DANTBAUApplication for building permit DANTBAUDATS8DATUM
DBAUGENEBuilding permit DBAUGENEDATS8DDAT
XBAUGENENote on building permit XBAUGENECHAR30XMBEZ
DBEZUGSFReady for occupancy DBEZUGSFDATS8DDAT
DFERTIGCompletion DFERTIGDATS8DDAT
DSCHLUSSFinal Inspection DSCHLUSSDATS8DDAT
YBAUJConstYr VVYBAUJNUMC4GJAHRGJAHR
YLMODYear of last modernization VVYLMODNUMC4GJAHRGJAHR
SGVERProperty conditions SGVERCHAR2TDO8SGVER
NWOHNNRApartment number for condominium NWOHNNRCHAR5CHAR5
NGESCHNRFloor Number for Condominium NGESCHNRCHAR5CHAR5
BBAUW13Building value BBAUW13CURR11(2) WRBTR
BKAUFPurchase price/total prime costs BKAUFCURR13(2) BWHR
SKAUFWHRCurrency Key WAERSCUKY5TCURCWAERSFWS
DKAUFObject purchase date DKAUFDATS8DATUM
FEINSArea unit FEINSUNIT3T006CUNITMEINSFEH
REINSUnit for cubic volume REINSUNIT3T006CUNITMEINS
SZWANGCollateral object legal measures ID VVSZWANGCHAR1VVSZWANG
JERBBAUHeritable building right indicator for collateral objects SOBJERBBAUCHAR1TDO9SOBJERBBAU
JREICHSHReichsheimstätte indicator JREICHSHCHAR1JANEI
DERBBAUInheritable building leasehold end DERBBAUDATS8DATUM
JDENKMALProtection of Historical Sites JDENKMALCHAR1JANE
RFAKTConversion factor for fractional share of property VVRFAKTNUMC6VVRFAKT
BMITEIGCo-ownership share BMITEIGDEC9(3) DEC6_3
RKLAMMERObject master number VVROBJSTMCHAR13VVRSTANRBOS
JHAUPTIndicator for the main object within a complete object VVJHAUPTCHAR1JANEI
XOBJALTPrevious object number XOBJALTCHAR15XKBEZ
SFGKZRelease Indicator VVSFGKZCHAR1VVSFGKZ
BOBADRNRAddress number for collateral object BOBADRNRCHAR10ADRCALPHAAD_ADDRNUMADR

Key field Non-key field



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

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

SELECT SINGLE *
FROM VDHOBJ
INTO CORRESPONDING FIELDS OF WA_VDHOBJ
WHERE...

How to access SAP table VDHOBJ

Within an ECC or HANA version of SAP you can also view further information about VDHOBJ 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!