SAP ABAP Table JBIUDA1 (TR: EDT 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	JBIUDA1	Table Relationship Diagram
Short Description	TR: EDT 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	STYPE	☐	STYPEDARL	STYPEDARL	CHAR	1	0	Record Category for TR-EDI: Loans
4	SFEMODE	☐	TRUBMODE	TRUBMODE	CHAR	1	0	Transfer mode
5	ROLE	☐	TB_ROLE_CORR	T_ROLE_CORR	CHAR	4	0	CML Correspondence Role Type of Recipient	TDPZ6
6	ROLETYP	☐	BU_PARTNERROLE	BU_ROLE	CHAR	6	0	BP Role	TB003
7	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
8	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
9	SSTATI	☐	SSTATI	STATI	NUMC	2	0	Status of data record	TZC37
10	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	TZPAB
11	RREFKONT	☐	RREFKONT	USTRU	CHAR	8	0	Account Assignment Reference in Financial Assets Management	T037S
12	STITEL	☐	STITEL	STITEL	NUMC	3	0	Loan Type Indicator	TD03
13	SGLZB	☐	SGLZB	SGLZB	CHAR	4	0	SCB asset group indicator	TW07
14	SFIBG	☐	SFIBG	SFIBG	NUMC	4	0	Asset Grouping Indicator	TW08
15	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	TW11
16	XAKT	☐	XAKT	CHAR32	CHAR	32	0	File Number
17	SGR1	☐	SGRP1	SGRP1	CHAR	6	0	Group Key 1 (Freely Available)	TDDG1
18	SGR2	☐	SGRP2	SGRP2	CHAR	6	0	Group Key 2 (Freely Available)	TDDG2
19	SSOLIST	☐	VVSSOLIST	VVSSOLIST	CHAR	1	0	Plan/Actual principle
20	SFRIST	☐	SFRIST	SFRIST	NUMC	2	0	Loan Term	TD09
21	BANTRAG	☐	UB_BANTRAG	NUM13	NUMC	13	0	Capital applied for
22	N_BANTRAG	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
23	SANTWHR	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
24	DANTRAG	☐	DANTRAG	DATUM	DATS	8	0	Entry Date of Loan Application
25	BZUSAGE	☐	UB_BZUSAGE	NUM13	NUMC	13	0	Commitment capital
26	N_BZUSAGE	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
27	BNBUERG	☐	VVUBBUERG	NUM13	NUMC	13	0	Initial capital not guaranteed
28	N_BNBUERG	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
29	DZUSAGE	☐	DZUSAGE	DATUM	DATS	8	0	Loan - Date of Commitment by Lender
30	DBLFZ	☐	DBLFZ	DATUM	DATS	8	0	Start of Term
31	DELFZ	☐	DENDLFZ	DATUM	DATS	8	0	End of Loan Term
32	SSICHER	☐	SSICHER	SSICH	CHAR	4	0	Primary collateral	TD01
33	SVZWECK	☐	SVZWECK	SVZWK	CHAR	2	0	Purpose of Loan	TD07
34	SSONDER	☐	SSONDER	SSONDER	NUMC	2	0	Special treatment of loan	TD10
35	SFIWO	☐	SFIWO	SFIWO	CHAR	2	0	Indicator: Type of Residential Object Financing	TD15
36	SHOME	☐	SHOME	SHOME	NUMC	3	0	Home statement	TD11
37	SLAENDER	☐	SLAENDER	LAND1	CHAR	3	0	Country ID	T005
38	SKWG14_NEU	☐	VVSKWG14	VVSKWG14	CHAR	2	0	Position grouping acc. Para 14 GBA (Sec. and loans)
39	JORIG	☐	BUCHSYS	BUCHSYS	NUMC	1	0	Posting system indicator for borrower's note loans
40	VVSLOEKZ	☐	VVSLOEKZ	VVSLOEKZ	NUMC	1	0	Deletion indicator
41	SDTYP	☐	VVSDTYP	VVSDTYP	NUMC	3	0	Loans Class	TD02
42	DBEWI	☐	VVDBEWI	DATUM	DATS	8	0	Approval date
43	AABTRET	☐	AABTRET	NUM02	NUMC	2	0	Number of Assignments Still Possible
44	BABTRET	☐	UBABTRET	NUMC13	NUMC	13	0	Minimum amount for assignments
45	N_BABTRET	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
46	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
47	SABT	☐	VVSABT	VVSABT	CHAR	4	0	Assignee	TDS1
48	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
49	SONDST	☐	VVSONDST	VVSONDST	CHAR	2	0	Special posting treatment	TD14
50	SGRP3	☐	SGRP3	SGRP3	CHAR	6	0	Group Key 3 (Freely Available)	TDDG3
51	SGRP4	☐	SGRP4	SGRP4	CHAR	6	0	Group Key 4 (Freely Available)	TDDG4
52	SZKEY	☐	VVSZKEY	VVSZKEY	NUMC	2	0	Indicator for Control of Incoming Payment Distribution	TVZ01
53	SVERFU	☐	VVSVERFU	VVSVERFU	NUMC	2	0	Type of Restraint on Drawing	TZV05
54	STITART	☐	VVSTITART	VVSTITART	NUMC	2	0	Borrower's Note Loan Security Type	TD16
55	NAVAL	☐	VVNAVAL	CHAR15	CHAR	15	0	Guarantee number
56	DVERFU	☐	VVDVERFU	DATUM	DATS	8	0	Date of restraint on disposal upto
57	RPORTB	☐	RPORTB	RPORTB	CHAR	10	0	Portfolio	TWPOB
58	SREGION	☐	VVSREGION	VVSREGION	CHAR	4	0	Sales Region	TD18
59	SGESST	☐	VVSGESST	VVSGESST	CHAR	4	0	Branch Office	TD17
60	SMAHNM	☐	VVSMAHNM	VVSMAHNM	CHAR	1	0	Loan Manual Dunning Level	*
61	SABGRENZ	☐	VVSABGRD	VVSABGRD	CHAR	1	0	Loan Discount Accrual/Deferral Method
62	SFEST	☐	VVFESTKZ	VVFESTKZ	CHAR	1	0	Indicator for Control of Fixed Contract
63	RDARNEHM	☐	RDARNEHM_NEW	BU_PARTNER	CHAR	10	0	Borrower/Applicant Number	*
64	SKWGDAR	☐	SKWGDAR	SKWGDAR	NUMC	1	0	Credit type indicator for Austrian reporting	TZ34
65	SKWGKRED	☐	SKWGKRED	SKWGKRED	NUMC	1	0	Credit category indicator Para. 75 report (Austria)	TZ35
66	DGUEL_KK	☐	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
67	STILGRHY	☐	STILGRHY	SRHYT	NUMC	2	0	Payment cycle
68	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
69	SDISEIN	☐	SDISEIN	SDISEIN	CHAR	1	0	Type of Discount Withholding
70	KZAHLUNG	☐	UB_KZAHLUNG	NUM10	NUMC	10	0	Pay-in/disbursement rate
71	N_KZAHLUNG	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
72	BZAHLUNG	☐	UB_BZAHLUNG	NUM13	NUMC	13	0	Pay-in/disbursement amount
73	N_BZAHLUNG	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
74	SWHRZHLG	☐	UB_SWHRZHLG	CHAR5	CHAR	5	0	Currency of payment amount
75	SWHRZUSA	☐	UB_SWHRZUSA	CHAR5	CHAR	5	0	Currency of commitment amount
76	SEFFMETH	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
77	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
78	SDISKO	☐	SDISKO	SDISKO	CHAR	1	0	Discounted
79	DKUEND	☐	DKUEND	DATUM	DATS	8	0	Date of notice
80	SKUEND	☐	SKUEND	SKUEART	NUMC	3	0	Reason for Notice	TD04
81	DKUENDDG	☐	DKUENDDG	DATUM	DATS	8	0	Earliest Possible Date for Notice Given by the Lender
82	DRESAM	☐	DRESAM	DATUM	DATS	8	0	Reservation of Conditions On
83	DRESBIS	☐	DRESBIS	DATUM	DATS	8	0	Reservation of Conditions Until
84	DANGAM	☐	DANGAM	DATUM	DATS	8	0	Offer creation date
85	DANGBIS	☐	DANGBIS	DATUM	DATS	8	0	Offer Effective To
86	SANGVOR	☐	SANGVOR	SANGVOR	NUMC	2	0	Offer/Acceptance Reservation Indicator	*
87	JANNAHME	☐	JANNAHME	JANEI	CHAR	1	0	Offer Acceptance Indicator
88	SANNAHME	☐	SANNAHME	SKONTAKT	NUMC	2	0	Type of offer acceptance indicator	TD13
89	DANNAHME	☐	DANNAHME	DATUM	DATS	8	0	Date of acceptance of offer
90	JVERTRAG	☐	JVERTRAG	JANEI	CHAR	1	0	Indicator: Contract Created?
91	DVERTRAM	☐	DVERTRAM	DATUM	DATS	8	0	Contract creation date
92	DVERTBIS	☐	DVERTBIS	DATUM	DATS	8	0	Return contract by
93	SEFFM2	☐	SEFFMETH	SEFFMETH	NUMC	1	0	Effective Interest Method (Financial Mathematics)
94	SKUEGL	☐	VVSKUEGL	VVSKUEGL	NUMC	3	0	Notice Arrangement Lender	TD28
95	DEFSZ	☐	VVDEFSZ	DATUM	DATS	8	0	Date of fixed period end
96	DGES	☐	VVDGES	DATUM	DATS	8	0	Earliest Notice Date in acc. with the Legal Right of Notice
97	SGESAUS	☐	VVSGESAUS	XFELD	CHAR	1	0	Legal Right of Notice Excluded
98	SZKZ	☐	VVSZKZ	VVSZKZ	CHAR	1	0	Special int. ID for int. on arrears for remaining balance	TDSOZ
99	NANGEBOT	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
100	SINCL	☐	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
101	ZVRHYEFF	☐	VVZVRHYEFF	NUMC03	NUMC	3	0	Int.sttlmnt frequency for effective int.rate calc.in months
102	PVGLEFFZ	☐	UBPVGLEFFZ	NUM10	NUMC	10	0	Comparative effective interest
103	N_PVGLEFFZ	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
104	SULTEFSZ	☐	VVSULTEFSZ	VVSULT	CHAR	1	0	Month-end indicator for end of fixed period
105	DABEFFZ	☐	VVDABEFFZ	DATUM	DATS	8	0	Date when calculation of effective rate starts
106	DKUENDDN	☐	VVDKUENDDN	DATUM	DATS	8	0	Earliest Possible Date for Notice Given by the Borrower
107	SKUEDN	☐	VVSKUEDN	VVSKUEDN	NUMC	3	0	Notice Arrangement Borrower	TD29
108	SKUEART	☐	VVSKUEART	VVSKUEART	NUMC	3	0	Notice Type for the Loan	TD27
109	DMARKTZINS	☐	DMARKTZINS	DATS	DATS	8	0	ISB: Market Rate Date: Market Interest Rate for NPV Calc.
110	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
111	DGUEL_KP	☐	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
112	NSTUFE	☐	NSTUFE	NUMC2	NUMC	2	0	Level number of condition item for recurring payments
113	PKOND	☐	UB_PKOND	NUM10	NUMC	10	0	Percentage rate for condition items
114	N_PKOND	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
115	BKOND	☐	UB_BKOND	NUM13	NUMC	13	0	Condition Item Currency Amount
116	N_BKOND	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
117	PEFFZINS	☐	UBPEFFZINS	NUM10	NUMC	10	0	Effective Interest Rate
118	N_PEFFZINS	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
119	SWHRKOND	☐	UB_SWHRKOND	CHAR5	CHAR	5	0	Currency of Condition Item
120	SBASIS	☐	VVSBASIS	VVSBASIS	CHAR	4	0	Calculation base reference	TZFB
121	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
122	SZSREFVZ	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
123	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
124	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
125	SZAWS	☐	SZAWS	SZAHLDIV	NUMC	1	0	Payment form (at start of period, mid-period, at period end)
126	RDIVNR	☐	RDIVNR	NUM03	NUMC	3	0	Dividend coupon number
127	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
128	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
129	JBMONAT	☐	JBMONAT	JANEI	CHAR	1	0	Indicator for calculating amount per month
130	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
131	AVGSTAGEVZ	☐	AVGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for value date
132	AFGSTAGEVZ	☐	AFGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for due date
133	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
134	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
135	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
136	RKONT	☐	RKONT	RKONT	NUMC	6	0	Quota number
137	SVULT	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
138	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
139	AVGSTAGE	☐	AVGSTAGE	NUMC2	NUMC	2	0	Number of working days for value date
140	AFGSTAGE	☐	AFGSTAGE	NUMC2	NUMC	2	0	Number of working days to due date
141	SVKALZUS	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
142	SFKALZUS	☐	VVSNVER1	CHAR1	CHAR	1	0	Field is no longer used
143	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
144	JSOFVERR	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
145	DALLGEM	☐	DALLGEM	DATUM	DATS	8	0	General date
146	SZEGEN	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	TD21
147	SBUST	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key	TZB09
148	SKOPO	☐	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items	TZK07
149	SALTKOND	☐	VVSALTKOND	SKONDGRP	NUMC	4	0	Bracket condition for alternative conditions
150	SZINSANP	☐	VVSZINSANP	SKONDGRP	NUMC	4	0	Cross-referenced condition grp for interest rate adjustment
151	SFORMREF	☐	VVSFORMREF	T_FORMBE	CHAR	4	0	Formula reference for the cash flow calculator	AT30
152	SVARNAME	☐	VVSVARNAME	T_XFELD04	CHAR	4	0	Description of variables in cash flow calculator
153	SVWERK	☐	VVSVWERK	T_SWERK	NUMC	1	0	Shift calculation date to working day
154	SVMETH	☐	VVSVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
155	SFWERK	☐	VVSFWERK	T_SWERK	NUMC	1	0	Shift due date to working day
156	SFMETH	☐	VVSFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
157	DPKOND	☐	VVDPKOND	DATUM	DATS	8	0	Determination date for percentage rate of condition items
158	AZGSTAGE	☐	AZGSTAGE	NUMC2	NUMC	2	0	Number of working days for interest fixing
159	SZKALRI	☐	SZKALRI	SKALRI	CHAR	1	0	Calendar direction for interest rate fixing
160	DZSREF	☐	VVDZSREF	DATUM	DATS	8	0	Date fixing for benchmark interest rate in cash flow
161	SKALID2	☐	VVSKALID2	WFCID	CHAR	2	0	Calendar ID 2 (valid in connection with calendar ID 1)	TFACD
162	JGESUCHT	☐	VVJGESUCHT	CHAR1	CHAR	1	0	Int. indicator for alternative calculations
163	KURS1	☐	UB_KURSF	KURSC	NUMC	9	0	Exchange rate
164	N_KURS1	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
165	BBASIS	☐	UB_BBASIS	NUM13	NUMC	13	0	Calculation base for conditions
166	N_BBASIS	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
167	SZWERK	☐	VVSZWERK	T_SWERK	NUMC	1	0	Shift to working day for interest fixing date
168	SFINCL	☐	VVSFINCL	VVSINCL	NUMC	1	0	Inclusive Indicator for Due Date
169	SRUNDVORF	☐	VVSRUNDVF	TFMSRUNDVF	NUMC	1	0	Rounding of interim results for prepayments
170	SZWKEY	☐	VVSZWKEY	VVSZWKEY	CHAR	2	0	Payment form with adjustment days	TDZW
171	SFVMETH	☐	TB_SFVMETH	T_SFVMETH	NUMC	2	0	Update method for calculation date/due date
172	SDWERK	☐	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
173	SBERECH	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
174	JPROZR	☐	TB_JPROZR	XFELD	CHAR	1	0	Percentage Calculation
175	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
176	SFANT	☐	VVSFANT	VVSFANT	NUMC	1	0	Indicator for due date-related FiMa calculations
177	SFRANZ	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
178	KBKOND	☐	UBKBKOND	NUM15	NUMC	15	0	Condition amount independent of currency
179	N_KBKOND	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
180	SBASFIX	☐	TFMSBASFIX	TFMSBASFIX	NUMC	1	0	Indicator for fixing calculation base
181	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
182	ZAHLS	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
183	RSBVER	☐	VVRSBVER_NEW	BU_PARTNER	CHAR	10	0	Loans Contract Clerk	BUT000
184	RSBBH	☐	VVRSBBH_NEW	BU_PARTNER	CHAR	10	0	Loans Clerk in Accounting	BUT000
185	RSBEAR	☐	VVRSPROL_NEW	BU_PARTNER	CHAR	10	0	Clerk Responsible for Rollover of Loan	BUT000
186	JKOPOVORBEL	☐	VVKOPOVORBEL	JANEI	CHAR	1	0	Indicator for Default Setting of Conditions from Customizing
187	COM_VAL_CLASS	☐	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	*
188	STYP1	☐	VVSTYP	VVSTYP	CHAR	1	0	Activity Type	*
189	STYP2	☐	VVSTYP	VVSTYP	CHAR	1	0	Activity Type	*
190	STYP3	☐	VVSTYP	VVSTYP	CHAR	1	0	Activity Type	*
191	NO_KOPO_CHANGE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
192	.INCLUDE	☐				0	0	TR-EDT: Regulatory Reporting
193	JDECK	☐	JDECK	JANEI	CHAR	1	0	Regulatory reporting BPV (hedge fund Y/N)
194	JBAVG	☐	JBAVG	KENZX	CHAR	1	0	BAV approval
195	XAKTZBAV	☐	XAKTZBAV	TEXT32	CHAR	32	0	BAV file number
196	DBAVGEN	☐	DBAVGEN	DATUM	DATS	8	0	Date of BAV authorization
197	SGBAV	☐	SGBAV	SGBAV	NUMC	3	0	BAV asset group (C11/74) indicator	TW06
198	SBAV501	☐	SBAV501	SBAV501	CHAR	4	0	*** Internal usage ***	TW12B
199	JARW	☐	JARW	JANEI	CHAR	1	0	*** Not used ***
200	DARWGEN	☐	DARWGEN	DATUM	DATS	8	0	Date for fixing the accepted value
201	XAKTZARW	☐	XAKTZARW	TEXT20	CHAR	20	0	BAV file character_accepted value
202	XAUFORT	☐	XAUFORT	TEXT22	CHAR	22	0	Storage location
203	DERWMEL	☐	DERWMEL	DATUM	DATS	8	0	Date when the acquistion was reported to FISO
204	SJBUE	☐	VVSJBUE	VVSJBUE	CHAR	6	0	Asset group R11/76, Asset 6 (yearly stock overview)	TZ17
205	SNEU_ANL	☐	VVSNEU_ANL	VVSNEU_ANL	CHAR	9	0	Asset group R11/76, appendix 3 and 4	TZ18
206	XR5_91_1	☐	VVXR5_91_1	VVXR5_91_1	CHAR	2	0	Indicator R5/91, appendix 1
207	XR5_91_2	☐	VVXR5_91_2	KENZX	CHAR	1	0	Indicator R5/91, appendix 1
208	XR5_91_3	☐	VVXR5_91_3	KENZX	CHAR	1	0	Indicator R5/91, appendix 3
209	XTREU	☐	VVXTREU	KENZX	CHAR	1	0	*** Internal usage ***
210	XDECK	☐	VVXDECK	KENZX	CHAR	1	0	Indicator for eligibility for premium reserve fund
211	XARW	☐	VVXARW	KENZX	CHAR	1	0	BAV approval of accepted value
212	SMW102	☐	VVSMW102	VVSMW102	CHAR	5	0	BAV asset group stmt 102	TZ32
213	X_R97_03	☐	VVX_R97_03	VVX_R97_03	CHAR	2	0	Indicator for circular R5/97 appendix 3 and 4	TZ36
214	X_R97_05	☐	VVX_R97_05	VVX_R97_05	CHAR	2	0	Indicator for R5/97 appendix 5	TZ37
215	X_R97_06	☐	VVX_R97_06	VVX_R97_06	CHAR	1	0	Indicator for R5/97 appendix 6 - Collateral
216	X_R97_08	☐	VVX_R97_08	VVX_R97_08	CHAR	1	0	Indicator for R5/97 appendix 8	TZ38
217	X_R97_101	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
218	X_R97_102	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
219	X_R97_103	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
220	X_R97_104	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
221	XTREU1	☐	VVXTREU1	VVXTREU1	CHAR	1	0	Trustee inflow/outflow list indicator
222	DGUEL_AB	☐	DGUEL_AB	DATUM	DATS	8	0	Entry effective from
223	SUDEC	☐	SUDEC	SUDEC	NUMC	2	0	Insurance Line of Business Indicator	TW05
224	SSKZB	☐	SSKZB	SSKZB	NUMC	1	0	BAV stock indicator	TZ11
225	SOEFFKL	☐	SOEFFKL	JANEI	CHAR	1	0	Indicator BAV opening clause
226	RINUM	☐	RINUM	RINUM	CHAR	22	0	BAV identification number
227	SSKZF	☐	SSKZF	SSKZF	NUMC	1	0	Tax office stock indicator	TZ13
228	RINUMH	☐	RINUMH	CHAR30	CHAR	30	0	BAV hist. identifications number
229	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
230	SANLART	☐	VVSANLART	VVSANLART	CHAR	6	0	BAV asset type PRF3 and PRF8	TZ19
231	BARWBAV	☐	UB_BARWBAV	NUM13	NUMC	13	0	BAV accepted value
232	N_BARWBAV	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
233	SAWHR	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
234	BVWERT	☐	UB_BVWERT	NUM13	NUMC	13	0	Market value BAV
235	N_BVWERT	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
236	SVWHR	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
237	BARW_VU	☐	UB_BARW_VU	NUM13	NUMC	13	0	Accepted value VU
238	N_BARW_VU	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
239	SAWHR_VU	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
240	SAART	☐	VVSAART	VVSAART	CHAR	6	0	Asset Type According to Regulatory Accounting Requirements	TZ28
241	SDV	☐	VVSDV	VVSDVNR	CHAR	2	0	Premium reserve fund list number	TZ30
242	SUABT	☐	VVSUABT	VVSUABT	CHAR	2	0	Subsection number of premium reserve fund list	TZ31
243	SMWWHR	☐	UB_WHR	CHAR5	CHAR	5	0	Currency ISO code
244	SNW600	☐	VVSNW600	VVSNW600	CHAR	4	0	Asset group BAV stmt 101, 201 and 600	TZ29P
245	.INCLUDE	☐				0	0	SAPscript: Text Lines
246	TDFORMAT	☐	TDFORMAT	TDELEMSTYL	CHAR	2	0	Tag column
247	TDLINE	☐	TDLINE	TDSTXLLINE	CHAR	132	0	Text Line
248	.INCLUDE	☐				0	0	TR-EDT: Transfer User-Defined Fields
249	SLWID	☐	SLWID	SLWID	CHAR	7	0	Key word ID for user-defined fields	TCN00
250	USR00	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
251	USR01	☐	USRCHAR20	USRCHAR20	CHAR	20	0	User field with 20 characters
252	USR02	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
253	USR03	☐	USRCHAR10	USRCHAR10	CHAR	10	0	User field with 10 characters
254	USR04	☐	NUM13	NUM13	NUMC	13	0	Numerical value, 13 characters long
255	N_USR04	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
256	USE04	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
257	USR05	☐	NUM13	NUM13	NUMC	13	0	Numerical value, 13 characters long
258	N_USR05	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
259	USE05	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
260	USR06	☐	NUM13	NUM13	NUMC	13	0	Numerical value, 13 characters long
261	N_USR06	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
262	USE06	☐	CHAR5	CHAR5	CHAR	5	0	R/2 table
263	USR07	☐	NUM13	NUM13	NUMC	13	0	Numerical value, 13 characters long
264	N_USR07	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
265	USE07	☐	CHAR5	CHAR5	CHAR	5	0	R/2 table
266	USR08	☐	USRDATE	USRDATE	DATS	8	0	User field for date
267	USR09	☐	USRDATE	USRDATE	DATS	8	0	User field for date
268	USR10	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
269	USR11	☐	USRFLAG	FLAG	CHAR	1	0	User-defined field: Indicator for reports
270	.INCLUDE	☐				0	0	TR-EDT: Dunning Control in Loans
271	SDUNNCMP	☐	SDUNNCMP	SDUNNCMP	CHAR	2	0	Summarization Level for Dunning Letter
272	XNODUNN	☐	XNODUNN	XFELD	CHAR	1	0	Exclude Loan from Dunning Run
273	SDUNCHARG	☐	SDUNCHARG	XFELD	CHAR	1	0	Post Dunning Charges and Interest to this Contract
274	SDUNNDOC	☐	SDUNNDOC	SDUNNDOC	CHAR	1	0	Type of Dunning Letter
275	SDUNNBUC	☐	SDUNNBUC	XFELD	CHAR	1	0	Post Dunning Charges and Interest to This Partner
276	ZUOND	☐	TB_ZUOND	TEXT18	CHAR	18	0	Assignment
277	REFER	☐	TB_REFER	CHAR16	CHAR	16	0	Internal Reference
278	MERKM	☐	TB_MERKM	CHAR25	CHAR	25	0	Characteristics
279	.INCLUDE	☐				0	0	Include Print and Transmission Control Data for VDARL
280	DBEGINEKA	☐	DBEGINEKA	CK_DATUM	DATS	8	0	Start date of last external account statement
281	DLASTEKA	☐	DLASTEKA	DATUM	DATS	8	0	Key date of last external account statement
282	DCREATEEKA	☐	DCREATEEKA	CK_DATUM	DATS	8	0	Creation date of last external account statement
283	SRHYEKA	☐	CREARHYEKA	ERSTRHY	NUMC	1	0	Generation frequency of external account statement
284	STMTNREKA	☐	STMTNREKA	NUMC07	NUMC	7	0	Number of last account statement
285	RESTCAPEKA	☐	UB_RESTCAPEKA	NUMC13	NUMC	13	0	Remaining capital at evaluation start of ext. acct statement
286	N_RESTCAPEKA	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
287	DLASTZB	☐	DLASTZB	CK_DATUM	DATS	8	0	Key date of the last interest certificate
288	SPROCZB	☐	SPROCZB	BZVERARB	NUMC	1	0	Processing type of interest certificate
289	RKLAMMER	☐	RKLAMMER	RANL	CHAR	13	0	Classification Number for Finance Projects
290	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
291	RANLALT1	☐	RANLALT1	CHAR13	CHAR	13	0	Alternative Identification
292	RANLALT2	☐	RANLALT2	CHAR13	CHAR	13	0	Alternative identification 2
293	SNICHTAB	☐	SNICHTAB	SNICHTAB	NUMC	2	0	Reason for Non-Acceptance	TDA5
294	HBKID	☐	HBKID	HBKID	CHAR	5	0	Short key for a house bank	T012
295	HKTID	☐	HKTID	HKTID	CHAR	5	0	ID for account details	T012K
296	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
297	DKONS	☐	DKONS	DATUM	DATS	8	0	Syndicate loan date
298	AKONS	☐	VVAKONS	NUM03	NUMC	3	0	Number of syndicate members
299	SOBEZ	☐	VVSOBEZ	CHAR2	CHAR	2	0	Organizational District
300	SBEZIRK	☐	VVSBEZIRK	CHAR4	CHAR	4	0	Agent District
301	SABTRANS	☐	VVSABTRANS	XFELD	CHAR	1	0	Indicator for Possible Foreign Assignment
302	DABTR	☐	VVDABTR	DATUM	DATS	8	0	Date of assignment
303	NABTRV	☐	VVNABTRV	CHAR15	CHAR	15	0	Contract of assignment number
304	BGESDAR	☐	UB_BGESDAR	NUM13	NUMC	13	0	Total Amount of Syndicated Loan
305	N_BGESDAR	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system
306	SPARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	*
307	SROUND	☐	TFM_SROUND	TFM_SROUND	CHAR	1	0	Rounding Category
308	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
309	DCALLEND	☐	TB_DCALLEND	DATUM	DATS	8	0	Provision Expiry Date
310	ADR_REF	☐	BP_ADR_REF_NEW	BU_ADRKIND	CHAR	10	0	Address ID	*
311	NLFD_ANG	☐	NLFD_ANG	LFNR3	NUMC	3	0	Offer consecutive number
312	S_PKOND	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
313	SFIMA_METHOD	☐	TB_FIMA_METHOD	T_FIMA_METHOD	CHAR	1	0	Control Settings for FiMa Connection
314	SCHEME_ID	☐	TB_SCHEME_ID	T_SCHEME_ID	CHAR	3	0	Calculation Profile for Interest on Arrears Calculation	*
315	A_PAYDAY	☐	TB_MODEL_PAYDAY	T_VIEW_DAY_OF_PAYMENT	NUMC	2	0	Model Calculation: Day of Installment Payment (1-31)
316	CONTRACT_IBAN	☐	BU_IBAN	CHAR34	CHAR	34	0	IBAN (International Bank Account Number)
317	CONTRACT_BIC	☐	SWIFT	SWIFT	CHAR	11	0	SWIFT/BIC for International Payments
318	CONTRACT_IBAN_DET	☐	TB_SEPA_IBAN_DET	TB_SEPA_IBAN_DET_DOM	CHAR	1	0	IBAN Determination Type for Contract
319	EXT_NUMV	☐	FVD_EXT_NUMBER	XFELD	CHAR	1	0	External Number Assignment
320	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
321	.INCLU--AP	☐				0	0	Append for Localization
322	BROUNDUNIT	☐	TB_BROUNDUNIT_AC	NUMC13	NUMC	13	0	Rounding Unit for Amounts (Migration Format)
323	N_BROUNDUNIT	☐	UB_KOMMA	NUM1	NUMC	1	0	Number of decimal places from legacy system

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBIUDA1	BUKRS	T001	BUKRS	KEY	1	1
2	JBIUDA1	GSART	TZPAB	GSART	KEY	1	CN
3	JBIUDA1	HBKID	T012	HBKID
4	JBIUDA1	HKTID	T012K	HKTID
5	JBIUDA1	MABER	T047M	MABER	KEY	1	CN
6	JBIUDA1	MANDT	T000	MANDT	KEY	1	1
7	JBIUDA1	MANSP	T040S	MANSP
8	JBIUDA1	MWSKZ	T007A	MWSKZ	KEY	1	CN
9	JBIUDA1	ROLE	TDPZ6	ROLE
10	JBIUDA1	ROLETYP	TB003	ROLE
11	JBIUDA1	RPORTB	TWPOB	RPORTB	KEY	1	CN
12	JBIUDA1	RREFKONT	T037S	RREFKONT	KEY	1	CN
13	JBIUDA1	RSBBH	BUT000	PARTNER
14	JBIUDA1	RSBEAR	BUT000	PARTNER
15	JBIUDA1	RSBVER	BUT000	PARTNER
16	JBIUDA1	SAART	TZ28	SAART
17	JBIUDA1	SABT	TDS1	SABT	KEY	1	CN
18	JBIUDA1	SANLART	TZ19	SANLART	KEY	1	CN
19	JBIUDA1	SANNAHME	TD13	SANNAHME	KEY	1	CN
20	JBIUDA1	SBASIS	TZFB	SBASIS	KEY	1	CN
21	JBIUDA1	SBAV501	TW12B	SBAV501	KEY	1	CN
22	JBIUDA1	SBILK	TW11	SBILK	KEY	1	1
23	JBIUDA1	SBUST	TZB09	SBUST	KEY	1	CN
24	JBIUDA1	SDTYP	TD02	SDTYP	KEY	1	CN
25	JBIUDA1	SDV	TZ30	SDV	KEY	1	CN
26	JBIUDA1	SFIBG	TW08	SFIBG	KEY	1	1
27	JBIUDA1	SFIWO	TD15	SFIWO	KEY	1	CN
28	JBIUDA1	SFORMREF	AT30	RFORMBEZ	KEY	1	CN
29	JBIUDA1	SFRIST	TD09	SFRIST
30	JBIUDA1	SGBAV	TW06	SGBAV	KEY	1	CN
31	JBIUDA1	SGESST	TD17	SGESST	KEY	1	CN
32	JBIUDA1	SGLZB	TW07	SGLZB	KEY	1	1
33	JBIUDA1	SGR1	TDDG1	SGRP1	KEY	1	CN
34	JBIUDA1	SGR2	TDDG2	SGRP2	KEY	1	CN
35	JBIUDA1	SGRP3	TDDG3	SGRP3	KEY	1	CN
36	JBIUDA1	SGRP4	TDDG4	SGRP4	KEY	1	CN
37	JBIUDA1	SHOME	TD11	SHOME	KEY	1	CN
38	JBIUDA1	SJBUE	TZ17	SJBUE	KEY	1	CN
39	JBIUDA1	SKALID	TFACD	IDENT	KEY	1	CN
40	JBIUDA1	SKALID2	TFACD	IDENT	KEY	1	CN
41	JBIUDA1	SKOART	TZK01	SKOART	KEY	1	CN
42	JBIUDA1	SKOPO	TZK07	SKOPO	KEY	1	CN
43	JBIUDA1	SKUEART	TD27	SKUEART
44	JBIUDA1	SKUEDN	TD29	SKUEDN
45	JBIUDA1	SKUEGL	TD28	SKUEGL
46	JBIUDA1	SKUEND	TD04	SKUEND
47	JBIUDA1	SKWGDAR	TZ34	SKWGDAR
48	JBIUDA1	SKWGKRED	TZ35	SKWGKRED
49	JBIUDA1	SLAENDER	T005	LAND1	KEY	1	1
50	JBIUDA1	SLWID	TCN00	SLWID	KEY	1	CN
51	JBIUDA1	SMW102	TZ32	SMW102	KEY	1	CN
52	JBIUDA1	SNEU_ANL	TZ18	SNEU_ANL	KEY	1	CN
53	JBIUDA1	SNICHTAB	TDA5	SNICHTAB
54	JBIUDA1	SNW600	TZ29P	SNW600
55	JBIUDA1	SONDST	TD14	SONDST	KEY	1	CN
56	JBIUDA1	SREGION	TD18	SREGION	KEY	1	CN
57	JBIUDA1	SSICHER	TD01	SSICH	KEY	1	CN
58	JBIUDA1	SSKZB	TZ11	SSKZB	KEY	1	CN
59	JBIUDA1	SSKZF	TZ13	SSKZF	KEY	1	CN
60	JBIUDA1	SSONDER	TD10	SSONDER	KEY	1	CN
61	JBIUDA1	SSTATI	TZC37	STATU
62	JBIUDA1	STITART	TD16	STITART	KEY	1	CN
63	JBIUDA1	STITEL	TD03	STITEL	KEY	1	CN
64	JBIUDA1	SUABT	TZ31	SUABT	KEY	1	CN
65	JBIUDA1	SUDEC	TW05	SUDEC	KEY	1	CN
66	JBIUDA1	SVERFU	TZV05	SVERFU	KEY	1	CN
67	JBIUDA1	SVZWECK	TD07	SVZWECK	KEY	1	CN
68	JBIUDA1	SZEGEN	TD21	SZEGEN	KEY	1	CN
69	JBIUDA1	SZKEY	TVZ01	SZKEY	KEY	1	CN
70	JBIUDA1	SZKZ	TDSOZ	SZKZ	KEY	1	CN
71	JBIUDA1	SZSREF	T056R	REFERENZ	KEY	1	CN
72	JBIUDA1	SZWKEY	TDZW	SZWKEY	KEY	1	CN
73	JBIUDA1	X_R97_03	TZ36	X_R97_03
74	JBIUDA1	X_R97_05	TZ37	X_R97_05
75	JBIUDA1	X_R97_08	TZ38	X_R97_08
76	JBIUDA1	X_R97_101	TZ39B	X_R97_10
77	JBIUDA1	X_R97_102	TZ39B	X_R97_10
78	JBIUDA1	X_R97_103	TZ39B	X_R97_10
79	JBIUDA1	X_R97_104	TZ39B	X_R97_10
80	JBIUDA1	ZAHLS	T008	ZAHLS
81	JBIUDA1	ZLSCH	T042Z	ZLSCH	KEY	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in