I_CommodityOrderRequest

Commodity Order Request Interface View | view: ICMMDTYORDREQ | TRAN | Extraction: Not supported | Component: Commodity Derivative Order and Trade Execution
Tables used: CMMFDOR_D_ORDER, CMMFSA_D_SUBACCT
Column Name Description
CommodityOrderRequestUUID UUID serving as key (parent key, root key)
Column Name Description
Column Name Description
📏 Derivative Contract Specification Unit of Measure (CmmdtyDrvtvQuantityUnitPerLot):
CmmdtyDerivativeQuantityPerLot Derivative Contract Specification Quantity
Column Name Description
CmmdtyOrdRequestExpirationDate Commodity Derivative Order Request Expiration Date
Column Name Description
CmmdtyOrderRequestReason Commodity Derivative Order Request Reason Show values
CmmdtyOrderRequestStatus Commodity Derivative Order Request Status Show values
CmmdtyOrderRequestSource Commodity Derivative Order Request Source Show values
CmmdtyOrderRequestExchangeType Commodity Derivative Order Request Exchange Type Show values
CmmdtyOrdReqExprtnInstruction Commodity Derivative Order Request Expiry Instruction Show values
CmmdtyOrdReqExpryInstrnCat Expiration Instruction Category of Derivative Orders Show values
CmmdtyOrdReqInitialStatusIsSet Order Request Initial Status is Set Show values
CmmdtyOrdReqPrcgExecInstrnCat Pricing and Execution Instruction Category Show values
Column Name Description Domain name
CommodityOrderRequest Commodity Derivative Order Request ID CMMFDOR_ORDERREQUESTID
CommodityOrdReqStatusReason Order Request Status Reason CMMFDOR_ORDERREQUSTATUSREASON
CmmdtyOrderReqRejectionReason Commodity Derivative Order Request Rejection Reason CMMFDOR_ORDERREQREJREASON
CommodityOrderRequestComment Commodity Derivative Order Request Comment CMMFDOR_ORDERREQUESTCOMMENT
CmmdtyOrdReqPricingProgram Commodity Derivative Order Request Pricing Program CMMFDOR_ORDREQPRICINGPROGRAM
CmmdtyOrdReqSentToBrkrDateTime Commodity Derivative Order Request Sent to Broker Time Stamp TZNTSTMPS
CmmdtyOrdReqNegttnDateTime Commodity Derivative Order Request Negotiation Date Time TZNTSTMPS
CommodityDerivativeBroker Comodity Derivative Broker ID BU_PARTNER
CommodityOrderRequestTrader Trader RDEALER
CmmdtyOrderRequestProcessStep Commodity Derivative Order Request Process Step CMMFDOR_ORDREQPROCESSSTEP
CmmdtyOrdRequestQuantityInLot Commodity Derivative Order Request Quantity in Lots INT2_NOS
CmmdtyOrderRequestQuantity Commodity Derivative Order Request Quantity For Filling CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqPrcgExecInstrn Commodity Order Request Pricing and Execution Instruction CMMFDOR_ORDPRCGEXECINSTRUCTION
CmmdtyOrdReqLmtPrc Commodity Derivative Order Request Limit Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqLmtPrcQuantity Commodity Derivative Order Request Limit Price Quantity CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqLmtSpreadPrc Commodity Derivative Order Request Limit Spread Value CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqLmtSpreadPrcQty Limit Spread Price Quantity of Order Request CMMFDOR_CMMDTYORDREQLSTMARKQTY
CmmdtyOrdReqStopPrice Commodity Derivative Order Request Stop Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqStopPriceQty Commodity Derivative Order Request Stop Price Quantity CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqStopLmtPrc Commodity Derivative Order Stop Limit Price CMMFDOR_ORDERSTOPLIMITPRICE
CmmdtyOrdReqStopLmtPrcQty Commodity Derivative Order Request Stop Limit Price Quantity CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqFxdPrc Commodity Derivative Order Request Requested Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqFxdPrcQty Commodity Derivative Order Request Requested Price Quantity CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqFxdSpreadPrc Commodity Derivative Order Request Requested Spread Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqFxdSpreadPrcQty Commodity Derivative Order Requested Spread Price Quantity CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqLeewayPrc Commodity Derivative Order Request Requested Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqLeewayPrcQty Commodity Derivative Order Request Requested Price Quantity CMMFDOR_CMMDTYORDREQLSTMARKQTY
CmmdtyOrdReqLeewayRngePrc Commodity Derivative Order Request Leeway Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqLeewayRngePrcQty Cmmdty Derivative Order Request Leeway Range Price Quantity CMMFDOR_CMMDTYORDREQLSTMARKQTY
CommoditySubAccount Commodity Subaccount ID CMMFSA_SUBACCOUNTID
CommoditySubAccountUUID UUID serving as key (parent key, root key) SYSUUID
CommoditySubAccountName Assigned Commodity Subaccount Name CMMFSA_SUBACCOUNTNAME
CmmdtyOrdReqCntrPtySubAcct Commodity Order Request Counterparty Subaccount CMMFSA_SUBACCOUNTID
CmmdtyOrdReqCntrPtySubAcctUUID UUID serving as key (parent key, root key) SYSUUID
Counterparty Counterparty number BU_PARTNER
CmmdtyOrdReqCntrPtyBroker Counterparty Broker CMMFSA_COUNTERPARTY_BROKER
CmmdtyOrdInternalCounterparty CDOTE Internal Counterparty BU_PARTNER
CmmdtyOrdRequestCancellationID Commodity Order Request Cancellation ID CMMFDOR_ORDCANCELLATIONID
CmmdtyOrdRequestCanclnDateTime Commodity Order Request Cancellation Date Time TZNTSTMPS
CmmdtyOrderRequestCanceledBy Commodity Order Request Cancelled By USNAM
CmmdtyOrderReqPreviousStatus Commodity Order Request Previous Status CMMFDOR_ORDERREQUESTPREVSTATUS
CmmdtyOrdRequestReferenceUUID UUID serving as key (parent key, root key) SYSUUID
CommodityOrderRequestReference Commodity Order Request Reference CMMFDOR_ORDREQREFERENCE
CmmdtyOrdReqOriglQuantityInLot Commodity Derivative Order Request Quantity in Lots INT2_NOS
CmmdtyOrdReqRejectionReference Order Rejection Reference CMMFDOR_REJECTIONREFERENCE
CmmdtyOrdRejectReferenceUUID Order Rejection Reference UUID SYSUUID
CmmdtyOrderReqIsCopied Copied Order Request Indicator CMMFDOR_ORDREQISCOPIED
CmmdtyOrdSelfMatchPreventionID Self-Match Prevention IDs for Commodity Deriviative Orders CMMFDOR_ORDSELFMATCHPREVID
CmmdtyOrdMatchPreventionInstrn Commodity Order Request Self-Match Prevention Instruction CMMFDOR_ORDSELFMATCHPREVINSTR
CommodityOrderRequestTicks Commodity Order Request Ticks CMMFDOR_ORDREQTICKS
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
Counterparty
  • Client
  • Counterparty Broker
  • Cmmdty Order Request Counterparty Broker Reference Account
  • Counterparty number
Commodity Derivative Order Request Type
  • Commodity Derivative Order Request Type
  • Client
Commodity
  • Commodity
  • Client
Company Code
  • Client
  • Company Code
  • I_COMMODITYORDERREQUEST.MANDT == T001.MANDT
  • I_COMMODITYORDERREQUEST.COMPANYCODE == T001.BUKRS
Market Identifier Code (MIC)
  • Client
  • Market Identifier Code (MIC)
  • I_COMMODITYORDERREQUEST.MANDT == TBAC_MIC.CLIENT
  • I_COMMODITYORDERREQUEST.MARKETIDENTIFIERCODE == TBAC_MIC.MIC