SAP VDSONSI Special Arrangements for Collateral Table
Overview
VDSONSI is a standard SAP S/4HANA table that stores Special Arrangements for Collateral data. There are total 21 fields in the VDSONSI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDSONSI 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 VDSONSI to other SAP tables and standard CDS views available based on VDSONSI table in S/4HANA 2020.
Techincal Settings of VDSONSI
Below are technical details of the table VDSONSI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDSONSI Fields
The following table gives you an overview of the fields available in VDSONSI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SNUMOBJ | Key for number range object | VVNUMOBJ | CHAR | 2 | |
| SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | |
| RSICHER | Collateral reference number | RSICHER | NUMC | 8 | |
| PARTNR | Business Partner Number | BP_PARTNR_NEW | BUT000 | CHAR | 10 |
| SSOND | Type of arrangement | VVSSOND | TD22 | NUMC | 2 |
| SRANG | Ranking | VVSRANG | CHAR | 1 | |
| BSOND | Special arrangement amount | VVBSOND | CURR | 13 | |
| BTREU | Amount retained by trustee | VVBTREU | CURR | 13 | |
| SWHR | Currency Key | WAERS | TCURC | CUKY | 5 |
| DSOND | Date of agreement | VVDSOND | DATS | 8 | |
| KOMM1 | Name | XLBEZ | CHAR | 50 | |
| 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 | |
| STREUKZ | Handling of trust amount | VVSTREUKZ | 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 VDSONSI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDSONSI | MANDT | 1: CN | T000 |
| VDSONSI | PARTNR | : | BUT000 |
| VDSONSI | SSOND | 1: CN | TD22 |
| VDSONSI | SWHR | 1: CN | TCURC |