VDLV SAP table for – Contracts/Credit (life ins., build.savings etc) basic data

Here we would like to draw your attention to VDLV table in SAP. As we know it is being mainly used with the SAP FS-CML (Loans Management in FS) component which is coming under FS module (Financial Services). VDLV is a SAP standard transp table used for storing Contracts/Credit (life ins., build.savings etc) basic data related data in SAP. It comes under the package FVVD.

SAP VDLV table

Table VDLV technical data

TableVDLV
Data storingContracts/Credit (life ins., build.savings etc) basic data
ModuleFS
Sub ModuleFS-CML
SAP PackageFVVD
Delivery ClassA – Application table (master and transaction data)
ComponentEA-FINSERV
Table CategoryTRANSP

SAP VDLV Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in VDLV table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RSICHER : Collateral reference number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • RERF : Entered by
    Its data type is CHAR (Character String) with field length 12
  • DERF : First Entered on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TERF : Time of Initial Entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • REHER : Source of initial entry
    Its data type is CHAR (Character String) with field length 10
  • RBEAR : Employee ID
    Its data type is CHAR (Character String) with field length 12
  • DBEAR : Last Edited on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TBEAR : Last Edited at
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • RBHER : Editing Source
    Its data type is CHAR (Character String) with field length 10
  • SSICH : Collateral type
    Its data type is CHAR (Character String) with field length 4
  • SSICHART : Category Of Collateral Group (Internal)
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • XLVNR : Contract / account number
    Its data type is CHAR (Character String) with field length 15
  • XLVTARIF : Contract Rate/Group
    Its data type is CHAR (Character String) with field length 15
  • DBLV : Contract Start
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DELV : Contract End Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DVERTRAG : Contract Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BVERTRAG : Contract Amount
    Its data type is CURR (Currency Field) with field length 13
  • SVWAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BLVPR : Contract contribution/premium
    Its data type is CURR (Currency Field) with field length 13
  • SZAWS : Payment form (at start of period, mid-period, at period end)
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • AMMRHY : Frequency in months
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DFAELLIG : Due date/calculation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DZAHLUNG : Payment date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PSPZINS : Interest on savings for credit balance
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PBONUS : Bonus / dynamization factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • SPFSTAT : Pledge status indicator
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • JZESSION : Assignment Indicator
    Its data type is CHAR (Character String) with field length 1
  • KOMM1 : Name
    Its data type is CHAR (Character String) with field length 50
  • KOMM2 : Name
    Its data type is CHAR (Character String) with field length 50
  • XKBEZPRT : Short term/character
    Its data type is CHAR (Character String) with field length 15
  • XAKT : File Number
    Its data type is CHAR (Character String) with field length 32
  • SLVSON : Insurance Policy Special Treatment Indicator
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DLVSON : Key Date for Special Treatment of Insurance
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DFINAMT : Date of tax office report
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SLVGRP1 : Internal Indicator
    Its data type is CHAR (Character String) with field length 6
  • SLVGRP2 : Internal indicator
    Its data type is CHAR (Character String) with field length 6
  • SBUEART1 : Guarantee type 2
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • SBUEART : Guarantee type 1
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DBUERG : Date of statement of guarantee
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • XKOKBEZ : Quota short name
    Its data type is CHAR (Character String) with field length 15
  • JDYNSTAT : Index-Linked Insurance Indicator
    Its data type is CHAR (Character String) with field length 1
  • JDYNANN : Adoption of index-linked insurance indicator
    Its data type is CHAR (Character String) with field length 1
  • DDYNANN : Acceptance date of last dynamics
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SLVHERK : Contract origin indicator
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • BVORABL : Prospective maturity payment
    Its data type is CURR (Currency Field) with field length 13
  • LVRECH : Calculation date of maturity payments
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SLAENDER : Country ID
    Its data type is CHAR (Character String) with field length 3
  • .INCLU–AP : Consumer Loan
  • CLI_COMMENT : Comment on Calculation of CLI Single Premium
    Its data type is CHAR (Character String) with field length 50
  • RECALC_COMMENT : Comment on Recalculation of CLI Single Premium
    Its data type is CHAR (Character String) with field length 50