SAP VTB_FX_WEB_QUOTE FX Quotes for Transfer as Transaction Table
Overview
VTB_FX_WEB_QUOTE is a standard SAP S/4HANA table that stores FX Quotes for Transfer as Transaction data. There are total 34 fields in the VTB_FX_WEB_QUOTE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTB_FX_WEB_QUOTE 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_FX_WEB_QUOTE to other SAP tables and standard CDS views available based on VTB_FX_WEB_QUOTE table in S/4HANA 2020.
Techincal Settings of VTB_FX_WEB_QUOTE
Below are technical details of the table VTB_FX_WEB_QUOTE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTB_FX_WEB_QUOTE Fields
The following table gives you an overview of the fields available in VTB_FX_WEB_QUOTE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| SERVICE | FTR Web Service | FTR_WEB_SERVICE | CHAR | 30 | |
| QUOTE_ID | Internal Reference | TB_REFER | CHAR | 16 | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | |
| GSART_SFHAART | CHAR08 | CHAR08 | CHAR | 8 | |
| PARTNER | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | |
| ID | Character Field with Length 10 | CHAR10 | CHAR | 10 | |
| BUYORSELL | Transaction Type | TX_XTRANSACTION_TYPE | CHAR | 1 | |
| REFER | Internal Reference | TB_REFER | CHAR | 16 | |
| RATE | Rate of Foreign Exchange Transaction | TB_KKURS | DEC | 13 | |
| SPOT | Spot Rate | TB_KKASSA | DEC | 13 | |
| CUR_PAIR | Character Field with Length 10 | CHAR10 | CHAR | 10 | |
| INV_RATE | Rate of Foreign Exchange Transaction | TB_KKURS | DEC | 13 | |
| INV_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 | |
| CURRENCY1_ISO | ISO currency code | ISOCD | CHAR | 3 | |
| CHAR_AMOUNT1 | Amount as Text Field | TX_XBZBETR | CHAR | 18 | |
| CURRENCY2_ISO | ISO currency code | ISOCD | CHAR | 3 | |
| CHAR_AMOUNT2 | Amount as Text Field | TX_XBZBETR | CHAR | 18 | |
| VALUE_DATE | Value Date | TX_DVALUTA | CHAR | 10 | |
| TENOR | Tenor | TX_TENOR | CHAR | 2 | |
| CHAR_RATE | Text field length 14 | CHAR14 | CHAR | 14 | |
| CHAR_SPOT | Text field length 14 | CHAR14 | CHAR | 14 | |
| CHAR_FORWARD | Text field length 14 | CHAR14 | CHAR | 14 | |
| CURRENCY1 | Transaction Currency | TB_WGSCHFT | * | CUKY | 5 |
| CURRENCY2 | Transaction Currency | TB_WGSCHFT | * | CUKY | 5 |
| AMOUNT1 | Payment Amount | BAPITB_BZBETR | DEC | 23 | |
| AMOUNT2 | Payment Amount | BAPITB_BZBETR | DEC | 23 | |
| CALC_CURRENCY | ISO currency code | ISOCD | CHAR | 3 | |
| CALC_AMOUNT | Amount as Text Field | TX_XBZBETR | CHAR | 18 | |
| WEB_SERVICE | FTR Web Service | FTR_WEB_SERVICE | CHAR | 30 |
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_FX_WEB_QUOTE