SAP VDLV Contracts/Credit (life ins., build.savings etc) basic data Table
Overview
VDLV is a standard SAP S/4HANA table that stores Contracts/Credit (life ins., build.savings etc) basic data data. There are total 50 fields in the VDLV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VDLV 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 VDLV to other SAP tables and standard CDS views available based on VDLV table in S/4HANA 2020.
Techincal Settings of VDLV
Below are technical details of the table VDLV
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VDLV Fields
The following table gives you an overview of the fields available in VDLV
| 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 | |
| XLVNR | Contract / account number | XLVNR | CHAR | 15 | |
| XLVTARIF | Contract Rate/Group | XLVTARIF | CHAR | 15 | |
| DBLV | Contract Start | DBLV | DATS | 8 | |
| DELV | Contract End Date | DELV | DATS | 8 | |
| DVERTRAG | Contract Date | DVERTRAG | DATS | 8 | |
| BVERTRAG | Contract Amount | BVERTRAG | CURR | 13 | |
| SVWAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| BLVPR | Contract contribution/premium | BLVPR | CURR | 13 | |
| SZAWS | Payment form (at start of period mid-period at period end) | SZAWS | NUMC | 1 | |
| AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | |
| DFAELLIG | Due date/calculation date | DFAELLIG | DATS | 8 | |
| DZAHLUNG | Payment date | DZAHLUNG | DATS | 8 | |
| PSPZINS | Interest on savings for credit balance | PSPZINS | DEC | 10 | |
| PBONUS | Bonus / dynamization factor | PBONUS | DEC | 10 | |
| SPFSTAT | Pledge status indicator | SPFSTAT | TDL3 | NUMC | 2 |
| JZESSION | Assignment Indicator | JZESSION | CHAR | 1 | |
| KOMM1 | Name | XLBEZ | CHAR | 50 | |
| KOMM2 | Name | XLBEZ | CHAR | 50 | |
| XKBEZPRT | Short term/character | XKBEZPRT | CHAR | 15 | |
| XAKT | File Number | XAKT | CHAR | 32 | |
| SLVSON | Insurance Policy Special Treatment Indicator | VVSLVSON | TDL1 | NUMC | 2 |
| DLVSON | Key Date for Special Treatment of Insurance | VVDLVSON | DATS | 8 | |
| DFINAMT | Date of tax office report | VVDFINAMT | DATS | 8 | |
| SLVGRP1 | Internal Indicator | VVSLVGRP1 | CHAR | 6 | |
| SLVGRP2 | Internal indicator | VVSLVGRP2 | CHAR | 6 | |
| SBUEART1 | Guarantee type 2 | VVSBUEART1 | TDL21 | NUMC | 2 |
| SBUEART | Guarantee type 1 | VVSBUEART | TDL2 | NUMC | 2 |
| DBUERG | Date of statement of guarantee | VVDBUERG | DATS | 8 | |
| XKOKBEZ | Quota short name | VVXKOKBEZ | CHAR | 15 | |
| JDYNSTAT | Index-Linked Insurance Indicator | VVJDYNSTAT | CHAR | 1 | |
| JDYNANN | Adoption of index-linked insurance indicator | VVJDYNANN | CHAR | 1 | |
| DDYNANN | Acceptance date of last dynamics | VVDDYNDAT | DATS | 8 | |
| SLVHERK | Contract origin indicator | VVSLVHERK | NUMC | 1 | |
| BVORABL | Prospective maturity payment | VVVVORABL | CURR | 13 | |
| LVRECH | Calculation date of maturity payments | VVDLVRECH | DATS | 8 | |
| SLAENDER | Country ID | SLAENDER | T005 | CHAR | 3 |
| CLI_COMMENT | Comment on Calculation of CLI Single Premium | TB_CLI_COMMENT | CHAR | 50 | |
| RECALC_COMMENT | Comment on Recalculation of CLI Single Premium | TB_CLI_RECALC_COMMENT | CHAR | 50 |
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 VDLV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VDLV | MANDT | 1: 1 | T000 |
| VDLV | SBUEART | 1: CN | TDL2 |
| VDLV | SBUEART1 | 1: CN | TDL21 |
| VDLV | SLAENDER | : | T005 |
| VDLV | SLVSON | 1: CN | TDL1 |
| VDLV | SPFSTAT | 1: CN | TDL3 |
| VDLV | SSICH | 1: CN | TD01 |
| VDLV | SVWAERS | 1: 1 | TCURC |