CMM_VFIND

CMM Versioned Financial Transactions Data | #transactional | Component: Basic Functions
Column Name Description
MANDT Client
COMPANY_CODE Company Code
EXPOSURE_CAT Exposure Category Show values
EXPOSURE_ID Commodity Price Exposure ID
VERSION Version of a Commodity Price Exposure
EXPOSURE_SUBKEY Hash key
Column Name Description
💲 Strike currency of option/future (STRIKE_CURRENCY):
STRIKE_PRICE Option strike amount
💲 Evaluation in Payment Currency (PAYT_CURRENCY):
AMOUNT Contract Amount in Payment Currency
Column Name Description
📏 Unit of Measure for the Commodity (UNIT_OF_MEASURE):
QUANTITY Quantity
📏 Base Unit of Measure for the Commodity (BASE_UOM):
BASE_QUANTITY Base Quantity
📏 Mass Unit of Measure for the Commodity (MASS_UOM):
MASS_QUANTITY Mass
📏 Volume Unit of Measure for the Commodity (VOLUME_UOM):
VOLUME_QUANTITY Volume
Column Name Description
VALID_FROM_DATE Valid-From Date of Exposure
VALID_FROM_TIME Valid-From Time of Commodity Derivative
VALID_TO_DATE Valid-To Date of Commodity Derivative
VALID_TO_TIME Valid-To Time of Commodity Derivative
START_TERM Term Start
END_TERM Term End
CALC_END_DATE End Date of Calculation Period
EXPOS_DUE_DATE Date on which the exposure is due and expires
REPORTING_DATE Reporting Date
DELIVERY_DATE Delivery Date of a Commodity Derivative
KEYDATE Maturity Key Date
Column Name Description
EXPOSURE_CAT Exposure Category Show values
HAS_ERROR Error Flag for Data Record of Commodity Risk Analytics Show values
IS_NOT_RELEVANT Indicates whether derivative entry is reporting relevant Show values
SIDE Transaction Flow Direction Show values
DIRECTION Indicates whether it is a long or a short position Show values
TIMING Timing/Periodicity of Commodity Forward Indexes Show values
OPTION_DIRECTION Put/Call Indicator Show values
EXERCISE_TYPE Exercise Type (American or European) Show values
FIXING_STATUS Fixation Status Show values
IGNR_RSK_VIEW Ignore for Risk View Show values
Column Name Description Domain name
VALID_FROM_TST Valid-From Timestamp of Commodity Derivative TZNTSTMPS
VALID_TO_TST Valid-To Timestamp of Commodity Derivative TZNTSTMPS
VERSION_MAX Highest Version Number CMM_MTM_VERSION
VERSION_GUID CMM_VFIND Version GUID SYSUUID
EXPOSURE_SUBKEY_XML Exposure subkey in readable XML format STRING
PRODUCT_CAT Product Category VVSANLF
PRODUCT_TYPE Product Type VVSART
F_TRANS_CAT Transaction Category T_SFGTYP
TRANS_TYPE Financial Transaction Type T_SFHAART
TRANS_ACT_TYPE Transaction Activity Category T_SFGZUTY
OBJNR Financial Object Number J_OBJNR
EVENT_TYPE Profit and Loss Event Type CMM_EVENT
IS_FINSYNC_RELEVANT Indicates whether derivative entry is relevant for FIN sync. CMM_FINSYNC_RELEVANT_FLAG
EXTERNAL_REFERENCE External Reference FTI_CHAR16LOW
PHYS_COMM_ID Commodity TBA_STOEFFCHEN
DCS Derivative Contract Specification ID TBA_DCSID
MIC Market Identifier Code TBA_MIC
PRICE_TYPE Type of Price Quotation VVSKURSART
TENOR Time to Maturity TBA_TENOR
CONTRACT_CODE Contract Maturity Code TBA_CONTRACT_CODE
FUTURES_ACCOUNT Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
DERIVATIVE_CONTRACT_ID Contract for Listed Options and Futures WP_RANL
NUMBER_OF_CONTRACTS Number of Contracts ASTUECK
CTY_STRIKE_PRICE Strike price for commodity listed options TB_CTY_STRIKE_PRICE
CTY_STRIKE_CURR_UNIT Currency Unit of the Rate VVSRUNIT
TRADED_DCS Traded Derivative Contract Specification ID TBA_DCSID
PARENT_DCS Parent Derivative Contract Specification ID TBA_DCSID
SEQNR Sequence Number NUMC6
BREAKOUT_LEVEL Breakout Level NUMC2
ENTITY_KEY Key of an Business Entity requiring an End-of-day snapshot