SAP ABAP Table VDARLSIC (Collateral for loan (relationship table))

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	VDARLSIC	Table Relationship Diagram
Short Description	Collateral for loan (relationship table)

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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	RANL	☑	RANL	RANL	CHAR	13	0	Contract Number
4	RSICHER	☑	RSICHER	NUMC8	NUMC	8	0	Collateral reference number
5	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
6	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
7	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
8	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
9	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
13	SSICH	☐	SSICH	SSICH	CHAR	4	0	Collateral type	TD01
14	SSICHART	☐	SSICHART	SSICHART	NUMC	2	0	Category Of Collateral Group (Internal)
15	BHAFTUNG	☐	BHAFTUNG	BWHR	CURR	13	2	Value of assigned rights from collateral
16	BHAFTWHR	☐	SWHR	WAERS	CUKY	5	0	Currency	TCURC
17	DABTRET	☐	DABTRET	DATUM	DATS	8	0	Date of assignment for collateral security
18	DBESTAET	☐	VVDABBST	DATUM	DATS	8	0	Assignment confirmation date
19	DANZEIGE	☐	VVDABANZ	DATUM	DATS	8	0	Assignment display date
20	XURK	☐	XURK	CHAR15	CHAR	15	0	Document number
21	SDOKUART	☐	SDOKUART	SDOKUART	NUMC	3	0	Indicator for the type of document
22	DURK	☐	DURK	DATUM	DATS	8	0	Document date/expert opinion date
23	JPROL	☐	VVJPROL	JANEI	CHAR	1	0	Indicator: Taken into consideration for rollover
24	DBEBEZ	☐	DBEBEZ	DATUM	DATS	8	0	Date of start of relationship
25	DENBEZ	☐	DENBEZ	DATUM	DATS	8	0	Date of end of relationship
26	JHAUPT	☐	VVJHSICH	JANEI	CHAR	1	0	Primary collateral indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VDARLSIC	BHAFTWHR	TCURC	WAERS
2	VDARLSIC	BUKRS	T001	BUKRS	KEY	1	1
3	VDARLSIC	MANDT	T000	MANDT	KEY	1	1
4	VDARLSIC	SSICH	TD01	SSICH	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in