CMMFDOR_D_ORDER

Transparent Table Application Table

Commodity Derivative Order Request

CMMFDOR_D_ORDER is an SAP database table in S/4HANA. Commodity Derivative Order Request. It contains 87 fields. 13 CDS views read from this table.

CDS Views using this table (13)

ViewTypeJoinVDMDescription
E_CommodityOrderRequest view from EXTENSION Commodity Order Request Extension View
I_ACMPendingStatusCDOTE view_entity inner BASIC Fetch the CDOTE orders in pending status
I_CmmdtyOrdAssgdFillByOrdReq view from BASIC Basic View to Count Ord Req Assgd Fills
I_CmmdtyOrdAssgdLegByOrderReq view from BASIC Basic View to Count Ord Req Assgd Legs
I_CmmdtyOrderReqQueueErrLog view inner BASIC bgRFC Queue Error Log for Order Request
I_CmmdtyOrdFillPacketCommodity view left_outer BASIC Basic View for Cmmdty Deriv Ord Fill Pkt
I_CmmdtyOrdReqAssgdDocByOrdReq view from BASIC Basic View to Count Ord Req Assgd Docs
I_CmmdtyOrdReqDocAndOrdReq view left_outer BASIC Customized Basic View Docs and Ord Req
I_CmmdtyRelatedBracketByOrdReq view from BASIC Basic View to Count Ord Rltd Brackets
I_CommodityOrderFill view left_outer BASIC Commodity Order Fill
I_CommodityOrderFillPacket view left_outer BASIC Basic View for Cmmdty Deriv Ord Fill Pkt
I_CommodityOrderRequest view from BASIC Commodity Order Request Interface View
P_PrcSttgMethExecutionAnalysis view left_outer BASIC

Fields (87)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY commodityorderrequestuuid /BOBF/UUID Key
commodityorderrequest CMMFDOR_ORDERREQUESTID Order ID
cmmdtyordreqsenttobrkrdatetime CMMFDOR_ORDREQSENTTOBRKRDTETME Transmitted On
cmmdtyorderrequesttype CMMFDOR_ORDERTYPE Order Type
commodityordreqstatusreason CMMFDOR_ORDERREQUSTATUSREASON Status Reason
cmmdtyorderreqrejectionreason CMMFDOR_ORDERREQREJREASON Rejection Reason
commodityorderrequestcomment CMMFDOR_ORDERREQUESTCOMMENT Comment
cmmdtyorderrequestreason CMMFDOR_ORDERREQUESTRSN Order Reason
cmmdtyorderrequeststatus CMMFDOR_ORDERREQUESTSTATUS Order Status
cmmdtyorderrequestsource CMMFDOR_CMMDTYORDREQUESTSOURCE Order Source
cmmdtyordreqpricingprogram CMMFDOR_ORDREQPRICINGPROGRAM Pricing Program
cmmdtyorderrequestexchangetype CMMFDOR_ORDREQEXCHANGETYPE Exchange Type
cmmdtyordreqnegttndatetime CMMFDOR_ORDNEGOTIATIONDATETIME Negotiated On
counterparty RKONTRAH_NEW Counterparty
cmmdtyordreqcntrptysubacct CMMFDOR_ORDREQCNTRPTYSUBACCT Counterparty Subacct
cmmdtyordreqcntrptysubacctuuid /BOBF/UUID Key
commoditysubaccount CMMFDOR_ASSIGNEDSUBACCOUNT Assigned Subaccount
commoditysubaccountuuid /BOBF/UUID Key
cmmdtyordrequestquantityinlot CMMFDOR_ORDREQNUMBEROFLOTS Order Lots
cmmdtyorderrequestflowtype CMMFDOR_ORDERREQUESTFLOWTYPE Flow Type
commodityderivativebroker CMMFDOR_BROKERID Broker ID
cmmdtyordreqcntrptybroker CMMFDOR_CNTRPARTY_BROKER Counterparty Broker
commodityorderrequesttrader RDEALER Trader
cmmdtyordinternalcounterparty CMMFDOR_INT_COUNTERPARTY Int. Counterparty
cmmdtyordcntrptybrokerrefacct CMMFDOR_CNTRPTYBROKERREFACCT Counterparty Account
cmmdtyderivativequantityperlot TBA_DCS_QNT DCS Quantity
cmmdtydrvtvquantityunitperlot CMMFDOR_ORDREQDCSUOM DCS Unit of Measure
cmmdtyderivativecurrencyperlot TBA_CURRENCY Currency
cmmdtyordreqexprtninstruction CMMFDOR_ORDEREXPIRATIONINST Expiry Instruction
cmmdtyordrequestexpirationdate CMMFDOR_ORDREQEXPIRATIONDATE Expiration Date
cmmdtyordreqexpryinstrncat CMMFDOR_EXPIRYINSTRUCTIONCAT Exp. Instr. Category
cmmdtyordreqprcgexecinstrn CMMFDOR_ORDPRCGEXECINSTRUCTION Prc/Exec Instruction
cmmdtyordreqprcgexecinstrncat CMMFDOR_ORDPRCGEXECINSTRNCAT Prc/Exec Instr. Cat.
cmmdtyordreqleewayrngeprc CMMFDOR_ORDREQLEEWAYRNGEPRC Leeway
cmmdtyordreqleewayrngeprccrcy CMMFDOR_ORDREQLEEWAYRNGEPRCCUR Leeway Prc Crcy
cmmdtyordreqleewayrngeprcqty CMMFDOR_ORDREQLEEWAYRNGEPRCQTY Leeway Prc Qty
cmmdtyordleewayrngeprcqtyunit CMMFDOR_ORDREQLWAYRNGPRCQTYUOM Leeway Qty UOM
cmmdtyordreqleewayprc CMMFDOR_ORDREQLEEWAYPRICE Requested Price
cmmdtyordreqleewayprccrcy CMMFDOR_ORDREQLEEWAYPRICECRCY Requested Price Crcy
cmmdtyordreqleewayprcqty CMMFDOR_ORDREQLEEWAYPRICEQTY Rqstd Price Quantity
cmmdtyordreqleewayprcqtyunit CMMFDOR_ORDREQLEEWAYPRCQTYUOM Rqstd Prc Qty UoM
cmmdtyordreqlmtprc CMMFDOR_CMMDTYORDERREQLIMPRICE Limit Price
cmmdtyordreqlmtprccurrency CMMFDOR_ORDREQLIMITPRICECRCY Limit Price Crcy
cmmdtyordreqlmtprcquantity CMMFDOR_ORDREQLIMITPRICEQTY Limit Price Quantity
cmmdtyordreqlmtprcquantityunit CMMFDOR_ORDREQLIMITPRCQTYUOM Limit Pr. Qty UoM
cmmdtyordreqlmtspreadprc CMMFDOR_ORDREQLMTSPREADPRICE Limit Spread Value
cmmdtyordreqlmtspreadprccrcy CMMFDOR_ORDREQLMTSPREADPRCCRCY Lim Spread Prc Crcy
cmmdtyordreqlmtspreadprcqty CMMFDOR_ORDREQLMTSPREADPRCQTY Limit Spr. Price Qty
cmmdtyordlmtspreadprcqtyunit CMMFDOR_ORDREQLMTSPRDPRCQTYUOM Lim Sprd Prc Qty UOM
cmmdtyordreqstopprice CMMFDOR_ORDREQSTOPPRICE Stop Price
cmmdtyordreqstoppricecrcy CMMFDOR_ORDREQSTOPPRICECRCY Stop Price Crcy
cmmdtyordreqstoppriceqty CMMFDOR_ORDREQSTOPPRICEQTY Stop Price Quantity
cmmdtyordreqstoppriceqtyunit CMMFDOR_ORDREQSTOPPRCQTYUOM Stop Price Qty UoM
cmmdtyordreqstoplmtprc CMMFDOR_ORDERSTOPLIMITPRICE Stop Limit Price
cmmdtyordreqstoplmtprccrcy CMMFDOR_ORDERSTOPLIMITPRCCRCY Stop Limit Prc Crcy
cmmdtyordreqstoplmtprcqty CMMFDOR_ORDERSTOPLIMITPRICEQTY Stop Limit Prc Qty
cmmdtyordreqstoplmtprcqtyunit CMMFDOR_ORDERSTOPLMTPRCQTYUOM Stop Lmt Prc Qty UoM
cmmdtyordreqfxdprc CMMFDOR_ORDREQFIXEDPRICE Fixed Price
cmmdtyordreqfxdprccrcy CMMFDOR_ORDREQFIXEDPRICECRCY Requested Price Crcy
cmmdtyordreqfxdprcqty CMMFDOR_ORDREQFIXEDPRICEQTY Rqstd Price Quantity
cmmdtyordreqfxdprcqtyunit CMMFDOR_ORDREQFIXEDPRCQTYUOM Rqstd Prc Qty UoM
cmmdtyordreqfxdspreadprc CMMFDOR_ORDREQFIXEDSPREADPRICE Fixed Spread Value
cmmdtyordreqfxdspreadprccrcy CMMFDOR_ORDREQFXDSPREADPRCCRCY Rqstd Spr Prc Crcy
cmmdtyordreqfxdspreadprcqty CMMFDOR_ORDREQFXDSPREADPRCQTY Rqstd Spr. Price Qty
cmmdtyordfxdspreadprcqtyunit CMMFDOR_ORDREQFXDSPRDPRCQTYUOM Rqstd Spr Pr Qty UoM
cmmdtyorderrequestprocessstep CMMFDOR_ORDREQPROCESSSTEP Process Step
cmmdtyordreqinitialstatusisset CMMFDOR_ORDREQINITIALSTATUS Initial Status
cmmdtyordrequestcancellationid CMMFDOR_ORDCANCELLATIONID Cancellation ID
cmmdtyordrequestcanclndatetime CMMFDOR_ORDCANCELLATIONDATTIME Cancelled On
cmmdtyorderrequestcanceledby CMMFDOR_ORDCANCELLEDBY Cancelled By
cmmdtyorderreqpreviousstatus CMMFDOR_ORDERREQUESTPREVSTATUS Ord Previous Status
cmmdtyordrequestreferenceuuid /BOBF/UUID Key
commodityorderrequestreference CMMFDOR_ORDREQREFERENCE Origin/Amended Order
cmmdtyordreqoriglquantityinlot CMMFDOR_ORDREQORIGNUMBEROFLOTS Original Order Lots
commodityorderrequestticks CMMFDOR_ORDREQTICKS Order Request Ticks
cmmdtyordselfmatchpreventionid CMMFDOR_ORDSELFMATCHPREVID SMP ID
cmmdtyordmatchpreventioninstrn CMMFDOR_ORDSELFMATCHPREVINSTR SMP Instruction
cmmdtyorderreqiscopied CMMFDOR_ORDREQISCOPIED Copied Order Request
cmmdtyordrejectreferenceuuid CMMFDOR_REJECTREFERENCEUUID Order Rej Ref UUID
cmmdtyordreqrejectionreference CMMFDOR_REJECTIONREFERENCE Order Rejection Refe
isarchived CMMFDOR_ORDREQARCHIVE Archive Status
createdbyuser CMMFDOR_CREATEDBY Created By
creationdatetime CMMFDOR_CREATIONDATETIME Created On
lastchangedbyuser CMMFDOR_LASTCHANGEDBYUSER Last Changed By
lastchangedatetime CMMFDOR_LASTCHANGEDATETIME Last Changed On
dummy_subaccountextn CFD_DUMMY Dummy

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 Request
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMMFDOR_D_ORDER (
    MANDT,                           -- Client [MANDT]
    COMMODITYORDERREQUESTUUID,       -- Key [/BOBF/UUID]
    COMMODITYORDERREQUEST,           -- Order ID [CMMFDOR_ORDERREQUESTID]
    CMMDTYORDREQSENTTOBRKRDATETIME,  -- Transmitted On [CMMFDOR_ORDREQSENTTOBRKRDTETME]
    CMMDTYORDERREQUESTTYPE,          -- Order Type [CMMFDOR_ORDERTYPE]
    COMMODITYORDREQSTATUSREASON,     -- Status Reason [CMMFDOR_ORDERREQUSTATUSREASON]
    CMMDTYORDERREQREJECTIONREASON,   -- Rejection Reason [CMMFDOR_ORDERREQREJREASON]
    COMMODITYORDERREQUESTCOMMENT,    -- Comment [CMMFDOR_ORDERREQUESTCOMMENT]
    CMMDTYORDERREQUESTREASON,        -- Order Reason [CMMFDOR_ORDERREQUESTRSN]
    CMMDTYORDERREQUESTSTATUS,        -- Order Status [CMMFDOR_ORDERREQUESTSTATUS]
    CMMDTYORDERREQUESTSOURCE,        -- Order Source [CMMFDOR_CMMDTYORDREQUESTSOURCE]
    CMMDTYORDREQPRICINGPROGRAM,      -- Pricing Program [CMMFDOR_ORDREQPRICINGPROGRAM]
    CMMDTYORDERREQUESTEXCHANGETYPE,  -- Exchange Type [CMMFDOR_ORDREQEXCHANGETYPE]
    CMMDTYORDREQNEGTTNDATETIME,      -- Negotiated On [CMMFDOR_ORDNEGOTIATIONDATETIME]
    COUNTERPARTY,                    -- Counterparty [RKONTRAH_NEW]
    CMMDTYORDREQCNTRPTYSUBACCT,      -- Counterparty Subacct [CMMFDOR_ORDREQCNTRPTYSUBACCT]
    CMMDTYORDREQCNTRPTYSUBACCTUUID,  -- Key [/BOBF/UUID]
    COMMODITYSUBACCOUNT,             -- Assigned Subaccount [CMMFDOR_ASSIGNEDSUBACCOUNT]
    COMMODITYSUBACCOUNTUUID,         -- Key [/BOBF/UUID]
    CMMDTYORDREQUESTQUANTITYINLOT,   -- Order Lots [CMMFDOR_ORDREQNUMBEROFLOTS]
    CMMDTYORDERREQUESTFLOWTYPE,      -- Flow Type [CMMFDOR_ORDERREQUESTFLOWTYPE]
    COMMODITYDERIVATIVEBROKER,       -- Broker ID [CMMFDOR_BROKERID]
    CMMDTYORDREQCNTRPTYBROKER,       -- Counterparty Broker [CMMFDOR_CNTRPARTY_BROKER]
    COMMODITYORDERREQUESTTRADER,     -- Trader [RDEALER]
    CMMDTYORDINTERNALCOUNTERPARTY,   -- Int. Counterparty [CMMFDOR_INT_COUNTERPARTY]
    CMMDTYORDCNTRPTYBROKERREFACCT,   -- Counterparty Account [CMMFDOR_CNTRPTYBROKERREFACCT]
    CMMDTYDERIVATIVEQUANTITYPERLOT,  -- DCS Quantity [TBA_DCS_QNT]
    CMMDTYDRVTVQUANTITYUNITPERLOT,   -- DCS Unit of Measure [CMMFDOR_ORDREQDCSUOM]
    CMMDTYDERIVATIVECURRENCYPERLOT,  -- Currency [TBA_CURRENCY]
    CMMDTYORDREQEXPRTNINSTRUCTION,   -- Expiry Instruction [CMMFDOR_ORDEREXPIRATIONINST]
    CMMDTYORDREQUESTEXPIRATIONDATE,  -- Expiration Date [CMMFDOR_ORDREQEXPIRATIONDATE]
    CMMDTYORDREQEXPRYINSTRNCAT,      -- Exp. Instr. Category [CMMFDOR_EXPIRYINSTRUCTIONCAT]
    CMMDTYORDREQPRCGEXECINSTRN,      -- Prc/Exec Instruction [CMMFDOR_ORDPRCGEXECINSTRUCTION]
    CMMDTYORDREQPRCGEXECINSTRNCAT,   -- Prc/Exec Instr. Cat. [CMMFDOR_ORDPRCGEXECINSTRNCAT]
    CMMDTYORDREQLEEWAYRNGEPRC,       -- Leeway [CMMFDOR_ORDREQLEEWAYRNGEPRC]
    CMMDTYORDREQLEEWAYRNGEPRCCRCY,   -- Leeway Prc Crcy [CMMFDOR_ORDREQLEEWAYRNGEPRCCUR]
    CMMDTYORDREQLEEWAYRNGEPRCQTY,    -- Leeway Prc Qty [CMMFDOR_ORDREQLEEWAYRNGEPRCQTY]
    CMMDTYORDLEEWAYRNGEPRCQTYUNIT,   -- Leeway Qty UOM [CMMFDOR_ORDREQLWAYRNGPRCQTYUOM]
    CMMDTYORDREQLEEWAYPRC,           -- Requested Price [CMMFDOR_ORDREQLEEWAYPRICE]
    CMMDTYORDREQLEEWAYPRCCRCY,       -- Requested Price Crcy [CMMFDOR_ORDREQLEEWAYPRICECRCY]
    CMMDTYORDREQLEEWAYPRCQTY,        -- Rqstd Price Quantity [CMMFDOR_ORDREQLEEWAYPRICEQTY]
    CMMDTYORDREQLEEWAYPRCQTYUNIT,    -- Rqstd Prc Qty UoM [CMMFDOR_ORDREQLEEWAYPRCQTYUOM]
    CMMDTYORDREQLMTPRC,              -- Limit Price [CMMFDOR_CMMDTYORDERREQLIMPRICE]
    CMMDTYORDREQLMTPRCCURRENCY,      -- Limit Price Crcy [CMMFDOR_ORDREQLIMITPRICECRCY]
    CMMDTYORDREQLMTPRCQUANTITY,      -- Limit Price Quantity [CMMFDOR_ORDREQLIMITPRICEQTY]
    CMMDTYORDREQLMTPRCQUANTITYUNIT,  -- Limit Pr. Qty UoM [CMMFDOR_ORDREQLIMITPRCQTYUOM]
    CMMDTYORDREQLMTSPREADPRC,        -- Limit Spread Value [CMMFDOR_ORDREQLMTSPREADPRICE]
    CMMDTYORDREQLMTSPREADPRCCRCY,    -- Lim Spread Prc Crcy [CMMFDOR_ORDREQLMTSPREADPRCCRCY]
    CMMDTYORDREQLMTSPREADPRCQTY,     -- Limit Spr. Price Qty [CMMFDOR_ORDREQLMTSPREADPRCQTY]
    CMMDTYORDLMTSPREADPRCQTYUNIT,    -- Lim Sprd Prc Qty UOM [CMMFDOR_ORDREQLMTSPRDPRCQTYUOM]
    CMMDTYORDREQSTOPPRICE,           -- Stop Price [CMMFDOR_ORDREQSTOPPRICE]
    CMMDTYORDREQSTOPPRICECRCY,       -- Stop Price Crcy [CMMFDOR_ORDREQSTOPPRICECRCY]
    CMMDTYORDREQSTOPPRICEQTY,        -- Stop Price Quantity [CMMFDOR_ORDREQSTOPPRICEQTY]
    CMMDTYORDREQSTOPPRICEQTYUNIT,    -- Stop Price Qty UoM [CMMFDOR_ORDREQSTOPPRCQTYUOM]
    CMMDTYORDREQSTOPLMTPRC,          -- Stop Limit Price [CMMFDOR_ORDERSTOPLIMITPRICE]
    CMMDTYORDREQSTOPLMTPRCCRCY,      -- Stop Limit Prc Crcy [CMMFDOR_ORDERSTOPLIMITPRCCRCY]
    CMMDTYORDREQSTOPLMTPRCQTY,       -- Stop Limit Prc Qty [CMMFDOR_ORDERSTOPLIMITPRICEQTY]
    CMMDTYORDREQSTOPLMTPRCQTYUNIT,   -- Stop Lmt Prc Qty UoM [CMMFDOR_ORDERSTOPLMTPRCQTYUOM]
    CMMDTYORDREQFXDPRC,              -- Fixed Price [CMMFDOR_ORDREQFIXEDPRICE]
    CMMDTYORDREQFXDPRCCRCY,          -- Requested Price Crcy [CMMFDOR_ORDREQFIXEDPRICECRCY]
    CMMDTYORDREQFXDPRCQTY,           -- Rqstd Price Quantity [CMMFDOR_ORDREQFIXEDPRICEQTY]
    CMMDTYORDREQFXDPRCQTYUNIT,       -- Rqstd Prc Qty UoM [CMMFDOR_ORDREQFIXEDPRCQTYUOM]
    CMMDTYORDREQFXDSPREADPRC,        -- Fixed Spread Value [CMMFDOR_ORDREQFIXEDSPREADPRICE]
    CMMDTYORDREQFXDSPREADPRCCRCY,    -- Rqstd Spr Prc Crcy [CMMFDOR_ORDREQFXDSPREADPRCCRCY]
    CMMDTYORDREQFXDSPREADPRCQTY,     -- Rqstd Spr. Price Qty [CMMFDOR_ORDREQFXDSPREADPRCQTY]
    CMMDTYORDFXDSPREADPRCQTYUNIT,    -- Rqstd Spr Pr Qty UoM [CMMFDOR_ORDREQFXDSPRDPRCQTYUOM]
    CMMDTYORDERREQUESTPROCESSSTEP,   -- Process Step [CMMFDOR_ORDREQPROCESSSTEP]
    CMMDTYORDREQINITIALSTATUSISSET,  -- Initial Status [CMMFDOR_ORDREQINITIALSTATUS]
    CMMDTYORDREQUESTCANCELLATIONID,  -- Cancellation ID [CMMFDOR_ORDCANCELLATIONID]
    CMMDTYORDREQUESTCANCLNDATETIME,  -- Cancelled On [CMMFDOR_ORDCANCELLATIONDATTIME]
    CMMDTYORDERREQUESTCANCELEDBY,    -- Cancelled By [CMMFDOR_ORDCANCELLEDBY]
    CMMDTYORDERREQPREVIOUSSTATUS,    -- Ord Previous Status [CMMFDOR_ORDERREQUESTPREVSTATUS]
    CMMDTYORDREQUESTREFERENCEUUID,   -- Key [/BOBF/UUID]
    COMMODITYORDERREQUESTREFERENCE,  -- Origin/Amended Order [CMMFDOR_ORDREQREFERENCE]
    CMMDTYORDREQORIGLQUANTITYINLOT,  -- Original Order Lots [CMMFDOR_ORDREQORIGNUMBEROFLOTS]
    COMMODITYORDERREQUESTTICKS,      -- Order Request Ticks [CMMFDOR_ORDREQTICKS]
    CMMDTYORDSELFMATCHPREVENTIONID,  -- SMP ID [CMMFDOR_ORDSELFMATCHPREVID]
    CMMDTYORDMATCHPREVENTIONINSTRN,  -- SMP Instruction [CMMFDOR_ORDSELFMATCHPREVINSTR]
    CMMDTYORDERREQISCOPIED,          -- Copied Order Request [CMMFDOR_ORDREQISCOPIED]
    CMMDTYORDREJECTREFERENCEUUID,    -- Order Rej Ref UUID [CMMFDOR_REJECTREFERENCEUUID]
    CMMDTYORDREQREJECTIONREFERENCE,  -- Order Rejection Refe [CMMFDOR_REJECTIONREFERENCE]
    ISARCHIVED,                      -- Archive Status [CMMFDOR_ORDREQARCHIVE]
    CREATEDBYUSER,                   -- Created By [CMMFDOR_CREATEDBY]
    CREATIONDATETIME,                -- Created On [CMMFDOR_CREATIONDATETIME]
    LASTCHANGEDBYUSER,               -- Last Changed By [CMMFDOR_LASTCHANGEDBYUSER]
    LASTCHANGEDATETIME,              -- Last Changed On [CMMFDOR_LASTCHANGEDATETIME]
    DUMMY_SUBACCOUNTEXTN,            -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, COMMODITYORDERREQUESTUUID)
);