SAP ABAP Table J11SDA1 (Send Structure for TR-EDT Receiever Structure JBIUDA1)

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	J11SDA1	Table Relationship Diagram
Short Description	Send Structure for TR-EDT Receiever Structure JBIUDA1

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

History

Last changed by/on	SAP	20131127
SAP Release Created in