TPMS_OF SAP (Class data for listed options and futures) Structure details
Description: Class data for listed options and futures
Structure field list including key, data, relationships and ABAP select examples
TPMS_OF 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 "Class data for listed options and futures" 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_TPMS_OF TYPE TPMS_OF.
The TPMS_OF table consists of various fields, each holding specific information or linking keys about Class data for listed options and futures data available in SAP. These include MANDT (Client), RANL (Security ID Number), SANLF (Product Category), SSTATI (Status of a security).. 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 TPMS_OF 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 |
ANLA | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Security ID Number | VVRANLW | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
SANLF | Product Category | SANLF | NUMC | 3 | VVSANLF | ||||
SSTATI | Status of a security | SEC_STATUS | NUMC | 2 | SEC_STATUS | ||||
RANLALT1 | RANLALT1 | RANLALT1S | CHAR | 13 | CHAR13S | RAN | |||
RANLALT2 | Alternative identification 2 | RANLALT2S | CHAR | 13 | CHAR13S | RAN | |||
GSART | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
SBRSCH | Industry key | BRSCH | CHAR | 4 | BRSCH | ||||
SWERTTYP | Security Type ID | SWERTTYP | NUMC | 1 | SAKTTYP | ||||
SBOERNOT | Indicator: Listed on an Exchange | SBOERNOT | CHAR | 1 | JANEI | ||||
WLOMB | Indicator eligible as collateral | WLOMB | CHAR | 1 | JANEI | ||||
JDECK | Regulatory reporting BPV (hedge fund Y/N) | JDECK | CHAR | 1 | JANEI | ||||
WPFAN | Indicator pledgeable | WPFAN | CHAR | 1 | JANEI | ||||
SSTBE | Tax treatment indicator | SSTBE | CHAR | 1 | JANEI | ||||
LOEVM | Deletion Indicator | LOEVM | CHAR | 1 | XFELD | ||||
JABMI | Joint partner vote indicator | JABMI | CHAR | 1 | JANEI | ||||
XALKZ | Short name | XALKZ | CHAR | 15 | XKBEZ | ||||
XALLB | Long name | XALLB | CHAR | 60 | XLBEZ | ||||
REPKE | Issuer Identity Key | REPKE_NEW | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
BEMPREIS | Issue Price | BEMPREIS | CURR | 10(2) | VVBNENNW | ||||
REWHR | Issue currency | REWHR | CUKY | 5 | WAERS | ||||
PEMKURS | Issue rate in percent | PEMKURS | DEC | 10(7) | DEC3_7 | ||||
SNOTI | Quotation Indicator | SNOTI | NUMC | 1 | SNOTI | ||||
PKUAB | Price deviation in percent | PKUAB | DEC | 10(7) | DEC3_7 | ||||
BKUAB | Absolute price deviation | BKUAB | CURR | 10(2) | WHRBTRG | ||||
DANDPFL | Obligation to offer for sale until | DANDPFL | DATS | 8 | DATUM | ||||
DANDRE | Right to offer until | DANDRE | DATS | 8 | DATUM | ||||
SOBJEKT | Internal key for object | VVKEYOBJ | CHAR | 10 | VVKEY | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
SROLEXT | General Security Classification | ALWPKL | CHAR | 3 | ALWPKL | ||||
VVSLOEKZ | Deletion indicator | VVSLOEKZ | NUMC | 1 | VVSLOEKZ | ||||
JMUENDEL | Eligibility indicator | VVJMUEND | CHAR | 1 | JANEI | ||||
SMOVERW | Possible custody type | SMOVERW | CHAR | 2 | SMOVERW | ||||
SIHERK | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
KBEMPREIS | Issue price independent of currency | VVKBEMPR | DEC | 15(6) | VVKWKURS | ||||
SDEPOSTAT | Securities account statistics key | VVDEPOSTAT | NUMC | 2 | VVDEPOSTA | ||||
SFUNDI | Indicator: Funded | VVSFUNDI | CHAR | 1 | JANEI | ||||
SWPHGMPF | Securities trading law reporting obligation indicator | VVSWPHGMPF | CHAR | 1 | JANEI | ||||
RISIN | International securities ID number (no longer used) | VVRISIN | CHAR | 13 | RISIN | ||||
INSTITUTE | Institute Providing Credit Standing Information | BP_SOL_INS | CHAR | 4 | BP_SOL_INS | ||||
RATING | Rating | BP_RATING | CHAR | 3 | BP_RATING | ||||
PRICE_INDEX | Name of Price Index | TIDX_INDEX_NAME | CHAR | 15 | TIDX_INDEX_NAME | ||||
PRICE_IDX_BDATE | Price Index Base Date | TIDX_INDEX_BASE_DATE | DATS | 8 | DATPER | ||||
.INCLU--AP | 0 | ||||||||
DERI | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
RANL | Security ID Number | VVRANLW | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
SGSART | Product Type | VVSART | CHAR | 3 | VVSART | SAN | VVSART_APPL_BAS | ||
DJAHR | Expiration year | TI_DJAHR | NUMC | 4 | GJAHR | GJAHR | |||
DMONAT | Expiration month | TI_DMOANT | NUMC | 2 | T_DMOANT | ||||
SOFTYP | Options/futures category | TI_SOFTYP | NUMC | 2 | T_SOFTYP | ||||
SOPTTYP | Original option category (on closing) | TV_OPTTYP | NUMC | 3 | T_OPTTYP | ||||
SABRMET | Settlement Method Option | TI_SABRMET | CHAR | 1 | T_SABRMET | ||||
SMARGART | Margin type | TB_MARGART | CHAR | 5 | T_MARGART | ||||
SNOTTYPE | Quotation type option/future | TI_NOTTYPE | CHAR | 1 | T_NOTTYPE | ||||
PPTICK | Tick in percentage points | TI_PPTICK | DEC | 10(7) | DECV3_7 | ||||
BETICK | Tick as amount | TI_BETICK | CURR | 13(2) | WERTV7 | ||||
PITICK | Tick in index points | TI_PITICK | DEC | 11(6) | T_PKTKUR | ||||
BWTICK | Tick value | TI_BWTICK | CURR | 13(2) | WERTV7 | ||||
WWTICK | Tick Value Currency | TI_WWTICK | CUKY | 5 | WAERS | ||||
SPUTCALL | Put/call indicator | TI_SPUTCAL | NUMC | 1 | T_SPUTCAL | ||||
SSETTLFL | Settlement indicator | TI_SETTLFL | CHAR | 1 | T_SETTLFL | ||||
SOPTAUS | Exercise Type (American or European) | SOPTAUS | NUMC | 1 | SOPTAUS | ||||
DVERFALL | Expiration date | TI_DVERF | DATS | 8 | DATUM | ||||
DLHANDEL | Last trade date | TI_DLHAND | DATS | 8 | DATUM | ||||
DERFUELL | Settlement date | TI_DERFUE | DATS | 8 | DATUM | ||||
SKALID | Factory calendar | SKALID | CHAR | 2 | WFCID | H_TFACD | |||
BNOMS | Nominal value | BNOMS | CURR | 13(2) | BWHR | ||||
RNWHR | Nominal currency | RNWHR | CUKY | 5 | WAERS | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
SZSREF | Reference Interest Rate | SZSREF | CHAR | 10 | ZIREFKU | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DENDF | Final due date | DENDF | DATS | 8 | DATUM | ||||
ASTUECK | Number of units for unit-quoted securities | ASTUECK | DEC | 15(5) | ASTUECK | ||||
URANL | Security ID Number | VVRANLW | CHAR | 13 | ALPHA | WP_RANL | RAN | SECURITY_F4 | |
UINDEX | Securities Index | IDX | CHAR | 10 | CHAR10 | ||||
BPINDEX | Value of an index point | TI_BPINDEX | CURR | 13(2) | WERTV7 | ||||
WPINDEX | Index point currency | TI_WPINDEX | CUKY | 5 | WAERS | ||||
BSTRIKE | Strike as amount | TI_BSTRIKE | CURR | 13(2) | WERTV7 | ||||
WSTRIKE | Strike Currency | TI_WSTRIKE | CUKY | 5 | WAERS | ||||
PKSTRIKE | Strike in points | TI_PKSTRIK | DEC | 9(4) | DEC5_4 | ||||
IPSTRIKE | Strike as inverted percentage notation | TI_IPSTRIK | DEC | 10(7) | DECV3_7 | ||||
.INCLU--AP | 0 | ||||||||
DEBEG | Issue start date | DEBEG | DATS | 8 | DATUM | ||||
BNWHR | Nominal amount | BNWHR | CURR | 13(2) | WERTV7 | ||||
SNWHR | Currency of nominal amount | SNWHR | CUKY | 5 | WAERS | ||||
BWTICK_FINE | Tick Value | TPM_BWTICK_FINE | DEC | 13(7) | DEC13_7 | ||||
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 | ||
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 | TRCO_COMM_UOM | ||||
QUANTITY | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
QUANTITY_UNIT | Unit of measure | TRCO_COMM_UOM | UNIT | 3 | TRCO_COMM_UOM | ||||
FIRST_NOTICE_DAY | First Notice Day | FIRST_NOTICE_DAY | DATS | 8 | FIRST_NOTICE_DAY | ||||
BETICK_CTY_CUNIT | Currency unit | VVSRUNIT | CHAR | 5 | VVSRUNIT | ||||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | TBA_DCSID | TBA_DCSID | TBAH_DCS | ||
KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | TBA_MIC | TBA_MIC | TBAH_MIC | ||
UNDERLYING_KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE |
Key field | Non-key field |
How do I retrieve data from SAP structure TPMS_OF using ABAP code?
As TPMS_OF 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 TPMS_OF as there is no data to select.How to access SAP table TPMS_OF
Within an ECC or HANA version of SAP you can also view further information about TPMS_OF 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