SAP ABAP View V_ESRFPVDARL (CML Corr.: Finance Projects)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML (Application Component) Loans Management
     ⤷ FVVD_CH (Package) CML - Country-Specifc Requirements for Switzerland

Basic Data

View Type	D	Database View
Database View	V_ESRFPVDARL
Short Description	CML Corr.: Finance Projects
Root table	VDARL	Loans

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VDARL	VDARL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VDARL	RKLAMMER		NE	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	VDARL	*		☐		☐
2	MANDT	VDARL	MANDT		☐	MANDT	☐	Client
3	BUKRS	VDARL	BUKRS		☐	BUKRS	☐	Company Code
4	SARCHIV	VDARL	SARCHIV		☐	SARCHIV	☐	Archiving Category Indicator
5	RANL	VDARL	RANL		☐	RANL	☐	Contract Number
6	RERF	VDARL	RERF		☐	RERF	☐	Entered by
7	DERF	VDARL	DERF		☐	DERF	☐	First Entered on
8	TERF	VDARL	TERF		☐	TERF	☐	Time of Initial Entry
9	REHER	VDARL	REHER		☐	REHER	☐	Source of initial entry
10	RBEAR	VDARL	RBEAR		☐	RBEAR	☐	Employee ID
11	DBEAR	VDARL	DBEAR		☐	DBEAR	☐	Last Edited on
12	TBEAR	VDARL	TBEAR		☐	TBEAR	☐	Last Edited at
13	RBHER	VDARL	RBHER		☐	RBHER	☐	Editing Source
14	SOBJEKT	VDARL	SOBJEKT		☐	VVKEYOBJ	☐	Internal key for object
15	SSTATI	VDARL	SSTATI		☐	SSTATI	☐	Status of data record
16	SANLF	VDARL	SANLF		☐	SANLF	☐	Product Category
17	GSART	VDARL	GSART		☐	VVSART	☐	Product Type
18	RREFKONT	VDARL	RREFKONT		☐	RREFKONT	☐	Account Assignment Reference in Financial Assets Management
19	HBKID	VDARL	HBKID		☐	HBKID	☐	Short key for a house bank
20	HKTID	VDARL	HKTID		☐	HKTID	☐	ID for account details
21	STITEL	VDARL	STITEL		☐	STITEL	☐	Loan Type Indicator
22	SGLZB	VDARL	SGLZB		☐	SGLZB	☐	SCB asset group indicator
23	SFIBG	VDARL	SFIBG		☐	SFIBG	☐	Asset Grouping Indicator
24	SBILK	VDARL	SBILK		☐	SBILK	☐	Balance Sheet Indicator
25	XALKZ	VDARL	XALKZ		☐	XALKZ	☐	Short name
26	XALLB	VDARL	XALLB		☐	XALLB	☐	Long name
27	XAKT	VDARL	XAKT		☐	XAKT	☐	File Number
28	RANLALT1	VDARL	RANLALT1		☐	RANLALT1	☐	Alternative Identification
29	RANLALT2	VDARL	RANLALT2		☐	RANLALT2	☐	Alternative identification 2
30	SGR1	VDARL	SGR1		☐	SGRP1	☐	Group Key 1 (Freely Available)
31	SGR2	VDARL	SGR2		☐	SGRP2	☐	Group Key 2 (Freely Available)
32	RKLAMMER	VDARL	RKLAMMER		☐	RKLAMMER	☐	Classification Number for Finance Projects
33	RANLKET	VDARL	RANLKET		☐	RANLHPT	☐	Principle loan investment number
34	RANTRAG	VDARL	RANTRAG		☐	RANTRAG	☐	Application number
35	SSOLIST	VDARL	SSOLIST		☐	VVSSOLIST	☐	Plan/Actual principle
36	SFRIST	VDARL	SFRIST		☐	SFRIST	☐	Loan Term
37	BANTRAG	VDARL	BANTRAG		☐	BANTRAG	☐	Capital applied for
38	SANTWHR	VDARL	SANTWHR		☐	SWHR	☐	Currency
39	DANTRAG	VDARL	DANTRAG		☐	DANTRAG	☐	Entry Date of Loan Application
40	BZUSAGE	VDARL	BZUSAGE		☐	BZUSAGE	☐	Commitment capital
41	DZUSAGE	VDARL	DZUSAGE		☐	DZUSAGE	☐	Loan - Date of Commitment by Lender
42	DZUSAGE_ORIGIN	VDARL	DZUSAGE_ORIGIN		☐	DZUSAGE_ORIGIN	☐	Date of the Original Approval from the Lender
43	DBLFZ	VDARL	DBLFZ		☐	DBLFZ	☐	Start of Term
44	DELFZ	VDARL	DELFZ		☐	DENDLFZ	☐	End of Loan Term
45	DBDIS	VDARL	DBDIS		☐	DBDIS	☐	Start of distribution of discount
46	SDISMETH	VDARL	SDISMETH		☐	SDISMETH	☐	Discount distribution method
47	SSICHER	VDARL	SSICHER		☐	SSICHER	☐	Primary collateral
48	SVZWECK	VDARL	SVZWECK		☐	SVZWECK	☐	Purpose of Loan
49	SSONDER	VDARL	SSONDER		☐	SSONDER	☐	Special treatment of loan
50	SFIWO	VDARL	SFIWO		☐	SFIWO	☐	Indicator: Type of Residential Object Financing
51	SDTI	VDARL	SDTI		☐	SDTI	☐	DTI indicator
52	SHOME	VDARL	SHOME		☐	SHOME	☐	Home statement
53	SLAENDER	VDARL	SLAENDER		☐	SLAENDER	☐	Country ID
54	AABTRET	VDARL	AABTRET		☐	AABTRET	☐	Number of Assignments Still Possible
55	BABTRET	VDARL	BABTRET		☐	BABTRET	☐	Minimum amount for assignments
56	SNICHTAB	VDARL	SNICHTAB		☐	SNICHTAB	☐	Reason for Non-Acceptance
57	DARCHIV	VDARL	DARCHIV		☐	DARCHIV	☐	Date of Rejection/Withdrawal
58	BGESDAR	VDARL	BGESDAR		☐	BGESDAR	☐	Total amount of syndicated loan
59	DKONS	VDARL	DKONS		☐	DKONS	☐	Syndicate loan date
60	SKWGKRED	VDARL	SKWGKRED		☐	SKWGKRED	☐	Credit category indicator Para. 75 report (Austria)
61	SKWGDAR	VDARL	SKWGDAR		☐	SKWGDAR	☐	Credit type indicator for Austrian reporting
62	JORIG	VDARL	JORIG		☐	BUCHSYS	☐	Posting system indicator for borrower's note loans
63	VVSLOEKZ	VDARL	VVSLOEKZ		☐	VVSLOEKZ	☐	Deletion indicator
64	SDTYP	VDARL	SDTYP		☐	VVSDTYP	☐	Loans Class
65	DBEWI	VDARL	DBEWI		☐	VVDBEWI	☐	Approval date
66	SABTRANS	VDARL	SABTRANS		☐	VVSABTRANS	☐	Indicator for Possible Foreign Assignment
67	AKONS	VDARL	AKONS		☐	VVAKONS	☐	Number of syndicate members
68	SFGKZ	VDARL	SFGKZ		☐	VVSFGKZ	☐	Release Indicator
69	SABT	VDARL	SABT		☐	VVSABT	☐	Assignee
70	MABER	VDARL	MABER		☐	MABER	☐	Dunning Area
71	MAHNS	VDARL	MAHNS		☐	MAHNS_D	☐	Dunning Level
72	MADAT	VDARL	MADAT		☐	MADAT	☐	Date of Last Dunning Notice
73	RPNR	VDARL	RPNR		☐	VVRPNR	☐	Activity number/rollover number
74	RSBEAR	VDARL	RSBEAR		☐	DUMMY_12	☐	Dummy field 12 characters CHAR
75	SONDST	VDARL	SONDST		☐	VVSONDST	☐	Special posting treatment
76	SGRP3	VDARL	SGRP3		☐	SGRP3	☐	Group Key 3 (Freely Available)
77	SGRP4	VDARL	SGRP4		☐	SGRP4	☐	Group Key 4 (Freely Available)
78	SZKEY	VDARL	SZKEY		☐	VVSZKEY	☐	Indicator for Control of Incoming Payment Distribution
79	BEGRU	VDARL	BEGRU		☐	BEGRU	☐	Authorization Group
80	SVERFU	VDARL	SVERFU		☐	VVSVERFU	☐	Type of Restraint on Drawing
81	STITART	VDARL	STITART		☐	VVSTITART	☐	Borrower's Note Loan Security Type
82	NABTRV	VDARL	NABTRV		☐	VVNABTRV	☐	Contract of assignment number
83	NAVAL	VDARL	NAVAL		☐	VVNAVAL	☐	Guarantee number
84	DABTR	VDARL	DABTR		☐	VVDABTR	☐	Date of assignment
85	DVERFU	VDARL	DVERFU		☐	VVDVERFU	☐	Date of restraint on disposal upto
86	SFGBEW	VDARL	SFGBEW		☐	VVSFGBEW	☐	Transaction data to be released available
87	DELSOZ	VDARL	DELSOZ		☐	VVDLESOZ	☐	Date of last special interest payment period
88	RPORTB	VDARL	RPORTB		☐	RPORTB	☐	Portfolio
89	SREGION	VDARL	SREGION		☐	VVSREGION	☐	Sales Region
90	SGESST	VDARL	SGESST		☐	VVSGESST	☐	Branch Office
91	SBEA	VDARL	SBEA		☐	VVSBEA	☐	Loan Processing Indicator
92	SOBEZ	VDARL	SOBEZ		☐	VVSOBEZ	☐	Organizational District
93	SBEZIRK	VDARL	SBEZIRK		☐	VVSBEZIRK	☐	Agent District
94	SPLIT	VDARL	SPLIT		☐	VVSPLIT	☐	Debit position splitting
95	BNBUERG	VDARL	BNBUERG		☐	VVBNBUERG	☐	Initial capital not guaranteed
96	SREFZINS	VDARL	SREFZINS		☐	VVSREFZINS	☐	Loan With Reference Interest Rate
97	SMAHNM	VDARL	SMAHNM		☐	VVSMAHNM	☐	Loan Manual Dunning Level
98	SIHERK	VDARL	SIHERK		☐	CHAR2	☐	Version Number Component
99	RGENUM	VDARL	RGENUM		☐	CHAR10	☐	Character Field Length = 10
100	DRUECK	VDARL	DRUECK		☐	VVDRUECK	☐	Date when loan will probably be redeemed
101	SABGRENZ	VDARL	SABGRENZ		☐	VVSABGRD	☐	Loan Discount Accrual/Deferral Method
102	SFEST	VDARL	SFEST		☐	VVFESTKZ	☐	Indicator for Control of Fixed Contract
103	SRATING	VDARL	SRATING		☐	BP_RATING	☐	Rating
104	SRATAGEN	VDARL	SRATAGEN		☐	SRATAGEN_NEW	☐	Rating agency
105	RDARNEHM	VDARL	RDARNEHM		☐	BP_PARTNR_NEW	☐	Business Partner Number
106	OBJNR	VDARL	OBJNR		☐	TB_FINOBJNR	☐	Object Number for Financial Transactions
107	HDN_KUNNR	VDARL	HDN_KUNNR		☐	HDN_KUNNR	☐	Main Borrower Customer Number
108	SKWG14_NEU	VDARL	SKWG14_NEU		☐	VVSKWG14	☐	Position grouping acc. Para 14 GBA (Sec. and loans)
109	RANLSTAMNR	VDARL	RANLSTAMNR		☐	RANLSTAMNR	☐	Master number part of loan number for finding contracts
110	MIGDATE	VDARL	MIGDATE		☐	MIGDATE	☐	Migration date
111	SDUNNCMP	VDARL	SDUNNCMP		☐	SDUNNCMP	☐	Summarization Level for Dunning Letter
112	XNODUNN	VDARL	XNODUNN		☐	XNODUNN	☐	Exclude Loan from Dunning Run
113	ZUOND	VDARL	ZUOND		☐	TB_ZUOND	☐	Assignment
114	REFER	VDARL	REFER		☐	TB_REFER	☐	Internal Reference
115	MERKM	VDARL	MERKM		☐	TB_MERKM	☐	Characteristics
116	SDUNCHARG	VDARL	SDUNCHARG		☐	SDUNCHARG	☐	Post Dunning Charges and Interest to this Contract
117	SWHRORG	VDARL	SWHRORG		☐	SWHRORG	☐	Loan currency before conversion to EURO
118	DCONVERT	VDARL	DCONVERT		☐	DCONVERT	☐	Date loan was converted to EURO
119	DCORRECT	VDARL	DCORRECT		☐	DCORRECT	☐	Date for adjustment flows resulting from EURO conversion
120	SAKTPAS	VDARL	SAKTPAS		☐	VVSAKTPAS	☐	Indicator: Asset/Liability Transaction
121	RPZAHL	VDARL	RPZAHL		☐	TB_RPZAHL_NEW	☐	Payer/payee
122	GSBER	VDARL	GSBER		☐	GSBER	☐	Business Area
123	JNOREPAY	VDARL	JNOREPAY		☐	TB_JNOREPAY	☐	Payoff Lock
124	JNODOIP	VDARL	JNODOIP		☐	TB_JNODOIP	☐	Blocked by Payoff: No Open Item Clearing for Loan
125	COM_VAL_CLASS	VDARL	COM_VAL_CLASS		☐	TPM_COM_VAL_CLASS	☐	General Valuation Class
126	SARC_EXCL	VDARL	SARC_EXCL		☐	TB_SARC_EXCL	☐	Documents For The Loan May Not Be Archived
127	SARC_DOCS	VDARL	SARC_DOCS		☐	TB_SARC_DOCS	☐	Indicator: Archived Loan Documents Exist
128	NO_PLAN_DONE	VDARL	NO_PLAN_DONE		☐	TB_NO_PLAN_DONE	☐	Do Not Transfer Loan to Status "Completed"
129	DPLAN_SET	VDARL	DPLAN_SET		☐	TB_DPLAN_SET	☐	Date of Transfer of Contract into Status Planned Completed
130	DOPEN	VDARL	DOPEN		☐	TB_DOPEN	☐	Opening Date of a Loan Contract
131	DCLOSE	VDARL	DCLOSE		☐	TB_DCLOSE	☐	Closing Date of a Loan Contract
132	DUNN_BLOCK_TILL	VDARL	DUNN_BLOCK_TILL		☐	TB_VIEW_DATE_DUNNING_BLOCK_TIL	☐	Expiration Date of Dunning Lock
133	XNOIOA	VDARL	XNOIOA		☐	TB_XNOIOA	☐	Lock for Interest on Arrears
134	NOIOA_TILL	VDARL	NOIOA_TILL		☐	TB_NOIOA_TILL	☐	Expiry Date of Lock on Interest on Arrears
135	ORIGIN	VDARL	ORIGIN		☐	TB_ORIGIN	☐	Loan Origin
136	DCALLEND	VDARL	DCALLEND		☐	TB_DCALLEND	☐	Provision Expiry Date
137	SVER_EXCL	VDARL	SVER_EXCL		☐	TB_SVER_EXCL	☐	Documents for the loan may not be summarized
138	LC_DISBURSEMENT	VDARL	LC_DISBURSEMENT		☐	TB_LC_CHARAC_DISBURSEMENT	☐	Processing Characteristic: Disbursement Status
139	LC_CAPITALS	VDARL	LC_CAPITALS		☐	TB_LC_CHARAC_CAPITALS	☐	Processing Characteristic: Status of Capital Amounts
140	LC_PLANNED_FLOW	VDARL	LC_PLANNED_FLOW		☐	TB_LC_CHARAC_PLANNED_FLOW	☐	Processing Characteristic: Status of Planned Records
141	LC_DEBIT	VDARL	LC_DEBIT		☐	TB_LC_CHARAC_DEBIT	☐	Processing Characteristic: Status of Customer Receivables
142	LC_CREDIT	VDARL	LC_CREDIT		☐	TB_LC_CHARAC_CREDIT	☐	Processing Characteristic: Status of Customer Payables
143	LC_STATUS	VDARL	LC_STATUS		☐	TB_LC_STATUS	☐	Status of Processing Characteristics for Loan
144	PAYM_STATUS	VDARL	PAYM_STATUS		☐	TB_PAYM_STATUS	☐	Payment Status
145	STOP_INDICATOR	VDARL	STOP_INDICATOR		☐	TB_STOP_INDICATOR	☐	Stop Indicator
146	PRODUCT_ID	VDARL	PRODUCT_ID		☐	TB_PR_PRODINT	☐	Internal Product ID
147	PRODUCT_VERSION	VDARL	PRODUCT_VERSION		☐	TB_PR_VERSION	☐	Product Version
148	SCHUFA_MESSAGE	VDARL	SCHUFA_MESSAGE		☐	TB_VIEW_SCHUFA	☐	Business Partner Has Signed a Schufa Declaration
149	DAT_FULL_PAY	VDARL	DAT_FULL_PAY		☐	TB_VIEW_DATE_OF_FULL_PAYMENT	☐	Date of Full Disbursement
150	DAT_OF_CANCEL	VDARL	DAT_OF_CANCEL		☐	TB_VIEW_DATE_OF_CANCELATION	☐	Rescission Date
151	FLG_CNCL	VDARL	FLG_CNCL		☐	TB_CNCL	☐	Rescission Indicator
152	DINSTR	VDARL	DINSTR		☐	TB_DINSTR	☐	Date Customer Was Instructed About Rescission Rights
153	ORGUNIT	VDARL	ORGUNIT		☐	TB_MD_ORGUNIT_CNMGT	☐	Organizational Unit
154	DISTRIB_CHANNEL	VDARL	DISTRIB_CHANNEL		☐	TB_MD_DISTRIBUTION_CHANNEL	☐	Sales Channel
155	FLG_CNCL_CLI	VDARL	FLG_CNCL_CLI		☐	TB_CNCL_CLI	☐	Indicator: Rescind Credit Life Insurance
156	FLG_NO_CHANGE	VDARL	FLG_NO_CHANGE		☐	TB_MD_NO_CHANGE	☐	Only Limited Changes Possible for Contract Indicator
157	SCHEME_ID	VDARL	SCHEME_ID		☐	TB_SCHEME_ID	☐	Calculation Profile for Interest on Arrears Calculation
158	SSTATE_OF_EXEC	VDARL	SSTATE_OF_EXEC		☐	TB_SREGION	☐	Region Where Contract Concluded
159	WAIVE_REASON	VDARL	WAIVE_REASON		☐	TB_WAIVE_REASON	☐	Reason for Automatic Waiver of Charges
160	WAIVE_METHOD	VDARL	WAIVE_METHOD		☐	TB_WAIVE_METHOD	☐	Waiver Method
161	BACKOFFICE_ID	VDARL	BACKOFFICE_ID		☐	TB_BACKOFFICE_ID	☐	Back Office
162	FLG_NON_ACCRUAL	VDARL	FLG_NON_ACCRUAL		☐	TB_FLG_NON_ACCRUAL	☐	Non-Accrual Status Permitted
163	SFIMA_METHOD	VDARL	SFIMA_METHOD		☐	TB_FIMA_METHOD	☐	Control Settings for FiMa Connection
164	GRACE_DAYS	VDARL	GRACE_DAYS		☐	TB_GRACEDAYS	☐	Grace Days
165	NOIOA_TILL_BLOCK	VDARL	NOIOA_TILL_BLOCK		☐	TB_NOIOA_TILL_BLOCK	☐	End Date of Non-IOA Period
166	RP_RELEVANT	VDARL	RP_RELEVANT		☐	VVRP_RELEVANT	☐	Indicator: 'CLC-Relevant'
167	CONTRACT_BIC	VDARL	CONTRACT_BIC		☐	SWIFT	☐	SWIFT/BIC for International Payments
168	CONTRACT_IBAN	VDARL	CONTRACT_IBAN		☐	BU_IBAN	☐	IBAN (International Bank Account Number)
169	IBAN_DET	VDARL	IBAN_DET		☐	TB_SEPA_IBAN_DET	☐	IBAN Determination Type for Contract
170	VDBEPP_DBEAR	VDARL	VDBEPP_DBEAR		☐	VDBEPP_DBEAR	☐	Planned Records Last Edited On
171	VDBEPP_TBEAR	VDARL	VDBEPP_TBEAR		☐	VDBEPP_TBEAR	☐	Planned Records Last Edited At
172	VDBEPP_RBHER	VDARL	VDBEPP_RBHER		☐	VDBEPP_RBHER	☐	Planned Records Editing Source

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	600