SAP VDBLSS Collateral Val. Real Value Other Table
Overview
VDBLSS is a standard SAP S/4HANA table that stores Collateral Val. Real Value Other data. There are total 60 fields in the VDBLSS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDBLSS 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 VDBLSS to other SAP tables and standard CDS views available based on VDBLSS table in S/4HANA 2020.
Techincal Settings of VDBLSS
Below are technical details of the table VDBLSS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDBLSS Fields
The following table gives you an overview of the fields available in VDBLSS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RBLNR | Collateral Number | VVRBLNR | VDHOBJBL | 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 | |
| PABLENT | Expiration Indemnity in % | VVPABLENT | DEC | 10 | |
| PABZINS | Discount interest | VVPABZINS | DEC | 10 | |
| PABFAK | Discount factor | VVPABFAK | DEC | 10 | |
| PAFAG | Deprec. allowance (DeA) in % for garages | VVPAFAG | DEC | 10 | |
| PAFAS | Deprec. allowance (DeA) for parking spaces in % | VVPAFAS | DEC | 10 | |
| AGARAGE | Number of garages | VVAGARAGE | DEC | 5 | |
| ASTELL | Number of parking spaces | VVASTELL | DEC | 5 | |
| PAUSER | External area and development costs in % | VVPAUSER | DEC | 10 | |
| PBAUNK | Construction incid. costs as % of net construction costs | VVBAUNK | DEC | 10 | |
| BERMIN | Building stock reduction due to heritable building right | VVBERMIN | CURR | 13 | |
| BBAUWERT | Building value | VVBAUWERT | CURR | 13 | |
| BBAUOERB | Building Value Without Heritable Building | VVBBAUOERB | CURR | 13 | |
| PBBAUT | Special building parts in % | VVPBBAUT | DEC | 10 | |
| BBODEMIN | Land value reduction due to heritable building right | VVBODEMIN | CURR | 13 | |
| BBODEN | Land value | VVBBODEN | CURR | 13 | |
| BBODOERB | Land Value Without Heritable Building | VVBBODOERB | CURR | 13 | |
| FGESAMT | Total area | FGESA | DEC | 8 | |
| BGPREIS | Total price per square unit | VVBGPREIS | CURR | 13 | |
| AJRND | Number of years adjusted remaining life | VVAJARND | DEC | 6 | |
| AJMRND | No. of years of average economic remaining life | VVAJMRND | DEC | 3 | |
| AJRLFZ | Heritable building right remaining life in years | VVAJRLFZ | DEC | 3 | |
| SZUSTAND | Condition of Building for Determining Building Value | VVSZUSTAND | NUMC | 1 | |
| PMAFABAU | Average depreciation allowance on construction costs in % | VVPMAFABAU | DEC | 10 | |
| BNEUAUS | External area new value | VVBNEUAUS | CURR | 13 | |
| BNEUBK | Construction costs new value | VVBNEUBK | CURR | 13 | |
| BNEUBNK | Construction incidental costs new value | VVBNEUBNK | CURR | 13 | |
| BNEUBS | New Building Value Before Collateral Markdown | VVBNEUBS | CURR | 13 | |
| BNEUBT | New value of special parts | VVBNEUBT | CURR | 13 | |
| BNEUG | Garages new value | VVBNEUG | CURR | 13 | |
| BNEURBK | Net construction costs new value | VVBNEURBK | CURR | 13 | |
| BNEUST | Parking spaces new value | VVBNEUST | CURR | 13 | |
| BSTEH | Price per parking space/unit | VVBSTEH | CURR | 13 | |
| BGEH | Price per garage/unit | VVBGEH | CURR | 13 | |
| PSWIND | Asset value index 1914 (Basis 1914=100) | VVPSWIND | DEC | 10 | |
| PSIAB | Collateral markdown in % | VVPSIAB | DEC | 10 | |
| BSIAB | Collateral markdown amount | VVBSIAB | CURR | 13 | |
| BZWBK | Present value of construction costs | VVBZWBK | CURR | 13 | |
| BZWAER | Present value of external area and internal development | VVBZWAER | CURR | 13 | |
| BZWBNK | Present value of additional building costs | VVBZWBNK | CURR | 13 | |
| BZWBWS | Present val. of building value bef. deducting coll.markdown | VVBZWBWS | CURR | 13 | |
| BZWBT | Present value of special elements | VVBZWBT | CURR | 13 | |
| BZWG | Present value of garages | VVBZWG | CURR | 13 | |
| BZWRBK | Present value of net construction costs | VVBZWRBK | CURR | 13 | |
| BZWST | Present value of parking spaces | VVBZWST | CURR | 13 | |
| BSZWGT | Total current market value of building parts | VVBSZWGT | CURR | 13 | |
| BSNEUGT | Building parts new value total | VVBSNEUGT | CURR | 13 | |
| JSIAB | Absolute amount indicator | VVJABSOL | CHAR | 1 | |
| JNEUBT | Absolute amount indicator | VVJABSOL | CHAR | 1 | |
| JNEUAUS | Absolute amount indicator | VVJABSOL | CHAR | 1 | |
| JNEUBNK | Absolute amount indicator | VVJABSOL | CHAR | 1 |
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 VDBLSS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDBLSS | MANDT | 1: CN | T000 |
| VDBLSS | RBLNR | 1: C | VDHOBJBL |