SAP VTB_MARKET Datafeed: Market data Table
Overview
VTB_MARKET is a standard SAP S/4HANA table that stores Datafeed: Market data data. There are total 50 fields in the VTB_MARKET table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTB_MARKET belongs to Basic Functions (FIN-FSCM-TRM-BF) module and is located in the package Treasury: Datafeed (FTDF).
In addition, following links provide an overview of foreign key relationships, if any, that link VTB_MARKET to other SAP tables and standard CDS views available based on VTB_MARKET table in S/4HANA 2020.
Techincal Settings of VTB_MARKET
Below are technical details of the table VTB_MARKET
- Buffering switched on
- Single entries of table were buffered
- Storage type is Column Store
List of VTB_MARKET Fields
The following table gives you an overview of the fields available in VTB_MARKET
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| SCLASS | Datafeed: Instrument Class | TB_CLASS | VTBDFC | CHAR | 2 |
| RKEY1 | Datafeed: Key 1 (Extended) | TB_KEY1 | CHAR | 15 | |
| RKEY2 | Datafeed: Key 2 | TB_KEY2 | CHAR | 15 | |
| SINSTRUMNT | Datafeed: Rate Type | TB_INSTR | CHAR | 5 | |
| RFEEDNAME | Market Data: Data Provider | TB_DFNAME | VTBDFF | CHAR | 10 |
| RZUSATZ | Datafeed: Additional Key | TB_ZUSATZ | CHAR | 10 | |
| SMETACLASS | Datafeed: Meta instrument class | TB_MCLASS | CHAR | 2 | |
| SCLASS2 | Datafeed: Instrument Class | TB_CLASS | VTBDFC | CHAR | 2 |
| RKEY12 | Datafeed: Key 1 (Extended) | TB_KEY1 | CHAR | 15 | |
| RKEY22 | Datafeed: Key 2 | TB_KEY2 | CHAR | 15 | |
| SSTATS | Datafeed: Status of market date | TB_STATS | CHAR | 2 | |
| SPOOLID | Datafeed: Spool- / Workflow identifier | TB_SPOOLID | DEC | 15 | |
| ERROR | Datafeed: Error message | TB_ERROR | CHAR | 80 | |
| RUPDHIST | Datafeed: Flag for refreshing R/3 tables | TB_UPDHIST | CHAR | 1 | |
| RDONE | Datafeed: Flag for update indicator | TB_DONE | CHAR | 1 | |
| RSUPID | Datafeed: Supplier ID | TB_SUPID | CHAR | 10 | |
| RCONID | Datafeed: Contributor ID | TB_CONID | CHAR | 10 | |
| RCONCN | Datafeed: contributor country | TB_CONCN | CHAR | 5 | |
| DDATE | Datafeed: Value Date in SAP Format | TB_SDATE | DATS | 8 | |
| TTIME | Datafeed: Time of Value (SAP Format) | TB_STIME | TIMS | 6 | |
| VALUE | Datafeed: Value of requested property | TB_VALUE | CHAR | 20 | |
| CURRENCY | Datafeed: Currency key | TB_CURR | CHAR | 5 | |
| FFACT | Datafeed: Factor for Units of From-Currency | TB_FFACT | DEC | 9 | |
| TFACT | Datafeed: Factor for Units of To-Currency | TB_TFACT | DEC | 9 | |
| MKIND | Datafeed: Price notation for security prices | TB_MKIND | CHAR | 5 | |
| RINID1 | Datafeed: Instrument Name | TB_INID1 | CHAR | 20 | |
| RINID2 | Datafeed: Data Source | TB_INID2 | CHAR | 15 | |
| SPRPTY | Market Data: Instrument Property | TB_PRPTY | CHAR | 15 | |
| UNAME | User Name | SYUNAME | CHAR | 12 | |
| UKURSART1 | Datafeed: Rate Type | TB_INSTR | CHAR | 5 | |
| UKURSART2 | Datafeed: Rate Type | TB_INSTR | CHAR | 5 | |
| ZEITRAUM | Datafeed: period | TB_ZEITR | CHAR | 4 | |
| KONFIDENZ | Datafeed: confidence level | TB_KONFID | CHAR | 6 | |
| DECAY | Datafeed: decay factor | TB_DECAY | CHAR | 6 | |
| REALTIME | Datafeed: Indicator for real-time data supply | TB_REALTME | CHAR | 1 | |
| LIMIT | Datafeed: Rate Monitoring | TB_LIMIT | INT1 | 3 | |
| SPOOLID2 | Datafeed: Spool- / Workflow identifier | TB_SPOOLID | DEC | 15 | |
| TIMEDEP | Datafeed: Indicator for intraday rates/prices | TB_TIMEDEP | CHAR | 1 | |
| MQUOTE | Datafeed: Indirect (x) or Direct Quotation ( ) | TB_QUOTE | CHAR | 1 | |
| CCY_UNIT | Datafeed: Currency | TB_CCYUNIT | CHAR | 5 | |
| UOM | Datafeed: Unit of Measurement | TB_UOM | CHAR | 3 | |
| PUT_CALL_IND | Datafeed: Put/Call Indicator for Listed Options | TB_PUTCALL | CHAR | 1 | |
| STRIKE_AMOUNT | Datafeed: Strike Price for Listed Options | TB_STRIKE_AMOUNT | CHAR | 20 | |
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 20 | |
| MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | |
| KEYDATE | Maturity Key Date | TBA_KEYDATE | DATS | 8 | |
| TENOR | Time to Maturity | TBA_TENOR | CHAR | 10 | |
| PRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 2 | |
| RREMARK | Datafeed: Explanations | TB_REMARK | CHAR | 50 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTB_MARKET
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTB_MARKET | MANDT | 1: CN | T000 |
| VTB_MARKET | RFEEDNAME | : | VTBDFF |
| VTB_MARKET | SCLASS | 1: CN | VTBDFC |
| VTB_MARKET | SCLASS2 | 1: CN | VTBDFC |