SAP VTB_WEB_QUOTES FX Quotes Received Table
Overview
VTB_WEB_QUOTES is a standard SAP S/4HANA table that stores FX Quotes Received data. There are total 18 fields in the VTB_WEB_QUOTES table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTB_WEB_QUOTES belongs to Transaction Management (FIN-FSCM-TRM-TM-TR) module and is located in the package Treasury: Financial Transaction (FTTR).
In addition, following links provide an overview of foreign key relationships, if any, that link VTB_WEB_QUOTES to other SAP tables and standard CDS views available based on VTB_WEB_QUOTES table in S/4HANA 2020.
Techincal Settings of VTB_WEB_QUOTES
Below are technical details of the table VTB_WEB_QUOTES
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTB_WEB_QUOTES Fields
The following table gives you an overview of the fields available in VTB_WEB_QUOTES
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| SERVICE | FTR Web Service | FTR_WEB_SERVICE | VTB_WEB_SERV_URL | CHAR | 30 |
| REFER | Internal Reference | TB_REFER | CHAR | 16 | |
| BUYORSELL | Transaction Type | TX_XTRANSACTION_TYPE | CHAR | 1 | |
| PARTNER | Business Partner Number | BP_PARTNR_NEW | * | CHAR | 10 |
| VALUE_DATE | Value Date | TX_DVALUTA | CHAR | 10 | |
| TENOR | Tenor | TX_TENOR | CHAR | 2 | |
| CURRENCY1_ISO | ISO currency code | ISOCD | CHAR | 3 | |
| CURRENCY2_ISO | ISO currency code | ISOCD | CHAR | 3 | |
| AMOUNT1 | Payment Amount | BAPITB_BZBETR | DEC | 23 | |
| AMOUNT2 | Payment Amount | BAPITB_BZBETR | DEC | 23 | |
| RATE | Rate of Foreign Exchange Transaction | TB_KKURS | DEC | 13 | |
| SPOT | Spot Rate | TB_KKASSA | DEC | 13 | |
| FORWARD | Swap Rate | TB_KSWAP | DEC | 13 | |
| ACTDATE | Contract conclusion date | TB_XVTRAB | CHAR | 10 | |
| ACTTIME | CHAR08 | CHAR08 | CHAR | 8 | |
| RESPONSETIME | Character field of length 6 | CHAR6 | CHAR | 6 | |
| EXT_REFERENCE | External Reference | TB_NORDEXT | CHAR | 16 |
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_WEB_QUOTES
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTB_WEB_QUOTES | SERVICE | : | VTB_WEB_SERV_URL |