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