SAP VDARLSIC Collateral for loan (relationship table) Table
Overview
VDARLSIC is a standard SAP S/4HANA table that stores Collateral for loan (relationship table) data. There are total 26 fields in the VDARLSIC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDARLSIC 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 VDARLSIC to other SAP tables and standard CDS views available based on VDARLSIC table in S/4HANA 2020.
Techincal Settings of VDARLSIC
Below are technical details of the table VDARLSIC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDARLSIC Fields
The following table gives you an overview of the fields available in VDARLSIC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RANL | Contract Number | RANL | CHAR | 13 | |
| 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 | |
| BHAFTUNG | Value of assigned rights from collateral | BHAFTUNG | CURR | 13 | |
| BHAFTWHR | Currency | SWHR | TCURC | CUKY | 5 |
| DABTRET | Date of assignment for collateral security | DABTRET | DATS | 8 | |
| DBESTAET | Assignment confirmation date | VVDABBST | DATS | 8 | |
| DANZEIGE | Assignment display date | VVDABANZ | DATS | 8 | |
| XURK | Document number | XURK | CHAR | 15 | |
| SDOKUART | Indicator for the type of document | SDOKUART | NUMC | 3 | |
| DURK | Document date/expert opinion date | DURK | DATS | 8 | |
| JPROL | Indicator: Taken into consideration for rollover | VVJPROL | CHAR | 1 | |
| DBEBEZ | Date of start of relationship | DBEBEZ | DATS | 8 | |
| DENBEZ | Date of end of relationship | DENBEZ | DATS | 8 | |
| JHAUPT | Primary collateral indicator | VVJHSICH | 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 VDARLSIC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDARLSIC | BHAFTWHR | : | TCURC |
| VDARLSIC | BUKRS | 1: 1 | T001 |
| VDARLSIC | MANDT | 1: 1 | T000 |
| VDARLSIC | SSICH | 1: CN | TD01 |