TPMS_OF SAP (Class data for listed options and futures) Structure details

Dictionary Type: Structure
Description: Class data for listed options and futures




ABAP Code to SELECT data from TPMS_OF
Related tables to TPMS_OF
Access table TPMS_OF




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
MANDTClient MANDTCLNT3MANDT
RANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
SANLFProduct Category SANLFNUMC3VVSANLF
SSTATIStatus of a security SEC_STATUSNUMC2SEC_STATUS
RANLALT1RANLALT1 RANLALT1SCHAR13CHAR13SRAN
RANLALT2Alternative identification 2 RANLALT2SCHAR13CHAR13SRAN
GSARTProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
SBRSCHIndustry key BRSCHCHAR4BRSCH
SWERTTYPSecurity Type ID SWERTTYPNUMC1SAKTTYP
SBOERNOTIndicator: Listed on an Exchange SBOERNOTCHAR1JANEI
WLOMBIndicator eligible as collateral WLOMBCHAR1JANEI
JDECKRegulatory reporting BPV (hedge fund Y/N) JDECKCHAR1JANEI
WPFANIndicator pledgeable WPFANCHAR1JANEI
SSTBETax treatment indicator SSTBECHAR1JANEI
LOEVMDeletion Indicator LOEVMCHAR1XFELD
JABMIJoint partner vote indicator JABMICHAR1JANEI
XALKZShort name XALKZCHAR15XKBEZ
XALLBLong name XALLBCHAR60XLBEZ
REPKEIssuer Identity Key REPKE_NEWCHAR10ALPHABU_PARTNERBPABUPA
BEMPREISIssue Price BEMPREISCURR10(2) VVBNENNW
REWHRIssue currency REWHRCUKY5WAERS
PEMKURSIssue rate in percent PEMKURSDEC10(7) DEC3_7
SNOTIQuotation Indicator SNOTINUMC1SNOTI
PKUABPrice deviation in percent PKUABDEC10(7) DEC3_7
BKUABAbsolute price deviation BKUABCURR10(2) WHRBTRG
DANDPFLObligation to offer for sale until DANDPFLDATS8DATUM
DANDRERight to offer until DANDREDATS8DATUM
SOBJEKTInternal key for object VVKEYOBJCHAR10VVKEY
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
SROLEXTGeneral Security Classification ALWPKLCHAR3ALWPKL
VVSLOEKZDeletion indicator VVSLOEKZNUMC1VVSLOEKZ
JMUENDELEligibility indicator VVJMUENDCHAR1JANEI
SMOVERWPossible custody type SMOVERWCHAR2SMOVERW
SIHERKVersion Number Component CHAR2CHAR2CHAR2
KBEMPREISIssue price independent of currency VVKBEMPRDEC15(6) VVKWKURS
SDEPOSTATSecurities account statistics key VVDEPOSTATNUMC2VVDEPOSTA
SFUNDIIndicator: Funded VVSFUNDICHAR1JANEI
SWPHGMPFSecurities trading law reporting obligation indicator VVSWPHGMPFCHAR1JANEI
RISINInternational securities ID number (no longer used) VVRISINCHAR13RISIN
INSTITUTEInstitute Providing Credit Standing Information BP_SOL_INSCHAR4BP_SOL_INS
RATINGRating BP_RATINGCHAR3BP_RATING
PRICE_INDEXName of Price Index TIDX_INDEX_NAMECHAR15TIDX_INDEX_NAME
PRICE_IDX_BDATEPrice Index Base Date TIDX_INDEX_BASE_DATEDATS8DATPER
.INCLU--AP 0
DERI 0
MANDTClient MANDTCLNT3MANDT
RANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
SGSARTProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
DJAHRExpiration year TI_DJAHRNUMC4GJAHRGJAHR
DMONATExpiration month TI_DMOANTNUMC2T_DMOANT
SOFTYPOptions/futures category TI_SOFTYPNUMC2T_SOFTYP
SOPTTYPOriginal option category (on closing) TV_OPTTYPNUMC3T_OPTTYP
SABRMETSettlement Method Option TI_SABRMETCHAR1T_SABRMET
SMARGARTMargin type TB_MARGARTCHAR5T_MARGART
SNOTTYPEQuotation type option/future TI_NOTTYPECHAR1T_NOTTYPE
PPTICKTick in percentage points TI_PPTICKDEC10(7) DECV3_7
BETICKTick as amount TI_BETICKCURR13(2) WERTV7
PITICKTick in index points TI_PITICKDEC11(6) T_PKTKUR
BWTICKTick value TI_BWTICKCURR13(2) WERTV7
WWTICKTick Value Currency TI_WWTICKCUKY5WAERS
SPUTCALLPut/call indicator TI_SPUTCALNUMC1T_SPUTCAL
SSETTLFLSettlement indicator TI_SETTLFLCHAR1T_SETTLFL
SOPTAUSExercise Type (American or European) SOPTAUSNUMC1SOPTAUS
DVERFALLExpiration date TI_DVERFDATS8DATUM
DLHANDELLast trade date TI_DLHANDDATS8DATUM
DERFUELLSettlement date TI_DERFUEDATS8DATUM
SKALIDFactory calendar SKALIDCHAR2WFCIDH_TFACD
BNOMSNominal value BNOMSCURR13(2) BWHR
RNWHRNominal currency RNWHRCUKY5WAERS
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
SZSREFReference Interest Rate SZSREFCHAR10ZIREFKU
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
DENDFFinal due date DENDFDATS8DATUM
ASTUECKNumber of units for unit-quoted securities ASTUECKDEC15(5) ASTUECK
URANLSecurity ID Number VVRANLWCHAR13ALPHAWP_RANLRANSECURITY_F4
UINDEXSecurities Index IDXCHAR10CHAR10
BPINDEXValue of an index point TI_BPINDEXCURR13(2) WERTV7
WPINDEXIndex point currency TI_WPINDEXCUKY5WAERS
BSTRIKEStrike as amount TI_BSTRIKECURR13(2) WERTV7
WSTRIKEStrike Currency TI_WSTRIKECUKY5WAERS
PKSTRIKEStrike in points TI_PKSTRIKDEC9(4) DEC5_4
IPSTRIKEStrike as inverted percentage notation TI_IPSTRIKDEC10(7) DECV3_7
.INCLU--AP 0
DEBEGIssue start date DEBEGDATS8DATUM
BNWHRNominal amount BNWHRCURR13(2) WERTV7
SNWHRCurrency of nominal amount SNWHRCUKY5WAERS
BWTICK_FINETick Value TPM_BWTICK_FINEDEC13(7) DEC13_7
BETICK_CTYTick Amount (Commodity) TI_BETICK_COMMODITYDEC13(7) DEC13_7
BWTICK_CTYTick Value (Commodity) TI_BWTICK_COMMODITYDEC13(7) DEC13_7
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
CONTRACT_SIZEContract Size TPM_CTY_CONTRACT_SIZEQUAN13(3) FTR_QUAN
CONTRACT_SZ_UNITMengeneinheit der Kontraktgröße TPM_CTY_CONTRACT_SIZE_UNITUNIT3TRCO_COMM_UOM
QUANTITYQuantity FTR_QUANQUAN13(3) FTR_QUAN
QUANTITY_UNITUnit of measure TRCO_COMM_UOMUNIT3TRCO_COMM_UOM
FIRST_NOTICE_DAYFirst Notice Day FIRST_NOTICE_DAYDATS8FIRST_NOTICE_DAY
BETICK_CTY_CUNITCurrency unit VVSRUNITCHAR5VVSRUNIT
DCSIDDerivative Contract Specification ID TBA_DCSIDCHAR6TBA_DCSIDTBA_DCSIDTBAH_DCS
KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE
MICMarket Identifier Code TBA_MICCHAR4TBA_MICTBA_MICTBAH_MIC
UNDERLYING_KEYDATEDCS Key Date TBA_KEYDATEDATS8DATE

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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!