CMMFDCO_D_DCSPRC

Derivative Contract Specification: Market Price Quotations | #masterdata | Component: Commodity Derivative Order and Trade Execution
Column Name Description
CLIENT FK Client
DCSID FK Derivative Contract Specification ID
MIC FK Market Identifier Code
KEYDATE Maturity Key Date
PRICETYPE Type of Price Quotation
Column Name Description
Column Name Description
Column Name Description
KEYDATE Maturity Key Date
Column Name Description
Column Name Description Domain name
PRICE Quotation Price TBA_PRICE
QUANTITY Quantity of Commodity CMMFDOR_CMMDTYORDREQUESTQTY
PRICE_TIMESTAMP Commodity Market Price Updated On Timestamp TZNTSTMPL
CREATEDBYUSER Created By User USNAM
CREATIONDATETIME Timestamp of record creation TZNTSTMPS
LASTCHANGEDBYUSER Last changed by user ID USNAM
LASTCHANGEDATETIME Timestamp of last change TZNTSTMPS
Master Data Relations Join Conditions
Client CMMFDCO_D_DCSPRC.CLIENT == T000.MANDT
Derivative Contract Specification ID CMMFDCO_D_DCSPRC.CLIENT == TBAC_DCS.CLIENT
Market Identifier Code
  • CMMFDCO_D_DCSPRC.CLIENT == TBAC_MIC.CLIENT
  • CMMFDCO_D_DCSPRC.MIC == TBAC_MIC.MIC
Quotation Currency
  • CMMFDCO_D_DCSPRC.CLIENT == TCURC.MANDT
  • CMMFDCO_D_DCSPRC.PRICE_CURRENCY == TCURC.WAERS
Quotation Unit of Measure
  • CMMFDCO_D_DCSPRC.CLIENT == T006.MANDT
  • CMMFDCO_D_DCSPRC.QUANTITY_UOM == T006.MSEHI