SAP ABAP Table VDHOBJBL (Determination of collateral value/Expert report of object)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDHOBJBL	Table Relationship Diagram
Short Description	Determination of collateral value/Expert report of object

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RBLNR	☑	VVRBLNR	VVRBLNR	NUMC	10	0	Collateral Number
3	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
4	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
5	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
6	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
7	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
8	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
9	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
10	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
11	ROBJNR	☐	ROBJNR	SBOBJNR	NUMC	10	0	Collateral object number	*
12	JWTEIG	☐	VVJWTEIG	JANEI	CHAR	1	0	Resid./Part Ownership
13	RGUTACHT	☐	RGUTACHT	BU_PARTNER	CHAR	10	0	Expert/Surveyor Identity Key	*
14	DGUTDAT	☐	DURK	DATUM	DATS	8	0	Document date/expert opinion date
15	JFRGUT	☐	JFREGUT	JANEI	CHAR	1	0	Third-party expert opinion indicator
16	BVERKEHR	☐	BVERKEHR	BWHR	CURR	13	2	Market value
17	SBELWHR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
18	BBELEIH	☐	BBELEIH	BWHR	CURR	13	2	Collateral value
19	BSACH	☐	BSACH	BWHR	CURR	13	2	Real Value
20	BVERKAUF	☐	VVBVERKAUF	BWHR	CURR	13	2	Selling value
21	BALTWMIN	☐	VVBALTWMIN	BWHR	CURR	13	2	Long-standing encumbrances reduc.in value
22	BAUFMOD	☐	VVBAUFMOD	BWHR	CURR	13	2	Expense for renovation/modernization/reconstruct./expansion
23	YBAUJ	☐	VVYBAUJ	GJAHR	NUMC	4	0	ConstYr
24	BBAUWMIN	☐	VVBBAUWMIN	BWHR	CURR	13	2	Construc.charges reduc.in value
25	BBLABZ	☐	VVBBLABZ	BWHR	CURR	13	2	Collateral value deduction (imputed)
26	BBLVNABZ	☐	VVBBLVNABZ	BWHR	CURR	13	2	Collateral Value Proposal After Imputed Deduction
27	BBLVTAX	☐	VVBBLVTAX	BWHR	CURR	13	2	Proposal of valuer for collateral value
28	BBLVVABZ	☐	VVBBLVVABZ	BWHR	CURR	13	2	Collateral Value Before Imputed Deduction
29	XBEMERK	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
30	DBESICHT	☐	VVDBESICHT	DATUM	DATS	8	0	Date of inspection of object
31	BKAUFPR	☐	BKAUF	BWHR	CURR	13	2	Purchase price/total prime costs
32	BSELBST	☐	VVBSELBST	BWHR	CURR	13	2	Self-help share amount (estimated)
33	SBWART	☐	VVSBWART	VVSBWART	NUMC	2	0	Type of Valuation Procedure	TDO4
34	SBWST	☐	VVSBWST	VVSBWST	NUMC	1	0	Valuation status
35	DAUFER	☐	VVDAUFER	DATUM	DATS	8	0	Date of expense creation
36	DBLFEST	☐	VVBLFEST	DATUM	DATS	8	0	Date collateral value fixed
37	DKAUF	☐	VVDKAUF	DATUM	DATS	8	0	Date of sales agreement
38	DWEPRUEF	☐	VVDWEPRUEF	DATUM	DATS	8	0	Date of valuation check
39	BOBJWERT	☐	VVBOBJWERT	BWHR	CURR	13	2	Determined object value
40	YLMOD	☐	VVYLMOD	GJAHR	NUMC	4	0	Year of last modernization
41	PFERTIG	☐	VVPFERTIG	DEC3_7	DEC	10	7	Degree of completion of object
42	XGEBURTEIL	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
43	XGESAMT	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
44	BA2MIND	☐	VVBA2MIND	BWHR	CURR	13	2	Reduction in value due to land register sect. II
45	BHEREGS	☐	VVBHEREGS	BWHR	CURR	13	2	Production costs excluding property
46	BHERIGS	☐	VVBHERIGS	BWHR	CURR	13	2	Production costs including property
47	BMIET	☐	VVBMIET	BWHR	CURR	13	2	Planned or realized rental income per year
48	SALTLAST	☐	VVSALTLAST	VVJANE	CHAR	1	0	Existing encumbrances check carried out
49	SALWMIND	☐	VVSALWMIND	VVJANE	CHAR	1	0	Reduction in value due to existing encumbrances
50	SBEURT	☐	VVSBEURT	VVSBEURT	NUMC	2	0	Valuation rating base	TDO5
51	SBLPR	☐	VVSBLPR	VVJANE	CHAR	1	0	Easement register checked
52	SBLWMIND	☐	VVSBLWMIND	VVJANE	CHAR	1	0	Reduction in value due to construction encumbrances checked
53	SBLRISI	☐	VVSBLRISI	VVSBLRISI	CHAR	1	0	Collateral risk
54	SAOBJ	☐	VVSAOBJ	VVJANE	CHAR	1	0	Reference to more detailed object description available
55	SEIGEN	☐	VVSEIGEN	VVSEIGEN	CHAR	1	0	Own Use
56	SRENOV	☐	VVSRENOV	VVSRENOV	CHAR	1	0	Indicator for expansion/modernization/clearance measure
57	SGEBURT	☐	VVSGEBURT	VVSZUST	CHAR	1	0	Building rating
58	SOBJGES	☐	VVSOBJGES	VVSZUST	CHAR	1	0	General impression of object
59	SA2WMIND	☐	VVSA2WMIND	VVJANE	CHAR	1	0	Decrease in valuation due to section II
60	SA2OK	☐	VVSA2OK	VVJANE	CHAR	1	0	Section II of the Land Register Checked
61	SKAUFPR	☐	VVSKAUFPR	VVSKAUFPR	CHAR	1	0	Purchase price rating
62	SLAGE	☐	VVSLAGE	VVSZUST	CHAR	1	0	Location Rating of Object
63	SLEER	☐	VVSLEER	VVSLEER	CHAR	1	0	Vacancies
64	SMIETNW	☐	VVSMIETNW	VVSMIETNW	CHAR	1	0	Rent statement
65	SZUWEG	☐	VVSZUWEG	VVJANE	CHAR	1	0	Public right of way exists
66	SSELANT	☐	VVSSELANT	VVSSELANT	CHAR	1	0	Self-Help Share
67	SSTARB	☐	VVSTARB	VVJANE	CHAR	1	0	Work on Object Started
68	XLAST	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
69	XLAGE	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
70	SOBJART	☐	SOBJART	SOBJART	NUMC	2	0	Object type	TIV5A
71	AJRLFZ	☐	VVAJRLFZ	DEC03	DEC	3	0	Heritable building right remaining life in years
72	DIMIETE	☐	VVDIMIETE	DATUM	DATS	8	0	Date fixing actual rent/rent expectation
73	XLAST1	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
74	XLAGE1	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
75	XBEMERK1	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
76	XGESAMT1	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
77	XGEBURT1	☐	VVXTEXT78	VVXTEXT78	CHAR	78	0	Text Field for Additional Descriptions
78	SFGKZ	☐	VVSFGKZ	VVSFGKZ	CHAR	1	0	Release Indicator
79	BMITTEL	☐	VVBMITTEL	BWHR_V	CURR	13	2	Mean value between asset and revenue values

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDHOBJBL	MANDT	T000	MANDT	KEY	1	1
2	VDHOBJBL	SBELWHR	TCURC	WAERS	KEY	1	CN
3	VDHOBJBL	SBEURT	TDO5	SBEURT	KEY	1	CN
4	VDHOBJBL	SBWART	TDO4	SBWART	KEY	1	CN
5	VDHOBJBL	SOBJART	TIV5A	SOBJART	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in