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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
RBLNRCollateral NumberVVRBLNRNUMC10
RERFEntered ByRERFCHAR12
DERFFirst Entered OnDERFDATS8
TERFTime of CreationTERFTIMS6
REHERSource of Initial EntryREHERCHAR10
RBEAREmployee IDRBEARCHAR12
DBEARLast Edited OnDBEARDATS8
TBEARLast Edited AtTBEARTIMS6
RBHEREditing SourceRBHERCHAR10
ROBJNRCollateral object numberROBJNRNUMC10
JWTEIGResid./Part OwnershipVVJWTEIGCHAR1
RGUTACHTExpert/Surveyor Identity KeyRGUTACHTCHAR10
DGUTDATDocument date/expert opinion dateDURKDATS8
JFRGUTThird-party expert opinion indicatorJFREGUTCHAR1
BVERKEHRMarket valueBVERKEHRCURR13
SBELWHRCurrency KeyWAERSTCURCCUKY5
BBELEIHCollateral valueBBELEIHCURR13
BSACHReal ValueBSACHCURR13
BVERKAUFSelling valueVVBVERKAUFCURR13
BALTWMINLong-standing encumbrances reduc.in valueVVBALTWMINCURR13
BAUFMODExpense for renovation/modernization/reconstruct./expansionVVBAUFMODCURR13
YBAUJConstYrVVYBAUJNUMC4
BBAUWMINConstruc.charges reduc.in valueVVBBAUWMINCURR13
BBLABZCollateral value deduction (imputed)VVBBLABZCURR13
BBLVNABZCollateral Value Proposal After Imputed DeductionVVBBLVNABZCURR13
BBLVTAXProposal of valuer for collateral valueVVBBLVTAXCURR13
BBLVVABZCollateral Value Before Imputed DeductionVVBBLVVABZCURR13
XBEMERKText Field for Additional DescriptionsVVXTEXT78CHAR78
DBESICHTDate of inspection of objectVVDBESICHTDATS8
BKAUFPRPurchase price/total prime costsBKAUFCURR13
BSELBSTSelf-help share amount (estimated)VVBSELBSTCURR13
SBWARTType of Valuation ProcedureVVSBWARTTDO4NUMC2
SBWSTValuation statusVVSBWSTNUMC1
DAUFERDate of expense creationVVDAUFERDATS8
DBLFESTDate collateral value fixedVVBLFESTDATS8
DKAUFDate of sales agreementVVDKAUFDATS8
DWEPRUEFDate of valuation checkVVDWEPRUEFDATS8
BOBJWERTDetermined object valueVVBOBJWERTCURR13
YLMODYear of last modernizationVVYLMODNUMC4
PFERTIGDegree of completion of objectVVPFERTIGDEC10
XGEBURTEILText Field for Additional DescriptionsVVXTEXT78CHAR78
XGESAMTText Field for Additional DescriptionsVVXTEXT78CHAR78
BA2MINDReduction in value due to land register sect. IIVVBA2MINDCURR13
BHEREGSProduction costs excluding propertyVVBHEREGSCURR13
BHERIGSProduction costs including propertyVVBHERIGSCURR13
BMIETPlanned or realized rental income per yearVVBMIETCURR13
SALTLASTExisting encumbrances check carried outVVSALTLASTCHAR1
SALWMINDReduction in value due to existing encumbrancesVVSALWMINDCHAR1
SBEURTValuation rating baseVVSBEURTTDO5NUMC2
SBLPREasement register checkedVVSBLPRCHAR1
SBLWMINDReduction in value due to construction encumbrances checkedVVSBLWMINDCHAR1
SBLRISICollateral riskVVSBLRISICHAR1
SAOBJReference to more detailed object description availableVVSAOBJCHAR1
SEIGENOwn UseVVSEIGENCHAR1
SRENOVIndicator for expansion/modernization/clearance measureVVSRENOVCHAR1
SGEBURTBuilding ratingVVSGEBURTCHAR1
SOBJGESGeneral impression of objectVVSOBJGESCHAR1
SA2WMINDDecrease in valuation due to section IIVVSA2WMINDCHAR1
SA2OKSection II of the Land Register CheckedVVSA2OKCHAR1
SKAUFPRPurchase price ratingVVSKAUFPRCHAR1
SLAGELocation Rating of ObjectVVSLAGECHAR1
SLEERVacanciesVVSLEERCHAR1
SMIETNWRent statementVVSMIETNWCHAR1
SZUWEGPublic right of way existsVVSZUWEGCHAR1
SSELANTSelf-Help ShareVVSSELANTCHAR1
SSTARBWork on Object StartedVVSTARBCHAR1
XLASTText Field for Additional DescriptionsVVXTEXT78CHAR78
XLAGEText Field for Additional DescriptionsVVXTEXT78CHAR78
SOBJARTObject typeSOBJARTTIV5ANUMC2
AJRLFZHeritable building right remaining life in yearsVVAJRLFZDEC3
DIMIETEDate fixing actual rent/rent expectationVVDIMIETEDATS8
XLAST1Text Field for Additional DescriptionsVVXTEXT78CHAR78
XLAGE1Text Field for Additional DescriptionsVVXTEXT78CHAR78
XBEMERK1Text Field for Additional DescriptionsVVXTEXT78CHAR78
XGESAMT1Text Field for Additional DescriptionsVVXTEXT78CHAR78
XGEBURT1Text Field for Additional DescriptionsVVXTEXT78CHAR78
SFGKZRelease IndicatorVVSFGKZCHAR1
BMITTELMean value between asset and revenue valuesVVBMITTELCURR13
NHKNew Real Value CalculationTB_NHK_FLAGCHAR1
BSACH_ANGPReal Value adjustedBSACH_ANGPCURR13
BSACH_BELWEReal Value (Collateral Value)BSACH_BELWECURR13
BWERT_GS_MERKValue of special property characteristicsBWERT_GS_MERKCURR13

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 NameFieldCardinalityCheck Table
VDHOBJBLMANDT1: 1T000
VDHOBJBLSBELWHR1: CNTCURC
VDHOBJBLSBEURT1: CNTDO5
VDHOBJBLSBWART1: CNTDO4
VDHOBJBLSOBJART1: CNTIV5A

Other References