CMMFDOF_D_FILL

Transparent Table Application Table
46 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 46 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 (46)

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
commodityorderrequestuuid /BOBF/UUID Key
cmmdtyorderreqleguuid /BOBF/UUID Key
cmmdtyorderreqlegownerrole CMMFDOR_CMMDTYORDERREQLEGOWNER Ord. Req. Leg Owner
commoditysubaccountuuid /BOBF/UUID Key
referencebrokeraccount CMMFSA_REFERENCEBROKERACCOUNT Reference Account
commodityderivativebroker CMMFDOR_BROKER Broker
cmmdtyorderfillquantityinlots CMMFDOF_CMMDTYFILLQTYINLOTS Fill Lots
cmmdtyorderfillprice CMMFDOF_CMMDTYORDERFILLPRICE Fill Price
cmmdtyorderfillpricecrcy CMMFDOF_CMMDTYORDFILLPRICECURR Fill Price Currency
cmmdtyordfillquantityperlot TBA_DCS_QNT DCS Quantity
cmmdtyordfilluomperlot CMMFDOR_ORDREQDCSUOM DCS Unit of Measure
cmmdtyorderfillcurrencyperlot TBA_CURRENCY Currency
cmmdtyordfillfinancialtransid CMMFDOF_FINANCIALTRANSID Financ Transact ID
createdbyuser CMMFDOF_CREATEDBY Created By
creationdatetime CMMFDOF_CREATIONDATETIME Created At
lastchangedbyuser CMMFDOF_LASTCHANGEDBYUSER Last Changed By
lastchangedatetime CMMFDOF_LASTCHANGEDATETIME Last Changed At
decidedby CMMFDOF_DECIDEDBY Decided By
decidedon CMMFDOF_DECIDEDON Decided On
cmmdtyordfillrejectionreason CMMFDOF_FILLREJECTIONREASON Rejection Reason
dummy_subaccountextn CFD_DUMMY Dummy
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]
    COMMODITYORDERREQUESTUUID,      -- Key [/BOBF/UUID]
    CMMDTYORDERREQLEGUUID,          -- Key [/BOBF/UUID]
    CMMDTYORDERREQLEGOWNERROLE,     -- Ord. Req. Leg Owner [CMMFDOR_CMMDTYORDERREQLEGOWNER]
    COMMODITYSUBACCOUNTUUID,        -- Key [/BOBF/UUID]
    REFERENCEBROKERACCOUNT,         -- Reference Account [CMMFSA_REFERENCEBROKERACCOUNT]
    COMMODITYDERIVATIVEBROKER,      -- Broker [CMMFDOR_BROKER]
    CMMDTYORDERFILLQUANTITYINLOTS,  -- Fill Lots [CMMFDOF_CMMDTYFILLQTYINLOTS]
    CMMDTYORDERFILLPRICE,           -- Fill Price [CMMFDOF_CMMDTYORDERFILLPRICE]
    CMMDTYORDERFILLPRICECRCY,       -- Fill Price Currency [CMMFDOF_CMMDTYORDFILLPRICECURR]
    CMMDTYORDFILLQUANTITYPERLOT,    -- DCS Quantity [TBA_DCS_QNT]
    CMMDTYORDFILLUOMPERLOT,         -- DCS Unit of Measure [CMMFDOR_ORDREQDCSUOM]
    CMMDTYORDERFILLCURRENCYPERLOT,  -- Currency [TBA_CURRENCY]
    CMMDTYORDFILLFINANCIALTRANSID,  -- Financ Transact ID [CMMFDOF_FINANCIALTRANSID]
    CREATEDBYUSER,                  -- Created By [CMMFDOF_CREATEDBY]
    CREATIONDATETIME,               -- Created At [CMMFDOF_CREATIONDATETIME]
    LASTCHANGEDBYUSER,              -- Last Changed By [CMMFDOF_LASTCHANGEDBYUSER]
    LASTCHANGEDATETIME,             -- Last Changed At [CMMFDOF_LASTCHANGEDATETIME]
    DECIDEDBY,                      -- Decided By [CMMFDOF_DECIDEDBY]
    DECIDEDON,                      -- Decided On [CMMFDOF_DECIDEDON]
    CMMDTYORDFILLREJECTIONREASON,   -- Rejection Reason [CMMFDOF_FILLREJECTIONREASON]
    DUMMY_SUBACCOUNTEXTN,           -- Dummy [CFD_DUMMY]
    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