SAP ABAP Table RLFVSIC (TR-EDT: Structure for External Data Transfer Collaterals)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	RLFVSIC	Table Relationship Diagram
Short Description	TR-EDT: Structure for External Data Transfer Collaterals

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RSICHER	☐	RSICHER	NUMC8	NUMC	8	0	Collateral reference number
2	XSICALT	☐	RSICHER	NUMC8	NUMC	8	0	Collateral reference number
3	NON_COMPATIBLE	☐	TB_DECCONV	BOOLEAN	CHAR	1	0	Interpretation of Numeric Fields According to Decimal Places
4	AUSWDYN	☐	VVJAUSWDYN	KENZX	CHAR	1	0	Index-Linked Insurance Radio Button
5	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
6	BLVPR	☐	UB_BLVPR	NUMC13	NUMC	13	0	Contract contribution/premium
7	BVERTRAG	☐	UB_BVERTRAG	NUMC13	NUMC	13	0	Contract Amount
8	BVORABL	☐	UB_VVVVORABL	NUMC13	NUMC	13	0	Prospective maturity payment
9	DBLV	☐	DBLV	DATUM	DATS	8	0	Contract Start
10	DDYNANN	☐	VVDDYNDAT	DATUM	DATS	8	0	Acceptance date of last dynamics
11	DELV	☐	DELV	DATUM	DATS	8	0	Contract End Date
12	DFINAMT	☐	VVDFINAMT	DATUM	DATS	8	0	Date of tax office report
13	DLVSON	☐	VVDLVSON	DATS	DATS	8	0	Key Date for Special Treatment of Insurance
14	DVERTRAG	☐	DVERTRAG	DATUM	DATS	8	0	Contract Date
15	JDYNANN	☐	VVJDYNANN	JANE	CHAR	1	0	Adoption of index-linked insurance indicator
16	KOMM1	☐	XLBEZ	XTEXT50	CHAR	50	0	Name
17	KOMM2	☐	XLBEZ	XTEXT50	CHAR	50	0	Name
18	PBONUS	☐	UB_PBONUS	NUMC10	NUMC	10	0	Bonus / dynamization factor
19	PSPZINS	☐	UB_PSPZINS	NUMC10	NUMC	10	0	Interest on savings for credit balance
20	SLAENDER	☐	SLAENDER	LAND1	CHAR	3	0	Country ID	T005
21	SLVHERK	☐	VVSLVHERK	VVSLVHERK	NUMC	1	0	Contract origin indicator
22	SLVSON	☐	VVSLVSON	VVLVSON	NUMC	2	0	Insurance Policy Special Treatment Indicator	TDL1
23	SPFSTAT	☐	SPFSTAT	SPFSTAT	NUMC	2	0	Pledge status indicator	TDL3
24	SSICH	☐	SSICH	SSICH	CHAR	4	0	Collateral type	TD01
25	SVWAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
26	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
27	XLVNR	☐	XLVNR	CHAR15	CHAR	15	0	Contract / account number
28	XLVTARIF	☐	XLVTARIF	XKBEZ	CHAR	15	0	Contract Rate/Group
29	BVALHYP	☐	UB_BVALHYP	NUMC13	NUMC	13	0	Mortgage value-dated amount
30	DEINTRAG	☐	DEINTRAG	DDAT	DATS	8	0	Date of entry
31	NBANDNR	☐	NBANDNR	TEXT15	CHAR	15	0	Land register volume number
32	NBLATTNR	☐	NBLATTNR	TEXT15	CHAR	15	0	Land register page number
33	SWHRVAL	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
34	XADRDV4	☐	XADRDV4	TEXT50	CHAR	50	0	Property location/ name of vessel
35	XGBAMT	☐	XGBAMT	XTEXT25	CHAR	25	0	Land registry ID
36	XGVON	☐	XGBVON	XTEXT25	CHAR	25	0	Land register district
37	XNRABT3	☐	XNRABT3	CHAR5	CHAR	5	0	No. of entry in Section 3 of land register
38	BNOMS	☐	UB_BNOMS	NUMC13	NUMC	13	0	Nominal value
39	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
40	DEBEG	☐	DEBEG	DATUM	DATS	8	0	Issue start date
41	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
42	DKURSWRT	☐	DKURSWRT	DATUM	DATS	8	0	Date of valuation at market value
43	DURUEB	☐	VVDURUEB	DATS	DATS	8	0	Date of document transfer/date of entry in debt register
44	PKUR	☐	UB_PKUR	NUMC10	NUMC	10	0	Price in Percent
45	PNOMZINS	☐	UB_PNOMZINS	NUMC10	NUMC	10	0	Nominal interest rate
46	SVERWA	☐	SVERWA	SVERWA	CHAR	1	0	Custody type	*
47	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
48	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
49	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
50	XDKBZ	☐	XDKBZ	XKBEZ	CHAR	15	0	Sec.acct position short description
51	XEMIT	☐	XEMIT	XDOKBS	CHAR	50	0	Name of issuer (info)
52	XREIHE	☐	XREIHE	XKBEZ	CHAR	15	0	Issue Series
53	XSERIE	☐	XSERIE	XKBEZ	CHAR	15	0	Issue serial number
54	XWPKN	☐	XWPKN	XKBEZ	CHAR	15	0	Securities ID number (Display PRF5)
55	ASTUECK	☐	UB_ASTUECK	NUMC15	NUMC	15	0	Number of units for unit-quoted securities
56	BNEWE	☐	UB_BNEWE	NUMC10	NUMC	10	0	Nominal value per share
57	BWKUR	☐	UB_BWKURS	NUMC13	NUMC	13	0	Security price for unit quotation
58	DBUERG	☐	VVDBUERG	DATUM	DATS	8	0	Date of statement of guarantee
59	SBUEART	☐	VVSBUEART	VVSBUEART	NUMC	2	0	Guarantee type 1	TDL2
60	SBUEART1	☐	VVSBUEART1	VVSBUEART1	NUMC	2	0	Guarantee type 2	TDL21
61	XKOKBEZ	☐	VVXKOKBEZ	CHAR15	CHAR	15	0	Quota short name
62	PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
63	ROLE	☐	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role	TB003
64	USE04	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
65	USE05	☐	USRUNIT	MEINS	UNIT	3	0	User field: Unit for quantity fields	T006
66	USE06	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
67	USE07	☐	USRCUKY	WAERS	CUKY	5	0	User field: Unit for value fields	TCURC
68	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
69	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
70	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
71	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
72	USR04	☐	UB_USRQUAN13	NUMC13	NUMC	13	0	User field for quantity (length 10.3)
73	USR05	☐	UB_USRQUAN13	NUMC13	NUMC	13	0	User field for quantity (length 10.3)
74	USR06	☐	UB_USRCURR13	NUMC13	NUMC	13	0	User-defined field for values (length 10,3)
75	USR07	☐	UB_USRCURR13	NUMC13	NUMC	13	0	User-defined field for values (length 10,3)
76	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
77	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
78	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
79	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
80	G_OUTBOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
81	G_DIALOG	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
82	MEMESC	☐	SO_ESCAPE	SO_ESCAPE	CHAR	1	0	Specification of recipient type
83	OBJDES	☐	SO_OBJ_DES	SO_OBJ_DES	CHAR	50	0	Short description of contents
84	OBJNAM	☐	SO_OBJ_NAM	SO_OBJ_NAM	CHAR	12	0	Name of document, folder or distribution list
85	ACALL	☐	SO_ACALL	SO_FLAG	CHAR	1	0	ToDo by all recipients
86	ACDAT	☐	SO_DAT_AC	DATUM	DATS	8	0	Date by which action is to be taken on the received document
87	ACTIM	☐	SO_TIM_AC	UZEIT	TIMS	6	0	Time by which the received object must be acted upon
88	FORFB	☐	SO_FORFB	SO_FLAG	CHAR	1	0	You cannot forward this message
89	OBJAC	☐	SO_OBJ_AC	SO_FLAG	CHAR	1	0	The recipient must take action
90	OBJRR	☐	SO_OBJ_RR	SO_FLAG	CHAR	1	0	A reply must be sent for this object
91	PRIFB	☐	SO_PRIFB	SO_FLAG	CHAR	1	0	Object cannot be printed
92	RCDAT	☐	SO_DAT_RC	DATUM	DATS	8	0	Date document was received
93	RCTIM	☐	SO_TIM_RC	UZEIT	TIMS	6	0	Time object was received
94	RECNAM	☐	SO_REC_NAM	USERNAME	CHAR	12	0	Recipient Name
95	SNDEX	☐	SO_SND_EX	SO_FLAG	CHAR	1	0	Send express
96	SO_PARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
97	BSOND	☐	UB_VVBSOND	NUMC13	NUMC	13	0	Special arrangement amount
98	DSOND	☐	VVDSOND	DATUM	DATS	8	0	Date of agreement
99	X_KOMM1	☐	XLBEZ	XTEXT50	CHAR	50	0	Name
100	SRANG	☐	VVSRANG	VVSRANG	CHAR	1	0	Ranking
101	SSOND	☐	VVSSOND	VVSSOND	NUMC	2	0	Type of arrangement	TD22
102	STREUKZ	☐	VVSTREUKZ	VVSTREUKZ	CHAR	1	0	Handling of trust amount
103	SWHR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
104	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
105	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
106	BHAFTUNG	☐	UB_BHAFTUNG	NUMC13	NUMC	13	0	Value of assigned rights from collateral
107	BHAFTWHR	☐	SWHR	WAERS	CUKY	5	0	Currency	*
108	DABTRET	☐	DABTRET	DATUM	DATS	8	0	Date of assignment for collateral security
109	DANZEIGE	☐	VVDABANZ	DATUM	DATS	8	0	Assignment display date
110	DBESTAET	☐	VVDABBST	DATUM	DATS	8	0	Assignment confirmation date
111	DURK	☐	DURK	DATUM	DATS	8	0	Document date/expert opinion date
112	XURK	☐	XURK	CHAR15	CHAR	15	0	Document number
113	SDOKUART	☐	SDOKUART	SDOKUART	NUMC	3	0	Indicator for the type of document
114	FLG_ADD_DATA	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RLFVSIC	BUKRS	T001	BUKRS
2	RLFVSIC	PARTNR	BUT000	PARTNER
3	RLFVSIC	ROLE	TB003	ROLE
4	RLFVSIC	SBUEART	TDL2	SBUEART
5	RLFVSIC	SBUEART1	TDL21	SBUEART
6	RLFVSIC	SLAENDER	T005	LAND1
7	RLFVSIC	SLVSON	TDL1	SLVSON
8	RLFVSIC	SO_PARTNR	BUT000	PARTNER
9	RLFVSIC	SPFSTAT	TDL3	STATUS
10	RLFVSIC	SSICH	TD01	SSICH
11	RLFVSIC	SSOND	TD22	SSOND
12	RLFVSIC	SVWAERS	TCURC	WAERS
13	RLFVSIC	SWHR	TCURC	WAERS
14	RLFVSIC	SWHRVAL	TCURC	WAERS
15	RLFVSIC	USE04	T006	MSEHI
16	RLFVSIC	USE05	T006	MSEHI
17	RLFVSIC	USE06	TCURC	WAERS
18	RLFVSIC	USE07	TCURC	WAERS
19	RLFVSIC	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in