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 |