SAP ABAP Table RBCT_RANL_VDARL (VDARL- Fields for Extraction Structure for IO 0FS_CTR_NO)

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	RBCT_RANL_VDARL	Table Relationship Diagram
Short Description	VDARL- Fields for Extraction Structure for IO 0FS_CTR_NO

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
3	DATETO	☐	DATE	CHAR8	CHAR	8	0	Date in CHAR format
4	DATEFROM	☐	DATE	CHAR8	CHAR	8	0	Date in CHAR format
5	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
6	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
7	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
8	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
9	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
10	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	TD03A
11	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
12	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	*
13	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
14	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
15	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
16	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
17	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	TDDG1
18	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	TDDG2
19	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
20	RANLKET	☐	RANLHPT	CHAR13	CHAR	13	0	Principle loan investment number
21	RANTRAG	☐	RANTRAG	CHAR13	CHAR	13	0	Application number
22	SSOLIST	☐	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
23	SFRIST	☐	SFRIST	SFRIST	NUMC	2	0	Loan Term	*
24	BANTRAG	☐	BANTRAG	BWHR	CURR	13	2	Capital applied for
25	SANTWHR	☐	SWHR	WAERS	CUKY	5	0	Currency	*
26	DANTRAG	☐	DANTRAG	DATUM	DATS	8	0	Entry Date of Loan Application
27	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
28	SSICHER	☐	SSICHER	SSICH	CHAR	4	0	Primary collateral	TD01
29	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	TD07
30	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	TD10
31	SLAENDER	☐	SLAENDER	LAND1	CHAR	3	0	Country ID	T005
32	SNICHTAB	☐	SNICHTAB	SNICHTAB	NUMC	2	0	Reason for Non-Acceptance	TDA5
33	JORIG	☐	BUCHSYS	BUCHSYS	NUMC	1	0	Posting system indicator for borrower's note loans
34	SDTYP	☐	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	TD02
35	DBEWI	☐	VVDBEWI	DATUM	DATS	8	0	Approval date
36	SABT	☐	VVSABT	VVSABT	CHAR	4	0	Assignee	*
37	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
38	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
39	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
40	SONDST	☐	VVSONDST	VVSONDST	CHAR	2	0	Special posting treatment	TD14
41	SGRP3	☐	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	TDDG3
42	SGRP4	☐	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	TDDG4
43	SZKEY	☐	VVSZKEY	VVSZKEY	NUMC	2	0	Indicator for Control of Incoming Payment Distribution	TVZ01
44	SVERFU	☐	VVSVERFU	VVSVERFU	NUMC	2	0	Type of Restraint on Drawing	TZV05
45	STITART	☐	VVSTITART	VVSTITART	NUMC	2	0	Borrower's Note Loan Security Type	TD16
46	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
47	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	TD18
48	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
49	SBEA	☐	VVSBEA	VVSBEA	NUMC	2	0	Loan Processing Indicator
50	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
51	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
52	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	TDMAHNS_MAN
53	DRUECK	☐	VVDRUECK	DATUM	DATS	8	0	Date when loan will probably be redeemed
54	SABGRENZ	☐	VVSABGRD	VVSABGRD	CHAR	1	0	Loan Discount Accrual/Deferral Method
55	SFEST	☐	VVFESTKZ	VVFESTKZ	CHAR	1	0	Indicator for Control of Fixed Contract
56	SRATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
57	SRATAGEN	☐	SRATAGEN_NEW	BU_PARTNER	CHAR	10	0	Rating agency	BUT000
58	RDARNEHM	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
59	OBJNR	☐	CHAR22	CHAR22	CHAR	22	0	Text string 22 characters
60	HDN_KUNNR	☐	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	KNA1
61	RANLSTAMNR	☐	RANLSTAMNR	RANL	CHAR	13	0	Master number part of loan number for finding contracts
62	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
63	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
64	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
65	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
66	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
67	SDUNCHARG	☐	SDUNCHARG	XFELD	CHAR	1	0	Post Dunning Charges and Interest to this Contract
68	SAKTPAS	☐	VVSAKTPAS	VVSAKTPAS	CHAR	1	0	Indicator: Asset/Liability Transaction
69	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
70	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
71	JNOREPAY	☐	TB_JNOREPAY	XFELD	CHAR	1	0	Payoff Lock
72	JNODOIP	☐	TB_JNODOIP	XFELD	CHAR	1	0	Blocked by Payoff: No Open Item Clearing for Loan
73	COM_VAL_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
74	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
75	SSTATE_OF_EXEC	☐	TB_SREGION	REGIO	CHAR	3	0	Region Where Contract Concluded	*
76	BACKOFFICE_ID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
77	PAYM_STATUS	☐	TB_PAYM_STATUS	T_PAYM_STATUS	CHAR	1	0	Payment Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RBCT_RANL_VDARL	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS	KEY
2	RBCT_RANL_VDARL	GSART	TZPA	GSART	KEY
3	RBCT_RANL_VDARL	GSBER	TGSB	GSBER	KEY
4	RBCT_RANL_VDARL	HBKID	T012	HBKID	KEY
5	RBCT_RANL_VDARL	HDN_KUNNR	KNA1	KUNNR	KEY
6	RBCT_RANL_VDARL	HKTID	T012K	HKTID	KEY
7	RBCT_RANL_VDARL	MABER	T047M	MABER	KEY
8	RBCT_RANL_VDARL	RDARNEHM	BUT000	PARTNER	KEY
9	RBCT_RANL_VDARL	RPORTB	TWPOB	RPORTB	KEY
10	RBCT_RANL_VDARL	RPZAHL	BUT000	PARTNER	KEY
11	RBCT_RANL_VDARL	RREFKONT	T037S	RREFKONT
12	RBCT_RANL_VDARL	SANLF	TZAF	SANLF	KEY
13	RBCT_RANL_VDARL	SBILK	TW11	SBILK	KEY
14	RBCT_RANL_VDARL	SDTYP	TD02	SDTYP	KEY
15	RBCT_RANL_VDARL	SGESST	TD17	SGESST	KEY
16	RBCT_RANL_VDARL	SGLZB	TW07	SGLZB	REF
17	RBCT_RANL_VDARL	SGR1	TDDG1	SGRP1	KEY
18	RBCT_RANL_VDARL	SGR2	TDDG2	SGRP2	KEY
19	RBCT_RANL_VDARL	SGRP3	TDDG3	SGRP3	KEY
20	RBCT_RANL_VDARL	SGRP4	TDDG4	SGRP4	KEY
21	RBCT_RANL_VDARL	SLAENDER	T005	LAND1	KEY
22	RBCT_RANL_VDARL	SMAHNM	TDMAHNS_MAN	SMAHNM	KEY
23	RBCT_RANL_VDARL	SNICHTAB	TDA5	SNICHTAB	KEY
24	RBCT_RANL_VDARL	SONDST	TD14	SONDST	KEY
25	RBCT_RANL_VDARL	SRATAGEN	BUT000	PARTNER	KEY
26	RBCT_RANL_VDARL	SRATING	TP06	RATING	KEY
27	RBCT_RANL_VDARL	SREGION	TD18	SREGION	KEY
28	RBCT_RANL_VDARL	SSICHER	TD01	SSICH	KEY
29	RBCT_RANL_VDARL	SSONDER	TD10	SSONDER	KEY
30	RBCT_RANL_VDARL	SSTATI	TZC37	STATU	KEY
31	RBCT_RANL_VDARL	STITART	TD16	STITART	KEY
32	RBCT_RANL_VDARL	STITEL	TD03A	STITEL	KEY
33	RBCT_RANL_VDARL	SVERFU	TZV05	SVERFU	KEY
34	RBCT_RANL_VDARL	SVZWECK	TD07	SVZWECK	KEY
35	RBCT_RANL_VDARL	SZKEY	TVZ01	SZKEY	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in	200