SAP VDHOBJBL Determination of collateral value/Expert report of object Table
Overview
VDHOBJBL is a standard SAP S/4HANA table that stores Determination of collateral value/Expert report of object data. There are total 83 fields in the VDHOBJBL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDHOBJBL belongs to Loans Management (FS-CML) module and is located in the package Treasury Loans (FVVD).
In addition, following links provide an overview of foreign key relationships, if any, that link VDHOBJBL to other SAP tables and standard CDS views available based on VDHOBJBL table in S/4HANA 2020.
Techincal Settings of VDHOBJBL
Below are technical details of the table VDHOBJBL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDHOBJBL Fields
The following table gives you an overview of the fields available in VDHOBJBL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RBLNR | Collateral Number | VVRBLNR | NUMC | 10 | |
| 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 | |
| ROBJNR | Collateral object number | ROBJNR | NUMC | 10 | |
| JWTEIG | Resid./Part Ownership | VVJWTEIG | CHAR | 1 | |
| RGUTACHT | Expert/Surveyor Identity Key | RGUTACHT | CHAR | 10 | |
| DGUTDAT | Document date/expert opinion date | DURK | DATS | 8 | |
| JFRGUT | Third-party expert opinion indicator | JFREGUT | CHAR | 1 | |
| BVERKEHR | Market value | BVERKEHR | CURR | 13 | |
| SBELWHR | Currency Key | WAERS | TCURC | CUKY | 5 |
| BBELEIH | Collateral value | BBELEIH | CURR | 13 | |
| BSACH | Real Value | BSACH | CURR | 13 | |
| BVERKAUF | Selling value | VVBVERKAUF | CURR | 13 | |
| BALTWMIN | Long-standing encumbrances reduc.in value | VVBALTWMIN | CURR | 13 | |
| BAUFMOD | Expense for renovation/modernization/reconstruct./expansion | VVBAUFMOD | CURR | 13 | |
| YBAUJ | ConstYr | VVYBAUJ | NUMC | 4 | |
| BBAUWMIN | Construc.charges reduc.in value | VVBBAUWMIN | CURR | 13 | |
| BBLABZ | Collateral value deduction (imputed) | VVBBLABZ | CURR | 13 | |
| BBLVNABZ | Collateral Value Proposal After Imputed Deduction | VVBBLVNABZ | CURR | 13 | |
| BBLVTAX | Proposal of valuer for collateral value | VVBBLVTAX | CURR | 13 | |
| BBLVVABZ | Collateral Value Before Imputed Deduction | VVBBLVVABZ | CURR | 13 | |
| XBEMERK | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| DBESICHT | Date of inspection of object | VVDBESICHT | DATS | 8 | |
| BKAUFPR | Purchase price/total prime costs | BKAUF | CURR | 13 | |
| BSELBST | Self-help share amount (estimated) | VVBSELBST | CURR | 13 | |
| SBWART | Type of Valuation Procedure | VVSBWART | TDO4 | NUMC | 2 |
| SBWST | Valuation status | VVSBWST | NUMC | 1 | |
| DAUFER | Date of expense creation | VVDAUFER | DATS | 8 | |
| DBLFEST | Date collateral value fixed | VVBLFEST | DATS | 8 | |
| DKAUF | Date of sales agreement | VVDKAUF | DATS | 8 | |
| DWEPRUEF | Date of valuation check | VVDWEPRUEF | DATS | 8 | |
| BOBJWERT | Determined object value | VVBOBJWERT | CURR | 13 | |
| YLMOD | Year of last modernization | VVYLMOD | NUMC | 4 | |
| PFERTIG | Degree of completion of object | VVPFERTIG | DEC | 10 | |
| XGEBURTEIL | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| XGESAMT | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| BA2MIND | Reduction in value due to land register sect. II | VVBA2MIND | CURR | 13 | |
| BHEREGS | Production costs excluding property | VVBHEREGS | CURR | 13 | |
| BHERIGS | Production costs including property | VVBHERIGS | CURR | 13 | |
| BMIET | Planned or realized rental income per year | VVBMIET | CURR | 13 | |
| SALTLAST | Existing encumbrances check carried out | VVSALTLAST | CHAR | 1 | |
| SALWMIND | Reduction in value due to existing encumbrances | VVSALWMIND | CHAR | 1 | |
| SBEURT | Valuation rating base | VVSBEURT | TDO5 | NUMC | 2 |
| SBLPR | Easement register checked | VVSBLPR | CHAR | 1 | |
| SBLWMIND | Reduction in value due to construction encumbrances checked | VVSBLWMIND | CHAR | 1 | |
| SBLRISI | Collateral risk | VVSBLRISI | CHAR | 1 | |
| SAOBJ | Reference to more detailed object description available | VVSAOBJ | CHAR | 1 | |
| SEIGEN | Own Use | VVSEIGEN | CHAR | 1 | |
| SRENOV | Indicator for expansion/modernization/clearance measure | VVSRENOV | CHAR | 1 | |
| SGEBURT | Building rating | VVSGEBURT | CHAR | 1 | |
| SOBJGES | General impression of object | VVSOBJGES | CHAR | 1 | |
| SA2WMIND | Decrease in valuation due to section II | VVSA2WMIND | CHAR | 1 | |
| SA2OK | Section II of the Land Register Checked | VVSA2OK | CHAR | 1 | |
| SKAUFPR | Purchase price rating | VVSKAUFPR | CHAR | 1 | |
| SLAGE | Location Rating of Object | VVSLAGE | CHAR | 1 | |
| SLEER | Vacancies | VVSLEER | CHAR | 1 | |
| SMIETNW | Rent statement | VVSMIETNW | CHAR | 1 | |
| SZUWEG | Public right of way exists | VVSZUWEG | CHAR | 1 | |
| SSELANT | Self-Help Share | VVSSELANT | CHAR | 1 | |
| SSTARB | Work on Object Started | VVSTARB | CHAR | 1 | |
| XLAST | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| XLAGE | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| SOBJART | Object type | SOBJART | TIV5A | NUMC | 2 |
| AJRLFZ | Heritable building right remaining life in years | VVAJRLFZ | DEC | 3 | |
| DIMIETE | Date fixing actual rent/rent expectation | VVDIMIETE | DATS | 8 | |
| XLAST1 | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| XLAGE1 | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| XBEMERK1 | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| XGESAMT1 | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| XGEBURT1 | Text Field for Additional Descriptions | VVXTEXT78 | CHAR | 78 | |
| SFGKZ | Release Indicator | VVSFGKZ | CHAR | 1 | |
| BMITTEL | Mean value between asset and revenue values | VVBMITTEL | CURR | 13 | |
| NHK | New Real Value Calculation | TB_NHK_FLAG | CHAR | 1 | |
| BSACH_ANGP | Real Value adjusted | BSACH_ANGP | CURR | 13 | |
| BSACH_BELWE | Real Value (Collateral Value) | BSACH_BELWE | CURR | 13 | |
| BWERT_GS_MERK | Value of special property characteristics | BWERT_GS_MERK | CURR | 13 |
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 VDHOBJBL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDHOBJBL | MANDT | 1: 1 | T000 |
| VDHOBJBL | SBELWHR | 1: CN | TCURC |
| VDHOBJBL | SBEURT | 1: CN | TDO5 |
| VDHOBJBL | SBWART | 1: CN | TDO4 |
| VDHOBJBL | SOBJART | 1: CN | TIV5A |