SAP Table VTVBAR
NPVs of OTC transactions
VTVBAR (NPVs of OTC transactions) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VTVBAR to other SAP tables.
VTVBAR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||||||||
| RANTYP | Contract Type | RANTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||
| RFHA | Financial Transaction | TB_RFHA | VTBFHA | CHAR | 13 | 0 | ||||||||||||||||||||||||||||||||
| RANLVD | Contract Number | RANL | CHAR | 13 | 0 | |||||||||||||||||||||||||||||||||
| OKUART | Price/NPV Type for OTC Transactions | TV_OKUART | ATVOK | CHAR | 3 | 0 | ||||||||||||||||||||||||||||||||
| DATABS | Effective from | TB_DATAB | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
| BARWERT | Net present value of OTC transaction | TV_BARWERT | CURR | 15 | 2 | |||||||||||||||||||||||||||||||||
| WBARWERT | Currency of net present value | TV_WBARWE | TCURC | CUKY | 5 | 0 | ||||||||||||||||||||||||||||||||
| INTRINSIC_VALUE | Intrinsic Value of an Option in Display Currency | TV_INTRINSIC_VALUE | CURR | 17 | 2 | |||||||||||||||||||||||||||||||||
| TIME_VALUE | Time Value of an Option in Display Currency | TV_TIME_VALUE | CURR | 17 | 2 | |||||||||||||||||||||||||||||||||
| CLEAN_PRICE | Clean price in display currency | TV_CLEAN_PRICE | CURR | 17 | 2 | |||||||||||||||||||||||||||||||||
| BARWERT_IN | NPV of Incoming Side | TV_BARWERT_IN | CURR | 17 | 2 | |||||||||||||||||||||||||||||||||
| BARWERT_OUT | NPV of Outgoing Side | TV_BARWERT_OUT | CURR | 17 | 2 | |||||||||||||||||||||||||||||||||
| BARWERT_RF | Risk Free NPV | TV_BARWERT_RF | CURR | 17 | 2 | |||||||||||||||||||||||||||||||||
| CREATE_NAME | Entered by | RERF | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||||
| CREATE_DATE | First Entered on | DERF | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
| CREATE_TIME | Time of Initial Entry | TERF | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||||
| CREATE_TCODE | Transaction Code | TCODE | CHAR | 20 | 0 | |||||||||||||||||||||||||||||||||
| CHANGE_NAME | Employee ID | RBEAR | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||||
| CHANGE_DATE | Last Edited on | DBEAR | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
| CHANGE_TIME | Last Edited at | TBEAR | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||||
| CHANGE_TCODE | Transaction Code | TCODE | CHAR | 20 | 0 | |||||||||||||||||||||||||||||||||
| LOG_GUID | GUID of Log | TPM_LOG_GUID | RAW | 16 | 0 | |||||||||||||||||||||||||||||||||
| CHECK_SUM | Hash Value (160 Bits) | HASH160X | RAW | 20 | 0 | |||||||||||||||||||||||||||||||||
VTVBAR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| VTVBAR | BUKRS | VTVBAR | MANDT | T001 | Company Codes | MANDT |
| VTVBAR | BUKRS | VTVBAR | BUKRS | T001 | Company Codes | BUKRS |
| VTVBAR | MANDT | VTVBAR | MANDT | T000 | Clients | MANDT |
| VTVBAR | OKUART | VTVBAR | MANDT | ATVOK | Rate types for OTC NPVs | MANDT |
| VTVBAR | OKUART | VTVBAR | OKUART | ATVOK | Rate types for OTC NPVs | OKUART |
| VTVBAR | RFHA | VTVBAR | MANDT | VTBFHA | Transaction | MANDT |
| VTVBAR | RFHA | VTVBAR | BUKRS | VTBFHA | Transaction | BUKRS |
| VTVBAR | RFHA | VTVBAR | RFHA | VTBFHA | Transaction | RFHA |
| VTVBAR | WBARWERT | VTVBAR | WBARWERT | TCURC | Currency Codes | WAERS |
| VTVBAR | WBARWERT | VTVBAR | MANDT | TCURC | Currency Codes | MANDT |
