CMMFDOR_D_ORDER

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]
    PRIMARY KEY (MANDT, COMMODITYORDERREQUESTUUID)
);