VTVBAR

Transparent Table Application Table
28 Fields 1 CDS Views

NPVs of OTC transactions

VTVBAR is an SAP database table in S/4HANA. NPVs of OTC transactions. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_FinancialTransactionNPV view_entity from BASIC Financial Transaction Net Present Value

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rantyp RANTYP Contract Type
KEY bukrs BUKRS Company Code
KEY rfha TB_RFHA Transaction
KEY ranlvd RANL Contract Number
KEY okuart TV_OKUART Price / NPV Type
KEY databs TB_DATAB Effective From
barwert TV_BARWERT NPV
wbarwert TV_WBARWE Currency of NPV
intrinsic_value TV_INTRINSIC_VALUE Intr. Value DC
time_value TV_TIME_VALUE Time Value DC
clean_price TV_CLEAN_PRICE Clean Price DC
barwert_in TV_BARWERT_IN NPV-Incoming Side
barwert_out TV_BARWERT_OUT NPV-Outgoing Side
barwert_rf TV_BARWERT_RF Risk-Free NPV
cva FTBCVA_CVA CVA
dva FTBCVA_DVA DVA
cva_type FTBCVA_CVA_TYPE CVA/DVA Type
create_name RERF Entered By
create_date DERF First Enterd On
create_time TERF Time
create_tcode TCODE Transaction Code
change_name RBEAR Last Changed By
change_date DBEAR Last Edited On
change_time TBEAR Last Edited At
change_tcode TCODE Transaction Code
log_guid TPM_LOG_GUID Log GUID
check_sum HASH160X Hash Value

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- NPVs of OTC transactions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTVBAR (
    MANDT,            -- Client [MANDT]
    RANTYP,           -- Contract Type [RANTYP]
    BUKRS,            -- Company Code [BUKRS]
    RFHA,             -- Transaction [TB_RFHA]
    RANLVD,           -- Contract Number [RANL]
    OKUART,           -- Price / NPV Type [TV_OKUART]
    DATABS,           -- Effective From [TB_DATAB]
    BARWERT,          -- NPV [TV_BARWERT]
    WBARWERT,         -- Currency of NPV [TV_WBARWE]
    INTRINSIC_VALUE,  -- Intr. Value DC [TV_INTRINSIC_VALUE]
    TIME_VALUE,       -- Time Value DC [TV_TIME_VALUE]
    CLEAN_PRICE,      -- Clean Price DC [TV_CLEAN_PRICE]
    BARWERT_IN,       -- NPV-Incoming Side [TV_BARWERT_IN]
    BARWERT_OUT,      -- NPV-Outgoing Side [TV_BARWERT_OUT]
    BARWERT_RF,       -- Risk-Free NPV [TV_BARWERT_RF]
    CVA,              -- CVA [FTBCVA_CVA]
    DVA,              -- DVA [FTBCVA_DVA]
    CVA_TYPE,         -- CVA/DVA Type [FTBCVA_CVA_TYPE]
    CREATE_NAME,      -- Entered By [RERF]
    CREATE_DATE,      -- First Enterd On [DERF]
    CREATE_TIME,      -- Time [TERF]
    CREATE_TCODE,     -- Transaction Code [TCODE]
    CHANGE_NAME,      -- Last Changed By [RBEAR]
    CHANGE_DATE,      -- Last Edited On [DBEAR]
    CHANGE_TIME,      -- Last Edited At [TBEAR]
    CHANGE_TCODE,     -- Transaction Code [TCODE]
    LOG_GUID,         -- Log GUID [TPM_LOG_GUID]
    CHECK_SUM,        -- Hash Value [HASH160X]
    PRIMARY KEY (MANDT, RANTYP, BUKRS, RFHA, RANLVD, OKUART, DATABS)
);

Learn More