VDLV

Contracts/Credit (life ins., build.savings etc) basic data | #masterdata | Component: Loans Management
Column Name Description
MANDT FK Client
RSICHER Collateral reference number
Column Name Description
💲 Currency Key (SVWAERS):
BVERTRAG Contract Amount
BLVPR Contract contribution/premium
BVORABL Prospective maturity payment
Column Name Description
Column Name Description
DERF First Entered On
TERF Time of Creation
DBEAR Last Edited On
TBEAR Last Edited At
DBLV Contract Start
DELV Contract End Date
DVERTRAG Contract Date
DFAELLIG Due date/calculation date
DZAHLUNG Payment date
DLVSON Key Date for Special Treatment of Insurance
DFINAMT Date of tax office report
DBUERG Date of statement of guarantee
DDYNANN Acceptance date of last dynamics
LVRECH Calculation date of maturity payments
Column Name Description
SSICHART Category Of Collateral Group (Internal) Show values
SZAWS Payment form (at start of period, mid-period, at period end) Show values
JZESSION Assignment Indicator Show values
JDYNSTAT Index-Linked Insurance Indicator Show values
JDYNANN Adoption of index-linked insurance indicator Show values
SLVHERK Contract origin indicator Show values
Column Name Description Domain name
RERF Entered By SYCHAR12
REHER Source of Initial Entry CHAR10
RBEAR Employee ID SYCHAR12
RBHER Editing Source CHAR10
XLVNR Contract / account number CHAR15
XLVTARIF Contract Rate/Group XKBEZ
AMMRHY Frequency in months NUMC03
PSPZINS Interest on savings for credit balance DEC3_7
PBONUS Bonus / dynamization factor DEC3_7
KOMM1 Name XTEXT50
KOMM2 Name XTEXT50
XKBEZPRT Short term/character XKBEZ
XAKT File Number CHAR32
SLVGRP1 Internal Indicator VVSLVGRP1
SLVGRP2 Internal indicator VVSLVGRP2
XKOKBEZ Quota short name CHAR15
CLI_COMMENT Comment on Calculation of CLI Single Premium CHAR50
RECALC_COMMENT Comment on Recalculation of CLI Single Premium CHAR50
Master Data Relations Join Conditions
Client VDLV.MANDT == T000.MANDT
Guarantee type
  • VDLV.MANDT == TDL2.MANDT
  • VDLV.SBUEART == TDL2.SBUEART
Guarantee type 2
  • VDLV.MANDT == TDL21.MANDT
  • VDLV.SBUEART1 == TDL21.SBUEART
Country indicator
  • Country/Region ID
  • Client
  • VDLV.SLAENDER == T005.LAND1
  • VDLV.MANDT == T005.MANDT
Special treatment indicator
  • Insurance Policy Special Treatment Indicator
  • Client
  • VDLV.SLVSON == TDL1.SLVSON
  • VDLV.MANDT == TDL1.MANDT
Pledge status
  • Pledge status indicator
  • Client
  • VDLV.SPFSTAT == TDL3.STATUS
  • VDLV.MANDT == TDL3.MANDT
Collateral key
  • VDLV.MANDT == TD01.MANDT
  • VDLV.SSICH == TD01.SSICH
Currency
  • VDLV.MANDT == TCURC.MANDT
  • VDLV.SVWAERS == TCURC.WAERS