I_CommodityOrderRequestTP

Commodity Order Req. Transactional View | view: ICMMDTYORDREQTP | TRAN | Extraction: Not supported | Component: Commodity Derivative Order and Trade Execution
Tables used: CMMFDOF_D_FILL, CMMFDOR_D_ORDER, CMMFDOR_D_DOC, BUT000, BUT100, CMMFDCO_C_RCNT, CMMFSA_D_SUBACCT, CMMFDOR_D_LEG, CMMFDOR_C_ORDTYP, CMMFDOR_D_ORDCTG, CMMFDOF_D_FLPKT, CMMFDOR_C_ORDTYT, CMMFSA_D_BROFIX, CMMFDOF_D_FLMSG, T006, T006A, T100
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
CmmdtyOrderReqNegotiationDate Commodity Derivative Order Request Negotiation Date
CmmdtyOrdRequestExpirationDate Commodity Derivative Order Request Expiration Date
CmmdtyOrderRequestMessageDate Date of record creation
CreationDateDecimalValue Created On
LastChangeDate Last Changed On
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
CmmdtyOrderRequestKind Commodity Derivative Order Kind Show values
CmmdtyOrdFillCounterPartyInfo Commodity Derivative Counterparty Information Show values
CmmdtyOrderReqDocCardinalValue Commodity Derivative Order Request Document Cardinal Value 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
CmmdtyOrderReqMsgIsAvailable Commodity Order Request Message Availability Show values
CmmdtyOrdReqPrcgExecInstrnCat Pricing and Execution Instruction Category Show values
Column Name Description Domain name
CommodityOrderRequest Commodity Derivative Order Request ID CMMFDOR_ORDERREQUESTID
CmmdtyOrderRequestFlowType Commodity Order Request Flow Type Text DDTEXT
CmmdtyOrderReqRejectionReason Commodity Derivative Order Request Rejection Reason CMMFDOR_ORDERREQREJREASON
StatusCriticality null
CommodityOrdReqStatusReason Order Request Status Reason CMMFDOR_ORDERREQUSTATUSREASON
CommodityOrderRequestTrader Trader RDEALER
CmmdtyOrderRequestProcessStep Commodity Derivative Order Request Process Step CMMFDOR_ORDREQPROCESSSTEP
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
CommodityOrderFillCategory Commodity Derivative Order Category CMMFDOR_ORDERCATEGORY
CmmdtyOrderRequestKindText Short Text for Fixed Values DDTEXT
CmmdtyDrvtvCounterPartyInfoTxt Short Text for Fixed Values DDTEXT
CmmdtyOrdReqNegttnDateTime Commodity Derivative Order Request Negotiation Date Time TZNTSTMPS
CmmdtyOrdRequestQuantityInLot Commodity Derivative Order Request Quantity in Lots INT2_NOS
CmmdtyOrderRequestQuantity Commodity Derivative Order Request Quantity For Filling CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqFilledQuantity Commodity Derivative Order Request Filled Quantity CMMFDOR_CMMDTYORDREQUESTTOTQTY
CriticalityCode null
CmmdtyOrdReqToBeFilledQty Remaining quantity of order to be filled CMMFDOR_CMMDTYORDREQFILLTOQTY
CmmdtyOrdReqToBeFilledQtyTxt null
CmmdtyOrdReqOpenQtyInLots Commodity Order Request Document Open Quantity in Lots CMMFDOR_CMMDTYORDOPNQTYINLOTS
CmmdtyOrdReqToPriceTotQty Commodity Derivative Order Request Quantity for Pricing CMMFDOR_ORDREQPRICEDQTY
CmmdtyOrdReqSendToBrkrIsAutom null
CmmdtyOrderReqIsApproved null
CmmdtyOrdReqPricedQuantity Commodity Derivative Order Request Priced Quantity CMMFDOR_ORDREQPRICEDQTY
Criticality null
CmmdtyOrdReqToBePricedQty Commodity Order Request Total Quantity To Be Priced CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqToBePricedQtyTxt null
CmmdtyOrdReqMessageDateTime Timestamp of record creation TZNTSTMPS
NumberOfErrorMessages null
NumberOfWarningMessages null
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
CommodityDerivativeBroker Comodity Derivative Broker ID BU_PARTNER
BusinessPartnerFullName Commodity Derivative Broker Name CMMFDOR_BROKERNAME
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
CmmdtyOrderReqIsSentForCancln null
CmmdtyOrderReqPreviousStatus Commodity Order Request Previous Status CMMFDOR_ORDERREQUESTPREVSTATUS
CmmdtyOrdRejectReferenceUUID Order Rejection Reference UUID SYSUUID
CmmdtyOrdReqRejectionReference Order Rejection Reference CMMFDOR_REJECTIONREFERENCE
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
CmmdtyOrderReqIsCopied Copied Order Request Indicator CMMFDOR_ORDREQISCOPIED
CommodityOrderRequestTicks Commodity Order Request Ticks CMMFDOR_ORDREQTICKS
CmmdtyOrdSelfMatchPreventionID Self-Match Prevention IDs for Commodity Deriviative Orders CMMFDOR_ORDSELFMATCHPREVID
CmmdtyOrdMatchPreventionInstrn Commodity Order Request Self-Match Prevention Instruction CMMFDOR_ORDSELFMATCHPREVINSTR
CreatedByUser Created By User USNAM
CreationDateTime Timestamp of record creation TZNTSTMPS
LastChangedByUser Last changed by user ID USNAM
LastChangeDateTime Timestamp of last change TZNTSTMPS
CmmdtyDrvtvOrdTrdExecIsRecent null
Master Data Relations Join Conditions
Counterparty
  • Cmmdty Order Request Counterparty Broker Reference Account
  • Counterparty Broker
  • Client
  • Counterparty number
Commodity Derivative Order Request Type
  • Client
  • Commodity Derivative Order Request Type
Commodity
  • Commodity
  • Client
Broker Group ID
  • Client
  • Broker Group ID
Company Code
  • Client
  • Company Code
  • I_COMMODITYORDERREQUESTTP.MANDT == T001.MANDT
  • I_COMMODITYORDERREQUESTTP.COMPANYCODE == T001.BUKRS
Market Identifier Code (MIC)
  • Client
  • Market Identifier Code (MIC)
  • I_COMMODITYORDERREQUESTTP.MANDT == TBAC_MIC.CLIENT
  • I_COMMODITYORDERREQUESTTP.MARKETIDENTIFIERCODE == TBAC_MIC.MIC