I_DrvtvPosInterfaceLayer

Derivative Position Interface Layer Extension | view: IVFINDIL | TRAN | Extraction: Not supported | Component: Commodity Derivative Risk Management
Tables used: CMM_FINSYNC, CMM_DEND_RUN, CMM_VFIND, CMM_VFINR
Column Name Description
CompanyCode Company Code
CommodityPriceExposure Commodity Price Exposure ID
CommodityExposureCategory Exposure Category Show values
CommodityPriceSubExposure Hash key
CommodityPriceExposureVersion Version of a Commodity Price Exposure
Column Name Description
Column Name Description
📏 Unit of Measure for the Commodity (CommodityPriceExposureUnit):
CommodityPriceExposureQuantity Quantity
PricedFinancialPositionQty Priced Financial Position Quantity
UnpricedFinancialPositionQty Unpriced Financial Position Quantity
DueInPastUnpricedFinPosQty Due In Past Unpriced Financial Position Quantity
DueMktOnClsUnpricedFinPosQty Due Market On Close Unpriced Financial Position Quantity
DueInFutureUnpricedFinPosQty Due In Future Unpriced Financial Position Quantity
UnpricedContrPriceExposureQty Unpriced Contract Price Exposure Quantity
UndeliveredMarketPrExposureQty Undelivered Market Price Exposure Quantity
OutrightPriceExposureQty Outright Exposure Quantity
FinancialPositionQty Financial Position Quantity
Column Name Description
ValidityStartDate Valid-From Date of Exposure
ValidityStartTime Valid-From Time of Commodity Derivative
ValidityEndDate Valid-To Date of Commodity Derivative
ValidityEndTime Valid-To Time of Commodity Derivative
ExposureDueDate Date on which the exposure is due and expires
ReportingDate Reporting Date
MaturityKeyDate Maturity Key Date
TermStartDate Term Start
TermEndDate Term End
DeliveryDate Delivery Date of a Commodity Derivative
EvaluationDate Evaluation Date
EndOfDaySnapshotDate Snapshot Date
Column Name Description
CommodityExposureCategory Exposure Category Show values
CashFlowDirection Transaction Flow Direction Show values
TreasuryPositionLongShortCode Indicates whether it is a long or a short position Show values
CmmdtyForwardIndexTiming Timing/Periodicity of Commodity Forward Indexes Show values
HasError Error Flag for Data Record of Commodity Risk Analytics Show values
CommodityPriceFixationStatus Fixation Status Show values
OptionPutCallCode Put/Call Indicator Show values
OptionExerciseType Exercise Type (American or European) Show values
MTMDataSelectionType VLOGP Data Selection Type Show values
DisplayView View Variant Show values
RiskViewIsNotRelevant Ignore for Risk View Show values
Column Name Description Domain name
CommodityViewTypeText null
CommodityViewSelectionType null
ValidityStartDateTime Valid-From Timestamp of Commodity Derivative TZNTSTMPS
ValidityEndDateTime Valid-To Timestamp of Commodity Derivative TZNTSTMPS
MaximumVersion Highest Version Number CMM_MTM_VERSION
RiskAnalyzerVersionUUID CMM_VFIND Version GUID SYSUUID
Commodity Commodity TBA_STOEFFCHEN
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
TimeToMaturity Time to Maturity TBA_TENOR
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
FinancialInstrProductCategory Product Category VVSANLF
FinancialAssetsMgmtProductType Product Type VVSART
FinInstrTransactionCategory Transaction Category T_SFGTYP
FinancialInstrumentProductType Financial Transaction Type T_SFHAART
FinancialInstrActivityCategory Transaction Activity Category T_SFGZUTY
FinancialObject Financial Object Number J_OBJNR
SystemMessageNumber null
NumberOfCommodityContracts Number of Contracts ASTUECK
TreasuryPositionAccount Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
DerivativeContract Contract for Listed Options and Futures WP_RANL
OptionStrikePrice Strike price for commodity listed options TB_CTY_STRIKE_PRICE
OptionStrikeCurrency Currency Unit of the Rate VVSRUNIT
OptionDeltaFactorKeyFigure Option Delta Factor CMM_EVAL_OPTION_DELTA_FACTOR
ExternalKeyFigureValue External Key figures
OptionDeltaFactor Option Delta Factor Value CDS_OPTION_DELTA_FACTOR
EndOfDayBusinessEntityKey Key of an Business Entity requiring an End-of-day snapshot
ReportingMonth Reporting Month CHAR3
ReportingYear Reporting Year GJAHR
EndOfDaySnapshotDateTime Timestamp defining a End-of-day snapshot TZNTSTMPS
FinInstrExternalReference External Reference FTI_CHAR16LOW
TradedDrvtvContrSpecification Traded Derivative Contract Specification ID TBA_DCSID
ParDrvtvContractSpecification Parent Derivative Contract Specification ID TBA_DCSID