SAP ABAP Table RCFA_LOAN (Structures and Tables for a Loan)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-CML-PO (Application Component) Portfolio
     ⤷ FVVD_CASHFLOW_ADJUSTMENT (Package) Adjustment of Cash Flow Flows During Backdated Cond. Change

Basic Data

Table Category	INTTAB	Structure
Structure	RCFA_LOAN	Table Relationship Diagram
Short Description	Structures and Tables for a Loan

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

History

Last changed by/on	SAP	20141121
SAP Release Created in	500