CMM_VFIND

Transparent Table Application Table
73 Fields 3 CDS Views

CMM Versioned Financial Transactions Data

CMM_VFIND is an SAP database table in S/4HANA. CMM Versioned Financial Transactions Data. It contains 73 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_FinancialInstrCharacteristic view from EXTENSION Extension View for Derivatives
I_CmmdtyVersFinTransac view_entity from BASIC CMM VFIND Interface layer
I_DerivativeCmmdtyExpsr view from BASIC Drvtv Basic Layer Select data from VFIND

Fields (73)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY company_code BUKRS Company Code
KEY exposure_cat CMM_VFIND_EXPOSURE_CAT Exposure Cat
KEY exposure_id FTR_CTY_EXPOS_ID Exposure ID
KEY version FTR_CTY_EXPOS_VERSION Version
KEY exposure_subkey CMM_VFIND_EXPOSURE_SUBKEY Expo Subkey
valid_from_tst FTR_VALID_FROM_STMP Valid-From Time
valid_to_tst FTR_VALID_TO_STMP Valid-To Time
valid_from_date FTR_VALID_FROM Valid From
valid_from_time FTR_VALID_FROM_TIME Valid-From Time
valid_to_date FTR_VALID_TO Valid-To Date
valid_to_time FTR_VALID_TO_TIME Valid-To Time
version_max CMM_MTM_VERSION_MAX Highest Version
version_guid CMM_VFIND_VERSION_GUID Version GUID
exposure_subkey_xml CMM_EXPOS_SUBKEY_XML Exp. Subkey
product_cat SANLF Prod. Category
product_type VVSART Product Type
f_trans_cat TB_SFGTYP Transaction Cat
trans_type TB_SFHAART Transactn Type
trans_act_type TB_SFGZUTY Activity Cat.
start_term TB_DBLFZ Term Start
end_term TB_DELFZ Term End
objnr FTR_OBJNR Fin. Object ID
event_type CMM_EVENT Event Type
has_error CMM_ERROR_FLAG Error in Data Record
is_not_relevant CMM_VFIND_RELEVANT_FLAG Reporting Relevant
calc_end_date CMM_VFIND_CALC_END Calc. End Date
is_finsync_relevant CMM_FINSYNC_RELEVANT_FLAG FIN-Sync. Relevant
external_reference TB_NORDEXT External Ref.
calc_start_date CMM_VFIND_CALC_START Calc. Start Date
portfolio CMM_VFIND_PORTFOLIO Portfolio
expos_due_date FTR_EXPOSURE_DATE Exp. Due Date
reporting_date FTR_REPORTING_DATE Reporting Date
delivery_date FTR_DELIVERY_DATE Delivery Date
phys_comm_id TBA_STOEFFCHEN Commodity
side CMM_SIDE Flow Direction
direction TPM_FLAG_LONG_SHORT Long/Short Position
dcs TBA_DCSID DCS ID
mic TBA_MIC MIC
price_type TBA_PRICETYPE Price Type
tenor TBA_TENOR Time to Maturity
timing TBA_TIMING Timing
keydate TBA_KEYDATE Maturity Key Date
contract_code TBA_CONTRACT_CODE Contr. Maturity Code
strike_price TI_OSTRIKE Strike amount
strike_currency TI_OFWAERS Strike Currency
option_direction TI_SPUTCAL Put/Call
exercise_type SOPTAUS Exercise Type
fixing_status FTR_FIXING_STATUS Fixation Status
futures_account TPM_POS_ACCOUNT_FUT Futures Acct
derivative_contract_id FTR_DERIVATIVE_CONTRACT_ID Derivative Contract
number_of_contracts TB_CONTRACTS_NUMBER Number of Contracts
quantity FTR_EXPOSURE_QTY Qty
unit_of_measure TPM_CTY_UOM Unit of Measure
base_quantity FTR_EXPOSURE_BASE_QTY Base Quantity
base_uom TPM_CTY_BASE_UOM Base UoM
mass_quantity FTR_EXPOSURE_MASS_QTY Mass
mass_uom TPM_CTY_MASS_UOM Mass UoM
volume_quantity FTR_EXPOSURE_VOLUME_QTY Volume
volume_uom TPM_CTY_VOLUME_UOM Volume UoM
amount CMM_VFIND_AMOUNT Contract Amount in Q
quot_currency CMM_EVAL_QUOT_CURR Quotation Crcy
payt_currency CMM_EVAL_PAYM_CURR Payment Currency
cty_strike_price TB_CTY_STRIKE_PRICE Strike Price
cty_strike_curr_unit TB_RUNIT Currency Unit
traded_dcs CMM_VFIND_TRADED_DCSID Traded DCS
parent_dcs CMM_VFIND_PARENT_DCSID Parent DCS ID
seqnr CMM_VFIND_SEQNR Sequence No.
breakout_level CMM_VFIND_BREAKOUT_LEVEL Breakout Level
ignr_rsk_view CMM_VFIND_IGNR_RSK_VIEW Ignore for Risk View
entity_key CMM_DEND_ENTITY_KEY Entity
hedge_book CMM_HEDGE_BOOK Hedge Book
plan_exposure_id CMM_EXPOSURE_ID Plan Exposure ID

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.

-- CMM Versioned Financial Transactions Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMM_VFIND (
    MANDT,                   -- Client [MANDT]
    COMPANY_CODE,            -- Company Code [BUKRS]
    EXPOSURE_CAT,            -- Exposure Cat [CMM_VFIND_EXPOSURE_CAT]
    EXPOSURE_ID,             -- Exposure ID [FTR_CTY_EXPOS_ID]
    VERSION,                 -- Version [FTR_CTY_EXPOS_VERSION]
    EXPOSURE_SUBKEY,         -- Expo Subkey [CMM_VFIND_EXPOSURE_SUBKEY]
    VALID_FROM_TST,          -- Valid-From Time [FTR_VALID_FROM_STMP]
    VALID_TO_TST,            -- Valid-To Time [FTR_VALID_TO_STMP]
    VALID_FROM_DATE,         -- Valid From [FTR_VALID_FROM]
    VALID_FROM_TIME,         -- Valid-From Time [FTR_VALID_FROM_TIME]
    VALID_TO_DATE,           -- Valid-To Date [FTR_VALID_TO]
    VALID_TO_TIME,           -- Valid-To Time [FTR_VALID_TO_TIME]
    VERSION_MAX,             -- Highest Version [CMM_MTM_VERSION_MAX]
    VERSION_GUID,            -- Version GUID [CMM_VFIND_VERSION_GUID]
    EXPOSURE_SUBKEY_XML,     -- Exp. Subkey [CMM_EXPOS_SUBKEY_XML]
    PRODUCT_CAT,             -- Prod. Category [SANLF]
    PRODUCT_TYPE,            -- Product Type [VVSART]
    F_TRANS_CAT,             -- Transaction Cat [TB_SFGTYP]
    TRANS_TYPE,              -- Transactn Type [TB_SFHAART]
    TRANS_ACT_TYPE,          -- Activity Cat. [TB_SFGZUTY]
    START_TERM,              -- Term Start [TB_DBLFZ]
    END_TERM,                -- Term End [TB_DELFZ]
    OBJNR,                   -- Fin. Object ID [FTR_OBJNR]
    EVENT_TYPE,              -- Event Type [CMM_EVENT]
    HAS_ERROR,               -- Error in Data Record [CMM_ERROR_FLAG]
    IS_NOT_RELEVANT,         -- Reporting Relevant [CMM_VFIND_RELEVANT_FLAG]
    CALC_END_DATE,           -- Calc. End Date [CMM_VFIND_CALC_END]
    IS_FINSYNC_RELEVANT,     -- FIN-Sync. Relevant [CMM_FINSYNC_RELEVANT_FLAG]
    EXTERNAL_REFERENCE,      -- External Ref. [TB_NORDEXT]
    CALC_START_DATE,         -- Calc. Start Date [CMM_VFIND_CALC_START]
    PORTFOLIO,               -- Portfolio [CMM_VFIND_PORTFOLIO]
    EXPOS_DUE_DATE,          -- Exp. Due Date [FTR_EXPOSURE_DATE]
    REPORTING_DATE,          -- Reporting Date [FTR_REPORTING_DATE]
    DELIVERY_DATE,           -- Delivery Date [FTR_DELIVERY_DATE]
    PHYS_COMM_ID,            -- Commodity [TBA_STOEFFCHEN]
    SIDE,                    -- Flow Direction [CMM_SIDE]
    DIRECTION,               -- Long/Short Position [TPM_FLAG_LONG_SHORT]
    DCS,                     -- DCS ID [TBA_DCSID]
    MIC,                     -- MIC [TBA_MIC]
    PRICE_TYPE,              -- Price Type [TBA_PRICETYPE]
    TENOR,                   -- Time to Maturity [TBA_TENOR]
    TIMING,                  -- Timing [TBA_TIMING]
    KEYDATE,                 -- Maturity Key Date [TBA_KEYDATE]
    CONTRACT_CODE,           -- Contr. Maturity Code [TBA_CONTRACT_CODE]
    STRIKE_PRICE,            -- Strike amount [TI_OSTRIKE]
    STRIKE_CURRENCY,         -- Strike Currency [TI_OFWAERS]
    OPTION_DIRECTION,        -- Put/Call [TI_SPUTCAL]
    EXERCISE_TYPE,           -- Exercise Type [SOPTAUS]
    FIXING_STATUS,           -- Fixation Status [FTR_FIXING_STATUS]
    FUTURES_ACCOUNT,         -- Futures Acct [TPM_POS_ACCOUNT_FUT]
    DERIVATIVE_CONTRACT_ID,  -- Derivative Contract [FTR_DERIVATIVE_CONTRACT_ID]
    NUMBER_OF_CONTRACTS,     -- Number of Contracts [TB_CONTRACTS_NUMBER]
    QUANTITY,                -- Qty [FTR_EXPOSURE_QTY]
    UNIT_OF_MEASURE,         -- Unit of Measure [TPM_CTY_UOM]
    BASE_QUANTITY,           -- Base Quantity [FTR_EXPOSURE_BASE_QTY]
    BASE_UOM,                -- Base UoM [TPM_CTY_BASE_UOM]
    MASS_QUANTITY,           -- Mass [FTR_EXPOSURE_MASS_QTY]
    MASS_UOM,                -- Mass UoM [TPM_CTY_MASS_UOM]
    VOLUME_QUANTITY,         -- Volume [FTR_EXPOSURE_VOLUME_QTY]
    VOLUME_UOM,              -- Volume UoM [TPM_CTY_VOLUME_UOM]
    AMOUNT,                  -- Contract Amount in Q [CMM_VFIND_AMOUNT]
    QUOT_CURRENCY,           -- Quotation Crcy [CMM_EVAL_QUOT_CURR]
    PAYT_CURRENCY,           -- Payment Currency [CMM_EVAL_PAYM_CURR]
    CTY_STRIKE_PRICE,        -- Strike Price [TB_CTY_STRIKE_PRICE]
    CTY_STRIKE_CURR_UNIT,    -- Currency Unit [TB_RUNIT]
    TRADED_DCS,              -- Traded DCS [CMM_VFIND_TRADED_DCSID]
    PARENT_DCS,              -- Parent DCS ID [CMM_VFIND_PARENT_DCSID]
    SEQNR,                   -- Sequence No. [CMM_VFIND_SEQNR]
    BREAKOUT_LEVEL,          -- Breakout Level [CMM_VFIND_BREAKOUT_LEVEL]
    IGNR_RSK_VIEW,           -- Ignore for Risk View [CMM_VFIND_IGNR_RSK_VIEW]
    ENTITY_KEY,              -- Entity [CMM_DEND_ENTITY_KEY]
    HEDGE_BOOK,              -- Hedge Book [CMM_HEDGE_BOOK]
    PLAN_EXPOSURE_ID,        -- Plan Exposure ID [CMM_EXPOSURE_ID]
    PRIMARY KEY (MANDT, COMPANY_CODE, EXPOSURE_CAT, EXPOSURE_ID, VERSION, EXPOSURE_SUBKEY)
);

Learn More