SAP ABAP Table JBDLOANDERI (Derivation Structure: Loans)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ IS-B-PA-STC (Application Component) Single Transaction Costing
     ⤷ JBT (Package) Application development IS-B Transaction Costing

Basic Data

Table Category	INTTAB	Structure
Structure	JBDLOANDERI	Table Relationship Diagram
Short Description	Derivation 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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	RANL	☐	RANL	RANL	CHAR	13	0	Contract Number
3	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
4	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
5	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
6	RDARNEHM	☐	RDARNEHM_NEW	BU_PARTNER	CHAR	10	0	Borrower/Applicant Number	*
7	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
8	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
9	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPAB
10	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	*
11	SANTWHR	☐	SWHR	WAERS	CUKY	5	0	Currency	TCURC
12	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	TD07
13	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
14	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
15	DELFZ	☐	DENDLFZ	DATUM	DATS	8	0	End of Loan Term
16	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	TDDG1
17	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	TDDG2
18	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
19	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
20	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
21	OBJNR	☐	CHAR22	CHAR22	CHAR	22	0	Text string 22 characters
22	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
23	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
24	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
27	BZUSAGE	☐	BZUSAGE	WERTV7	CURR	13	2	Commitment capital
28	SDISEIN	☐	SDISEIN	SDISEIN	CHAR	1	0	Type of Discount Withholding
29	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBDLOANDERI	BUKRS	T001	BUKRS
2	JBDLOANDERI	GSART	TZPAB	GSART		1	CN
3	JBDLOANDERI	GSBER	TGSB	GSBER
4	JBDLOANDERI	RPORTB	TWPOB	RPORTB	KEY	1	CN
5	JBDLOANDERI	SANLF	TZAF	SANLF
6	JBDLOANDERI	SANTWHR	TCURC	WAERS		1	1
7	JBDLOANDERI	SGESST	TD17	SGESST		1	CN
8	JBDLOANDERI	SGR1	TDDG1	SGRP1		1	CN
9	JBDLOANDERI	SGR2	TDDG2	SGRP2		1	CN
10	JBDLOANDERI	SSTATI	TZC37	STATU		1	CN
11	JBDLOANDERI	SVZWECK	TD07	SVZWECK	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in