SAP ABAP Table RBCT_RANL (CML BCT: Extraction Structure Loans)

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	Table Relationship Diagram
Short Description	CML BCT: Extraction Structure Loans

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	.INCLUDE	☐				0	0	VDARL- Fields for Extraction Structure for IO 0FS_CTR_NO
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
4	DATETO	☐	DATE	CHAR8	CHAR	8	0	Date in CHAR format
5	DATEFROM	☐	DATE	CHAR8	CHAR	8	0	Date in CHAR format
6	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
7	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
8	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
9	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
10	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
11	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	TD03A
12	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
13	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	*
14	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
15	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
16	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
17	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
18	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	TDDG1
19	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	TDDG2
20	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
21	RANLKET	☐	RANLHPT	CHAR13	CHAR	13	0	Principle loan investment number
22	RANTRAG	☐	RANTRAG	CHAR13	CHAR	13	0	Application number
23	SSOLIST	☐	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
24	SFRIST	☐	SFRIST	SFRIST	NUMC	2	0	Loan Term	*
25	BANTRAG	☐	BANTRAG	BWHR	CURR	13	2	Capital applied for
26	SANTWHR	☐	SWHR	WAERS	CUKY	5	0	Currency	*
27	DANTRAG	☐	DANTRAG	DATUM	DATS	8	0	Entry Date of Loan Application
28	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
29	SSICHER	☐	SSICHER	SSICH	CHAR	4	0	Primary collateral	TD01
30	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	TD07
31	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	TD10
32	SLAENDER	☐	SLAENDER	LAND1	CHAR	3	0	Country ID	T005
33	SNICHTAB	☐	SNICHTAB	SNICHTAB	NUMC	2	0	Reason for Non-Acceptance	TDA5
34	JORIG	☐	BUCHSYS	BUCHSYS	NUMC	1	0	Posting system indicator for borrower's note loans
35	SDTYP	☐	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	TD02
36	DBEWI	☐	VVDBEWI	DATUM	DATS	8	0	Approval date
37	SABT	☐	VVSABT	VVSABT	CHAR	4	0	Assignee	*
38	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
39	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
40	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
41	SONDST	☐	VVSONDST	VVSONDST	CHAR	2	0	Special posting treatment	TD14
42	SGRP3	☐	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	TDDG3
43	SGRP4	☐	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	TDDG4
44	SZKEY	☐	VVSZKEY	VVSZKEY	NUMC	2	0	Indicator for Control of Incoming Payment Distribution	TVZ01
45	SVERFU	☐	VVSVERFU	VVSVERFU	NUMC	2	0	Type of Restraint on Drawing	TZV05
46	STITART	☐	VVSTITART	VVSTITART	NUMC	2	0	Borrower's Note Loan Security Type	TD16
47	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
48	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	TD18
49	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
50	SBEA	☐	VVSBEA	VVSBEA	NUMC	2	0	Loan Processing Indicator
51	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
52	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
53	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	TDMAHNS_MAN
54	DRUECK	☐	VVDRUECK	DATUM	DATS	8	0	Date when loan will probably be redeemed
55	SABGRENZ	☐	VVSABGRD	VVSABGRD	CHAR	1	0	Loan Discount Accrual/Deferral Method
56	SFEST	☐	VVFESTKZ	VVFESTKZ	CHAR	1	0	Indicator for Control of Fixed Contract
57	SRATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
58	SRATAGEN	☐	SRATAGEN_NEW	BU_PARTNER	CHAR	10	0	Rating agency	BUT000
59	RDARNEHM	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
60	OBJNR	☐	CHAR22	CHAR22	CHAR	22	0	Text string 22 characters
61	HDN_KUNNR	☐	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	KNA1
62	RANLSTAMNR	☐	RANLSTAMNR	RANL	CHAR	13	0	Master number part of loan number for finding contracts
63	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
64	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
65	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
66	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
67	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
68	SDUNCHARG	☐	SDUNCHARG	XFELD	CHAR	1	0	Post Dunning Charges and Interest to this Contract
69	SAKTPAS	☐	VVSAKTPAS	VVSAKTPAS	CHAR	1	0	Indicator: Asset/Liability Transaction
70	RPZAHL	☐	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
71	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
72	JNOREPAY	☐	TB_JNOREPAY	XFELD	CHAR	1	0	Payoff Lock
73	JNODOIP	☐	TB_JNODOIP	XFELD	CHAR	1	0	Blocked by Payoff: No Open Item Clearing for Loan
74	COM_VAL_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
75	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
76	SSTATE_OF_EXEC	☐	TB_SREGION	REGIO	CHAR	3	0	Region Where Contract Concluded	*
77	BACKOFFICE_ID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
78	PAYM_STATUS	☐	TB_PAYM_STATUS	T_PAYM_STATUS	CHAR	1	0	Payment Status
79	.INCLUDE	☐				0	0	VZZKOKO-Fields from Extraction Structure for IO 0FS_CTR_NO
80	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
81	NLFD_ANG	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
82	SKOKOART	☐	SKOKOART	SKOKOART	NUMC	2	0	Type of Condition Header
83	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
84	KZAHLUNG	☐	KZAHLUNG	DEC3_7	DEC	10	7	Pay-in/disbursement rate
85	BZUSAGE	☐	BZUSAGE	WERTV7	CURR	13	2	Commitment capital
86	PEFFZINS	☐	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
87	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
88	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
89	SDISKO	☐	SDISKO	SDISKO	CHAR	1	0	Discounted
90	DKUEND	☐	DKUEND	DATUM	DATS	8	0	Date of notice
91	SKUEND	☐	SKUEND	SKUEART	NUMC	3	0	Reason for Notice	TD04
92	DKUENDDG	☐	DKUENDDG	DATUM	DATS	8	0	Earliest Possible Date for Notice Given by the Lender
93	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
94	DELFZ	☐	DELFZ	DATUM	DATS	8	0	End of Term
95	PMANEFFZ	☐	PEFFZINS_INTERN	DEC3_7	DEC	10	7	Internal Effective Interest Rate
96	SEFFM2	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
97	SKUEGL	☐	VVSKUEGL	VVSKUEGL	NUMC	3	0	Notice Arrangement Lender	TD28
98	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
99	DABEFFZ	☐	VVDABEFFZ	DATUM	DATS	8	0	Date when calculation of effective rate starts
100	DKUENDDN	☐	VVDKUENDDN	DATUM	DATS	8	0	Earliest Possible Date for Notice Given by the Borrower
101	SKUEDN	☐	VVSKUEDN	VVSKUEDN	NUMC	3	0	Notice Arrangement Borrower	TD29
102	SKUEART	☐	VVSKUEART	VVSKUEART	NUMC	3	0	Notice Type for the Loan	TD27
103	DMARKTZINS	☐	DMARKTZINS	DATS	DATS	8	0	ISB: Market Rate Date: Market Interest Rate for NPV Calc.
104	.INCLUDE	☐				0	0	Various Additional Fields for Extractn Structure 0FS_CTR_NO
105	NOM_INTEREST	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
106	INTEREST_TYPE	☐			CHAR	1	0
107	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	*
108	INTEB	☐	VVSINTEB	INTEB	NUMC	2	0	Financial Assets Management internal level	*
109	NOMZINS	☐	NOMZI	NOMZI	DEC	6	3	Nominal interest rate with 3 decimal places
110	EFFZC	☐			DEC	6	3
111	EFFZIC	☐			DEC	6	3

Foreign Keys

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

History

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