SAP VDHOBJ Collateral Objects Table
Overview
VDHOBJ is a standard SAP S/4HANA table that stores Collateral Objects data. There are total 57 fields in the VDHOBJ table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDHOBJ 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 VDHOBJ to other SAP tables and standard CDS views available based on VDHOBJ table in S/4HANA 2020.
Techincal Settings of VDHOBJ
Below are technical details of the table VDHOBJ
- Buffering allowed but switched off
- No buffering
- Storage type is Column Store
List of VDHOBJ Fields
The following table gives you an overview of the fields available in VDHOBJ
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| ROBJNR | Collateral object number | ROBJNR | 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 | |
| SGRUNDB | Land register number | SGRUNDB | NUMC | 8 | |
| SOBJART | Object type | SOBJART | TIV5A | NUMC | 2 |
| SNUTZART | Main usage type of object | VVSNUTZ | TIV01 | NUMC | 4 |
| SOBJBAU | Object building method indicator | SOBJBAU | TDO1 | NUMC | 2 |
| SOBJGEB | Indicator: Area Description for Object | SOBJGEB | TDO12 | NUMC | 2 |
| SOBJLAGE | Indicator - District of Object | SOBJLAGE | TIV45 | NUMC | 2 |
| SVERKEHR | Transport Connections of Business Entity | SVERKEHR | TIV44 | CHAR | 1 |
| SOBJZUST | Indicator for Condition of Object | SOBJZUST | TDO10 | NUMC | 2 |
| SOBJAUST | Object fixtures/fittings indicator | SOBJAUST | TDO11 | NUMC | 2 |
| DANTBAU | Application for building permit | DANTBAU | DATS | 8 | |
| DBAUGENE | Building permit | DBAUGENE | DATS | 8 | |
| XBAUGENE | Note on building permit | XBAUGENE | CHAR | 30 | |
| DBEZUGSF | Ready for occupancy | DBEZUGSF | DATS | 8 | |
| DFERTIG | Completion | DFERTIG | DATS | 8 | |
| DSCHLUSS | Final Inspection | DSCHLUSS | DATS | 8 | |
| YBAUJ | ConstYr | VVYBAUJ | NUMC | 4 | |
| YLMOD | Year of last modernization | VVYLMOD | NUMC | 4 | |
| SGVER | Property conditions | SGVER | TDO8 | CHAR | 2 |
| NWOHNNR | Apartment number for condominium | NWOHNNR | CHAR | 5 | |
| NGESCHNR | Floor Number for Condominium | NGESCHNR | CHAR | 5 | |
| BBAUW13 | Building value | BBAUW13 | CURR | 11 | |
| BKAUF | Purchase price/total prime costs | BKAUF | CURR | 13 | |
| SKAUFWHR | Currency Key | WAERS | TCURC | CUKY | 5 |
| DKAUF | Object purchase date | DKAUF | DATS | 8 | |
| FEINS | Area Unit | FEINS | T006 | UNIT | 3 |
| REINS | Unit for cubic volume | REINS | T006 | UNIT | 3 |
| SZWANG | Collateral object legal measures ID | VVSZWANG | CHAR | 1 | |
| JERBBAU | Heritable building right indicator for collateral objects | SOBJERBBAU | TDO9 | CHAR | 1 |
| JREICHSH | Reichsheimstätte indicator | JREICHSH | CHAR | 1 | |
| DERBBAU | Inheritable building leasehold end | DERBBAU | DATS | 8 | |
| JDENKMAL | Protection of Historical Sites | JDENKMAL | CHAR | 1 | |
| RFAKT | Conversion factor for fractional share of property | VVRFAKT | NUMC | 6 | |
| BMITEIG | Co-ownership share | BMITEIG | DEC | 9 | |
| RKLAMMER | Object master number | VVROBJSTM | CHAR | 13 | |
| JHAUPT | Indicator for the main object within a complete object | VVJHAUPT | CHAR | 1 | |
| XOBJALT | Previous object number | XOBJALT | CHAR | 15 | |
| SFGKZ | Release Indicator | VVSFGKZ | CHAR | 1 | |
| BOBADRNR | Address number for collateral object | BOBADRNR | ADRC | CHAR | 10 |
| YBAUJF | Notional Construction Year | VVYBAUJF | NUMC | 4 | |
| MODGRAD | Modernization Grade | MODGRAD | NUMC | 2 | |
| BAUINDEX_STAND | Building index state | BAUINDEX_STAND | CHAR | 5 | |
| LRINTRENO | Internal Number of Land Register | FVD_LR_INTRENO | CHAR | 13 | |
| LRDISTRICT | Land Register District | FVD_LRDISTRICT | CHAR | 60 | |
| LRVOLUMENO | Number of Land Register Volume | FVD_LRVOLUMENO | CHAR | 15 | |
| LRPAGENO | Page Number in Land Register | FVD_LRPAGENO | CHAR | 15 | |
| LRTYPE | Land Register Type | FVD_LRTYPE | NUMC | 2 | |
| XLR | Name of Land Register | FVD_XLR | CHAR | 60 |
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 VDHOBJ
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDHOBJ | BOBADRNR | 1: C | ADRC |
| VDHOBJ | FEINS | 1: CN | T006 |
| VDHOBJ | JERBBAU | C: CN | TDO9 |
| VDHOBJ | MANDT | 1: CN | T000 |
| VDHOBJ | REINS | 1: CN | T006 |
| VDHOBJ | SGVER | C: CN | TDO8 |
| VDHOBJ | SKAUFWHR | 1: CN | TCURC |
| VDHOBJ | SNUTZART | 1: CN | TIV01 |
| VDHOBJ | SOBJART | 1: CN | TIV5A |
| VDHOBJ | SOBJAUST | C: CN | TDO11 |
| VDHOBJ | SOBJBAU | 1: CN | TDO1 |
| VDHOBJ | SOBJGEB | C: CN | TDO12 |
| VDHOBJ | SOBJLAGE | 1: CN | TIV45 |
| VDHOBJ | SOBJZUST | C: CN | TDO10 |
| VDHOBJ | SVERKEHR | : | TIV44 |