SAP ABAP Table JBTLOBEWEG (Loans (Flow 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	JBTLOBEWEG	Table Relationship Diagram
Short Description	Loans (Flow 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	MANDT	MANDT	MANDT	CLNT	3	0	Client	*
2	DTRANS	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
3	TTRANS	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
4	NTRANS	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
5	RBELKPFD	RBELKPFD	RBELKPFD	CHAR	10	0	Document Number of Document Header (Loan)
6	RLDEPO	RLDEPO	RLDEPO	CHAR	10	0	Securities Account	*
7	DVORGANG	DVORGANG	DATUM	DATS	8	0	Activity date
8	SVORGANG	RVORGANG	RVORGANG	CHAR	8	0	Securities-Activity
9	NVORGANG	NVORGANG	CHAR3	CHAR	3	0	Activity number
10	SBEWART	SBEWART	SBEWART	CHAR	4	0	Flow Type	*
11	SREFBEW	SREFBEW	SBEWART	CHAR	4	0	Reference flow type	*
12	SSOLHAB	VVSSOLHAB	VVSSOLHAB	CHAR	1	0	Debit/credit indicator
13	RERF	RERF	SYCHAR12	CHAR	12	0	Entered by
14	DERF	DERF	DATUM	DATS	8	0	First Entered on
15	TERF	TERF	TIMES	TIMS	6	0	Time of Initial Entry
16	REHER	REHER	CHAR10	CHAR	10	0	Source of initial entry
17	RBEAR	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
18	DBEAR	DBEAR	DATUM	DATS	8	0	Last Edited on
19	TBEAR	TBEAR	TIMES	TIMS	6	0	Last Edited at
20	RBHER	RBHER	CHAR10	CHAR	10	0	Editing Source
21	RREFKONT	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	*
22	RANL	RANL	RANL	CHAR	13	0	Contract Number
23	SSTATI	SSTATI	STATI	NUMC	2	0	Status of data record	*
24	INTEB	VVSINTEB	INTEB	NUMC	2	0	Financial Assets Management internal level	*
25	SSTORNO	SSTORNO	SSTORNO	CHAR	1	0	Reversal indicator
26	SSTOGRD	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	*
27	RSTBLG	STBLG	BELNR	CHAR	10	0	Reverse Document Number
28	RVORGANG	RVORGANG	RVORGANG	CHAR	8	0	Securities-Activity
29	SBEWZITI	SBEWZITI	SBEWZITI	CHAR	4	0	Flow category	*
30	SAEND	TFM_SAEND	TFM_SAEND	NUMC	1	0	Change Indicator for FiMa Flow Records
31	SPLANIST	SPLANIST	SPLANIST	CHAR	1	0	Plan/actual record/record to be released indicator
32	SWOHER	SWOHER	CHAR1	CHAR	1	0	Source of flow record
33	SABGRENZ	VVSABGRENZ	VVSABGRENZ	NUMC	1	0	Accrual/deferral method
34	SFDLEV	FDLEV	FDLEV	CHAR	2	0	Planning Level	*
35	JFDUPD	JFDUPD	JANEI	CHAR	1	0	Record transferred to cash management and forecast
36	SSORTZIT	SSORTZIT	CHAR1	CHAR	1	0	Sort indicator for interest/repayment schedule calculations
37	NFOLGE	NFOLGE	VVNFOLGE	NUMC	4	0	Display sequence of condition types within the group
38	JZINSBAS	JZINSBAS	JANEI	CHAR	1	0	Flow in interest base
39	JZINSZPT	JZINSZPT	JANEI	CHAR	1	0	Interest date
40	JONLAEN	JONLAEN	VVSONLAEN	CHAR	1	0	Indicator for fixing a flow record
41	JONLBUC	JONLBUC	CHAR1	CHAR	1	0	Online posting flag indicator
42	SBWHR	SBWHR	WAERS	CUKY	5	0	Position Currency (Currency of Position Amount)	*
43	BBWHR	BBWHR	WERTV7	CURR	13	2	Amount in position currency
44	SCWHR	SCWHR	WAERS	CUKY	5	0	Settlement Currency	*
45	BCWHR	BCWHR	WERTV7	CURR	13	2	Settlement Amount
46	BHWHR	BHWHR	WERTV7	CURR	13	2	Amount in local currency
47	SNWHR	SNWHR	WAERS	CUKY	5	0	Currency of nominal amount	*
48	BNWHR	BNWHR	WERTV7	CURR	13	2	Nominal amount
49	BBASIS	BBASIS	WERTV7	CURR	13	2	Calculation base amount
50	DBERVON	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
51	SEXCLVON	VVSEXCLVON	VVSEXCLVON	NUMC	1	0	Exclusive Indicator for the Start of a Calculation Period
52	SULTVON	VVSULTVON	VVSULT	CHAR	1	0	Month-End Indicator for Start of a Calculation Period
53	DBERBIS	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
54	SINCLBIS	VVSINCLBIS	VVSINCLBIS	NUMC	1	0	Inclusive Indicator for the End of a Calculation Period
55	SULTBIS	VVSULTBIS	VVSULT	CHAR	1	0	Month-End Indicator for the End of a Calculation Period
56	DFAELL	DFAELL	DATUM	DATS	8	0	Due date
57	SFULT	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
58	DDISPO	DDISPO	DATUM	DATS	8	0	Payment Date
59	DVALUT	DVALUT	DATUM	DATS	8	0	Calculation Date
60	SINCL	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
61	SVULT	VVSVULT	VVSULT	CHAR	1	0	Month-End Indicator for Value Date
62	DVERRECH	VVDVERRECH	DATUM	DATS	8	0	Settlement date
63	SINCLVERR	VVSINCLVER	VVSINCLVER	NUMC	1	0	Inclusive Indicator for Clearing Date
64	SULTVERR	VVSULTVERR	VVSULT	CHAR	1	0	Month-End Indicator for Clearing Date
65	ATAGE	VVATAGE	INT6	NUMC	6	0	Number of days
66	ABASTAGE	ABASTAGE	INT6	NUMC	6	0	Number of base days in a calculation period
67	APERTAGE	VVAPERTAGE	INT6	NUMC	6	0	No. of days of a (calculation) period in cash flow
68	STGMETH	VVSTGMETH	VVSTGMETH	NUMC	1	0	Daily Method
69	STGBASIS	VVSTGBASIS	VVSTGBASIS	CHAR	1	0	Base Days Method
70	SZBMETH	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
71	PKOND	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
72	DPKOND	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
73	DBPERIOD	VVDBPERIOD	DATUM	DATS	8	0	Period start
74	SPAEXCL	TFMSPAEXCL	TFMSPAEXCL	NUMC	1	0	Exclusive Indicator for Start Date of a Period
75	SPAULT	TFMSPAULT	VVSULT	CHAR	1	0	Month-End Indicator for Start Date of a Period
76	DEPERIOD	VVDEPERIOD	DATUM	DATS	8	0	Period End
77	SPEINCL	TFMSPEINCL	TFMSPEINCL	NUMC	1	0	Inclusive Indicator for End Date of a Period
78	SPEULT	TFMSPEULT	VVSULT	CHAR	1	0	Month-End Indicator for End of a Period
79	SWHRKOND	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	*
80	BKOND	BKOND	WERTV7	CURR	13	2	Condition item currency amount
81	MWSKZ	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
82	BMWST	BMWST	WRTV7	CURR	13	2	Value-added tax amount included
83	SBASIS	SBASIS	VVSBASIS	CHAR	4	0	Calculation base indicator	*
84	JSOFVERR	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
85	BSALDO	BSALDO	WERTV7	CURR	13	2	Remaining Balance of a Contract (Account)
86	BTIKALK	TFMBTIKALK	TFM_WRTV7	CURR	13	2	Imputed annuity repayment amount (FiMa internal)
87	BKARZINS	TFMBKAZINS	TFM_WRTV7	CURR	13	2	Int.for days betw. redemption clear.and pmnt (FiMa-internal)
88	BFRATE	BBWHR	WERTV7	CURR	13	2	Amount in position currency
89	AMMRHY	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
90	ATTRHY	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
91	XBEWART	XBEWART	TEXT30	CHAR	30	0	Name of flow type
92	JGESUCHT	VVJGESUCHT	CHAR1	CHAR	1	0	Int. indicator for alternative calculations
93	ASTUECK	ASTUECK	ASTUECK	DEC	15	5	Number of units for unit-quoted securities
94	BWKURS	BWKURS	BWKURS	CURR	13	2	Security price for unit quotation
95	SSWHR	VVSSWHR	WAERS	CUKY	5	0	Stock price currency	*
96	PWKURS	PWKURS	PWKURS	DEC	10	7	Security price for percentage quotation
97	BSWHR	VVBSWHR	WERTV7	CURR	13	2	Market value
98	KWKURS	VVKWKURS	VVKWKURS	DEC	15	6	Security price
99	SRUNIT	VVSRUNIT	VVSRUNIT	CHAR	5	0	Currency unit	*
100	SSTCKKZ	SSTCKKZ	SSTCKKZ	CHAR	1	0	Accrued interest method
101	SSTCKTG	SSTCKTG	SZBMETH	CHAR	1	0	Accrued interest: Daily method
102	PEFFZINS	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
103	SEFFMETH	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
104	KURS1	KURSF	KURSF	DEC	9	5	Exchange rate
105	KURS2	KURSF	KURSF	DEC	9	5	Exchange rate
106	DBESTAND	DBESTAND	DATUM	DATS	8	0	Position value date
107	DBEST6B	DBEST6B	DATUM	DATS	8	0	Date for §6b EstG relevant postings
108	DORDER	DORDER	DATUM	DATS	8	0	Order day
109	NORDER	NORDER	NUM8	NUMC	8	0	Order Number
110	NORDEXT	NORDEXT	CHAR20	CHAR	20	0	External order number
111	SSPESEN	SSPESEN	SSPESEN	CHAR	1	0	Expenses key
112	SLIMIT	SLIMIT	SLIMIT	CHAR	1	0	Order notation
113	BLIMIT	BLIMIT	BWKURS	CURR	13	2	Limit price for unit quotation
114	PLIMIT	PLIMIT	PWKURS	DEC	10	7	Limit price for percentage quotation
115	RSOLL	RSOLL	SAKNR	CHAR	10	0	Account for debit posting	*
116	RHABEN	RHABEN	SAKNR	CHAR	10	0	Account for credit posting	*
117	RBANKK	RBANKK	SAKNR	CHAR	10	0	Bank account	*
118	RZKSOLL	RZKSOLL	SAKNR	CHAR	10	0	Debit interim account	*
119	RZKHABE	RZKHABE	SAKNR	CHAR	10	0	Credit interim account	*
120	RVERMIT	RVERMIT_NEW	BU_PARTNER	CHAR	10	0	Agent partner ID	*
121	RKONTRA	RVERMIT_NEW	BU_PARTNER	CHAR	10	0	Agent partner ID	*
122	SROLEXTKO	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role	*
123	XZUSATZ	XZUSATZ	CHAR18	CHAR	18	0	Assignment
124	BVTYP	BVTYP	BVTYP	CHAR	4	0	Partner bank type
125	SPARTNR	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
126	SZEGEN	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	*
127	ZLSCH	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
128	SREQU0	SREQUEST	JANEI	CHAR	1	0	Request
129	SREQU1	SREQUEST	JANEI	CHAR	1	0	Request
130	SREQU2	SREQUEST	JANEI	CHAR	1	0	Request
131	SCRWHR1	WAERS	WAERS	CUKY	5	0	Currency Key	*
132	SCRWHR2	WAERS	WAERS	CUKY	5	0	Currency Key	*
133	KCROSS	KURSF	KURSF	DEC	9	5	Exchange rate
134	SBSLSOLL	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
135	SBSLHABEN	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
136	SBSLZKSO	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
137	SBSLZKHA	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
138	SWHRT	SWHRT	SWHRT	CHAR	1	0	Currency swap indicator
139	DANST	DANST	DATUM	DATS	8	0	Reservation date
140	TANST	TANST	TIMES	TIMS	6	0	Order time of day
141	SANST	SANST	SANST	CHAR	2	0	Reservation reason	*
142	RDEALER	RDEALER	RDEALER	CHAR	12	0	Trader	*
143	KOSTL	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
144	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
145	RBELNR	RBELKPF	RBELKPF	CHAR	10	0	Number of flow header	*
146	KUNNR	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
147	MABER	MABER	MABER	CHAR	2	0	Dunning Area	*
148	RZBANK	VVRZBANK_NEW	BU_PARTNER	CHAR	10	0	Paying Bank	*
149	SROLEXTZB	DUMMY_3	CHAR3	CHAR	3	0	Dummy function
150	JVERK6B	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
151	RPNNR	VVRPNNR	VVRPNNR	CHAR	10	0	Daybook no.
152	JEINBEHALT	VVJEINBE	KENZX	CHAR	1	0	Indicator for withholding of amount during disbursement
153	HBKID	HBKID	HBKID	CHAR	5	0	Short key for a house bank	*
154	SGTXT	SGTXT	TEXT50	CHAR	50	0	Item Text
155	SBUST	VVSBUST	VVSBUST	NUMC	2	0	Posting control key
156	DSTOCK	VVDSTOCK	DATUM	DATS	8	0	Premium reserve fund date
157	DBUDAT	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
158	JVERF	JVERF	JVERF	CHAR	1	0	Indicator whether drawings exist for the disbursement
159	ZAHLS	DZAHLS	ZAHLS	CHAR	1	0	Block Key for Payment	*
160	SBERFIMA	SBEWFIMA	SBEWFIMA	CHAR	4	0	Calculation category for cash flow calculator	*
161	SBUCHA	VVSBUCHA	CHAR1	CHAR	1	0	Indicator for postings to accruals/deferrals accounts
162	SREFZITI	VVSREFZITI	SBEWZITI	CHAR	4	0	Refer.flow category in accrual/deferral flow records	*
163	JVORAUS	VVJVORAUS	KENZX	CHAR	1	0	ID for planned record reference to an advance payment
164	RKLAMMER	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
165	ZUONR	DZUONR	ZUONR	CHAR	18	0	Assignment number
166	SCOUPON	VVSCOUPON	VVSCOUPON	CHAR	1	0	Coupon ID for interest and accrued interest calculation
167	DCOUPON	VVDCOUPON	DATUM	DATS	8	0	Coupon date of next delivered coupon
168	SFLAT	VVSFLAT	XFELD	CHAR	1	0	Indicator 'Traded flat',i.e.no accrued interest calculation
169	SKOART	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	*
170	DGUEL_KK	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
171	NLFD_ANG	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
172	DGUEL_KP	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
173	NSTUFE	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
174	.INCLUDE				0	0	Include structure for VZZBEPP for new securities fields
175	RHANDPL	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	*
176	SFIXRATE2	VVSFIXRATE	XFELD	CHAR	1	0	Fixed exchange rate
177	SFIXRATE1	VVSFIXRATE	XFELD	CHAR	1	0	Fixed exchange rate
178	NEVAL	NUM4	NUM04	NUMC	4	0	Four-digit number
179	RPOSNR	NVORGANG	CHAR3	CHAR	3	0	Activity number
180	SEVALPOST	SEVALPOST	XFELD	CHAR	1	0	PEC for flow executed indicator yes/no
181	SHERKUNFT	VVSHERK	VVSHERK	CHAR	1	0	Origin indicator: 'From planned record/actual record'
182	UMSKZ	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
183	BUKRS	BUKRS	BUKRS	CHAR	4	0	Company Code	*
184	SVORGKZ	VVSVORGKZ	VVSVORGKZ	NUMC	2	0	Activity indicator for debit/credit control
185	ZINKZ	DZINKZ	ZINKZ	CHAR	2	0	Exempted from Interest Calculation
186	SSALBAS	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
187	MANSP	MANSP	MANSP	CHAR	1	0	Dunning block	*
188	RKONT	RKONT	RKONT	NUMC	6	0	Quota number
189	DAUSZ	VVDAUSZ	DATUM	DATS	8	0	Lead date for withholding amounts for disbursement
190	DTRANSREF	VVDTRANS	DATUM	DATS	8	0	Flow data key: System date
191	TTRANSREF	VVTTRANS	UZEIT	TIMS	6	0	Transaction data key: system time
192	NTRANSREF	VVNTRANS	NUMC4	NUMC	4	0	Transaction data key: Consecutive number
193	SSOLIST	SSOLIST	CHAR1	CHAR	1	0	Calculation using actual principle (or debit)
194	RDARNEHM	RDARNEHM_NEW	BU_PARTNER	CHAR	10	0	Borrower/Applicant Number	*
195	KBKOND	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
196	RZEBEL	RZEBEL	RBELKPFD	CHAR	10	0	Doc.no. of debit pos. doc.header (only for inc.pmnt records)
197	RAHABKI	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank	*
198	RAHKTID	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account	*
199	RPBANK	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
200	SZART	TB_SZART	XFELD	CHAR	1	0	Payment transaction
201	RBELNRFI	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
202	RBELNRFI2	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
203	DZFEST	TB_DZFEST	DATUM	DATS	8	0	Interest rate fixing date
204	DSCHLUSS	VVDSCHLUSS	DATUM	DATS	8	0	Date of business closing
205	TSCHLUSS	VVTSCHLUSS	UZEIT	TIMS	6	0	Time of business closing
206	ZFBDT	DDISPO	DATUM	DATS	8	0	Payment Date
207	PEFFZCALL	PEFFZINS	DEC3_7	DEC	10	7	Effective Interest Rate
208	REFRLDEPO	VVREFRLDEP	RLDEPO	CHAR	10	0	Reference sec.acct for sec.acct transfer (inflow/outflow)	*
209	HDN_KUNNR	HDN_KUNNR	KUNNR	CHAR	10	0	Main Borrower Customer Number	*
210	RUZBEL	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
211	REBZJ	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
212	REBZG	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
213	REBZZ	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
214	RPARTNR	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
215	S_SSDREF	VVS_SSDREF	SBEWZITI	CHAR	4	0	Reference flow category in borrower's note loan flow records	*
216	KGV_FLAG	TKGV	TKGV	CHAR	1	0	Manages status of the related price gains/losses flows
217	OBJNR	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
218	DEVALPOST	DEVALPOST	DATUM	DATS	8	0	Date of period-end closing
219	ZUOND	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
220	REFER	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
221	MERKM	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
222	SPAYRQ	TB_SPAYRQK	XFELD	CHAR	1	0	Generate payment request
223	SPRSNG	TB_SPRSNGK	XFELD	CHAR	1	0	Individual payment
224	PRKEY	PRQ_KEYNO	PRQ_KEYNO	CHAR	10	0	Key Number for Payment Request	*
225	XPORE	PRQ_XPORE	XFELD	CHAR	1	0	Indicator: Individual Payment?
226	HKTID	HKTID	HKTID	CHAR	5	0	ID for account details	*
227	RPZAHL	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	*