JBIUSECDA SAP (Receiver Structure for Security Class Data) Structure details
Description: Receiver Structure for Security Class Data
Structure field list including key, data, relationships and ABAP select examples
JBIUSECDA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Receiver Structure for Security Class Data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_JBIUSECDA TYPE JBIUSECDA.
The JBIUSECDA table consists of various fields, each holding specific information or linking keys about Receiver Structure for Security Class Data data available in SAP. These include SANLF (Product Category), GSART (Product Type), STATUS (Status of a security), XALKZ (Short name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP JBIUSECDA structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
RANL | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
SANLF | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
GSART | Product Type | VVSART | CHAR | 3 | Assigned to domain | VVSART | SAN | VVSART_APPL_BAS | |
STATUS | Status of a security | SEC_STATUS | NUMC | 2 | SEC_STATUS | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
RANLALT1 | Secondary index class data | VVRANLWX | CHAR | 20 | CHAR20 | ||||
RANLALT2 | Secondary index class data | VVRANLWX | CHAR | 20 | CHAR20 | ||||
SROLEXT | General Security Classification | ALWPKL | CHAR | 3 | TW22 | ALWPKL | |||
INSTITUTE | Institute Providing Credit Standing Information | BP_SOL_INS | CHAR | 4 | TP07 | BP_SOL_INS | |||
RATING | Rating | BP_RATING | CHAR | 3 | TP06 | BP_RATING | |||
REPKE | Partner ID of issuer in partner management | REMITT_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
REWHR | Issue currency | REWHR | CUKY | 5 | TCURC | WAERS | |||
SWERTTYP | Security Type ID | SWERTTYP | NUMC | 1 | TW20 | SAKTTYP | |||
SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
KBNEWE | Nominal Value per Stock (Independent of Currency) | VVBNEWE | DEC | 15(6) | VVKWKURS | ||||
SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
SAKAR | Stock category | SAKAR | NUMC | 1 | SAKAR | ||||
SVBRE | Stock form indicator | SVBRE | NUMC | 1 | SVBRE | ||||
SARTBET | Type of shareholding | SARTBET | NUMC | 2 | TW02 | SARTBET | |||
SKONBET | Details about structure of shareholding | SKONBET | NUMC | 2 | TW03 | SKONBET | |||
WLOMB | Indicator eligible as collateral | WLOMB | CHAR | 1 | JANEI | ||||
JDECK | Regulatory reporting BPV (hedge fund Y/N) | JDECK | CHAR | 1 | JANEI | ||||
JMUENDEL | Eligibility indicator | VVJMUEND | CHAR | 1 | JANEI | ||||
JABMI | Joint partner vote indicator | JABMI | CHAR | 1 | JANEI | ||||
AAAAKTIE | Number of stocks issued | AAAAKTIE | DEC | 12 | DEC12 | ||||
PKUAB | Price deviation in percent | PKUAB | DEC | 10(7) | DEC3_7 | ||||
BKUAB | Absolute price deviation | BKUAB | CURR | 10(2) | WHRBTRG | ||||
SARTBEZ | ID for type of relationship between product categories | SARTBEZ | NUMC | 3 | TWRF | SARTBEZ | |||
RANL2 | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
BBREVERZ | Subscription right ratio - Numerator | BBREVERZ | DEC | 9(4) | DEC5_4 | ||||
BBREVERN | Subscription right ratio - Denominator | BBREVERN | DEC | 9(4) | DEC5_4 | ||||
SMOVERW | Possible custody type | SMOVERW | CHAR | 2 | TW50 | SMOVERW | |||
SDEPOSTAT | Securities account statistics key | VVDEPOSTAT | NUMC | 2 | TW51 | VVDEPOSTA | |||
SSTBE | Tax treatment indicator | SSTBE | CHAR | 1 | JANEI | ||||
SWPHGMPF | Securities trading law reporting obligation indicator | VVSWPHGMPF | CHAR | 1 | JANEI | ||||
SFUNDI | Indicator: Funded | VVSFUNDI | CHAR | 1 | JANEI | ||||
MARK | Selection for stock exchange | HMARK | CHAR | 1 | KENZX | ||||
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | TWH01 | VVRHANDPL | WHP | ||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
FLAT | Flat price - Yes/No | VVJFLAT | CHAR | 1 | KENZX | ||||
HEIBOE | Home exchange - Yes/No | VVJHEIBOE | CHAR | 1 | KENZX | ||||
SBOEN | Listing key | VVSBOEN | NUMC | 2 | TW53 | VVSBOEN | |||
DGUEL_KK | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
DEBEG | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
KZAHLAKT | Pay-in rate | KZAHLAKT | DEC | 10(7) | DEC3_7 | ||||
BZAHLAKT | Amount Deposited | BZAHLAKT | CURR | 10(2) | WHRBTRG | ||||
DREST | Balance payment date | DREST | DATS | 8 | DATUM | ||||
PDIVBER | Dividend rights per unit in percentage terms | PDIVBER | DEC | 10(7) | DEC3_7 | ||||
DDBAB | Date from which entitled to dividends | DDBAB | DATS | 8 | DATUM | ||||
KBEMPREIS | Issue price independent of currency | VVKBEMPR | DEC | 15(6) | VVKWKURS | ||||
PEMKURS | Issue rate in percent | PEMKURS | DEC | 10(7) | DEC3_7 | ||||
DTSCHAB | Swap period from | DTFVO | DATS | 8 | DATUM | ||||
DXTAUSCH | Swap period to | DTFBI | DATS | 8 | DATUM | ||||
ATSHZAE | Swap ratio - numerator | BTVZA | DEC | 9(4) | DEC5_4 | ||||
ATCHNEN | Swap ratio - denominator | BTVNE | DEC | 9(4) | DEC5_4 | ||||
BAUSGLCH | Clearing amount for swap | BABTA | CURR | 10(2) | WHRBTRG | ||||
SWHRAUSG | Clearing amount currency | SWHRAUSG | CUKY | 5 | TCURC | WAERS | |||
DXGUELT | Trading until | DTGBI | DATS | 8 | DATUM | ||||
PAUSG | Issue premium in percentage | PAUSG | DEC | 10(7) | DEC3_7 | ||||
SFOTY | Fund type indicator | SFOTY | NUMC | 1 | TW21 | SFOTY | |||
SFOART | Fund category indicator | VVSFOART | CHAR | 2 | VVSFOART | ||||
SOEFF | Public fund indicator | SOEFF | CHAR | 1 | JANEI | ||||
BFONVOL | Fund volume | BFONVOL | CURR | 15(2) | WERT8 | ||||
SAING | Foreign Investment Law indicator | SAING | CHAR | 1 | JANEI | ||||
JTHESAU | Reinvestment indicator | STHES | CHAR | 1 | JANEI | ||||
PWANLRAB | Reinvestment discount percent | PWARB | DEC | 10(7) | DEC3_7 | ||||
BBPRU | Underlying subscription price | BBPRU | CURR | 10(2) | VVBNENNW | ||||
RWBZP | Subscription price currency | RWBZP | CUKY | 5 | TCURC | WAERS | |||
BBVHZ | Subscription ratio - Numerator | BBVHZ | DEC | 9(4) | DEC5_4 | ||||
BBVHN | Subscription ratio - Denominator | BBVHN | DEC | 9(4) | DEC5_4 | ||||
DBFRV | Subscription period from | DBFRV | DATS | 8 | DATUM | ||||
DBFRB | Date subscription period until | DBFRB | DATS | 8 | DATUM | ||||
RIGHTS_TEXT | Short text/description of the object | KURZTEXT | CHAR | 40 | TEXT40 | ||||
DBHAV | Date of subscription rights trading from | DBHAV | DATS | 8 | DATUM | ||||
DBHAB | Date of subscription rights trading until | DBHAB | DATS | 8 | DATUM | ||||
KREAK | Post Subscription Rights | KREAK | DEC | 15(6) | VVKWKURS | ||||
BVNJA | Advantage/disadvantage dividend of new stock | BVNJA | CURR | 10(2) | WHRBTRG | ||||
SWPKLASS | Classification of bond | SWPKLASS | NUMC | 3 | TW01 | SWPKLASS | |||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
BNHAE | Nominal per trading unit | BNHAE | CURR | 13(2) | BWHR | ||||
DKOBL | Bondholder call date | DKOBL | DATS | 8 | DATUM | ||||
DKEMI | Issuer call date | DKEMI | DATS | 8 | DATUM | ||||
DANDPFL | Obligation to offer for sale until | DANDPFL | DATS | 8 | DATUM | ||||
DANDRE | Right to offer until | DANDRE | DATS | 8 | DATUM | ||||
JAUSL | Drawing Indicator | JAUSL | CHAR | 1 | JANEI | ||||
DAUSL | Drawing date | DAUSL | DATS | 8 | DATUM | ||||
JNACHR | Secondary loans ID | VVJNACHR | CHAR | 1 | JANE | ||||
DEMBEG | Bonds and debentures issue start | DEMBEG | DATS | 8 | DATUM | ||||
DENDFAE | Final due date of bonds | DENDFAE | DATS | 8 | DATUM | ||||
SINKKOKO | Inclusive indicator | VVWSINCL | CHAR | 1 | XFELD | ||||
SRENDMETH | Indicator for yield method | SRENDMETH | NUMC | 1 | SEFFMETH | ||||
YIELD_FREQUENCY | Int.sttlmnt frequency for effective int.rate calc.in months | VVZVRHYEFF | NUMC | 3 | NUMC03 | ||||
KOKO_ZMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
BATRT | Number of cutting days | BATRT | NUMC | 3 | NUMC03 | ||||
STILGART | Repayment Type Indicator | STILGART | NUMC | 1 | STILGART | ||||
SDISKO | Discounted | SDISKO | CHAR | 1 | SDISKO | ||||
SCUEX | Cum/ex indicator | SCUEX | NUMC | 1 | SCUEX | ||||
UNDERLYING2 | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
BOPHE | Number of warrants per nominal value | BOPHE | NUMC | 3 | NUM03 | ||||
DWAFV | Conversion period from | DWAFV | DATS | 8 | DATUM | ||||
DWAFB | Conversion period until | DWAFB | DATS | 8 | DATUM | ||||
BWAVZ | Conversion ratio - Numerator | BWAVZ | DEC | 9(4) | DEC5_4 | ||||
BWAVN | Conversion ratio - Denominator | BWAVN | DEC | 9(4) | DEC5_4 | ||||
BAUFP | Premium when converting a convertible bond | BAUFP | CURR | 13(2) | BWHR | ||||
RWAUF | Currency markup | RWAUF | CUKY | 5 | TCURC | WAERS | |||
SOPTTYP | Indicator: Option Category | SOPTTYP | NUMC | 1 | SOPTTYP | ||||
AMINDEST | Exercise minimum | AMINDEST | DEC | 15(5) | ASTUECK | ||||
SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
DLAVO | Term from | DLAVO | DATS | 8 | DATUM | ||||
DLABI | Term to | DLABI | DATS | 8 | DATUM | ||||
BOVZA | Option ratio - numerator | BOVZA | DEC | 9(4) | DEC5_4 | ||||
BOVNE | Option ratio - Denominator | BOVNE | DEC | 9(4) | DEC5_4 | ||||
SVERROPT | Option Settlement Indicator | SVERROPT | NUMC | 1 | SVERROPT | ||||
BBASPREI | Exercise price | BBASPREI | CURR | 13(2) | BWHR | ||||
RWHRBAS | Exercise price currency | RWHRBAS | CUKY | 5 | TCURC | WAERS | |||
BBEZEIN | Reference units | VVBBEZEIN | CURR | 13(2) | BWHR | ||||
RBEZWHR | Reference unit currency | VVRBEZEIN | CUKY | 5 | TCURC | WAERS | |||
PBASKURS | Basic rate | PBASKURS | DEC | 10(7) | DEC3_7 | ||||
SINDEART | Securities Index | IDX | CHAR | 10 | CHAR10 | ||||
IBASIS | Index base | VVBASIS | DEC | 8(3) | DEC5_3 | ||||
BINDEX | Index point per monetary unit | BINDEX | CURR | 13(2) | BWHR | ||||
RINDWHR | Index currency | RINDWHR | CUKY | 5 | TCURC | WAERS | |||
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | TZK01 | SKOART | |||
KBKOND | Condition amount independent of currency | VVKBKOND | DEC | 15(6) | VVKWKURS | ||||
DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
SZSREFVZ | +/- sign / reference interest rate operator | SZSREFVZ | CHAR | 1 | SZSREFVZ | ||||
SZSREF | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
BKOND | Condition item currency amount | BKOND | CURR | 13(2) | WERTV7 | ||||
SWHRKOND | Currency of Condition Item | SWHRKOND | CUKY | 5 | TCURC | WAERS | |||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
KURS1 | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
SBASIS | Calculation base reference | VVSBASIS | CHAR | 4 | TZFB | VVSBASIS | |||
BBASIS | Calculation base amount | BBASIS | CURR | 13(2) | WERTV7 | ||||
JBMONAT | Indicator for calculating amount per month | JBMONAT | CHAR | 1 | JANEI | ||||
JPROZR | Percentage Calculation | TB_JPROZR | CHAR | 1 | XFELD | ||||
SPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
RDIVNR | Dividend coupon number | RDIVNR | NUMC | 3 | NUM03 | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
ZAHLS | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
RKONT | Quota number | RKONT | NUMC | 6 | RKONT | RKT | |||
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
SBUST | Posting control key | VVSBUST | NUMC | 2 | VVSBUST | ||||
SZEGEN | Generate incoming payment immediately | SZEGEN | NUMC | 2 | Assigned to domain | SZEGEN | |||
DVALUT | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
JSINCL | Inclusive indicator for calculation date | TFMJSINCL | CHAR | 1 | TFMSINCL | ||||
SVWERK | Shift calculation date to working day | VVSVWERK | NUMC | 1 | T_SWERK | ||||
AVGSTAGE | Number of working days for value date | AVGSTAGE | NUMC | 2 | NUMC2 | ||||
AVGSTAGEVZ | +/- sign for number of working days for value date | AVGSTAGEVZ | CHAR | 1 | PLUSM | ||||
SVMETH | Method for determining the next value date | VVSVMETH | NUMC | 1 | T_SVMETH | ||||
SVULT | Month-end indicator for calculation date | VVSBULT | CHAR | 1 | JFLAGG | ||||
JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
SZEITANT | Indicator for Pro Rata Temporis Calculations | VVSZEITANT | NUMC | 1 | VVSZEITANT | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
JSFINCL | Inclusive Indicator for Due Date | TFMJSFINCL | CHAR | 1 | TFMSINCL | ||||
SFWERK | Shift due date to working day | VVSFWERK | NUMC | 1 | T_SWERK | ||||
SDWERK | Working Day Shift for Payment Date | TB_SDWERK | NUMC | 1 | T_SWERK | ||||
AFGSTAGE | Number of working days to due date | AFGSTAGE | NUMC | 2 | NUMC2 | ||||
SFMETH | Method for determining the next due date | VVSFMETH | NUMC | 1 | T_SFMETH | ||||
SFULT | Month-End Indicator for Due Date | SFULT | CHAR | 1 | VVSULT | ||||
SFRANZ | Shift Due Date | TFMSFRANZ | NUMC | 1 | TFMSFRANZ | ||||
SBERECH | Grace Period Interest Method | SBERECH | CHAR | 1 | XFELD | ||||
SFANT | Indicator for due date-related FiMa calculations | VVSFANT | NUMC | 1 | VVSFANT | ||||
SZAWS | Payment form (at start of period, mid-period, at period end) | SZAWS | NUMC | 1 | SZAHLDIV | ||||
JNULLKON | Condition Form | JNULLKON | CHAR | 1 | SKONDF | ||||
SZWKEY | Payment form with adjustment days | VVSZWKEY | CHAR | 2 | TDZW | VVSZWKEY | |||
AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | NUMC03 | ||||
SKOPO | Detailed identification for condition items | VVSKOPO | NUMC | 2 | Assigned to domain | VVSKOPO | |||
ATTRHY | Frequency in Days | ATTRHY | NUMC | 3 | NUMC03 | ||||
SKALID | Factory calendar | SKALID | CHAR | 2 | TFACD | WFCID | H_TFACD | ||
SKALID2 | Calendar ID 2 (valid in connection with calendar ID 1) | VVSKALID2 | CHAR | 2 | TFACD | WFCID | |||
SFORMREF | Formula Reference | TB_XFORMBE | CHAR | 4 | AT30 | T_FORMBE | |||
PKONDMIN | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
PKONDMAX | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
SZSREFMIN | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
SZSREFMAX | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
PRUNIT | Rounding Unit | TFMPRUNIT | DEC | 13(7) | TFMSRUNIT | ||||
JAUSW1 | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
JAUSW2 | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
JAUSW3 | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
PKOND_V1 | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
PKOND_V2 | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
PKOND_V3 | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
PKOND_V4 | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
SZSREF_V1 | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
SZSREF_V2 | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
SZSREF_V3 | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
SZSREF_V4 | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
MODE | Mode of Data Flow | JBSMODE | CHAR | 1 | JBSMODE |
Key field | Non-key field |
How do I retrieve data from SAP structure JBIUSECDA using ABAP code?
As JBIUSECDA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on JBIUSECDA as there is no data to select.How to access SAP table JBIUSECDA
Within an ECC or HANA version of SAP you can also view further information about JBIUSECDA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects