VTVSZS0MD SAP (Market Data) Structure details
Description: Market Data
Structure field list including key, data, relationships and ABAP select examples
VTVSZS0MD 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 "Market 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_VTVSZS0MD TYPE VTVSZS0MD.
The VTVSZS0MD table consists of various fields, each holding specific information or linking keys about Market Data data available in SAP. These include REFERENZ (Reference Interest Rate), DZINS (Interest rate date), NTAGE (Number of days), IGKM (Par rate).. 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 VTVSZS0MD 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 |
REFERENZ | Reference Interest Rate | REFERENZ | CHAR | 10 | Assigned to domain | ZIREFKU | |||
DZINS | Interest rate date | JBDZINS | DATS | 8 | DATUM | ||||
NTAGE | Number of days | JBNTAGEINT4 | INT4 | 10 | JBNTAGE | ||||
IGKM | Par rate | JBIGKM | DEC | 10(7) | DECV3_7 | ||||
IFR | Zero coupon | JBIFR | DEC | 10(7) | DECV3_7 | ||||
IZBAF | Zero bond discounting factor | JBIZBAF | DEC | 10(9) | DEC_1_9 | ||||
BSPRD_ID | Basis Spread ID | TYC_BSPRD_ID | CHAR | 15 | Assigned to domain | TYC_BSPRD_ID | |||
VOLDAT | Volatilities - Valid from Date | TV_VOLDAT | DATS | 8 | DATUM | ||||
VNAME | Volatility Name | TV_VNAME | CHAR | 15 | Assigned to domain | TV_VNAME | |||
PROFIL | Volatility Pofile | TV_PROFIL | CHAR | 15 | Assigned to domain | TV_PROFIL | |||
VOLA | Volatility | TV_VOLA | DEC | 11(7) | TV_VOLA | ||||
MEAN_REV | Reversion Rate for Yield Curve Model | FTBB_DTE_MEANREV | DEC | 16(8) | RM_VOLAMEANREV | ||||
DCURR | Date of Currency | TV_DATCR | DATS | 8 | |||||
FCURR | From Currency | TV_FCURR | CUKY | 5 | Assigned to domain | WAERS | |||
TCURR | To-Currency | TV_TCURR | CUKY | 5 | Assigned to domain | WAERS | |||
GUKURS | Bid rate | KURSG | DEC | 9(5) | EXCRT | UKURS | |||
BUKURS | Selling rate | KURSBR | DEC | 9(5) | EXCRT | UKURS | |||
KURSART | Exchange Rate Indicator for Market Valuation | JBRKURSA | CHAR | 2 | Assigned to domain | VVSKURSART | |||
KURSNAME | Security | JBRRANL | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | S_RM_VWPANLA_RANL |
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
FOUNDDAT | Date on which actual data found | TV_FOUNDDT | DATS | 8 | DATUM | ||||
KURSWERT | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
IDXART | Index Type | IDXART | CHAR | 2 | CHAR2 | ||||
IDX | Securities Index | IDX | CHAR | 10 | CHAR10 | ||||
DKURS | Rate/Price Date | DKURS | DATS | 8 | DATUM | ||||
IDXSTAND | Index value | IDXSTAND | DEC | 15(6) | VVPKTKUR | ||||
COMM_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
QUOTSRC | Quotation Source | TCR_CTY_QUOTSRC | CHAR | 2 | Assigned to domain | TCR_CTY_QUOTSRC | |||
QUOTTYPE | Commodity Quotation Type | TCR_CTY_QUOTTYPE | CHAR | 5 | Assigned to domain | TCR_CTY_QUOTTYPE | |||
FOUNDDATE | Date on which actual data found | TV_FOUNDDT | DATS | 8 | DATUM | ||||
PRICEQUOT | Price Quotation | CPET_PRICEQUOT | CURR | 15(2) | CPE_AMOUNT | ||||
QUOTCURR | Quotation Currency | CPET_QUOTCURR | CUKY | 5 | Assigned to domain | WAERS | |||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | Assigned to domain | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
DCSMIC | Market Identifier Code | TBA_MIC | CHAR | 4 | Assigned to domain | TBA_MIC | TBA_MIC | TBAH_MIC | |
DCSKEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE | ||||
DCSKEYDATETEXT | DCS Key Date Description | TBA_KEYDATE_TXT | CHAR | 40 | TEXT40 | ||||
DCSPRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
DCSPRICEDATE | Date of Price Quotation | TBA_PRICEDATE | DATS | 8 | DATUM | ||||
DCSPRICETIME | Time of Price Quotation | TBA_PRICETIME | TIMS | 6 | TIME | ||||
DCSTENOR | Time to Maturity | TBA_TENOR | CHAR | 10 | Assigned to domain | TBA_TENOR | TBAH_TENOR | ||
DCSPRICE | Quotation Price | TBA_PRICE | D34D | 31(14) | TBA_PRICE | ||||
DCSUOM | Quotation Unit of Measure | TBA_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DCSCPE_UOM | Commodity Pricing Engine Unit of Measure | TBA_CPEUOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DCSCURRENCY | Quotation Currency | TBA_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
FUTURE_ID | Security ID Number | VVRANLW | CHAR | 13 | Assigned to domain | ALPHA | WP_RANL | RAN | SECURITY_F4 |
EXCHANGE | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
PRICE_TYPE | Rate/Price Type - Treasury Instruments | TI_KURSART | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
FOUND_DATE | Market data found date for commodity futures | TPM_CTY_FOUND_DATE | DATS | 8 | |||||
PRICE_F | Field of type FLTP | FLOAT | FLTP | 16(16) | FLTP | ||||
PRICE | Price of Unit- or Percentage-Quoted Security | VVPKTKUR | DEC | 15(6) | VVPKTKUR | ||||
CURRENCY | Currency Key for Commodity Price | TCR_CTY_QUOTCURR | CUKY | 5 | Assigned to domain | WAERS | |||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | ||
PROVIDER | Provider of Commodity Market Data | TCR_CTY_PROVIDER | CHAR | 10 | Assigned to domain | TCR_CTY_PROVIDER | |||
QUOT_DATE | Quotation Date | TCR_CTY_QUOTDATE | DATS | 8 | DATUM | ||||
QUOT_TYPE | Commodity Quotation Type | TCR_CTY_QUOTTYPE | CHAR | 5 | Assigned to domain | TCR_CTY_QUOTTYPE | |||
PERIOD_START | Start of Price Period | TCR_CTY_PERIOD_START | DATS | 8 | DATUM | ||||
PERIOD_TYPE | Type of Price Period | TCR_CTY_PERIOD_TYPE | NUMC | 2 | TCR_CTY_PERIOD_TYPE | ||||
QUOT_VALUE | Quotation Value of Commodity | TCR_CTY_QUOTVALUE | DEC | 15(6) | VVPKTKUR | ||||
QUOT_UOM | Unit of Measure of Quotation | TCR_CTY_QUOT_UOM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
QUOT_CURR_UNIT | Currency Unit for Commodity | TCR_CTY_CURRUNIT | CHAR | 5 | Assigned to domain | VVSRUNIT | |||
ENTERED_BY | Entered by | TB_CRUSER | CHAR | 12 | SYCHAR12 | ||||
PERIOD_END | End of Price Period | TCR_CTY_PERIOD_END | DATS | 8 | DATUM | ||||
PERIOD_DESCR | Period Description | TPM_CTY_PERIOD_DESCR | CHAR | 10 | TPM_CTY_PERIOD_DESCR |
Key field | Non-key field |
How do I retrieve data from SAP structure VTVSZS0MD using ABAP code?
As VTVSZS0MD 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 VTVSZS0MD as there is no data to select.How to access SAP table VTVSZS0MD
Within an ECC or HANA version of SAP you can also view further information about VTVSZS0MD 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