C_CommodityOrderRequestTP

Commodity Derivative Order Request | view: CCMMDTYORDREQTP | TRAN | Extraction: Not supported | Component: Commodity Derivative Order and Trade Execution
Tables used: CMMFDOF_D_FILL, CMMFDOR_D_ORDER, CMMFDOR_D_ORD_D, SDRAFT_ADMIN, CMMFDOR_D_DOC, CMMFDOR_D_BKTI, BUT000, BUT100, TBAC_DCS_KD, TBAC_DCS, ADCP, ADR2, ADR6, ADRP, USR21, CMMFDCO_C_RCNT, CMMFDOR_C_EINSTR, CMMFDOR_C_EINSTT, CMMFDOR_D_EXINTR, CMMFDOR_D_EXINTT, CMMFSA_D_SUBACCT, VTIDERI, VWPANLA, CMMFDOR_D_LEG, CMMFDOR_C_ORDTYP, CMMFDOR_D_ORDCTG, CMMFDOF_D_FLPKT, CMMFSA_D_BROFIX, CMMFDOR_C_ORDTYT, CMMFDOR_C_PREXEC, CMMFDOR_C_PREXET, CMMFDOR_D_PRCGET, CMMFDOR_D_PRCGEX, CMMFSA_D_OFFFOOT, TBAC_PHYSCOMMT, CMMFDOF_D_FLMSG, T001, TKA02, TBAC_DCST, TBAC_MICT, T006, T006A, USR05, TBAC_DCS_LOF, TBAC_DCS_MIC, TBAC_DCS_CTY, T100
Column Name Description
CommodityOrderRequestUUID UUID serving as key (parent key, root key)
Column Name Description
Column Name Description
📏 Commodity Derivative Order Request Priced Quantity UOM (CmmdtyOrdReqToBePricedQtyUnit):
CmmdtyDerivativeQuantityPerLot Derivative Contract Specification Quantity
Column Name Description
CmmdtyOrderReqNegotiationDate Commodity Derivative Order Request Negotiation Date
CmmdtyOrderRequestMessageDate Date of record creation
CmmdtyOrdReqLongMaturityKeyDte Maturity Key Date
CmmdtyOrdReqShrtMaturityKeyDte Maturity Key Date
CmmdtyOrdRequestExpirationDate Commodity Derivative Order Request Expiration Date
CreationDateDecimalValue Created On
LastChangeDate Last Changed On
Column Name Description
CmmdtyOrderReqDocCardinalValue Commodity Derivative Order Request Document Cardinal Value Show values
CmmdtyOrderRequestKind Commodity Derivative Order Kind Show values
CmmdtyOrdFillCounterPartyInfo Commodity Derivative Counterparty Information Show values
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
CmmdtyOrdReqInitialStatusIsSet Order Request Initial Status is Set Show values
CmmdtyOrdReqExpiryInstruction Commodity Derivative Order Request Expiry Instruction Show values
CmmdtyOrderReqMsgIsAvailable Commodity Order Request Message Availability Show values
CmmdtyOrderRequestLongFlowType Commodity Derivative Order Request Flow Type Show values
CmmdtyDrvtvLongMktPriceSource Commodity Order Request Last Known Market Price Source Show values
CmmdtyOrdRequestShortFlowType Commodity Derivative Order Request Flow Type Show values
CmmdtyDrvtvShrtMktPriceSource Commodity Order Request Last Known Market Price Source Show values
CmmdtyOrdReqPrcgExecInstrnCat Pricing and Execution Instruction Category Show values
CmmdtyOrdReqExprtnInstruction Commodity Derivative Order Request Expiry Instruction Show values
CmmdtyOrdReqExpryInstrnCat Expiration Instruction Category of Derivative Orders Show values
Column Name Description Domain name
CommodityOrderRequest Commodity Derivative Order Request ID CMMFDOR_ORDERREQUESTID
CmmdtyOrdReqSentToBrkrDateTime Commodity Derivative Order Request Sent to Broker Time Stamp TZNTSTMPS
CompanyCodeName Name of Company Code or Company TEXT25
CmmdtyOrderRequestTypeText Commodity Derivative Order Type Description CMMFDOR_ORDERTYPEDESCRIPTION
CommodityOrderFillCategory Commodity Derivative Order Category CMMFDOR_ORDERCATEGORY
CommodityOrdReqStatusReason Order Request Status Reason CMMFDOR_ORDERREQUSTATUSREASON
CmmdtyOrderReqRejectionReason Commodity Derivative Order Request Rejection Reason CMMFDOR_ORDERREQREJREASON
CmmdtyOrderRequestKindText Short Text for Fixed Values DDTEXT
CmmdtyDrvtvCounterPartyInfoTxt Short Text for Fixed Values DDTEXT
CmmdtyOrderRequestFlowType Commodity Order Request Flow Type Text DDTEXT
CmmdtyOrderRequestReasonText Description of Order Request Reason DDTEXT
StatusCriticality null
CmmdtyOrderRequestStatusText Commodity Derivative Order Request Status Text CMMFDOF_ORDFILLSTATUSTEXT
CmmdtyOrderRequestSourceText Short Text for Fixed Values DDTEXT
CmmdtyOrdReqPricingProgram Commodity Derivative Order Request Pricing Program CMMFDOR_ORDREQPRICINGPROGRAM
CommodityOrderRequestTrader Trader RDEALER
CommodityOrderRequestComment Commodity Derivative Order Request Comment
CmmdtyOrdReqExchangeTypeText Commodity Derivative Order Request Exchange Type Text DDTEXT
CmmdtyOrdReqNegttnDateTime Commodity Derivative Order Request Negotiation Date Time TZNTSTMPS
CmmdtyOrderRequestProcessStep Commodity Derivative Order Request Process Step CMMFDOR_ORDREQPROCESSSTEP
CmmdtyOrdReqCntrPtySubAcctName 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
HasErrorDescription Commodity Order Request Message Availability Text DDTEXT
CmmdtyOrdReqMessageDateTime Timestamp of record creation TZNTSTMPS
NumberOfErrorMessages null
NumberOfWarningMessages null
CmmdtyOrdReqNrOfAssignedDocs null
CmmdtyOrdReqNrOfAssignedFills null
CmmdtyOrdReqNrOfReltdBrackets null
NumberOfRecords null
CmmdtyOrdReqLongFlowTypeText Short Text for Fixed Values DDTEXT
CmmdtyOrderRequestLongFuture Commodity Order Request Future ID CMMFDOR_CMMDTYORDFILLFUTUREID
CmmdtyOrdRequestLongFutureName Short Name XKBEZ
CmmdtyOrdReqLongCommodityName Commodity Description ALLTEXT
CmmdtyOrdReqLongMktIDCodeName Market Identifier Code Description ALLTEXT
CmmdtyOrdReqLongDrvtvContrName Description of Derivative Contract Specification TEXT40
CmmdtyDrvtvLongLegMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
CmmdtyDrvtvLongMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
CmmdtyDrvtvLongMktPrcPerQtyTxt Commodity Order Request Last Known Market Price per Qty Text CHAR80
CmmdtyDrvtvLongMktPrcUpdatedOn Commodity Derivative Last Known Market Price Updated On TZNTSTMPL
CmmdtyDrvtvLongMktPrcSrceText Commodity Order Request Last Known Market Price Source Text DDTEXT
CmmdtyOrdReqShortFlowTypeText Short Text for Fixed Values DDTEXT
CmmdtyOrdReqShortFuture Commodity Order Request Future ID CMMFDOR_CMMDTYORDFILLFUTUREID
CmmdtyOrdReqShortFutureName Short Name XKBEZ
CmmdtyOrdReqShortCommodityName Commodity Description ALLTEXT
CmmdtyOrdReqShrtMktIDCodeName Market Identifier Code Description ALLTEXT
CmmdtyOrdReqShrtDrvtvContrName Description of Derivative Contract Specification TEXT40
CmmdtyDrvtvShrtLegMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
CmmdtyDrvtvShrtMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
CmmdtyDrvtvShrtMktPrcPerQtyTxt Commodity Order Request Last Known Market Price per Qty Text CHAR80
CmmdtyDrvtvShrtMktPrcUpdatedOn Commodity Derivative Last Known Market Price Updated On TZNTSTMPL
CmmdtyDrvtvShrtMktPrcSrceText Commodity Order Request Last Known Market Price Source Text DDTEXT
CmmdtyOrdRequestQuantityInLot Commodity Derivative Order Request Quantity in Lots INT2_NOS
CmmdtyOrdReqToBeFilledQty Remaining quantity of order to be filled CMMFDOR_CMMDTYORDREQFILLTOQTY
CmmdtyOrdReqToBeFilledQtyTxt null
CmmdtyOrderRequestQuantity Commodity Derivative Order Request Quantity For Filling CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqFilledQuantity Commodity Derivative Order Request Filled Quantity CMMFDOR_CMMDTYORDREQUESTTOTQTY
CmmdtyOrdReqToBePricedQty Commodity Order Request Total Quantity To Be Priced CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqToBePricedQtyTxt null
CriticalityCode null
Criticality null
CmmdtyOrdReqToPriceTotQty Commodity Derivative Order Request Quantity for Pricing CMMFDOR_ORDREQPRICEDQTY
CmmdtyOrdReqPricedQuantity Commodity Derivative Order Request Priced Quantity CMMFDOR_ORDREQPRICEDQTY
CmmdtyDrvtvLastMktPrcPerQtyTxt Commodity Order Request Last Known Market Price per Qty Text CHAR80
CmmdtyLastSpreadValPerQtyTxt Commodity Order Request Requested Spread Value per Qty Text CHAR80
CmmdtyOrdReqPrcgExecInstrn Commodity Order Request Pricing and Execution Instruction CMMFDOR_ORDPRCGEXECINSTRUCTION
CmmdtyOrdReqPrcExecInsText Cmmdty Drvtv Order Pricing Execution Instruction Description DDTEXT
CmmdtyOrdReqLmtPrc Commodity Derivative Order Request Limit Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqLmtPrcQuantity Commodity Derivative Order Request Limit Price Quantity CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqLmtPrcPerQtyTxt Commodity Order Request Limt Price per Quantity Text CHAR80
CmmdtyOrdReqLmtSpreadPrc Commodity Derivative Order Request Limit Spread Value CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqLmtSpreadPrcQty Limit Spread Price Quantity of Order Request CMMFDOR_CMMDTYORDREQLSTMARKQTY
CmmdtyOrdReqLmtSpreadPrcQtyTxt Order Request Limit Spread Price per Quantity Unit CHAR80
CmmdtyOrdReqStopPrice Commodity Derivative Order Request Stop Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqStopPriceQty Commodity Derivative Order Request Stop Price Quantity CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqStopPricePerQtyTxt Commodity Order Request Stop Price per Quantity Text CHAR80
CmmdtyOrdReqStopLmtPrc Commodity Derivative Order Stop Limit Price CMMFDOR_ORDERSTOPLIMITPRICE
CmmdtyOrdReqStopLmtPrcQty Commodity Derivative Order Request Stop Limit Price Quantity CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqLeewayPrc Commodity Derivative Order Request Requested Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqLeewayPrcQty Commodity Derivative Order Request Requested Price Quantity CMMFDOR_CMMDTYORDREQLSTMARKQTY
CmmdtyOrdReqLeewayPrcPerQtyTxt Commodity Order Request Requested Price per Quantity Text CHAR80
CmmdtyOrdReqLeewayRngePrc Commodity Derivative Order Request Leeway Price CMMFDOR_CMMDTYORDERREQLIMPRICE
CmmdtyOrdReqLeewayRngePrcQty Cmmdty Derivative Order Request Leeway Range Price Quantity CMMFDOR_CMMDTYORDREQLSTMARKQTY
CmmdtyOrdLeewayRngePrcQtyTxt Commodity Order Request Leeway Price per Quantity Text CHAR80
CommodityOrderRequestTicks Commodity Order Request Ticks CMMFDOR_ORDREQTICKS
CmmdtyOrdReqExpInstrnText Expiration Instruction Description DDTEXT
CommoditySubAccountUUID UUID serving as key (parent key, root key) SYSUUID
CommoditySubAccount Assigned Commodity Subaccount CMMFSA_SUBACCOUNTID
CommoditySubAccountName Assigned Commodity Subaccount Name CMMFSA_SUBACCOUNTNAME
UnitOfMeasureNumberOfDecimals null
CommodityDerivativeBroker Comodity Derivative Broker ID BU_PARTNER
BusinessPartnerFullName Commodity Derivative Broker Name CMMFDOR_BROKERNAME
CmmdtyOrdSelfMatchPreventionID Self-Match Prevention IDs for Commodity Deriviative Orders CMMFDOR_ORDSELFMATCHPREVID
CmmdtyOrdMatchPreventionInstrn Commodity Order Request Self-Match Prevention Instruction CMMFDOR_ORDSELFMATCHPREVINSTR
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
CmmdtyOrderReqPreviousStatus Commodity Order Request Previous Status CMMFDOR_ORDERREQUESTPREVSTATUS
CreationDateTime Timestamp of record creation TZNTSTMPS
CreatedByUser Created By User USNAM
CreatedByUserName Created by user name TEXT80
LastChangeDateTime Timestamp of last change TZNTSTMPS
LastChangedByUser Last changed by user ID USNAM
LastChangedByUserName Last changed by user name TEXT80
CmmdtyOrdRequestCancellationID Commodity Order Request Cancellation ID CMMFDOR_ORDCANCELLATIONID
CmmdtyOrdRequestCanclnDateTime Commodity Order Request Cancellation Date Time TZNTSTMPS
CmmdtyOrderRequestCanceledBy Commodity Order Request Cancelled By USNAM
UserDescription Cancelled by user name TEXT80
InProcessByUser Draft In Process By UNAME
CmmdtyDrvtvOrdTrdExecIsRecent null
Master Data Relations Join Conditions
Counterparty
  • Cmmdty Order Request Counterparty Broker Reference Account
  • Counterparty number
  • Counterparty Broker
  • Client
Commodity Derivative Order Request Type
  • Commodity Derivative Order Request Type
  • Client
Commodity Derivative Order Request Exchange Commodity
  • Commodity
  • Commodity Derivative Order Request Exchange Commodity
  • Commodity Derivative Order Request Exchange Commodity
  • Client
  • C_COMMODITYORDERREQUESTTP.COMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQLONGCOMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQSHORTCOMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.MANDT == TBAC_PHYSCOMM.CLIENT
Derivative Contract Specification (DCS) C_COMMODITYORDERREQUESTTP.MANDT == TBAC_DCS.CLIENT
Market Identifier Code
  • Client
  • Market Identifier Code
  • Market Identifier Code
  • C_COMMODITYORDERREQUESTTP.MANDT == TBAC_MIC.CLIENT
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQLONGMKTIDCODE == TBAC_MIC.MIC
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQSHRTMKTIDCODE == TBAC_MIC.MIC
Commodity Derivative Order Request Exchange Commodity
  • Commodity
  • Commodity Derivative Order Request Exchange Commodity
  • Commodity Derivative Order Request Exchange Commodity
  • Client
  • C_COMMODITYORDERREQUESTTP.COMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQLONGCOMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQSHORTCOMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.MANDT == TBAC_PHYSCOMM.CLIENT
Derivative Contract Specification (DCS) C_COMMODITYORDERREQUESTTP.MANDT == TBAC_DCS.CLIENT
Market Identifier Code
  • Client
  • Market Identifier Code
  • Market Identifier Code
  • C_COMMODITYORDERREQUESTTP.MANDT == TBAC_MIC.CLIENT
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQLONGMKTIDCODE == TBAC_MIC.MIC
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQSHRTMKTIDCODE == TBAC_MIC.MIC
Commodity
  • Commodity
  • Commodity Derivative Order Request Exchange Commodity
  • Commodity Derivative Order Request Exchange Commodity
  • Client
  • C_COMMODITYORDERREQUESTTP.COMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQLONGCOMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.CMMDTYORDREQSHORTCOMMODITY == TBAC_PHYSCOMM.COMMODITY
  • C_COMMODITYORDERREQUESTTP.MANDT == TBAC_PHYSCOMM.CLIENT
Broker Group ID
  • Broker Group ID
  • Client
Company Code
  • Company Code
  • Client
  • C_COMMODITYORDERREQUESTTP.COMPANYCODE == T001.BUKRS
  • C_COMMODITYORDERREQUESTTP.MANDT == T001.MANDT
Derivative Contract Specification (DCS) C_COMMODITYORDERREQUESTTP.MANDT == TBAC_DCS.CLIENT
Market Identifier Code (MIC)
  • Market Identifier Code (MIC)
  • Client
  • C_COMMODITYORDERREQUESTTP.MARKETIDENTIFIERCODE == TBAC_MIC.MIC
  • C_COMMODITYORDERREQUESTTP.MANDT == TBAC_MIC.CLIENT