SAP ABAP Table JBTLOSTAMM (Loans (Master Data))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ JBA (Package) Application developmnet IS-B General Development

Basic Data

Table Category	INTTAB	Structure
Structure	JBTLOSTAMM	Table Relationship Diagram
Short Description	Loans (Master Data)

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	SARCHIV	☑	SARCHIV	SARCHIV	CHAR	1	0	Archiving Category Indicator
4	RANL	☑	RANL	RANL	CHAR	13	0	Contract Number
5	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
6	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
7	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
8	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
9	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
13	SOBJEKT	☐	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
14	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	*
15	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
16	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
17	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
18	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
19	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	*
20	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	*
21	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	*
22	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	*
23	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	*
24	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
25	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
26	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
27	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
28	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
29	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	*
30	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	*
31	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
32	RANLKET	☐	RANLHPT	CHAR13	CHAR	13	0	Principle loan investment number
33	RANTRAG	☐	RANTRAG	CHAR13	CHAR	13	0	Application number
34	SSOLIST	☐	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
35	SFRIST	☐	SFRIST	SFRIST	NUMC	2	0	Loan Term	*
36	BANTRAG	☐	BANTRAG	BWHR	CURR	13	2	Capital applied for
37	SANTWHR	☐	SWHR	WAERS	CUKY	5	0	Currency	*
38	DANTRAG	☐	DANTRAG	DATUM	DATS	8	0	Entry Date of Loan Application
39	BZUSAGE	☐	BZUSAGE	WERTV7	CURR	13	2	Commitment capital
40	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
41	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
42	DELFZ	☐	DENDLFZ	DATUM	DATS	8	0	End of Loan Term
43	DBDIS	☐	DBDIS	DDAT	DATS	8	0	Start of distribution of discount
44	SDISMETH	☐	SDISMETH	DISMETH	NUMC	1	0	Discount distribution method
45	SSICHER	☐	SSICHER	SSICH	CHAR	4	0	Primary collateral	*
46	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	*
47	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	*
48	SFIWO	☐	SFIWO	SFIWO	CHAR	2	0	Indicator: Type of Residential Object Financing	*
49	SDTI	☐	SDTI	NUMC	NUMC	5	0	DTI indicator
50	SHOME	☐	SHOME	SHOME	NUMC	3	0	Home statement	*
51	SLAENDER	☐	SLAENDER	LAND1	CHAR	3	0	Country ID	*
52	AABTRET	☐	AABTRET	NUM02	NUMC	2	0	Number of Assignments Still Possible
53	BABTRET	☐	BABTRET	BWHR	CURR	13	2	Minimum amount for assignments
54	SNICHTAB	☐	SNICHTAB	SNICHTAB	NUMC	2	0	Reason for Non-Acceptance	*
55	DARCHIV	☐	DARCHIV	DATUM	DATS	8	0	Date of Rejection/Withdrawal
56	BGESDAR	☐	BGESDAR	BWHR	CURR	13	2	Total amount of syndicated loan
57	DKONS	☐	DKONS	DATUM	DATS	8	0	Syndicate loan date
58	SKWGKRED	☐	SKWGKRED	SKWGKRED	NUMC	1	0	Credit category indicator Para. 75 report (Austria)	*
59	SKWGDAR	☐	SKWGDAR	SKWGDAR	NUMC	1	0	Credit type indicator for Austrian reporting	*
60	JORIG	☐	BUCHSYS	BUCHSYS	NUMC	1	0	Posting system indicator for borrower's note loans
61	VVSLOEKZ	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
62	SDTYP	☐	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	*
63	DBEWI	☐	VVDBEWI	DATUM	DATS	8	0	Approval date
64	SABTRANS	☐	VVSABTRANS	XFELD	CHAR	1	0	Indicator for Possible Foreign Assignment
65	AKONS	☐	VVAKONS	NUM03	NUMC	3	0	Number of syndicate members
66	SFGKZ	☐	VVSFGKZ	VVSFGKZ	CHAR	1	0	Release Indicator
67	SABT	☐	VVSABT	VVSABT	CHAR	4	0	Assignee	*
68	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	*
69	MAHNS	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
70	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
71	RPNR	☐	VVRPNR	NUMC08	NUMC	8	0	Activity number/rollover number
72	RSBEAR	☐	DUMMY_12	CHAR12	CHAR	12	0	Dummy field 12 characters CHAR
73	SONDST	☐	VVSONDST	VVSONDST	CHAR	2	0	Special posting treatment	*
74	SGRP3	☐	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	*
75	SGRP4	☐	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	*
76	SZKEY	☐	VVSZKEY	VVSZKEY	NUMC	2	0	Indicator for Control of Incoming Payment Distribution	*
77	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
78	SVERFU	☐	VVSVERFU	VVSVERFU	NUMC	2	0	Type of Restraint on Drawing	*
79	STITART	☐	VVSTITART	VVSTITART	NUMC	2	0	Borrower's Note Loan Security Type	*
80	NABTRV	☐	VVNABTRV	CHAR15	CHAR	15	0	Contract of assignment number
81	NAVAL	☐	VVNAVAL	CHAR15	CHAR	15	0	Guarantee number
82	DABTR	☐	VVDABTR	DATUM	DATS	8	0	Date of assignment
83	DVERFU	☐	VVDVERFU	DATUM	DATS	8	0	Date of restraint on disposal upto
84	SFGBEW	☐	VVSFGBEW	VVSFGBEW	NUMC	2	0	Transaction data to be released available
85	DELSOZ	☐	VVDLESOZ	DATUM	DATS	8	0	Date of last special interest payment period
86	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
87	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	*
88	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	*
89	SBEA	☐	VVSBEA	VVSBEA	NUMC	2	0	Loan Processing Indicator
90	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
91	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
92	SPLIT	☐	VVSPLIT	XFELD	CHAR	1	0	Debit position splitting
93	BNBUERG	☐	VVBNBUERG	WERTV7	CURR	13	2	Initial capital not guaranteed
94	SREFZINS	☐	VVSREFZINS	XFELD	CHAR	1	0	Loan With Reference Interest Rate
95	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	*
96	SIHERK	☐	JBSIHERK	JBSIHERK	CHAR	2	0	Internal Source Indicator
97	RGENUM	☐	JBRGENUM	JBRGENUM	CHAR	10	0	Transaction Number
98	DRUECK	☐	VVDRUECK	DATUM	DATS	8	0	Date when loan will probably be redeemed
99	SABGRENZ	☐	VVSABGRD	VVSABGRD	CHAR	1	0	Loan Discount Accrual/Deferral Method
100	SFEST	☐	VVFESTKZ	VVFESTKZ	CHAR	1	0	Indicator for Control of Fixed Contract
101	SRATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	*
102	SRATAGEN	☐	SRATAGEN_NEW	BU_PARTNER	CHAR	10	0	Rating agency	*
103	RDARNEHM	☐	RDARNEHM_NEW	BU_PARTNER	CHAR	10	0	Borrower/Applicant Number	*
104	OBJNR	☐	JBOBJNR	J_OBJNR	CHAR	22	0	Object number for financial transactions	*
105	HDN_KUNNR	☐	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	*
106	SKWG14_NEU	☐	VVSKWG14	VVSKWG14	CHAR	2	0	Position grouping acc. Para 14 GBA (Sec. and loans)
107	RANLSTAMNR	☐	RANLSTAMNR	RANL	CHAR	13	0	Master number part of loan number for finding contracts
108	MIGDATE	☐	MIGDATE	DATUM	DATS	8	0	Migration date
109	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
110	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
111	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics

History

Last changed by/on	SAP	20110901
SAP Release Created in