CMMFDOF_D_FILL

Transparent Table Application Table
25 Fields 12 CDS Views

Commodity Derivative Order Fills

CMMFDOF_D_FILL is an SAP database table in S/4HANA. Commodity Derivative Order Fills. It contains 25 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
E_CommodityOrderFill view from EXTENSION Extension View for Commodity Order Fill
I_CmmdtyOrdAssgdFillByOrdReq view left_outer BASIC Basic View to Count Ord Req Assgd Fills
I_CmmdtyOrderAssgdDocByOrdFill view from BASIC Basic View to Count Ord Fill Assgd Docs
I_CmmdtyOrderAssgdFillByPacket view left_outer BASIC Basic View to Count Packet Assgd Fills
I_CmmdtyOrderFillPacketRcvdOn view left_outer BASIC Basic View for Fill Packet Recieved On
I_CmmdtyOrdReltdFillByOrdFill view from BASIC Basic View to Count Fill Related Fills
I_CmmdtyOrdReltdFillByOrdFill view left_outer BASIC Basic View to Count Fill Related Fills
I_CmmdtyOrdReqDocAndOrdReq view left_outer BASIC Customized Basic View Docs and Ord Req
I_CommodityOrderFill view from BASIC Commodity Order Fill
I_CommodityOrderRequestFill view from BASIC Basic View for Commodity Order Fill
P_CmmdtyOrdFillPacketFirstFill view from BASIC
P_PrcSttgMethExecutionAnalysis view left_outer BASIC

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY commodityorderfilluuid /bobf/uuid Key
commodityorderfillpacketuuid /bobf/uuid Key
commodityorderfill cmmfdof_commodityorderfill Fill ID
cmmdtyorderfillpacket cmmfdof_cmmdtyorderfillpacket Fill Packet Sequence
cmmdtyorderfilldatetime cmmfdof_cmmdtyordfilldatetime Transaction Time
cmmdtyorderfillstatus cmmfdof_cmmdtyorderfillstatus Fill Status
cmmdtyorderrequestflowtype cmmfdor_orderrequestflowtype Flow Type
cmmdtyorderfillfutureid cmmfdof_cmmdtyordfillfutureid Future
commodity tba_stoeffchen Commodity
marketidentifiercode cmmfdof_marketidentifercode MIC
derivativecontrspecification cmmfsa_derivativecontractspec DCS
maturitykeydate tba_keydate Maturity Key Date
cmmdtyordfillassignorder cmmfdof_orderassigned Assigned To Order
cmmdtyordreqcntrptybroker cmmfdor_cntrparty_broker Counterparty Broker
cmmdtyorderfillcounterparty cmmfdof_cmmdtyfillcounterparty Counter Party
cmmdtyorderisfillwithorder cmmfdof_isfillwithorder Fill With Order
succ_archive cmmfdof_archive Archive Status
cmmdtyordreqcntrptysubacct cmmfdor_ordreqcntrptysubacct Counterparty Subacct
commodityorderrequestticks cmmfdor_ordertradedticks Order Traded Ticks
commodityproductsymbol cmmfdof_product_symbol Product Symbol
cmmdtyordfillismktclsprcassgd cmmfdof_ismktclsprcassgd Mkt Cls Prc Assigned
cmmdtyordfillmarketcloseprice cmmfdof_market_close_price Market Close Price
cmmdtyordfillmktprcatfwdcrtn cmmfdof_market_price Market Price
cmmdtyorderreqistrdatsettlmt cmmfdor_ordreqistasorder Trade at Settlement

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Commodity Derivative Order Fills
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMFDOF_D_FILL (
    MANDT,                          -- Client [mandt]
    COMMODITYORDERFILLUUID,         -- Key [/bobf/uuid]
    COMMODITYORDERFILLPACKETUUID,   -- Key [/bobf/uuid]
    COMMODITYORDERFILL,             -- Fill ID [cmmfdof_commodityorderfill]
    CMMDTYORDERFILLPACKET,          -- Fill Packet Sequence [cmmfdof_cmmdtyorderfillpacket]
    CMMDTYORDERFILLDATETIME,        -- Transaction Time [cmmfdof_cmmdtyordfilldatetime]
    CMMDTYORDERFILLSTATUS,          -- Fill Status [cmmfdof_cmmdtyorderfillstatus]
    CMMDTYORDERREQUESTFLOWTYPE,     -- Flow Type [cmmfdor_orderrequestflowtype]
    CMMDTYORDERFILLFUTUREID,        -- Future [cmmfdof_cmmdtyordfillfutureid]
    COMMODITY,                      -- Commodity [tba_stoeffchen]
    MARKETIDENTIFIERCODE,           -- MIC [cmmfdof_marketidentifercode]
    DERIVATIVECONTRSPECIFICATION,   -- DCS [cmmfsa_derivativecontractspec]
    MATURITYKEYDATE,                -- Maturity Key Date [tba_keydate]
    CMMDTYORDFILLASSIGNORDER,       -- Assigned To Order [cmmfdof_orderassigned]
    CMMDTYORDREQCNTRPTYBROKER,      -- Counterparty Broker [cmmfdor_cntrparty_broker]
    CMMDTYORDERFILLCOUNTERPARTY,    -- Counter Party [cmmfdof_cmmdtyfillcounterparty]
    CMMDTYORDERISFILLWITHORDER,     -- Fill With Order [cmmfdof_isfillwithorder]
    SUCC_ARCHIVE,                   -- Archive Status [cmmfdof_archive]
    CMMDTYORDREQCNTRPTYSUBACCT,     -- Counterparty Subacct [cmmfdor_ordreqcntrptysubacct]
    COMMODITYORDERREQUESTTICKS,     -- Order Traded Ticks [cmmfdor_ordertradedticks]
    COMMODITYPRODUCTSYMBOL,         -- Product Symbol [cmmfdof_product_symbol]
    CMMDTYORDFILLISMKTCLSPRCASSGD,  -- Mkt Cls Prc Assigned [cmmfdof_ismktclsprcassgd]
    CMMDTYORDFILLMARKETCLOSEPRICE,  -- Market Close Price [cmmfdof_market_close_price]
    CMMDTYORDFILLMKTPRCATFWDCRTN,   -- Market Price [cmmfdof_market_price]
    CMMDTYORDERREQISTRDATSETTLMT,   -- Trade at Settlement [cmmfdor_ordreqistasorder]
    PRIMARY KEY (MANDT, COMMODITYORDERFILLUUID)
);

Learn More