SAP VDSDV4 Loan collateral in acc. with BAV/PRF4 Table
Overview
VDSDV4 is a standard SAP S/4HANA table that stores Loan collateral in acc. with BAV/PRF4 data. There are total 28 fields in the VDSDV4 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDSDV4 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 VDSDV4 to other SAP tables and standard CDS views available based on VDSDV4 table in S/4HANA 2020.
Techincal Settings of VDSDV4
Below are technical details of the table VDSDV4
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDSDV4 Fields
The following table gives you an overview of the fields available in VDSDV4
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RSICHER | Collateral reference number | RSICHER | NUMC | 8 | |
| 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 | |
| SSICH | Collateral type | SSICH | TD01 | CHAR | 4 |
| SSICHART | Category Of Collateral Group (Internal) | SSICHART | NUMC | 2 | |
| BVALHYP | Mortgage value-dated amount | BVALHYP | CURR | 13 | |
| SWHRVAL | Currency Key | WAERS | TCURC | CUKY | 5 |
| XADRDV4 | Property location/ name of vessel | XADRDV4 | CHAR | 50 | |
| XGBAMT | Land registry ID | XGBAMT | CHAR | 25 | |
| XGVON | Land register district | XGBVON | CHAR | 25 | |
| NBANDNR | Land register volume number | NBANDNR | CHAR | 15 | |
| NBLATTNR | Land register page number | NBLATTNR | CHAR | 15 | |
| XNRABT3 | No. of entry in Section 3 of land register | XNRABT3 | CHAR | 5 | |
| DEINTRAG | Date of entry | DEINTRAG | DATS | 8 | |
| XPARTNER | Name | NAME1 | CHAR | 30 | |
| XAKT | File Number | XAKT | CHAR | 32 | |
| KOMM1 | Name | XLBEZ | CHAR | 50 | |
| KOMM2 | Name | XLBEZ | CHAR | 50 | |
| RANL | Contract Number | RANL | CHAR | 13 | |
| SLAENDER | Country ID | SLAENDER | T005 | CHAR | 3 |
| UEBERGABE_DAT | Date | DATUM | DATS | 8 |
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 VDSDV4
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDSDV4 | MANDT | 1: CN | T000 |
| VDSDV4 | SLAENDER | : | T005 |
| VDSDV4 | SSICH | 1: CN | TD01 |
| VDSDV4 | SWHRVAL | 1: CN | TCURC |