VDHOBJ - Collateral Objects
Collateral Objects information is stored in SAP table VDHOBJ.
It is part of development package FVVD in software component FS-CML. This development package consists of objects that can be grouped under "Treasury Loans".
It is part of development package FVVD in software component FS-CML. This development package consists of objects that can be grouped under "Treasury Loans".
Fields for table VDHOBJ
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
ROBJNR | Collateral object number | X | ROBJNR | NUMC | 20 | |
RERF | Entered By | RERF | CHAR | 24 | ||
DERF | First Entered On | DERF | DATS | 16 | ||
TERF | Time of Creation | TERF | TIMS | 12 | ||
REHER | Source of Initial Entry | REHER | CHAR | 20 | ||
RBEAR | Employee ID | RBEAR | CHAR | 24 | ||
DBEAR | Last Edited On | DBEAR | DATS | 16 | ||
TBEAR | Last Edited At | TBEAR | TIMS | 12 | ||
RBHER | Editing Source | RBHER | CHAR | 20 | ||
SGRUNDB | Land register number | SGRUNDB | NUMC | 16 | ||
SOBJART | Object type | SOBJART | NUMC | 4 | TIV5A | |
SNUTZART | Main usage type of object | VVSNUTZ | NUMC | 8 | TIV01 | |
SOBJBAU | Object building method indicator | SOBJBAU | NUMC | 4 | TDO1 | |
SOBJGEB | Indicator: Area Description for Object | SOBJGEB | NUMC | 4 | TDO12 | |
SOBJLAGE | Indicator - District of Object | SOBJLAGE | NUMC | 4 | TIV45 | |
SVERKEHR | Transport Connections of Business Entity | SVERKEHR | CHAR | 2 | TIV44 | |
SOBJZUST | Indicator for Condition of Object | SOBJZUST | NUMC | 4 | TDO10 | |
SOBJAUST | Object fixtures/fittings indicator | SOBJAUST | NUMC | 4 | TDO11 | |
DANTBAU | Application for building permit | DANTBAU | DATS | 16 | ||
DBAUGENE | Building permit | DBAUGENE | DATS | 16 | ||
XBAUGENE | Note on building permit | XBAUGENE | CHAR | 60 | ||
DBEZUGSF | Ready for occupancy | DBEZUGSF | DATS | 16 | ||
DFERTIG | Completion | DFERTIG | DATS | 16 | ||
DSCHLUSS | Final Inspection | DSCHLUSS | DATS | 16 | ||
YBAUJ | ConstYr | VVYBAUJ | NUMC | 8 | ||
YLMOD | Year of last modernization | VVYLMOD | NUMC | 8 | ||
SGVER | Property conditions | SGVER | CHAR | 4 | TDO8 | |
NWOHNNR | Apartment number for condominium | NWOHNNR | CHAR | 10 | ||
NGESCHNR | Floor Number for Condominium | NGESCHNR | CHAR | 10 | ||
BBAUW13 | Building value | BBAUW13 | CURR | 6 | ||
BKAUF | Purchase price/total prime costs | BKAUF | CURR | 7 | ||
SKAUFWHR | Currency Key | WAERS | CUKY | 10 | TCURC | |
DKAUF | Object purchase date | DKAUF | DATS | 16 | ||
FEINS | Area Unit | FEINS | UNIT | 6 | T006 | |
REINS | Unit for cubic volume | REINS | UNIT | 6 | T006 | |
SZWANG | Collateral object legal measures ID | VVSZWANG | CHAR | 2 | ||
JERBBAU | Heritable building right indicator for collateral objects | SOBJERBBAU | CHAR | 2 | TDO9 | |
JREICHSH | Reichsheimst�tte indicator | JREICHSH | CHAR | 2 | ||
DERBBAU | Inheritable building leasehold end | DERBBAU | DATS | 16 | ||
JDENKMAL | Protection of Historical Sites | JDENKMAL | CHAR | 2 | ||
RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 12 | ||
BMITEIG | Co-ownership share | BMITEIG | DEC | 5 | ||
RKLAMMER | Object master number | VVROBJSTM | CHAR | 26 | ||
JHAUPT | Indicator for the main object within a complete object | VVJHAUPT | CHAR | 2 | ||
XOBJALT | Previous object number | XOBJALT | CHAR | 30 | ||
SFGKZ | Release Indicator | VVSFGKZ | CHAR | 2 | ||
BOBADRNR | Address number for collateral object | BOBADRNR | CHAR | 20 | ADRC | |
YBAUJF | Notional Construction Year | VVYBAUJF | NUMC | 8 | ||
MODGRAD | Modernization Grade | MODGRAD | NUMC | 4 | ||
WRND | Economical Remaining Useful Life | WRND | NUMC | 6 | ||
MOD_RND | Modified Remaining Useful Life (rounded) | MODRND | NUMC | 6 | ||
ASTUFE | Faciity level | ASTUFE | DEC | 2 | ||
GND | Total Useful Life | GND | NUMC | 6 | ||
BAUINDEX_STAND | Building index state | BAUINDEX_STAND | CHAR | 10 | ||
LRINTRENO | Internal Number of Land Register | FVD_LR_INTRENO | CHAR | 26 | ||
LRDISTRICT | Land Register District | FVD_LRDISTRICT | CHAR | 120 | ||
LRVOLUMENO | Number of Land Register Volume | FVD_LRVOLUMENO | CHAR | 30 | ||
LRPAGENO | Page Number in Land Register | FVD_LRPAGENO | CHAR | 30 | ||
LRTYPE | Land Register Type | FVD_LRTYPE | NUMC | 4 | ||
XLR | Name of Land Register | FVD_XLR | CHAR | 120 |