C_CmmdtyOrdFillEnrichment

Commodity Order Fill Enrichment View | view: CCMMDTYORDFILLEN | TRAN | Extraction: Not supported | Component: Commodity Derivative Order and Trade Execution
Tables used: CMMFDOF_D_FILL, CMMFDOF_D_FILL, CMMFDOF_D_FILL, CMMFDOF_D_FILL, CMMFDOR_D_ORDER, CMMFDOF_D_FILL, CMMFDOF_D_FWD, CMMFDOR_D_ORDER, CMMFDOF_D_FILL, CMMFDOR_D_DOC, CMMFDOF_D_FILL, CMMFDOR_D_ORDER, CMMFDOR_D_ORDER, CMMFDOF_D_FILL, CMMFDOF_D_FILL, BUT000, BUT100, TBAC_DCS_KD, TBAC_DCS, ADCP, ADR2, ADR6, ADRP, USR21, CMMFDCO_C_RCNT, CMMFDOF_D_FLPKT, CMMFDOF_D_FLPKT, CMMFSA_D_SUBACCT, VTIDERI, VWPANLA, CMMFDOR_D_LEG, CMMFDOR_C_ORDTYP, CMMFDOR_D_ORDCTG, CMMFDOF_D_FLPKT, CMMFSA_D_BROFIX, CMMFDOR_C_ORDTYP, CMMFDOR_C_ORDTYT, CMMFSA_D_BROFIX, CMMFSA_D_OFFFOOT, TBAC_PHYSCOMMT, CMMFDOF_D_FLPKT, CMMFSA_D_SUBACCT, CMMFDOF_D_FLPKT, CMMFDOF_D_FLPKT, CMMFSA_D_SUBACCT, CMMFDOF_D_FLMSG, CMMFDOF_C_FILLTT, CMMFDOF_C_FILLTY, CMMFSA_D_SUBACCT, T001, TKA02, T001, TKA02, TBAC_DCST, TBAC_MICT, CEPC, CEPCT, USR05, TBAC_DCS_LOF, TBAC_DCS_MIC, TBAC_DCS_CTY, T100
Column Name Description
CommodityOrderFillUUID UUID serving as key (parent key, root key)
Column Name Description
Column Name Description
Column Name Description
CmmdtyOrdFillReceiveDate Transaction On
MaturityKeyDate Maturity Key Date
LastChangeDate Last Changed On
Column Name Description
CmmdtyOrderReqLegOwnerRole Commodity Derivative Order Leg Owner Show values
CmmdtyOrderFillIsNavgnEnabled Commodity Derivative Fills Navigation Enabled Show values
CmmdtyOrderFillStatus Lifecycle Status of Commodity Order Fill Show values
IsArchived Archive Status Show values
CmmdtyOrderRequestFlowType Commodity Derivative Order Request Flow Type Show values
CmmdtyOrderFillPacketStatus Commodity Order Fill Packet Status Show values
CommodityOrderFillKind Commodity Order Fill Kind Show values
CmmdtyOrderReqDocCardinalValue Commodity Derivative Order Request Document Cardinal Value Show values
CmmdtyOrderRequestKind Commodity Derivative Order Kind Show values
CmmdtyOrderRequestReason Commodity Derivative Order Request Reason Show values
CmmdtyDrvtvCounterPartyInfo Commodity Derivative Counterparty Information Show values
CmmdtyOrdFillAssignOrder Assigned to Order Show values
CmmdtyOrderFillIsMultiLegOrder Commodity Derivative Multileg Order Show values
CmmdtyOrderFillAssignedToOrder Commodity Derivative Assign to Order Show values
CmmdtyOrderReqIsTrdAtSettlmt Is Trade at Settlement Order Show values
Column Name Description Domain name
CommodityOrderRequestUUID UUID serving as key (parent key, root key) SYSUUID
CommodityOrderFillPacketUUID UUID serving as key (parent key, root key) SYSUUID
CommodityOrderRequest Commodity Derivative Order Request ID CMMFDOR_ORDERREQUESTID
CmmdtyOrderRequestText Order Request ID CMMFDOF_CMMDTYORDERREQUESTTEXT
CommoditySubAccountUUID UUID serving as key (parent key, root key) SYSUUID
CmmdtyOrderReqLegUUID UUID serving as key (parent key, root key) SYSUUID
CommodityOrderFill Fill ID CMMFDOF_COMMODITYORDERFILL
SectionTitle null
CommodityOrderFillPacketID Commodity Derivative Order Fill Packet ID CMMFDOF_CMMDTYORDERFILLPKTID
CmmdtyOrderFillPacket Commodity Derivative Order Fill Packet Sequence CMMFDOF_CMMDTYORDERFILLPACKET
CmmdtyOrderFillPositionText Commodity Order Fill Position Type Text CMMFDOF_CMMDTYORDFILLPOSTEXT
CmmdtyOrderFillRequestTypeDesc Commodity Derivative Fill Packet Type CMMFDOF_FILLTYPEDESCRIPTION
CmmdtyOrderFillRequestType Commodity Derivative Fill Packet Type CMMFDOF_FILLTYPE
CmmdtyOrdFillFirstDistrdDteTme Commodity Order Fill First Distribution Date Time TZNTSTMPS
CmmdtyOrdFillLastDistrdDateTme Commodity Order Fill Last Distribution Date Time TZNTSTMPS
CmmdtyOrderFillDateTime Transaction Date Time
CmmdtyOrdFillPacketStatusText Commodity fill packet status CMMFDOF_FILLPACKETSTATUS
CommodityOrderFillKindText Commodity Order Fill Kind Text CMMFDOF_ORDFILLSTATUSTEXT
ProfitCenterName Description of Profit Center TEXT20
CommodityDerivativeBroker Comodity Derivative Broker ID BU_PARTNER
BusinessPartnerFullName Commodity Derivative Broker Name CMMFDOR_BROKERNAME
CompanyCodeName Name of Company Code or Company TEXT25
CmmdtyFillPacketMsgOrdID Commodity Order Fill External Source Reference CMMFDOF_CMMDTYORDFILLEXTORDREF
CmmdtyFillPacketTrdExecutionID Commodity Order Fill Trade Execution ID CMMFDOF_CMMDTYORDFILLTRDEXECID
CommodityOrderRequestTrader Trader RDEALER
StatusCriticality null
ConfirmationStatusCriticality null
CmmdtyOrderFillStatusText Commodity Order Fill Status Text CMMFDOF_ORDFILLSTATUSTEXT
CmmdtyOrderDateTime Order Req Created Oncreation TZNTSTMPS
CmmdtyOrderRequestKindText Short Text for Fixed Values DDTEXT
CmmdtyOrderRequestTypeText Commodity Derivative Order Type Description CMMFDOR_ORDERTYPEDESCRIPTION
CmmdtyOrderRequestReasonText Short Text for Fixed Values DDTEXT
CmmdtyDrvtvCounterPartyInfoTxt Short Text for Fixed Values DDTEXT
CmmdtyOrdFillRejectionReason Fill Rejection Reason CMMFDOF_FILLREJECTIONREASON
CommodityName Commodity Description TEXT40
MarketIdentifierCodeName Market Identifier Code Description TEXT40
DerivativeContrSpecName Description of Derivative Contract Specification TEXT40
CmmdtyOrdFillFinancialTransID Commodity Order Fill Financial Transaction ID T_RFHA
ContrDrvtvContrMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
CmmdtyOrderFillFutureID Commodity Order Fill Future ID CMMFDOF_CMMDTYORDFILLFUTUREID
CmmdtyOrderFillFutureName Short Name
CmmdtyOrderFillPrice Commodity Order Fill Price CMMFDOF_CMMDTYORDERFILLPRICE
CmmdtyOrdFillPrcPerFillQtyTxt Commodity Order Fill Price per Quantity Text CMMFDOF_FILLPRICEPERFILLTEXT
CmmdtyOrderFillTotalPrice Commodity Order Fill Total Price CMMFDOF_CMMDTYORDFILLTOTPRICE
CommodityProductSymbol Product Symbol CMMFDOF_PRODUCT_SYMBOL
CommodityOrderRequestTicks Commodity Order Traded Ticks CMMFDOR_ORDREQTICKS
CommodityOrderFillForwardID Commodity Forward ID CMMFDOF_COMMODITYORDERFORWARD
CmmdtyOrdFillForwardFinTransID Commodity Forward Financial Transaction ID T_RFHA
CmmdtyOrdFillForwardStatusText Short Text for Fixed Values
CmmdtyOrdFillNrOfAssignedDocs null
CmmdtyOrdFillNrOfRelatedFills null
CmmdtyOrderFillQuantityInLots Commodity Order Fill Quantity In Lots INT4
CmmdtyOrderFillTotalQuantity Commodity Derivative Order Request Quantity For Filling CMMFDOR_CMMDTYORDREQUESTQTY
CmmdtyOrdReqFilledQuantity null
CmmdtyOrdReqToBeFilledQtyTxt null
CmmdtyOrdReqToBePricedQtyTxt null
CmmdtyOrderFillQuantity Commodity Order Fill Quantity CMMFDOF_CMMDTYORDFILLQUANTITY
CmmdtyOrderRequestQuantity Commodity Order Fill Quantity CMMFDOF_CMMDTYORDFILLQUANTITY
CmmdtyOrdReqFilledQtyInLots Order Quantity In Lots CMMFDOF_CMMDTYFLPKTFLEDQTYLOTS
CmmdtyOrdReqRmngQtyInLots Remaining Quantity In Lots CMMFDOF_CMMDTYFLPKTRMGQTYLOTS
CmmdtyOrdFillRemQtyToPrice Remaining Quantity To Be Priced CMMFDOF_CMMDTYFILLREMQTYPRICE
CmmdtyOrderFillQuantityToPrice Fill Quantity to be Priced CMMFDOF_CMMDTYORDFILLQTYTOPRI
CmmdtyOrderFillPricedQuantity Fill Priced Quantity CMMFDOF_CMMDTYORDFILLPRICEDQTY
CmmdtyOrdReqToPriceTotQty null
Criticality null
CmmdtyOrdFillCumulativeQty Commodity Fill Order Cumilative Quantity
CmmdtyOrdFillCumulativeQtyText Commodity Fill Order Cumilative Quantity Text CMMFDOF_CMMDTYORDFILLCUMQTYTXT
CriticalityCode null
CmmdtyOrdFillCumPricedQuantity Commodity Fill Order Cumulative Priced Quantity
CmmdtyOrdFillCumltvPrcdQtyText Commodity Fill Order Cumulative Priced Quantity Text CMMFDOF_CMMDTYFILLCUMPRCQTYTXT
CommoditySubAccount Commodity Subaccount ID CMMFSA_SUBACCOUNTID
CommoditySubAccountName Commodity Subaccount Name CMMFSA_SUBACCOUNTNAME
CreationDateTime Timestamp of record creation TZNTSTMPS
CreatedByUser Created By User USNAM
LastChangeDateTime Timestamp of last change TZNTSTMPS
CmmdtyDrvtvOrdTrdExecIsRecent null
LastChangedByUser Last changed by user ID USNAM
CmmdtyOrdFillDecidedByUserName Decided By user name SUIDTECHDESC
CommodityOrderFillDecidedBy Decided By USNAM
Master Data Relations Join Conditions
Commodity Derivative Order Request Type
  • Commodity Derivative Order Request Type
  • Client
Commodity
  • Client
  • Commodity
Company Code
  • Company Code
  • Client
  • C_CMMDTYORDFILLENRICHMENT.COMPANYCODE == T001.BUKRS
  • C_CMMDTYORDFILLENRICHMENT.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_CMMDTYORDFILLENRICHMENT.MANDT == TKA01.MANDT
  • C_CMMDTYORDFILLENRICHMENT.CONTROLLINGAREA == TKA01.KOKRS
Derivative Contract Specification (DCS) C_CMMDTYORDFILLENRICHMENT.MANDT == TBAC_DCS.CLIENT
Market Identifier Code (MIC)
  • Client
  • Market Identifier Code (MIC)
  • C_CMMDTYORDFILLENRICHMENT.MANDT == TBAC_MIC.CLIENT
  • C_CMMDTYORDFILLENRICHMENT.MARKETIDENTIFIERCODE == TBAC_MIC.MIC
Profit Center
  • Client
  • Profit Center
  • ?
  • ?
  • C_CMMDTYORDFILLENRICHMENT.MANDT == CEPC.MANDT
  • C_CMMDTYORDFILLENRICHMENT.PROFITCENTER == CEPC.PRCTR
  • C_CMMDTYORDFILLENRICHMENT.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_CMMDTYORDFILLENRICHMENT.[column in domain "DATBI"] == CEPC.DATBI