SAP ABAP Table VDLV (Contracts/Credit (life ins., build.savings etc) basic data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD (Package) Treasury Loans

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VDLV	Table Relationship Diagram
Short Description	Contracts/Credit (life ins., build.savings etc) basic data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RSICHER	☑	RSICHER	NUMC8	NUMC	8	0	Collateral reference number
3	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
4	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
5	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
6	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
7	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
8	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
9	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
10	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
11	SSICH	☐	SSICH	SSICH	CHAR	4	0	Collateral type	TD01
12	SSICHART	☐	SSICHART	SSICHART	NUMC	2	0	Category Of Collateral Group (Internal)
13	XLVNR	☐	XLVNR	CHAR15	CHAR	15	0	Contract / account number
14	XLVTARIF	☐	XLVTARIF	XKBEZ	CHAR	15	0	Contract Rate/Group
15	DBLV	☐	DBLV	DATUM	DATS	8	0	Contract Start
16	DELV	☐	DELV	DATUM	DATS	8	0	Contract End Date
17	DVERTRAG	☐	DVERTRAG	DATUM	DATS	8	0	Contract Date
18	BVERTRAG	☐	BVERTRAG	WERTV7	CURR	13	2	Contract Amount
19	SVWAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	BLVPR	☐	BLVPR	WERTV7	CURR	13	2	Contract contribution/premium
21	SZAWS	☐	SZAWS	SZAHLDIV	NUMC	1	0	Payment form (at start of period, mid-period, at period end)
22	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
23	DFAELLIG	☐	DFAELLIG	DATUM	DATS	8	0	Due date/calculation date
24	DZAHLUNG	☐	DZAHLUNG	DATUM	DATS	8	0	Payment date
25	PSPZINS	☐	PSPZINS	DEC3_7	DEC	10	7	Interest on savings for credit balance
26	PBONUS	☐	PBONUS	DEC3_7	DEC	10	7	Bonus / dynamization factor
27	SPFSTAT	☐	SPFSTAT	SPFSTAT	NUMC	2	0	Pledge status indicator	TDL3
28	JZESSION	☐	JZESSION	JANEI	CHAR	1	0	Assignment Indicator
29	KOMM1	☐	XLBEZ	XTEXT50	CHAR	50	0	Name
30	KOMM2	☐	XLBEZ	XTEXT50	CHAR	50	0	Name
31	XKBEZPRT	☐	XKBEZPRT	XKBEZ	CHAR	15	0	Short term/character
32	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
33	SLVSON	☐	VVSLVSON	VVLVSON	NUMC	2	0	Insurance Policy Special Treatment Indicator	TDL1
34	DLVSON	☐	VVDLVSON	DATS	DATS	8	0	Key Date for Special Treatment of Insurance
35	DFINAMT	☐	VVDFINAMT	DATUM	DATS	8	0	Date of tax office report
36	SLVGRP1	☐	VVSLVGRP1	VVSLVGRP1	CHAR	6	0	Internal Indicator
37	SLVGRP2	☐	VVSLVGRP2	VVSLVGRP2	CHAR	6	0	Internal indicator
38	SBUEART1	☐	VVSBUEART1	VVSBUEART1	NUMC	2	0	Guarantee type 2	TDL21
39	SBUEART	☐	VVSBUEART	VVSBUEART	NUMC	2	0	Guarantee type 1	TDL2
40	DBUERG	☐	VVDBUERG	DATUM	DATS	8	0	Date of statement of guarantee
41	XKOKBEZ	☐	VVXKOKBEZ	CHAR15	CHAR	15	0	Quota short name
42	JDYNSTAT	☐	VVJDYNSTAT	JANE	CHAR	1	0	Index-Linked Insurance Indicator
43	JDYNANN	☐	VVJDYNANN	JANE	CHAR	1	0	Adoption of index-linked insurance indicator
44	DDYNANN	☐	VVDDYNDAT	DATUM	DATS	8	0	Acceptance date of last dynamics
45	SLVHERK	☐	VVSLVHERK	VVSLVHERK	NUMC	1	0	Contract origin indicator
46	BVORABL	☐	VVVVORABL	BWHR	CURR	13	2	Prospective maturity payment
47	LVRECH	☐	VVDLVRECH	DATUM	DATS	8	0	Calculation date of maturity payments
48	SLAENDER	☐	SLAENDER	LAND1	CHAR	3	0	Country ID	T005
49	.INCLU--AP	☐				0	0	Consumer Loan
50	CLI_COMMENT	☐	TB_CLI_COMMENT	CHAR50	CHAR	50	0	Comment on Calculation of CLI Single Premium
51	RECALC_COMMENT	☐	TB_CLI_RECALC_COMMENT	CHAR50	CHAR	50	0	Comment on Recalculation of CLI Single Premium

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDLV	MANDT	T000	MANDT	KEY	1	1
2	VDLV	SBUEART	TDL2	SBUEART	KEY	1	CN
3	VDLV	SBUEART1	TDL21	SBUEART	KEY	1	CN
4	VDLV	SLAENDER	T005	LAND1
5	VDLV	SLVSON	TDL1	SLVSON	KEY	1	CN
6	VDLV	SPFSTAT	TDL3	STATUS	KEY	1	CN
7	VDLV	SSICH	TD01	SSICH	KEY	1	CN
8	VDLV	SVWAERS	TCURC	WAERS	KEY	1	1

History

Last changed by/on	SAP	20110901
SAP Release Created in