SAP ABAP Table BAPILOAN_GET (Display of Loan Contract Data)

Hierarchy

☛

EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷

FS-CML (Application Component) Loans Management
⤷

FVVD_BAPI (Package) Development Class for BAPIs and RFC Modules in Loans

Basic Data

Table Category	INTTAB	Structure
Structure	BAPILOAN_GET	Table Relationship Diagram
Short Description	Display of Loan Contract Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	COMP_CODE	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	ARCHIVE	SARCHIV	SARCHIV	CHAR	1	0	Archiving Category Indicator
3	CONTRACT_NO	RANL	RANL	CHAR	13	0	Contract Number
4	CREATION_USER	RERF	SYCHAR12	CHAR	12	0	Entered by
5	CREATION_DATE	DERF	DATUM	DATS	8	0	First Entered on
6	CREATION_TIME	TERF	TIMES	TIMS	6	0	Time of Initial Entry
7	SOUINTENTR	REHER	CHAR10	CHAR	10	0	Source of initial entry
8	LASTCHANGE_USER	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
9	LASTCHANGE_DATE	DBEAR	DATUM	DATS	8	0	Last Edited on
10	LASTCHANGE_TIME	TBEAR	TIMES	TIMS	6	0	Last Edited at
11	EDITSOURCE	RBHER	CHAR10	CHAR	10	0	Editing Source
12	OBJECT	VVKEYOBJ	VVKEY	CHAR	10	0	Internal key for object
13	STATUS	SSTATI	STATI	NUMC	2	0	Status of data record	*
14	PRODUCT_CATEGORY	SANLF	VVSANLF	NUMC	3	0	Product Category	*
15	PROD_TYPE	VVSART	VVSART	CHAR	3	0	Product Type	*
16	ACCTASSREF	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
17	HOUSEBANKID	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
18	HOUSEBANKACCTID	HKTID	HKTID	CHAR	5	0	ID for account details	*
19	LOAN_TYPE	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	*
20	SCB_AS_GRP	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	*
21	ASSET_GR	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	*
22	BAL_SH_IND	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	*
23	SHORT_TEXT	XALKZ	XKBEZ	CHAR	15	0	Short name
24	LONG_TEXT	XALLB	XLBEZ	CHAR	60	0	Long name
25	FILENO	XAKT	CHAR32	CHAR	32	0	File Number
26	ALT_NO_1	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
27	ALT_NO_2	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
28	GRP_KEY_I	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	*
29	GRP_KEY_II	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	*
30	FIN_PROJ	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
31	PRINCLN	RANLHPT	CHAR13	CHAR	13	0	Principle loan investment number
32	APPLIC_NO	RANTRAG	CHAR13	CHAR	13	0	Application number
33	PLAN_ACT	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
34	MATURITY	SFRIST	SFRIST	NUMC	2	0	Loan Term	*
35	CAPAPP	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
36	CURRENCY	SWHR	WAERS	CUKY	5	0	Currency	*
37	CURRENCY_ISO	ISOCD	ISOCD	CHAR	3	0	ISO currency code
38	APPL_DATE	DANTRAG	DATUM	DATS	8	0	Entry Date of Loan Application
39	COMM_CAP	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
40	COMMIT_DTE	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
41	TERM_START	DBLFZ	DATUM	DATS	8	0	Start of Term
42	DUE_DATE	DENDLFZ	DATUM	DATS	8	0	End of Loan Term
43	ST_DE_DIS	DBDIS	DDAT	DATS	8	0	Start of distribution of discount
44	DIS_DIST	SDISMETH	DISMETH	NUMC	1	0	Discount distribution method
45	COLLATERAL	SSICHER	SSICH	CHAR	4	0	Primary collateral	*
46	LOAN_PUR	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	*
47	SPEC_CONDS	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	*
48	FINANCTYPE	SFIWO	SFIWO	CHAR	2	0	Indicator: Type of Residential Object Financing	*
49	DTI	SDTI	NUMC	NUMC	5	0	DTI indicator
50	HOMESTAT	SHOME	SHOME	NUMC	3	0	Home statement	*
51	COUNTRY	SLAENDER	LAND1	CHAR	3	0	Country ID	*
52	COUNTRY_ISO	INTCA	INTCA	CHAR	2	0	Country ISO code
53	POSS_ASS	AABTRET	NUM02	NUMC	2	0	Number of Assignments Still Possible
54	MIN_AMTASS	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
55	NON_ACCEPT	SNICHTAB	SNICHTAB	NUMC	2	0	Reason for Non-Acceptance	*
56	REJECTION	DARCHIV	DATUM	DATS	8	0	Date of Rejection/Withdrawal
57	TOTAL_CAP	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
58	SYNDICATE	DKONS	DATUM	DATS	8	0	Syndicate loan date
59	CC_AUSTRIA	SKWGKRED	SKWGKRED	NUMC	1	0	Credit category indicator Para. 75 report (Austria)	*
60	CRED_TYPE	SKWGDAR	SKWGDAR	NUMC	1	0	Credit type indicator for Austrian reporting	*
61	POST_SYST	BUCHSYS	BUCHSYS	NUMC	1	0	Posting system indicator for borrower's note loans
62	DEL_IND	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
63	LOAN_CLASS	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	*
64	APPRDATE	VVDBEWI	DATUM	DATS	8	0	Approval date
65	FORASSIG	VVSABTRANS	XFELD	CHAR	1	0	Indicator for Possible Foreign Assignment
66	NOSYNMEM	VVAKONS	NUM03	NUMC	3	0	Number of syndicate members
67	REL_INDIC	VVSFGKZ	VVSFGKZ	CHAR	1	0	Release Indicator
68	ASSIGNEE	VVSABT	VVSABT	CHAR	4	0	Assignee	*
69	DUNN_AREA	MABER	MABER	CHAR	2	0	Dunning Area	*
70	DUNN_LEVEL	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
71	LAST_DUNN	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
72	ROLL_NO	VVRPNR	NUMC08	NUMC	8	0	Activity number/rollover number
73	RSBEAR	DUMMY_12	CHAR12	CHAR	12	0	Dummy field 12 characters CHAR
74	SP_POS_TR	VVSONDST	VVSONDST	CHAR	2	0	Special posting treatment	*
75	GRPKEY_III	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	*
76	GRP_KEY_IV	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	*
77	IPD_CONTR	VVSZKEY	VVSZKEY	NUMC	2	0	Indicator for Control of Incoming Payment Distribution	*
78	AUTHORITYGROUP	BEGRU	BEGRU	CHAR	4	0	Authorization Group
79	RESTR_DRAW	VVSVERFU	VVSVERFU	NUMC	2	0	Type of Restraint on Drawing	*
80	SEC_TYPE	VVSTITART	VVSTITART	NUMC	2	0	Borrower's Note Loan Security Type	*
81	NO_ASSIG	VVNABTRV	CHAR15	CHAR	15	0	Contract of assignment number
82	GUARAN_NO	VVNAVAL	CHAR15	CHAR	15	0	Guarantee number
83	ASSIGN_ON	VVDABTR	DATUM	DATS	8	0	Date of assignment
84	DISPUNTIL	VVDVERFU	DATUM	DATS	8	0	Date of restraint on disposal upto
85	SRETRA	VVSFGBEW	VVSFGBEW	NUMC	2	0	Transaction data to be released available
86	PMNTPER	VVDLESOZ	DATUM	DATS	8	0	Date of last special interest payment period
87	PORTFOLIO	RPORTB	RPORTB	CHAR	10	0	Portfolio	*
88	SALESRGN	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	*
89	BRA_OFF	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	*
90	PROC_ID	VVSBEA	VVSBEA	NUMC	2	0	Loan Processing Indicator
91	ORG_DISTR	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
92	DISTRICT	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
93	SPLITTING	VVSPLIT	XFELD	CHAR	1	0	Debit position splitting
94	N_GUAR_CAP	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
95	REF_INT	VVSREFZINS	XFELD	CHAR	1	0	Loan With Reference Interest Rate
96	MANDUNNLVL	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	*
97	SIHERK	CHAR2	CHAR2	CHAR	2	0	Version Number Component
98	RGENUM	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
99	LOANREDEEM	VVDRUECK	DATUM	DATS	8	0	Date when loan will probably be redeemed
100	DACC_DEF	VVSABGRD	VVSABGRD	CHAR	1	0	Loan Discount Accrual/Deferral Method
101	FIXED	VVFESTKZ	VVFESTKZ	CHAR	1	0	Indicator for Control of Fixed Contract
102	RATING	BP_RATING	BP_RATING	CHAR	3	0	Rating	*
103	SRATAGEN	SRATAGEN_NEW	BU_PARTNER	CHAR	10	0	Rating agency	*
104	PARTNER	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
105	OBJNR	CHAR22	CHAR22	CHAR	22	0	Text string 22 characters
106	MBORRCUSNO	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	*
107	SKWG14_NEW	VVSKWG14	VVSKWG14	CHAR	2	0	Position grouping acc. Para 14 GBA (Sec. and loans)
108	MASTER_NO	RANLSTAMNR	RANL	CHAR	13	0	Master number part of loan number for finding contracts
109	MIG_DATE	MIGDATE	DATUM	DATS	8	0	Migration date
110	DUNN_PER	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
111	NO_DUNNING	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
112	ASSIGNMENT	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
113	INTERNAL_REFERENCE	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
114	CHARACTERISTICS	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
115	POST_DUNN	SDUNCHARG	XFELD	CHAR	1	0	Post Dunning Charges and Interest to this Contract
116	CURR_B_EUR	SWHRORG	WAERS	CUKY	5	0	Loan currency before conversion to EURO	*
117	CURR_B_EUR_ISO	ISOCD	ISOCD	CHAR	3	0	ISO currency code
118	CONV_DATE	DCONVERT	DATE	DATS	8	0	Date loan was converted to EURO
119	ADJ_DATE	DCORRECT	DATE	DATS	8	0	Date for adjustment flows resulting from EURO conversion
120	ASS_LIA	VVSAKTPAS	VVSAKTPAS	CHAR	1	0	Indicator: Asset/Liability Transaction
121	REGULIERER	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*
122	BUS_AREA	GSBER	GSBER	CHAR	4	0	Business Area	*
123	PO_BLOCK	TB_JNOREPAY	XFELD	CHAR	1	0	Payoff Lock
124	IPD_BLOCK	TB_JNODOIP	XFELD	CHAR	1	0	Blocked by Payoff: No Open Item Clearing for Loan
125	GENVALNCL	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	*
126	INT_LEVEL	VVSINTEB	INTEB	NUMC	2	0	Financial Assets Management internal level	*
127	DO_NOT_ARC	TB_SARC_EXCL	T_SARC_EXCL	CHAR	1	0	Documents For The Loan May Not Be Archived
128	ARCH_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	OPEN_DATE	TB_DOPEN	DATUM	DATS	8	0	Opening Date of a Loan Contract
131	CLOSE_DATE	TB_DCLOSE	DATUM	DATS	8	0	Closing Date of a Loan Contract
132	DUNN_BLOCK_TILL	TB_VIEW_DATE_DUNNING_BLOCK_TIL	DATUM	DATS	8	0	Expiration Date of Dunning Lock
133	NO_INT_ARS	TB_XNOIOA	CHAR1	CHAR	1	0	Lock for Interest on Arrears
134	LK_IOA_TO	TB_NOIOA_TILL	DATUM	DATS	8	0	Expiry Date of Lock on Interest on Arrears
135	ORIGIN	TB_ORIGIN	T_ORIGIN	CHAR	2	0	Loan Origin	*
136	DCALLEND	TB_DCALLEND	DATUM	DATS	8	0	Provision Expiry Date
137	CAPANTSTAT	TB_LC_CHARAC_CAPITALS	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Capital Amounts	*
138	DISB_STAT	TB_LC_CHARAC_DISBURSEMENT	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Disbursement Status	*
139	LC_PLANNED_FLOW	TB_LC_CHARAC_PLANNED_FLOW	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Planned Records	*
140	LC_DEBIT	TB_LC_CHARAC_DEBIT	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Customer Receivables	*
141	LC_CREDIT	TB_LC_CHARAC_CREDIT	T_LC_CHARACVALUE	CHAR	1	0	Processing Characteristic: Status of Customer Payables	*
142	LC_STATUS	TB_LC_STATUS	T_LC_STATUS	CHAR	1	0	Status of Processing Characteristics for Loan