SAP VDHOBJBL Determination of collateral value/Expert report of object Table data and field list

VDHOBJBL is a standard SAP Table which is used to store Determination of collateral value/Expert report of object data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDHOBJBL table consists of various fields, each holding specific information or linking keys about Determination of collateral value/Expert report of object data available in SAP. These include RBLNR (Collateral 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. .

VDHOBJBL table Technical Details:

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 VDHOBJBL table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VDHOBJBL table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
RBLNR	Collateral Number	VVRBLNR	NUMC	10			VVRBLNR	RBW	BELW
RERF	Entered by	RERF	CHAR	12			SYCHAR12
DERF	First Entered on	DERF	DATS	8			DATUM
TERF	Time of Initial Entry	TERF	TIMS	6			TIMES
REHER	Source of initial entry	REHER	CHAR	10			CHAR10
RBEAR	Employee ID	RBEAR	CHAR	12			SYCHAR12
DBEAR	Last Edited on	DBEAR	DATS	8			DATUM
TBEAR	Last Edited at	TBEAR	TIMS	6			TIMES
RBHER	Editing Source	RBHER	CHAR	10			CHAR10
ROBJNR	Collateral object number	ROBJNR	NUMC	10	Assigned to domain		SBOBJNR	BOB
JWTEIG	Resid./Part Ownership	VVJWTEIG	CHAR	1			JANEI
RGUTACHT	Expert/Surveyor Identity Key	RGUTACHT	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
DGUTDAT	Document date/expert opinion date	DURK	DATS	8			DATUM
JFRGUT	Third-party expert opinion indicator	JFREGUT	CHAR	1			JANEI
BVERKEHR	Market value	BVERKEHR	CURR	13(2)			BWHR
SBELWHR	Currency Key	WAERS	CUKY	5	TCURC		WAERS	FWS
BBELEIH	Collateral value	BBELEIH	CURR	13(2)			BWHR
BSACH	Real Value	BSACH	CURR	13(2)			BWHR
BVERKAUF	Selling value	VVBVERKAUF	CURR	13(2)			BWHR
BALTWMIN	Long-standing encumbrances reduc.in value	VVBALTWMIN	CURR	13(2)			BWHR
BAUFMOD	Expense for renovation/modernization/reconstruct./expansion	VVBAUFMOD	CURR	13(2)			BWHR
YBAUJ	ConstYr	VVYBAUJ	NUMC	4		GJAHR	GJAHR
BBAUWMIN	Construc.charges reduc.in value	VVBBAUWMIN	CURR	13(2)			BWHR
BBLABZ	Collateral value deduction (imputed)	VVBBLABZ	CURR	13(2)			BWHR
BBLVNABZ	Collateral Value Proposal After Imputed Deduction	VVBBLVNABZ	CURR	13(2)			BWHR
BBLVTAX	Proposal of valuer for collateral value	VVBBLVTAX	CURR	13(2)			BWHR
BBLVVABZ	Collateral Value Before Imputed Deduction	VVBBLVVABZ	CURR	13(2)			BWHR
XBEMERK	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
DBESICHT	Date of inspection of object	VVDBESICHT	DATS	8			DATUM
BKAUFPR	Purchase price/total prime costs	BKAUF	CURR	13(2)			BWHR
BSELBST	Self-help share amount (estimated)	VVBSELBST	CURR	13(2)			BWHR
SBWART	Type of Valuation Procedure	VVSBWART	NUMC	2	TDO4		VVSBWART
SBWST	Valuation status	VVSBWST	NUMC	1			VVSBWST
DAUFER	Date of expense creation	VVDAUFER	DATS	8			DATUM
DBLFEST	Date collateral value fixed	VVBLFEST	DATS	8			DATUM
DKAUF	Date of sales agreement	VVDKAUF	DATS	8			DATUM
DWEPRUEF	Date of valuation check	VVDWEPRUEF	DATS	8			DATUM
BOBJWERT	Determined object value	VVBOBJWERT	CURR	13(2)			BWHR
YLMOD	Year of last modernization	VVYLMOD	NUMC	4		GJAHR	GJAHR
PFERTIG	Degree of completion of object	VVPFERTIG	DEC	10(7)			DEC3_7
XGEBURTEIL	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
XGESAMT	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
BA2MIND	Reduction in value due to land register sect. II	VVBA2MIND	CURR	13(2)			BWHR
BHEREGS	Production costs excluding property	VVBHEREGS	CURR	13(2)			BWHR
BHERIGS	Production costs including property	VVBHERIGS	CURR	13(2)			BWHR
BMIET	Planned or realized rental income per year	VVBMIET	CURR	13(2)			BWHR
SALTLAST	Existing encumbrances check carried out	VVSALTLAST	CHAR	1			VVJANE
SALWMIND	Reduction in value due to existing encumbrances	VVSALWMIND	CHAR	1			VVJANE
SBEURT	Valuation rating base	VVSBEURT	NUMC	2	TDO5		VVSBEURT
SBLPR	Easement register checked	VVSBLPR	CHAR	1			VVJANE
SBLWMIND	Reduction in value due to construction encumbrances checked	VVSBLWMIND	CHAR	1			VVJANE
SBLRISI	Collateral risk	VVSBLRISI	CHAR	1			VVSBLRISI
SAOBJ	Reference to more detailed object description available	VVSAOBJ	CHAR	1			VVJANE
SEIGEN	Own Use	VVSEIGEN	CHAR	1			VVSEIGEN
SRENOV	Indicator for expansion/modernization/clearance measure	VVSRENOV	CHAR	1			VVSRENOV
SGEBURT	Building rating	VVSGEBURT	CHAR	1			VVSZUST
SOBJGES	General impression of object	VVSOBJGES	CHAR	1			VVSZUST
SA2WMIND	Decrease in valuation due to section II	VVSA2WMIND	CHAR	1			VVJANE
SA2OK	Section II of the Land Register Checked	VVSA2OK	CHAR	1			VVJANE
SKAUFPR	Purchase price rating	VVSKAUFPR	CHAR	1			VVSKAUFPR
SLAGE	Location Rating of Object	VVSLAGE	CHAR	1			VVSZUST
SLEER	Vacancies	VVSLEER	CHAR	1			VVSLEER
SMIETNW	Rent statement	VVSMIETNW	CHAR	1			VVSMIETNW
SZUWEG	Public right of way exists	VVSZUWEG	CHAR	1			VVJANE
SSELANT	Self-Help Share	VVSSELANT	CHAR	1			VVSSELANT
SSTARB	Work on Object Started	VVSTARB	CHAR	1			VVJANE
XLAST	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
XLAGE	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
SOBJART	Object type	SOBJART	NUMC	2	TIV5A		SOBJART
AJRLFZ	Heritable building right remaining life in years	VVAJRLFZ	DEC	3			DEC03
DIMIETE	Date fixing actual rent/rent expectation	VVDIMIETE	DATS	8			DATUM
XLAST1	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
XLAGE1	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
XBEMERK1	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
XGESAMT1	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
XGEBURT1	Text Field for Additional Descriptions	VVXTEXT78	CHAR	78			VVXTEXT78
SFGKZ	Release Indicator	VVSFGKZ	CHAR	1			VVSFGKZ
BMITTEL	Mean value between asset and revenue values	VVBMITTEL	CURR	13(2)			BWHR_V

Key field

Non-key field

< VDHOBJ - Collateral Objects VDHOBJGT - Object building parts >

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

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

SELECT SINGLE *
FROM VDHOBJBL
INTO CORRESPONDING FIELDS OF WA_VDHOBJBL
WHERE...

How to access SAP table VDHOBJBL

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

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