SAP VDBLSWT Collateral Value Real Value Resid. Prop./Part-Owners. Table
Overview
VDBLSWT is a standard SAP S/4HANA table that stores Collateral Value Real Value Resid. Prop./Part-Owners. data. There are total 30 fields in the VDBLSWT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDBLSWT 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 VDBLSWT to other SAP tables and standard CDS views available based on VDBLSWT table in S/4HANA 2020.
Techincal Settings of VDBLSWT
Below are technical details of the table VDBLSWT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDBLSWT Fields
The following table gives you an overview of the fields available in VDBLSWT
| 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 | |
| FAUSSEN | External area | VVFAUSSEN | DEC | 8 | |
| SUFLAE | Area unit | VVSUFLAE | T006 | UNIT | 3 |
| AGARAGE | Number of garages | VVAGARAGE | DEC | 5 | |
| BGEH | Price per garage/unit | VVBGEH | CURR | 13 | |
| ASTELL | Number of parking spaces | VVASTELL | DEC | 5 | |
| BSTEH | Price per parking space/unit | VVBSTEH | CURR | 13 | |
| BZWG | Present value of garages | VVBZWG | CURR | 13 | |
| BZWST | Present value of parking spaces | VVBZWST | CURR | 13 | |
| BZWAUSS | Present value of external area | VVBZWAUSS | CURR | 13 | |
| SBESNACH | Valuation can be qualified | VVSBESNACH | TDO3 | NUMC | 2 |
| SZUSTAND | Condition of Building for Determining Building Value | VVSZUSTAND | NUMC | 1 | |
| 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 | |
| BAUEH | Price per unit of measurement for external area | VVBAUEH | CURR | 13 | |
| PABZERB | Price reduction in % for heritable building | VVPABZERB | DEC | 10 | |
| BSAOSI | Asset value without collateral markdown | VVBSAOSI | CURR | 13 | |
| SBELWHR | Currency Key | WAERS | TCURC | CUKY | 5 |
| BSZWGT | Total current market value of building parts | VVBSZWGT | CURR | 13 | |
| BSNEUGT | Building parts new value total | VVBSNEUGT | CURR | 13 |
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 VDBLSWT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDBLSWT | MANDT | 1: CN | T000 |
| VDBLSWT | RBLNR | 1: C | VDHOBJBL |
| VDBLSWT | SBELWHR | 1: CN | TCURC |
| VDBLSWT | SBESNACH | 1: CN | TDO3 |
| VDBLSWT | SUFLAE | 1: CN | T006 |