CMM_GMDA_R

Generic Market Data Storage for reporting with Flat PriceDt | #masterdata | Component: Basic Functions
Column Name Description
CLIENT Client
SCENARIO Scenario
DCSID Derivative Contract Specification ID
MIC Market Identifier Code
PRICETYPE Type of Price Quotation
INSTRUMENT A key required to access market data
PRICEDATE_FROM Date of Price Quotation
Column Name Description
Column Name Description
Column Name Description
PRICEDATE_FROM Date of Price Quotation
PRICEDATE_TO Date of Price Quotation
PRICETIME Time of Price Quotation
ADJ_REF_KEYDATE Basis Market reference maturity keydate
KEYDATE Maturity Key Date
DELIVERY_FROM Delivery From for comparison against the Basis Table
DELIVERY_TO Delivery End Date
Column Name Description
TIMING Timing/Periodicity of Commodity Forward Indexes Show values
READ_BACK Read Back Indicator Show values
Column Name Description Domain name
PRICE Quotation Price in DEC 20.8 format CMM_GMDA_PRICE
PRICE_DEC34 Quotation Price in floating decimal CMM_GMDA_PRICE_DF34
INSTRUMENT_XML Instrument in readable XML Format STRING
ADJ_REF_CONTRACT_CD Basis Market Reference Contract Maturity Code CMM_BAS_MKT_REF_CONTRACT_CODE
ADJ_REF_RATE Original Basis Market reference rate CMM_GMDA_PRICE
ADJ_SPREAD Adjustment Value CMM_GMDA_PRICE
CONTRACT_CODE Contract Maturity Code TBA_CONTRACT_CODE
BASIS_TYPE Basis Type TBAC_BASIS_TYPE
BASIS_ID Basis ID TBAC_BASIS_ID
Master Data Relations Join Conditions
Commodity Pricing Engine Unit of Measure
  • CMM_GMDA_R.CLIENT == T006.MANDT
  • CMM_GMDA_R.CPE_UOM == T006.MSEHI
Quotation Currency
  • CMM_GMDA_R.CLIENT == TCURC.MANDT
  • CMM_GMDA_R.CURRENCY == TCURC.WAERS
Quotation Unit of Measure
  • CMM_GMDA_R.CLIENT == T006.MANDT
  • CMM_GMDA_R.UOM == T006.MSEHI