CMM_VFIND - CMM Versioned Financial Transactions Data

CMM Versioned Financial Transactions Data information is stored in SAP table CMM_VFIND.
It is part of development package FTR_COMMODITY_EXPOSURE in software component LO-CMM-BF. This development package consists of objects that can be grouped under "Commodity Price Exposures".

Fields for table CMM_VFIND

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE		X		CMM_VFIND_KEY	0
COMPANY_CODE	Company Code	X	BUKRS	CHAR	8
EXPOSURE_CAT	Exposure Category	X	CMM_VFIND_EXPOSURE_CAT	CHAR	4
EXPOSURE_ID	Commodity Price Exposure ID	X	FTR_CTY_EXPOS_ID	CHAR	26
VERSION	Version of a Commodity Price Exposure	X	FTR_CTY_EXPOS_VERSION	NUMC	20
EXPOSURE_SUBKEY	Hash key	X	CMM_VFIND_EXPOSURE_SUBKEY	CHAR	80
.INCLUDE				CMM_VFIND_TIMESTAMP	0
VALID_FROM_TST	Valid-From Timestamp of Commodity Derivative		FTR_VALID_FROM_STMP	DEC	8
VALID_TO_TST	Valid-To Timestamp of Commodity Derivative		FTR_VALID_TO_STMP	DEC	8
VALID_FROM_DATE	Valid-From Date of Exposure		FTR_VALID_FROM	DATS	16
VALID_FROM_TIME	Valid-From Time of Commodity Derivative		FTR_VALID_FROM_TIME	TIMS	12
VALID_TO_DATE	Valid-To Date of Commodity Derivative		FTR_VALID_TO	DATS	16
VALID_TO_TIME	Valid-To Time of Commodity Derivative		FTR_VALID_TO_TIME	TIMS	12
VERSION_MAX	Highest Version Number		CMM_MTM_VERSION_MAX	NUMC	20
VERSION_GUID	CMM_VFIND Version GUID		CMM_VFIND_VERSION_GUID	RAW	16
.INCLUDE				CMM_VFIND_BASIC	0
EXPOSURE_SUBKEY_XML	Exposure subkey in readable XML format		CMM_EXPOS_SUBKEY_XML	STRG	8
PRODUCT_CAT	Product Category		SANLF	NUMC	6	*
PRODUCT_TYPE	Product Type		VVSART	CHAR	6
F_TRANS_CAT	Transaction Category		TB_SFGTYP	NUMC	6	*
TRANS_TYPE	Financial Transaction Type		TB_SFHAART	CHAR	6
TRANS_ACT_TYPE	Transaction Activity Category		TB_SFGZUTY	NUMC	4
START_TERM	Term Start		TB_DBLFZ	DATS	16
END_TERM	Term End		TB_DELFZ	DATS	16
OBJNR	Financial Object Number		FTR_OBJNR	CHAR	44	*
EVENT_TYPE	Profit and Loss Event Type		CMM_EVENT	CHAR	20
HAS_ERROR	Error Flag for Data Record of Commodity Risk Analytics		CMM_ERROR_FLAG	CHAR	2
IS_NOT_RELEVANT	Indicates whether derivative entry is reporting relevant		CMM_VFIND_RELEVANT_FLAG	CHAR	2
CALC_END_DATE	End Date of Calculation Period		CMM_VFIND_CALC_END	DATS	16
IS_FINSYNC_RELEVANT	Indicates whether derivative entry is relevant for FIN sync.		CMM_FINSYNC_RELEVANT_FLAG	CHAR	2
EXTERNAL_REFERENCE	External Reference		TB_NORDEXT	CHAR	32
.INCLUDE				CMM_VFIND_RISK_QUANTITY	0
EXPOS_DUE_DATE	Date on which the exposure is due and expires		FTR_EXPOSURE_DATE	DATS	16
REPORTING_DATE	Reporting Date		FTR_REPORTING_DATE	DATS	16
DELIVERY_DATE	Delivery Date of a Commodity Derivative		FTR_DELIVERY_DATE	DATS	16
PHYS_COMM_ID	Commodity		TBA_STOEFFCHEN	CHAR	36
SIDE	Transaction Flow Direction		CMM_SIDE	CHAR	2
DIRECTION	Indicates whether it is a long or a short position		TPM_FLAG_LONG_SHORT	CHAR	2
DCS	Derivative Contract Specification ID		TBA_DCSID	CHAR	40
MIC	Market Identifier Code		TBA_MIC	CHAR	8
PRICE_TYPE	Type of Price Quotation		TBA_PRICETYPE	CHAR	4
TENOR	Time to Maturity		TBA_TENOR	CHAR	20
TIMING	Timing/Periodicity of Commodity Forward Indexes		TBA_TIMING	NUMC	4
KEYDATE	Maturity Key Date		TBA_KEYDATE	DATS	16
CONTRACT_CODE	Contract Maturity Code		TBA_CONTRACT_CODE	CHAR	26
STRIKE_PRICE	Option strike amount		TI_OSTRIKE	CURR	7
STRIKE_CURRENCY	Strike currency of option/future		TI_OFWAERS	CUKY	10	*
OPTION_DIRECTION	Put/Call Indicator		TI_SPUTCAL	NUMC	2
EXERCISE_TYPE	Exercise Type (American or European)		SOPTAUS	NUMC	2
FIXING_STATUS	Fixation Status		FTR_FIXING_STATUS	CHAR	2
FUTURES_ACCOUNT	Futures Account for Listed Options and Futures		TPM_POS_ACCOUNT_FUT	CHAR	20
DERIVATIVE_CONTRACT_ID	Contract for Listed Options and Futures		FTR_DERIVATIVE_CONTRACT_ID	CHAR	26
NUMBER_OF_CONTRACTS	Number of Contracts		TB_CONTRACTS_NUMBER	DEC	8
QUANTITY	Quantity		FTR_EXPOSURE_QTY	QUAN	7
UNIT_OF_MEASURE	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
BASE_QUANTITY	Base Quantity		FTR_EXPOSURE_BASE_QTY	QUAN	7
BASE_UOM	Base Unit of Measure for the Commodity		TPM_CTY_BASE_UOM	UNIT	6	*
MASS_QUANTITY	Mass		FTR_EXPOSURE_MASS_QTY	QUAN	7
MASS_UOM	Mass Unit of Measure for the Commodity		TPM_CTY_MASS_UOM	UNIT	6	*
VOLUME_QUANTITY	Volume		FTR_EXPOSURE_VOLUME_QTY	QUAN	7
VOLUME_UOM	Volume Unit of Measure for the Commodity		TPM_CTY_VOLUME_UOM	UNIT	6	*
AMOUNT	Contract Amount in Payment Currency		CMM_VFIND_AMOUNT	CURR	7
QUOT_CURRENCY	Evaluation in Quotation Currency		CMM_EVAL_QUOT_CURR	CUKY	10	*
PAYT_CURRENCY	Evaluation in Payment Currency		CMM_EVAL_PAYM_CURR	CUKY	10	*
CTY_STRIKE_PRICE	Strike price for commodity listed options		TB_CTY_STRIKE_PRICE	DEC	7
CTY_STRIKE_CURR_UNIT	Currency Unit of the Rate		TB_RUNIT	CHAR	10	*
.INCLUDE				CMM_VFIND_FLT_PRC	0
TRADED_DCS	Traded Derivative Contract Specification ID		CMM_VFIND_TRADED_DCSID	CHAR	40	*
PARENT_DCS	Parent Derivative Contract Specification ID		CMM_VFIND_PARENT_DCSID	CHAR	40	*
SEQNR	Sequence Number		CMM_VFIND_SEQNR	NUMC	12
BREAKOUT_LEVEL	Breakout Level		CMM_VFIND_BREAKOUT_LEVEL	NUMC	4
IGNR_RSK_VIEW	Ignore for Risk View		CMM_VFIND_IGNR_RSK_VIEW	CHAR	2
.INCLUDE				CMM_VFIND_EOD	0
ENTITY_KEY	Key of an Business Entity requiring an End-of-day snapshot		CMM_DEND_ENTITY_KEY	RAW	20