SAP VDSDV5 Collateral in securities in acc. with BAV/PRF5 Table
Overview
VDSDV5 is a standard SAP S/4HANA table that stores Collateral in securities in acc. with BAV/PRF5 data. There are total 39 fields in the VDSDV5 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDSDV5 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 VDSDV5 to other SAP tables and standard CDS views available based on VDSDV5 table in S/4HANA 2020.
Techincal Settings of VDSDV5
Below are technical details of the table VDSDV5
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDSDV5 Fields
The following table gives you an overview of the fields available in VDSDV5
| 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 | |
| XWPKN | Securities ID number (Display PRF5) | XWPKN | CHAR | 15 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| BKURSWRT | Market value of a security according to stmnt in PRF5 | BKURSWRT | CURR | 13 | |
| DKURSWRT | Date of valuation at market value | DKURSWRT | DATS | 8 | |
| BNEWE | Nominal value per share | BNEWE | CURR | 10 | |
| BWKUR | Security price for unit quotation | BWKURS | CURR | 13 | |
| PKUR | Price in Percent | PKUR | DEC | 10 | |
| ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15 | |
| BNOMS | Nominal Value | BNOMS | CURR | 13 | |
| XALKZ | Short Name | XALKZ | CHAR | 15 | |
| XALLB | Long Name | XALLB | CHAR | 60 | |
| XEMIT | Name of issuer (info) | XEMIT | CHAR | 50 | |
| PNOMZINS | Nominal interest rate | PNOMZINS | DEC | 10 | |
| DEBEG | Issue Start Date | DEBEG | DATS | 8 | |
| XSERIE | Issue serial number | XSERIE | CHAR | 15 | |
| XREIHE | Issue Series | XREIHE | CHAR | 15 | |
| SVERWA | Custody type | SVERWA | * | CHAR | 1 |
| XDKBZ | Sec.acct position short description | XDKBZ | CHAR | 15 | |
| DBLFZ | Start of Term | DBLFZ | DATS | 8 | |
| DELFZ | End of Term | DELFZ | DATS | 8 | |
| XAKT | File Number | XAKT | CHAR | 32 | |
| KOMM1 | Name | XLBEZ | CHAR | 50 | |
| KOMM2 | Name | XLBEZ | CHAR | 50 | |
| RLDEPO | Securities Account | RLDEPO | * | CHAR | 10 |
| DURUEB | Date of document transfer/date of entry in debt register | VVDURUEB | DATS | 8 | |
| BBWHR | Amount in position currency | BBWHR | CURR | 13 | |
| SLAENDER | Country ID | SLAENDER | T005 | CHAR | 3 |
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 VDSDV5
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDSDV5 | MANDT | 1: CN | T000 |
| VDSDV5 | SLAENDER | : | T005 |
| VDSDV5 | SSICH | 1: CN | TD01 |
| VDSDV5 | WAERS | 1: CN | TCURC |