SAP VTVBAR NPVs of OTC transactions Table
Overview
VTVBAR is a standard SAP S/4HANA table that stores NPVs of OTC transactions data. There are total 27 fields in the VTVBAR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTVBAR belongs to Market Risk Analyzer (FIN-FSCM-TRM-MR) module and is located in the package Applic. development R/3 Treasury risk simulation analysis (FTB).
In addition, following links provide an overview of foreign key relationships, if any, that link VTVBAR to other SAP tables and standard CDS views available based on VTVBAR table in S/4HANA 2020.
Techincal Settings of VTVBAR
Below are technical details of the table VTVBAR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTVBAR Fields
The following table gives you an overview of the fields available in VTVBAR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RANTYP | Contract Type | RANTYP | CHAR | 1 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| RFHA | Financial Transaction | TB_RFHA | VTBFHA | CHAR | 13 |
| RANLVD | Contract Number | RANL | CHAR | 13 | |
| OKUART | Price/NPV Type for OTC Transactions | TV_OKUART | ATVOK | CHAR | 3 |
| DATABS | Effective From | TB_DATAB | DATS | 8 | |
| BARWERT | Net Present Value of OTC Transaction | TV_BARWERT | CURR | 15 | |
| WBARWERT | Currency of Net Present Value | TV_WBARWE | TCURC | CUKY | 5 |
| INTRINSIC_VALUE | Intrinsic Value of an Option in Display Currency | TV_INTRINSIC_VALUE | CURR | 17 | |
| TIME_VALUE | Time Value of an Option in Display Currency | TV_TIME_VALUE | CURR | 17 | |
| CLEAN_PRICE | Clean Price in Display Currency | TV_CLEAN_PRICE | CURR | 17 | |
| BARWERT_IN | NPV of Incoming Side | TV_BARWERT_IN | CURR | 17 | |
| BARWERT_OUT | NPV of Outgoing Side | TV_BARWERT_OUT | CURR | 17 | |
| BARWERT_RF | Risk-Free NPV | TV_BARWERT_RF | CURR | 17 | |
| CVA | Credit Value Adjustment | FTBCVA_CVA | CURR | 21 | |
| DVA | Debit Value Adjustment | FTBCVA_DVA | CURR | 21 | |
| CVA_TYPE | Credit and Debit Value Adjustment Type | FTBCVA_CVA_TYPE | CHAR | 3 | |
| CREATE_NAME | Entered By | RERF | CHAR | 12 | |
| CREATE_DATE | First Entered On | DERF | DATS | 8 | |
| CREATE_TIME | Time of Creation | TERF | TIMS | 6 | |
| CREATE_TCODE | Transaction Code | TCODE | CHAR | 20 | |
| CHANGE_NAME | Employee ID | RBEAR | CHAR | 12 | |
| CHANGE_DATE | Last Edited On | DBEAR | DATS | 8 | |
| CHANGE_TIME | Last Edited At | TBEAR | TIMS | 6 | |
| CHANGE_TCODE | Transaction Code | TCODE | CHAR | 20 | |
| LOG_GUID | GUID of Log | TPM_LOG_GUID | RAW | 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 VTVBAR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTVBAR | BUKRS | 1: CN | T001 |
| VTVBAR | MANDT | 1: CN | T000 |
| VTVBAR | OKUART | 1: CN | ATVOK |
| VTVBAR | RFHA | 1: CN | VTBFHA |
| VTVBAR | WBARWERT | 1: CN | TCURC |