SAP ABAP Table JBIUSECDA (Receiver Structure for Security Class 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	JBIUSECDA	Table Relationship Diagram
Short Description	Receiver Structure for Security Class 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	RANL	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
2	SANLF	☐	SANLF	VVSANLF	NUMC	3	0	Product Category	*
3	GSART	☐	VVSART	VVSART	CHAR	3	0	Product Type	*
4	STATUS	☐	SEC_STATUS	SEC_STATUS	NUMC	2	0	Status of a security
5	XALKZ	☐	XALKZ	XKBEZ	CHAR	15	0	Short name
6	XALLB	☐	XALLB	XLBEZ	CHAR	60	0	Long name
7	RANLALT1	☐	VVRANLWX	CHAR20	CHAR	20	0	Secondary index class data
8	RANLALT2	☐	VVRANLWX	CHAR20	CHAR	20	0	Secondary index class data
9	SROLEXT	☐	ALWPKL	ALWPKL	CHAR	3	0	General Security Classification	TW22
10	INSTITUTE	☐	BP_SOL_INS	BP_SOL_INS	CHAR	4	0	Institute Providing Credit Standing Information	TP07
11	RATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
12	REPKE	☐	REMITT_NEW	BU_PARTNER	CHAR	10	0	Partner ID of issuer in partner management	*
13	BPEXT	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
14	REWHR	☐	REWHR	WAERS	CUKY	5	0	Issue currency	TCURC
15	SWERTTYP	☐	SWERTTYP	SAKTTYP	NUMC	1	0	Security Type ID	TW20
16	SNOTI	☐	SNOTI	SNOTI	NUMC	1	0	Quotation Indicator
17	KBNEWE	☐	VVBNEWE	VVKWKURS	DEC	15	6	Nominal Value per Stock (Independent of Currency)
18	SBOERNOT	☐	SBOERNOT	JANEI	CHAR	1	0	Indicator: Listed on an Exchange
19	SAKAR	☐	SAKAR	SAKAR	NUMC	1	0	Stock category
20	SVBRE	☐	SVBRE	SVBRE	NUMC	1	0	Stock form indicator
21	SARTBET	☐	SARTBET	SARTBET	NUMC	2	0	Type of shareholding	TW02
22	SKONBET	☐	SKONBET	SKONBET	NUMC	2	0	Details about structure of shareholding	TW03
23	WLOMB	☐	WLOMB	JANEI	CHAR	1	0	Indicator eligible as collateral
24	JDECK	☐	JDECK	JANEI	CHAR	1	0	Regulatory reporting BPV (hedge fund Y/N)
25	JMUENDEL	☐	VVJMUEND	JANEI	CHAR	1	0	Eligibility indicator
26	JABMI	☐	JABMI	JANEI	CHAR	1	0	Joint partner vote indicator
27	AAAAKTIE	☐	AAAAKTIE	DEC12	DEC	12	0	Number of stocks issued
28	PKUAB	☐	PKUAB	DEC3_7	DEC	10	7	Price deviation in percent
29	BKUAB	☐	BKUAB	WHRBTRG	CURR	10	2	Absolute price deviation
30	SARTBEZ	☑	SARTBEZ	SARTBEZ	NUMC	3	0	ID for type of relationship between product categories	TWRF
31	RANL2	☑	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
32	BBREVERZ	☐	BBREVERZ	DEC5_4	DEC	9	4	Subscription right ratio - Numerator
33	BBREVERN	☐	BBREVERN	DEC5_4	DEC	9	4	Subscription right ratio - Denominator
34	SMOVERW	☐	SMOVERW	SMOVERW	CHAR	2	0	Possible custody type	TW50
35	SDEPOSTAT	☐	VVDEPOSTAT	VVDEPOSTA	NUMC	2	0	Securities account statistics key	TW51
36	SSTBE	☐	SSTBE	JANEI	CHAR	1	0	Tax treatment indicator
37	SWPHGMPF	☐	VVSWPHGMPF	JANEI	CHAR	1	0	Securities trading law reporting obligation indicator
38	SFUNDI	☐	VVSFUNDI	JANEI	CHAR	1	0	Indicator: Funded
39	MARK	☐	HMARK	KENZX	CHAR	1	0	Selection for stock exchange
40	RHANDPL	☐	VVRHANDPL	VVRHANDPL	CHAR	10	0	Exchange	TWH01
41	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
42	FLAT	☐	VVJFLAT	KENZX	CHAR	1	0	Flat price - Yes/No
43	HEIBOE	☐	VVJHEIBOE	KENZX	CHAR	1	0	Home exchange - Yes/No
44	SBOEN	☐	VVSBOEN	VVSBOEN	NUMC	2	0	Listing key	TW53
45	DGUEL_KK	☑	DGUEL	DATUM	DATS	8	0	Date Condition Effective from
46	DEBEG	☐	DEBEG	DATUM	DATS	8	0	Issue start date
47	KZAHLAKT	☐	KZAHLAKT	DEC3_7	DEC	10	7	Pay-in rate
48	BZAHLAKT	☐	BZAHLAKT	WHRBTRG	CURR	10	2	Amount Deposited
49	DREST	☐	DREST	DATUM	DATS	8	0	Balance payment date
50	PDIVBER	☐	PDIVBER	DEC3_7	DEC	10	7	Dividend rights per unit in percentage terms
51	DDBAB	☐	DDBAB	DATUM	DATS	8	0	Date from which entitled to dividends
52	KBEMPREIS	☐	VVKBEMPR	VVKWKURS	DEC	15	6	Issue price independent of currency
53	PEMKURS	☐	PEMKURS	DEC3_7	DEC	10	7	Issue rate in percent
54	DTSCHAB	☐	DTFVO	DATUM	DATS	8	0	Swap period from
55	DXTAUSCH	☐	DTFBI	DATUM	DATS	8	0	Swap period to
56	ATSHZAE	☐	BTVZA	DEC5_4	DEC	9	4	Swap ratio - numerator
57	ATCHNEN	☐	BTVNE	DEC5_4	DEC	9	4	Swap ratio - denominator
58	BAUSGLCH	☐	BABTA	WHRBTRG	CURR	10	2	Clearing amount for swap
59	SWHRAUSG	☐	SWHRAUSG	WAERS	CUKY	5	0	Clearing amount currency	TCURC
60	DXGUELT	☐	DTGBI	DATUM	DATS	8	0	Trading until
61	PAUSG	☐	PAUSG	DEC3_7	DEC	10	7	Issue premium in percentage
62	SFOTY	☐	SFOTY	SFOTY	NUMC	1	0	Fund type indicator	TW21
63	SFOART	☐	VVSFOART	VVSFOART	CHAR	2	0	Fund category indicator
64	SOEFF	☐	SOEFF	JANEI	CHAR	1	0	Public fund indicator
65	BFONVOL	☐	BFONVOL	WERT8	CURR	15	2	Fund volume
66	SAING	☐	SAING	JANEI	CHAR	1	0	Foreign Investment Law indicator
67	JTHESAU	☐	STHES	JANEI	CHAR	1	0	Reinvestment indicator
68	PWANLRAB	☐	PWARB	DEC3_7	DEC	10	7	Reinvestment discount percent
69	BBPRU	☐	BBPRU	VVBNENNW	CURR	10	2	Underlying subscription price
70	RWBZP	☐	RWBZP	WAERS	CUKY	5	0	Subscription price currency	TCURC
71	BBVHZ	☐	BBVHZ	DEC5_4	DEC	9	4	Subscription ratio - Numerator
72	BBVHN	☐	BBVHN	DEC5_4	DEC	9	4	Subscription ratio - Denominator
73	DBFRV	☐	DBFRV	DATUM	DATS	8	0	Subscription period from
74	DBFRB	☐	DBFRB	DATUM	DATS	8	0	Date subscription period until
75	RIGHTS_TEXT	☐	KURZTEXT	TEXT40	CHAR	40	0	Short text/description of the object
76	DBHAV	☐	DBHAV	DATUM	DATS	8	0	Date of subscription rights trading from
77	DBHAB	☐	DBHAB	DATUM	DATS	8	0	Date of subscription rights trading until
78	KREAK	☐	KREAK	VVKWKURS	DEC	15	6	Post Subscription Rights
79	BVNJA	☐	BVNJA	WHRBTRG	CURR	10	2	Advantage/disadvantage dividend of new stock
80	SWPKLASS	☐	SWPKLASS	SWPKLASS	NUMC	3	0	Classification of bond	TW01
81	BNOMS	☐	BNOMS	BWHR	CURR	13	2	Nominal value
82	BNHAE	☐	BNHAE	BWHR	CURR	13	2	Nominal per trading unit
83	DKOBL	☐	DKOBL	DATUM	DATS	8	0	Bondholder call date
84	DKEMI	☐	DKEMI	DATUM	DATS	8	0	Issuer call date
85	DANDPFL	☐	DANDPFL	DATUM	DATS	8	0	Obligation to offer for sale until
86	DANDRE	☐	DANDRE	DATUM	DATS	8	0	Right to offer until
87	JAUSL	☐	JAUSL	JANEI	CHAR	1	0	Drawing Indicator
88	DAUSL	☐	DAUSL	DATUM	DATS	8	0	Drawing date
89	JNACHR	☐	VVJNACHR	JANE	CHAR	1	0	Secondary loans ID
90	DEMBEG	☐	DEMBEG	DATUM	DATS	8	0	Bonds and debentures issue start
91	DENDFAE	☐	DENDFAE	DATUM	DATS	8	0	Final due date of bonds
92	SINKKOKO	☐	VVWSINCL	XFELD	CHAR	1	0	Inclusive indicator
93	SRENDMETH	☐	SRENDMETH	SEFFMETH	NUMC	1	0	Indicator for yield method
94	YIELD_FREQUENCY	☐	VVZVRHYEFF	NUMC03	NUMC	3	0	Int.sttlmnt frequency for effective int.rate calc.in months
95	KOKO_ZMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
96	BATRT	☐	BATRT	NUMC03	NUMC	3	0	Number of cutting days
97	STILGART	☐	STILGART	STILGART	NUMC	1	0	Repayment Type Indicator
98	SDISKO	☐	SDISKO	SDISKO	CHAR	1	0	Discounted
99	SCUEX	☐	SCUEX	SCUEX	NUMC	1	0	Cum/ex indicator
100	UNDERLYING2	☐	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	*
101	BOPHE	☐	BOPHE	NUM03	NUMC	3	0	Number of warrants per nominal value
102	DWAFV	☐	DWAFV	DATUM	DATS	8	0	Conversion period from
103	DWAFB	☐	DWAFB	DATUM	DATS	8	0	Conversion period until
104	BWAVZ	☐	BWAVZ	DEC5_4	DEC	9	4	Conversion ratio - Numerator
105	BWAVN	☐	BWAVN	DEC5_4	DEC	9	4	Conversion ratio - Denominator
106	BAUFP	☐	BAUFP	BWHR	CURR	13	2	Premium when converting a convertible bond
107	RWAUF	☐	RWAUF	WAERS	CUKY	5	0	Currency markup	TCURC
108	SOPTTYP	☐	SOPTTYP	SOPTTYP	NUMC	1	0	Indicator: Option Category
109	AMINDEST	☐	AMINDEST	ASTUECK	DEC	15	5	Exercise minimum
110	SOPTAUS	☐	SOPTAUS	SOPTAUS	NUMC	1	0	Exercise Type (American or European)
111	DLAVO	☐	DLAVO	DATUM	DATS	8	0	Term from
112	DLABI	☐	DLABI	DATUM	DATS	8	0	Term to
113	BOVZA	☐	BOVZA	DEC5_4	DEC	9	4	Option ratio - numerator
114	BOVNE	☐	BOVNE	DEC5_4	DEC	9	4	Option ratio - Denominator
115	SVERROPT	☐	SVERROPT	SVERROPT	NUMC	1	0	Option Settlement Indicator
116	BBASPREI	☐	BBASPREI	BWHR	CURR	13	2	Exercise price
117	RWHRBAS	☐	RWHRBAS	WAERS	CUKY	5	0	Exercise price currency	TCURC
118	BBEZEIN	☐	VVBBEZEIN	BWHR	CURR	13	2	Reference units
119	RBEZWHR	☐	VVRBEZEIN	WAERS	CUKY	5	0	Reference unit currency	TCURC
120	PBASKURS	☐	PBASKURS	DEC3_7	DEC	10	7	Basic rate
121	SINDEART	☐	IDX	CHAR10	CHAR	10	0	Securities Index
122	IBASIS	☐	VVBASIS	DEC5_3	DEC	8	3	Index base
123	BINDEX	☐	BINDEX	BWHR	CURR	13	2	Index point per monetary unit
124	RINDWHR	☐	RINDWHR	WAERS	CUKY	5	0	Index currency	TCURC
125	SKOART	☐	SKOART	SKOART	NUMC	4	0	Condition Type (Smallest Subdivision of Condition Records)	TZK01
126	KBKOND	☐	VVKBKOND	VVKWKURS	DEC	15	6	Condition amount independent of currency
127	DGUEL_KP	☑	DGUEL_KP	DATUM	DATS	8	0	Condition Item Valid From
128	PKOND	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
129	SZSREFVZ	☐	SZSREFVZ	SZSREFVZ	CHAR	1	0	+/- sign / reference interest rate operator
130	SZSREF	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
131	BKOND	☐	BKOND	WERTV7	CURR	13	2	Condition item currency amount
132	SWHRKOND	☐	SWHRKOND	WAERS	CUKY	5	0	Currency of Condition Item	TCURC
133	SZBMETH	☐	SZBMETH	SZBMETH	CHAR	1	0	Interest Calculation Method
134	KURS1	☐	KURSF	KURSF	DEC	9	5	Exchange rate
135	SBASIS	☐	VVSBASIS	VVSBASIS	CHAR	4	0	Calculation base reference	TZFB
136	BBASIS	☐	BBASIS	WERTV7	CURR	13	2	Calculation base amount
137	JBMONAT	☐	JBMONAT	JANEI	CHAR	1	0	Indicator for calculating amount per month
138	JPROZR	☐	TB_JPROZR	XFELD	CHAR	1	0	Percentage Calculation
139	SPARTNR	☐	BP_PARTNR_NEW	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
140	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
141	RDIVNR	☐	RDIVNR	NUM03	NUMC	3	0	Dividend coupon number
142	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
143	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
144	ZAHLS	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
145	RKONT	☐	RKONT	RKONT	NUMC	6	0	Quota number
146	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
147	SBUST	☐	VVSBUST	VVSBUST	NUMC	2	0	Posting control key
148	SZEGEN	☐	SZEGEN	SZEGEN	NUMC	2	0	Generate incoming payment immediately	*
149	DVALUT	☐	DVALUT	DATUM	DATS	8	0	Calculation Date
150	JSINCL	☐	TFMJSINCL	TFMSINCL	CHAR	1	0	Inclusive indicator for calculation date
151	SVWERK	☐	VVSVWERK	T_SWERK	NUMC	1	0	Shift calculation date to working day
152	AVGSTAGE	☐	AVGSTAGE	NUMC2	NUMC	2	0	Number of working days for value date
153	AVGSTAGEVZ	☐	AVGSTAGEVZ	PLUSM	CHAR	1	0	+/- sign for number of working days for value date
154	SVMETH	☐	VVSVMETH	T_SVMETH	NUMC	1	0	Method for determining the next value date
155	SVULT	☐	VVSBULT	JFLAGG	CHAR	1	0	Month-end indicator for calculation date
156	JSOFVERR	☐	JSOFVERR	TFMSOFVERR	CHAR	1	0	Immediate settlement
157	SZEITANT	☐	VVSZEITANT	VVSZEITANT	NUMC	1	0	Indicator for Pro Rata Temporis Calculations
158	DFAELL	☐	DFAELL	DATUM	DATS	8	0	Due date
159	JSFINCL	☐	TFMJSFINCL	TFMSINCL	CHAR	1	0	Inclusive Indicator for Due Date
160	SFWERK	☐	VVSFWERK	T_SWERK	NUMC	1	0	Shift due date to working day
161	SDWERK	☐	TB_SDWERK	T_SWERK	NUMC	1	0	Working Day Shift for Payment Date
162	AFGSTAGE	☐	AFGSTAGE	NUMC2	NUMC	2	0	Number of working days to due date
163	SFMETH	☐	VVSFMETH	T_SFMETH	NUMC	1	0	Method for determining the next due date
164	SFULT	☐	SFULT	VVSULT	CHAR	1	0	Month-End Indicator for Due Date
165	SFRANZ	☐	TFMSFRANZ	TFMSFRANZ	NUMC	1	0	Shift Due Date
166	SBERECH	☐	SBERECH	XFELD	CHAR	1	0	Grace Period Interest Method
167	SFANT	☐	VVSFANT	VVSFANT	NUMC	1	0	Indicator for due date-related FiMa calculations
168	SZAWS	☐	SZAWS	SZAHLDIV	NUMC	1	0	Payment form (at start of period, mid-period, at period end)
169	JNULLKON	☐	JNULLKON	SKONDF	CHAR	1	0	Condition Form
170	SZWKEY	☐	VVSZWKEY	VVSZWKEY	CHAR	2	0	Payment form with adjustment days	TDZW
171	AMMRHY	☐	AMMRHY	NUMC03	NUMC	3	0	Frequency in months
172	SKOPO	☐	VVSKOPO	VVSKOPO	NUMC	2	0	Detailed identification for condition items	*
173	ATTRHY	☐	ATTRHY	NUMC03	NUMC	3	0	Frequency in Days
174	SKALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
175	SKALID2	☐	VVSKALID2	WFCID	CHAR	2	0	Calendar ID 2 (valid in connection with calendar ID 1)	TFACD
176	SFORMREF	☐	TB_XFORMBE	T_FORMBE	CHAR	4	0	Formula Reference	AT30
177	PKONDMIN	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
178	PKONDMAX	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
179	SZSREFMIN	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
180	SZSREFMAX	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
181	PRUNIT	☐	TFMPRUNIT	TFMSRUNIT	DEC	13	7	Rounding Unit
182	JAUSW1	☐	XFELD	XFELD	CHAR	1	0	Checkbox
183	JAUSW2	☐	XFELD	XFELD	CHAR	1	0	Checkbox
184	JAUSW3	☐	XFELD	XFELD	CHAR	1	0	Checkbox
185	PKOND_V1	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
186	PKOND_V2	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
187	PKOND_V3	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
188	PKOND_V4	☐	PKOND	DECV3_7	DEC	10	7	Percentage rate for condition items
189	SZSREF_V1	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
190	SZSREF_V2	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
191	SZSREF_V3	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
192	SZSREF_V4	☐	SZSREF	ZIREFKU	CHAR	10	0	Reference Interest Rate	T056R
193	MODE	☐	JBSMODE	JBSMODE	CHAR	1	0	Mode of Data Flow

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JBIUSECDA	INSTITUTE	TP07	SOL_INS
2	JBIUSECDA	MABER	T047M	MABER
3	JBIUSECDA	MWSKZ	T007A	MWSKZ
4	JBIUSECDA	RATING	TP06	RATING
5	JBIUSECDA	RBEZWHR	TCURC	WAERS
6	JBIUSECDA	REWHR	TCURC	WAERS
7	JBIUSECDA	RHANDPL	TWH01	RHANDPL
8	JBIUSECDA	RINDWHR	TCURC	WAERS
9	JBIUSECDA	RWAUF	TCURC	WAERS
10	JBIUSECDA	RWBZP	TCURC	WAERS
11	JBIUSECDA	RWHRBAS	TCURC	WAERS
12	JBIUSECDA	SARTBET	TW02	SARTBET
13	JBIUSECDA	SARTBEZ	TWRF	SARTBEZ
14	JBIUSECDA	SBASIS	TZFB	SBASIS
15	JBIUSECDA	SBOEN	TW53	SBOEN
16	JBIUSECDA	SDEPOSTAT	TW51	SDEPOSTAT
17	JBIUSECDA	SFORMREF	AT30	RFORMBEZ
18	JBIUSECDA	SFOTY	TW21	SFOTY
19	JBIUSECDA	SKALID	TFACD	IDENT
20	JBIUSECDA	SKALID2	TFACD	IDENT
21	JBIUSECDA	SKOART	TZK01	SKOART
22	JBIUSECDA	SKONBET	TW03	SKONBET
23	JBIUSECDA	SMOVERW	TW50	SMOVERW
24	JBIUSECDA	SPARTNR	BUT000	PARTNER
25	JBIUSECDA	SROLEXT	TW22	ALWPKL
26	JBIUSECDA	SWERTTYP	TW20	SWERTTYP
27	JBIUSECDA	SWHRAUSG	TCURC	WAERS
28	JBIUSECDA	SWHRKOND	TCURC	WAERS
29	JBIUSECDA	SWPKLASS	TW01	SWPKLASS
30	JBIUSECDA	SZSREF	T056R	REFERENZ
31	JBIUSECDA	SZSREFMAX	T056R	REFERENZ
32	JBIUSECDA	SZSREFMIN	T056R	REFERENZ
33	JBIUSECDA	SZSREF_V1	T056R	REFERENZ
34	JBIUSECDA	SZSREF_V2	T056R	REFERENZ
35	JBIUSECDA	SZSREF_V3	T056R	REFERENZ
36	JBIUSECDA	SZSREF_V4	T056R	REFERENZ
37	JBIUSECDA	SZWKEY	TDZW	SZWKEY
38	JBIUSECDA	WAERS	TCURC	WAERS
39	JBIUSECDA	ZAHLS	T008	ZAHLS
40	JBIUSECDA	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in