SECURITY_COMPLEX SAP (Complex Structure of Class Data) Structure details
Description: Complex Structure of Class Data
Related tables to SECURITY_COMPLEX
Access table SECURITY_COMPLEX
Structure field list including key, data, relationships and ABAP select examples
SECURITY_COMPLEX 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 "Complex Structure of 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_SECURITY_COMPLEX TYPE SECURITY_COMPLEX.
The SECURITY_COMPLEX table consists of various fields, each holding specific information or linking keys about Complex Structure of Class Data data available in SAP. These include SECURITY_NUMBER (Security ID Number), SHORT_TEXT (Short name), LONG_TEXT (Long name), PRODUCT_CATEGORY (Product Category).. 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 (Deep)
SAP SECURITY_COMPLEX 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 |
SECURITY_NUMBER | Security ID Number | VVRANLW | CHAR | 13 | VWPANLA | ALPHA | WP_RANL | RAN | SECURITY_F4 |
SHORT_TEXT | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
LONG_TEXT | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
PRODUCT_CATEGORY | Product Category | SANLF | NUMC | 3 | TZAF | VVSANLF | |||
PRODUCT_CATEGORY_TEXT | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
PRODUCT_TYPE | Product Type | VVSART | CHAR | 3 | TZPA | VVSART | SAN | VVSART_APPL_BAS | |
PRODUCT_TYPE_TEXT | Text (30 Characters) | TEXT30 | CHAR | 30 | TEXT30 | ||||
LISTED | Indicator: Listed on an Exchange | SEC_LISTED | CHAR | 1 | ATXF1 | ||||
QUOTATION | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
ISSUER | Issuer Identity Key | REPKE_NEW | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | BPA | BUPA |
ISSUER_TEXT | Address line | LINES | CHAR | 80 | LINES | ||||
ISSUE_CURRENCY | Issue currency | REWHR | CUKY | 5 | TCURC | WAERS | |||
ISSUE_PRICE | Issue price independent of currency | VVKBEMPR | DEC | 15(6) | VVKWKURS | ||||
ISSUE_RATE | Issue rate in percent | PEMKURS | DEC | 10(7) | DEC3_7 | ||||
CLASSIFICATION | 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 | |||
FUNDED | Indicator: Funded | SEC_FUNDED | CHAR | 1 | ATXF1 | ||||
PRICE_INDEX | Name of Price Index | TIDX_INDEX_NAME | CHAR | 15 | TIDX_PRICE_INDEX | TIDX_INDEX_NAME | |||
PRICE_IDX_BDATE | Price Index Base Date | TIDX_INDEX_BASE_DATE | DATS | 8 | DATPER | ||||
SECURITY_TYPE | Security Type ID | SWERTTYP | NUMC | 1 | TW20 | SAKTTYP | |||
ELIGIBLE | Eligibility indicator | SEC_ELIGIBLE | CHAR | 1 | ATXF1 | ||||
ELIGIBLE_AS_COLL | Indicator eligible as collateral | SEC_AS_COLL | CHAR | 1 | ATXF1 | ||||
ELIGIBLE_TO_SERVE | Eligible for premium reserve fund | SEC_TO_SERVE | CHAR | 1 | ATXF1 | ||||
ISSUE_START | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
SMOVERW | Possible custody type | SMOVERW | CHAR | 2 | Assigned to domain | SMOVERW | |||
SDEPOSTAT | Securities account statistics key | VVDEPOSTAT | NUMC | 2 | Assigned to domain | VVDEPOSTA | |||
SSTBE | Tax treatment indicator | SSTBE | CHAR | 1 | JANEI | ||||
SWPHGMPF | Securities trading law reporting obligation indicator | VVSWPHGMPF | CHAR | 1 | JANEI | ||||
JNACHR | Secondary loans ID | VVJNACHR | CHAR | 1 | JANE | ||||
CALC_BEGIN | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
NOMINAL_VALUE_S | Nominal Value per Stock (Independent of Currency) | VVBNEWE | DEC | 15(6) | VVKWKURS | ||||
FELLOW_PARTNER | Joint partner vote indicator | SEC_FELLOW_PARTNER | CHAR | 1 | ANKREUZ | ||||
CONDITION_VALID_FROM | Date Condition Effective from | DGUEL | DATS | 8 | DATUM | ||||
SECURITY_CATEGORY | General Security Classification | ALWPKL | CHAR | 3 | TW22 | ALWPKL | |||
BONDCLASS | Classification of bond | SWPKLASS | NUMC | 3 | TW01 | SWPKLASS | |||
NOMINAL_VALUE_B | Nominal Value | BNOMS_FWZZ | CURR | 13(2) | BWHR | ||||
TRADING_UNIT | Nominal per trading unit | BNHAE | CURR | 13(2) | BWHR | ||||
ISSUER_CALL | Issuer call date | DKEMI | DATS | 8 | DATUM | ||||
BONDHOLDER_CALL | Bondholder call date | DKOBL | DATS | 8 | DATUM | ||||
SECONDARY_LOANS | Secondary loans ID | VVJNACHR | CHAR | 1 | JANE | ||||
DRAWING | Drawing Indicator | SEC_JAUSL | CHAR | 1 | ATXF1 | ||||
DRAWING_DATE | Drawing date | DAUSL | DATS | 8 | DATUM | ||||
FINAL_DUE_DATE | End of Term | DELFZ | DATS | 8 | DATUM | ||||
INCLUSIVE_INDICATOR | Inclusive indicator | VVWSINCL | CHAR | 1 | XFELD | ||||
ISSUE_YIELD | Effective Interest Rate | TB_PYIELD | DEC | 10(7) | DECV3_7 | ||||
YIELD_METHOD | Effective Interest Method (Financial Mathematics) | SEFFMETH_NEW | NUMC | 1 | SEFFMETH_NEW | ||||
YIELD_FREQUENCY | Int.sttlmnt frequency for effective int.rate calc.in months | VVZVRHYEFF | NUMC | 3 | NUMC03 | ||||
INTEREST_CALC_METHOD | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
REPAYMENT_TYPE | Repayment Type Indicator | STILGART | NUMC | 1 | STILGART | ||||
CUTTING_DAYS | Number of cutting days | BATRT | NUMC | 3 | NUMC03 | ||||
DISCOUNTED | Discounted | SDISKO | CHAR | 1 | SDISKO | ||||
CALENDAR_WT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
ROUNDING_RULE | Rounding Rule | TPM_ROUNDING_RULE | CHAR | 4 | TRSC_ROUND_RULE | TPM_ROUNDING_RULE | |||
SET_NAME | Redemption Schedule Set | RDPT_SET_NAME | CHAR | 15 | Assigned to domain | RDPT_SET_NAME | RDPT_SET_NAME | RDPT_F4_SET | |
FACTORY_CALENDAR | Factory calendar | SKALID | CHAR | 2 | TFACD | WFCID | H_TFACD | ||
OPT_FUT_CATEGORY | Options/futures category | TI_SOFTYP | NUMC | 2 | T_SOFTYP | ||||
OPT_FUT_QUOTATION | Quotation type option/future | TI_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
MARGIN_TYPE | Margin type | TB_MARGART | CHAR | 5 | Assigned to domain | T_MARGART | |||
TICK_IN_PERCENT | Tick in percentage points | TI_PPTICK | DEC | 10(7) | DECV3_7 | ||||
TICK_AMOUNT | Tick as amount | TI_BETICK | CURR | 13(2) | WERTV7 | ||||
TICK_IN_POINTS | Tick in index points | TI_PITICK | DEC | 11(6) | T_PKTKUR | ||||
TICK_VALUE | Tick value | TI_BWTICK | CURR | 13(2) | WERTV7 | ||||
TICK_VALUE_FINE | Tick Value | TPM_BWTICK_FINE | DEC | 13(7) | DEC13_7 | ||||
TICK_CURRENCY | Tick Value Currency | TI_WWTICK | CUKY | 5 | TCURC | WAERS | |||
LAST_TRADING_DAY | Last trade date | TI_DLHAND | DATS | 8 | DATUM | ||||
SETTLEMENT_DAY | Settlement date | TI_DERFUE | DATS | 8 | DATUM | ||||
EXPIRY_DATE | Expiration date | TI_DVERF | DATS | 8 | DATUM | ||||
REFERENCE_DATE | Reference date | TI_DREFDAT | DATS | 8 | DATUM | ||||
LAST_TRADING_DAY_X | Last trade date | TI_XLHAND | CHAR | 10 | T_XDATUM | ||||
SETTLEMENT_DAY_X | Settlement date | TI_XERFUE | CHAR | 10 | T_XDATUM | ||||
EXPIRY_DATE_X | Expiration date | TI_XVERF | CHAR | 10 | T_XDATUM | ||||
BETICK_CTY_CUNIT | Currency unit | VVSRUNIT | CHAR | 5 | TZUNI | VVSRUNIT | |||
OPTION_CATEGORY | Indicator: Option Category | SOPTTYP | NUMC | 1 | SOPTTYP | ||||
TERM_FROM | Term from | DLAVO | DATS | 8 | DATUM | ||||
TERM_UPTO | Term to | DLABI | DATS | 8 | DATUM | ||||
EXERCISE_TYPE | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
EXERCISE_MIN | Exercise minimum | AMINDEST | DEC | 15(5) | ASTUECK | ||||
DENOMINATOR | Option ratio - Denominator | BOVNE | DEC | 9(4) | DEC5_4 | ||||
NUMERATOR | Option ratio - numerator | BOVZA | DEC | 9(4) | DEC5_4 | ||||
REFERENCE_UNITS | Reference units | VVBBEZEIN | CURR | 13(2) | BWHR | ||||
REFERENCE_CURRENCY | Reference unit currency | VVRBEZEIN | CUKY | 5 | TCURC | WAERS | |||
SETTLEMENT | Option Settlement Indicator | SVERROPT | NUMC | 1 | SVERROPT | ||||
UNDERLYING | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
UNDERLYING_TEXT | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
UNDERLYING2 | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
UNDERLYING2_TEXT | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
EXERCISE_PRICE | Exercise price | BBASPREI | CURR | 13(2) | BWHR | ||||
EXERCISE_CURRENCY | Exercise price currency | RWHRBAS | CUKY | 5 | TCURC | WAERS | |||
STOCK_CATEGORY | Stock category | SAKAR | NUMC | 1 | SAKAR | ||||
STOCK_FORM | Stock form indicator | SVBRE | NUMC | 1 | SVBRE | ||||
SHAREHOLDING_TYPE | Type of shareholding | SARTBET | NUMC | 2 | TW02 | SARTBET | |||
SHAREHOLDING_STRUCT | Details about structure of shareholding | SKONBET | NUMC | 2 | TW03 | SKONBET | |||
SHARES_OUTSTANDING | Number of stocks issued | AAAAKTIE | DEC | 12 | DEC12 | ||||
INPAYMENT_RATE | Pay-in rate | KZAHLAKT | DEC | 10(7) | DEC3_7 | ||||
PAYMENT_AMOUNT | Amount Deposited | BZAHLAKT | CURR | 10(2) | WHRBTRG | ||||
BALANCE_DATE | Balance payment date | DREST | DATS | 8 | DATUM | ||||
DIVIDEND_RIGHTS | Dividend rights per unit in percentage terms | PDIVBER | DEC | 10(7) | DEC3_7 | ||||
ENTITLED_FROM | Date from which entitled to dividends | DDBAB | DATS | 8 | DATUM | ||||
EXCHANGE_FROM | Swap period from | DTFVO | DATS | 8 | DATUM | ||||
EXCHANGE_TO | Swap period to | DTFBI | DATS | 8 | DATUM | ||||
EXCHANGE_NUMERATOR | Swap ratio - numerator | BTVZA | DEC | 9(4) | DEC5_4 | ||||
EXCHANGE_DENOMINATOR | Swap ratio - denominator | BTVNE | DEC | 9(4) | DEC5_4 | ||||
CLEARING_AMOUNT | Clearing amount for swap | BABTA | CURR | 10(2) | WHRBTRG | ||||
CLEARING_CURRENCY | Clearing amount currency | SWHRAUSG | CUKY | 5 | Assigned to domain | WAERS | |||
TRADING_UNTIL | Trading until | DTGBI | DATS | 8 | DATUM | ||||
PARTLY_PAYED | Partly paid stock | SEC_PARTLY_PAYED | CHAR | 1 | ANKREUZ | ||||
FUND_TYPE | Fund type indicator | SFOTY | NUMC | 1 | TW21 | SFOTY | |||
FUND_CATEGORY | Fund category indicator | VVSFOART | CHAR | 2 | VVSFOART | ||||
FUND_VOLUME | Fund volume | BFONVOL | CURR | 15(2) | WERT8 | ||||
PUBLIC_FUND | Public fund indicator | SEC_SOEFF | CHAR | 1 | ATXF1 | ||||
ISSUE_PREMIUM | Issue premium in percentage | PAUSG | DEC | 10(7) | DEC3_7 | ||||
FOREIGN_INVESTMENT_LAW | Foreign Investment Law indicator | SEC_SAING | CHAR | 1 | ATXF1 | ||||
ACCUMULATION | Reinvestment indicator | SEC_ACCUMULATION | CHAR | 1 | ANKREUZ | ||||
REINVESTMENT_DISCOUNT | Reinvestment discount percent | PWARB | DEC | 10(7) | DEC3_7 | ||||
COUPON_NUMBER | Dividend coupon number | RDIVNR | NUMC | 3 | NUM03 | ||||
SUB_PRICE | Underlying subscription price | BBPRU | CURR | 10(2) | VVBNENNW | ||||
SUB_CURRENCY | Subscription price currency | RWBZP | CUKY | 5 | Assigned to domain | WAERS | |||
SUB_NUMERATOR | Subscription ratio - Numerator | BBVHZ | DEC | 9(4) | DEC5_4 | ||||
SUB_DENOMINATOR | Subscription ratio - Denominator | BBVHN | DEC | 9(4) | DEC5_4 | ||||
SUB_PERIOD_FROM | Subscription period from | DBFRV | DATS | 8 | DATUM | ||||
SUB_PERIOD_UNTIL | Date subscription period until | DBFRB | DATS | 8 | DATUM | ||||
SUB_TRADING_FROM | Date of subscription rights trading from | DBHAV | DATS | 8 | DATUM | ||||
SUB_TRADING_UNTIL | Date of subscription rights trading until | DBHAB | DATS | 8 | DATUM | ||||
PRICE_REF_SHARE | Post Subscription Rights | KREAK | DEC | 15(6) | VVKWKURS | ||||
DIVIDEND_ADV_DIS | Advantage/disadvantage dividend of new stock | BVNJA | CURR | 10(2) | WHRBTRG | ||||
OBLIGATION_TO_OFFER | Obligation to offer for sale until | DANDPFL | DATS | 8 | DATUM | ||||
RIGHT_TO_OFFER | Right to offer until | DANDRE | DATS | 8 | DATUM | ||||
CONV_PERIOD_FROM | Conversion period from | DWAFV | DATS | 8 | DATUM | ||||
CONV_PERIOD_TO | Conversion period until | DWAFB | DATS | 8 | DATUM | ||||
CONV_RATIO_NUMERATOR | Conversion ratio - Numerator | BWAVZ | DEC | 9(4) | DEC5_4 | ||||
CONV_RATIO_DENOMINATOR | Conversion ratio - Denominator | BWAVN | DEC | 9(4) | DEC5_4 | ||||
CONV_PREMIUM | Premium when converting a convertible bond | BAUFP | CURR | 13(2) | BWHR | ||||
CURRENCY_MARKUP | Currency markup | RWAUF | CUKY | 5 | TCURC | WAERS | |||
CUM_EX_INDICATOR | Cum/ex indicator | SCUEX | NUMC | 1 | SCUEX | ||||
NUMBER_OF_WARRANTS | Number of warrants per nominal value | BOPHE | NUMC | 3 | NUM03 | ||||
SECURITY_INDEX | Securities Index | IDX | CHAR | 10 | INDEXD | CHAR10 | |||
INDEX_TEXT | Short name for ATAB tables | XKURZBEZ | CHAR | 15 | XKBEZ | ||||
INDEX_MARK | Index point per monetary unit | BINDEX | CURR | 13(2) | BWHR | ||||
INDEX_BASE | Index base | VVBASIS | DEC | 8(3) | DEC5_3 | ||||
INDEX_CURRENCY | Index currency | RINDWHR | CUKY | 5 | TCURC | WAERS | |||
BASIC_RATE | Basic rate | PBASKURS | DEC | 10(7) | DEC3_7 | ||||
SETTLEMENT_METHOD | Settlement Method Option | TI_SABRMET | CHAR | 1 | T_SABRMET | ||||
PUT_CALL_INDICATOR | Put/call indicator | TI_SPUTCAL | NUMC | 1 | T_SPUTCAL | ||||
SETTLEMENT_OPT | Settlement Indicator | SETTLFL | CHAR | 1 | SETTLFL | ||||
EXERCISE_TYPE_OPT | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
NUMBER_OF_UNITS | Units Underlying | FTI_UNITS_UL | DEC | 22(6) | TPM_UNITS | ||||
NOM_AMT_UL | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
NOM_CURRENCY_UL | Currency of nominal amount | SNWHR | CUKY | 5 | TCURC | WAERS | |||
PRODUCT_CATEGORY_REFERENCE | Product Category | SANLF | NUMC | 3 | Assigned to domain | VVSANLF | |||
SECURITY_REFERENCE | Security ID number | WP_RANL | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
STRIKE_AMOUNT | Strike as amount | TI_BSTRIKE | CURR | 13(2) | WERTV7 | ||||
STRIKE_CURRENCY | Strike Currency | TI_WSTRIKE | CUKY | 5 | TCURC | WAERS | |||
STRIKE_IN_PERCENT | Strike as inverted percentage notation | TI_IPSTRIK | DEC | 10(7) | DECV3_7 | ||||
STRIKE_IN_POINTS | Strike in points | TI_PKSTRIK | DEC | 9(4) | DEC5_4 | ||||
INDEX_POINT_VALUE | Value of an index point | TI_BPINDEX | CURR | 13(2) | WERTV7 | ||||
INDEX_P_CURRENCY | Index point currency | TI_WPINDEX | CUKY | 5 | TCURC | WAERS | |||
QUANTITY_OPT | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
QUANTITY_UNIT_OPT | Unit of measure | TRCO_COMM_UOM | UNIT | 3 | Assigned to domain | TRCO_COMM_UOM | |||
UNDERLYING_KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
UNDERLYING_KEYDATE_TXT | DCS Key Date Description | TBA_KEYDATE_TXT | CHAR | 40 | TEXT40 | ||||
UNDERLYING_DCSID | Derivative Contract Specification ID | TBA_DCSID_UNDERLYING | CHAR | 6 | Assigned to domain | TBA_DCSID | TBAH_DCS | ||
UNDERLYING_DCSID_TXT | Derivative Contract Specification Description | TBA_DCSID_TXT | CHAR | 40 | TEXT40 | ||||
NOMINAL_VALUE_F_X | Nominal value | TI_XNOMS | CHAR | 18 | CHAR18 | ||||
NOMINAL_CURRENCY | Nominal currency | RNWHR | CUKY | 5 | TCURC | WAERS | |||
PERCENTAGE_RATE | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
INTEREST_CALC_F | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
REF_INTEREST_RATE | Reference Interest Rate | SZSREF | CHAR | 10 | T056R | ZIREFKU | |||
REF_INTEREST_RATE_TEXT | Short Text for Reference Interest Rate | KUZITEXT | CHAR | 15 | TEXT15 | ||||
FINAL_DUE_DATE_F | Final due date | DENDF | DATS | 8 | DATUM | ||||
FINAL_DUE_DATE_F_X | Final due date | TI_XENDF | CHAR | 10 | T_XDATUM | ||||
NOMINAL_VALUE_F | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
BETICK_CTY | Tick Amount (Commodity) | TI_BETICK_COMMODITY | DEC | 13(7) | DEC13_7 | ||||
BWTICK_CTY | Tick Value (Commodity) | TI_BWTICK_COMMODITY | DEC | 13(7) | DEC13_7 | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
COMMODITY_NAME | Name of the Commodity | TPM_CTY_NAME | CHAR | 40 | TPM_CTY_NAME | ||||
CONTRACT_SIZE | Contract Size | TPM_CTY_CONTRACT_SIZE | QUAN | 13(3) | FTR_QUAN | ||||
CONTRACT_SZ_UNIT | Mengeneinheit der Kontraktgröße | TPM_CTY_CONTRACT_SIZE_UNIT | UNIT | 3 | Assigned to domain | TRCO_COMM_UOM | |||
QUANTITY | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
QUANTITY_UNIT | Unit of Measurement | MSEHI | UNIT | 3 | T006 | CUNIT | MEINS | ||
FIRST_NOTICE_DAY | First Notice Day | FIRST_NOTICE_DAY | DATS | 8 | FIRST_NOTICE_DAY | ||||
FIRST_NOTICE_DAY_X | First Notice Date | X_FIRST_NOT_DAY | CHAR | 10 | T_XDATUM | ||||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | Assigned to domain | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
DCSID_TXT | Derivative Contract Specification Description | TBA_DCSID_TXT | CHAR | 40 | TEXT40 | ||||
KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
KEYDATE_TXT | DCS Key Date Description | TBA_KEYDATE_TXT | CHAR | 40 | TEXT40 | ||||
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | Assigned to domain | TBA_MIC | TBA_MIC | TBAH_MIC | |
MIC_TXT | Market Identifier Code Description | TBA_MIC_TXT | CHAR | 40 | TEXT40 | ||||
ENTERED_BY | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
INITIAL_DATE | First Entered on | DERF | DATS | 8 | DATUM | ||||
INITIAL_TIME | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
INITIAL_SOURCE | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
EMPLOYEE_ID | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
LAST_EDIT_DATE | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
LAST_EDIT_TIME | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
LAST_EDIT_SOURCE | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
STATUS | Status of a security | SEC_STATUS | NUMC | 2 | SEC_STATUS | ||||
OBJECT_KEY | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
POOL_ID | Pool ID | VVPOOLID | CHAR | 13 | |||||
EXP_MAT_DATE | Expected End of Term | VVEXPMATDATE | DATS | 8 | DATE | ||||
POOL_CLASSIF | Asset Pool Classification | VVPOOLCL | NUMC | 3 | VWIRPPOOLCLASSIF | VVPOOLCL | |||
POOL_VOLUME | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
REINV_PERIOD | Reinvestment Period | TPM_REINV_PERIOD | DATS | 8 | DATS | ||||
TRANCHE_CLASSIF | Tranche Classification | VVTRANCHECL | NUMC | 3 | VWIRPTRANCLASSIF | VVTRANCHECL | |||
ATTRIBUTE_LI01 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWPT_ATTR_L | VWP_ATTR_LONG | |||
ATTRIBUTE_LI02 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWPT_ATTR_L | VWP_ATTR_LONG | |||
ATTRIBUTE_LI03 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWPT_ATTR_L | VWP_ATTR_LONG | |||
ATTRIBUTE_LI04 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWPT_ATTR_L | VWP_ATTR_LONG | |||
ATTRIBUTE_LI05 | Value of the Free Attribute (20 Characters) | VWP_ATTR_LONG | CHAR | 20 | VWPT_ATTR_L | VWP_ATTR_LONG | |||
ATTRIBUTE_SI01 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI02 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI03 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI04 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI05 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI06 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI07 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI08 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI09 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_SI10 | Value of the Free Attribute (5 Characters) | VWP_ATTR_SHORT | CHAR | 5 | VWPT_ATTR_S | VWP_ATTR_SHORT | |||
ATTRIBUTE_FR01 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_FR02 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_FR03 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_FR04 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_FR05 | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
ATTRIBUTE_DI01 | Value of the Free Attribute (Date) | VWP_ATTR_DATE | DATS | 8 | VWP_ATTR_DATE | ||||
ATTRIBUTE_DI02 | Value of the Free Attribute (Date) | VWP_ATTR_DATE | DATS | 8 | VWP_ATTR_DATE | ||||
ATTRIBUTE_CU01 | Value of the Free Attribute (Currency) | VWP_ATTR_CURR | CUKY | 5 | TCURC | WAERS | |||
ATTRIBUTE_CU02 | Value of the Free Attribute (Currency) | VWP_ATTR_CURR | CUKY | 5 | TCURC | WAERS | |||
ATTRIBUTE_DTFR | Value of the Free Attribute (Date) | VWP_ATTR_DATE | DATS | 8 | VWP_ATTR_DATE | ||||
ATTRIBUTE_DTTO | Value of the Free Attribute (Date) | VWP_ATTR_DATE | DATS | 8 | VWP_ATTR_DATE | ||||
.INCLU--AP | 0 | ||||||||
COVERAGE_ELIG | Coverage Eligibility Entry | /TRMKR/COVERAGE_ELIG | CHAR | 2 | /TRMKR/COVERAGE_ELIG | ||||
EMBD_DERIVATIVE | Embedded Derivative | /TRMKR/EMBD_DERIVATIVE | CHAR | 30 | /TRMKR/EMBD_DERIVATIVE | ||||
ORIG_ISSUE_CURR | Original Issue Currency | /TRMKR/ISSUE_CURR | CUKY | 5 | TCURC | WAERS | |||
QUOT_BREAKDOWN | Quotation Breakdown | /TRMKR/QUOT_BREAKDOWN | CHAR | 2 | /TRMKR/QUOT_BREAKDOWN | ||||
CONDITIONS | 0 | ||||||||
ADD_ISSUER | 0 | ||||||||
REFS | 0 | ||||||||
LISTINGS | 0 | ||||||||
INDICES | 0 | ||||||||
PERIODS | 0 | ||||||||
RIGHTS | 0 | ||||||||
SHARE_CAPITALS | 0 | ||||||||
INTERNAL | 0 | ||||||||
STATUS | Status of a security | SEC_STATUS | NUMC | 2 | SEC_STATUS | ||||
OBJECT_KEY | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
PARTLY_PAIDS | 0 | ||||||||
RATINGS | 0 | ||||||||
POOLDATA | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
POOL_ID | Pool ID | VVPOOLID | CHAR | 13 | |||||
CLASSIFICATION | Asset Pool Classification | VVPOOLCL | NUMC | 3 | VVPOOLCL | ||||
TOTAL_VOLUME | Nominal Amount | TPM_NOMINAL_AMT | CURR | 21(2) | TPM_AMOUNT | ||||
TOTAL_VOLUME_CUR | Nominal Currency | TPM_NOMINAL_CURR | CUKY | 5 | WAERS | ||||
REINV_PERIOD | Reinvestment Period | TPM_REINV_PERIOD | DATS | 8 | DATS | ||||
POOLRATING | 0 | ||||||||
POOLREMARK | 0 | ||||||||
TIERLEVEL | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure SECURITY_COMPLEX using ABAP code?
As SECURITY_COMPLEX 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 SECURITY_COMPLEX as there is no data to select.How to access SAP table SECURITY_COMPLEX
Within an ECC or HANA version of SAP you can also view further information about SECURITY_COMPLEX 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