I_CommodityOrderFill

DDL: I_COMMODITYORDERFILL SQL: ICMMDTYORDERFILL Type: view BASIC Package: FS_CMM_CDOTE_ORDER_FILL
61 Fields 4 Data Sources 1 Associations

Commodity Order Fill

I_CommodityOrderFill is a Basic CDS View that provides data about "Commodity Order Fill" in SAP S/4HANA. It reads from 4 data sources (cmmfdof_d_flpkt, cmmfdor_d_order, cmmfsa_d_subacct, cmmfdof_d_fill) and exposes 61 fields with key field CommodityOrderFillUUID. It has 1 association to related views. Part of development package FS_CMM_CDOTE_ORDER_FILL.

Data Sources (4)

SourceAliasJoin Type
cmmfdof_d_flpkt CommodityOrderFillPacket left_outer
cmmfdor_d_order CommodityOrderRequest left_outer
cmmfsa_d_subacct CommoditySubaccount left_outer
cmmfdof_d_fill Fill from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_CommodityOrderFill _Extension $projection.CommodityOrderFillUUID = _Extension.CommodityOrderFillUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYORDERFILL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Commodity Order Fill view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY CommodityOrderFillUUID cmmfdof_d_fill commodityorderfilluuid Key
CommodityOrderFillPacketUUID cmmfdof_d_fill commodityorderfillpacketuuid Key
CommodityOrderFillPacketID cmmfdof_d_flpkt commodityorderfillpacketid Fill Packet ID
CommodityOrderFill cmmfdof_d_fill commodityorderfill Fill ID
CmmdtyOrderFillRequestType cmmfdof_d_flpkt cmmdtyorderfillrequesttype Fill Packet Type
CmmdtyOrderFillPacket cmmfdof_d_fill cmmdtyorderfillpacket Fill Packet Sequence
CmmdtyOrderFillDateTime cmmfdof_d_fill cmmdtyorderfilldatetime Transaction Time
CommodityOrderRequestUUID cmmfdof_d_fill commodityorderrequestuuid Key
CmmdtyOrderReqLegUUID cmmfdof_d_fill cmmdtyorderreqleguuid Key
CommodityOrderRequest cmmfdor_d_order commodityorderrequest Order ID
CmmdtyOrderDateTime cmmfdor_d_order creationdatetime Timestamp
CmmdtyOrderRequestType cmmfdor_d_order cmmdtyorderrequesttype Order Type
CmmdtyOrderRequestSource cmmfdor_d_order cmmdtyorderrequestsource Order Source
CmmdtyOrderRequestReason cmmfdor_d_order cmmdtyorderrequestreason Order Reason
CmmdtyOrdRequestQuantityInLot cmmfdor_d_order cmmdtyordrequestquantityinlot Quantity Amendment
CmmdtyDerivativeQuantityPerLot cmmfdor_d_order cmmdtyderivativequantityperlot DCS Quantity
CmmdtyOrderFillStatus cmmfdof_d_fill cmmdtyorderfillstatus Ord. Fill Proc. Type
CommoditySubAccountUUID cmmfdof_d_fill commoditysubaccountuuid Key
CommoditySubAccount cmmfsa_d_subacct commoditysubaccount Subaccount ID
CommoditySubAccountName cmmfsa_d_subacct commoditysubaccountname Subaccount Name
CommodityDerivativeBroker cmmfdof_d_fill commodityderivativebroker Broker ID
ReferenceBrokerAccount cmmfdof_d_fill referencebrokeraccount Reference Account
CmmdtyOrdReqCntrPtyBroker cmmfdof_d_fill cmmdtyordreqcntrptybroker Counterparty Broker
CmmdtyOrdReqCntrPtySubAcct cmmfdof_d_fill cmmdtyordreqcntrptysubacct Counterparty Subacct
CmmdtyOrderReqLegOwnerRole cmmfdof_d_fill cmmdtyorderreqlegownerrole Ord. Req. Leg Owner
ProfitCenter cmmfsa_d_subacct profitcenter Profit Center
CompanyCode cmmfsa_d_subacct companycode Receiver Company Code
CmmdtyOrdFillFinancialTransID cmmfdof_d_fill cmmdtyordfillfinancialtransid Financ Transact ID
CmmdtyOrderRequestFlowType cmmfdof_d_fill cmmdtyorderrequestflowtype Flow Type
CmmdtyOrderFillFutureID cmmfdof_d_fill cmmdtyorderfillfutureid Future
Commodity cmmfdof_d_fill commodity Commodity Code
MarketIdentifierCode cmmfdof_d_fill marketidentifiercode MIC
DerivativeContrSpecification cmmfdof_d_fill derivativecontrspecification DCS ID
MaturityKeyDate cmmfdof_d_fill maturitykeydate Maturity Key Date
CmmdtyOrdFillQuantityPerLot cmmfdof_d_fill cmmdtyordfillquantityperlot DCS Quantity
CmmdtyOrdFillUoMPerLot cmmfdof_d_fill cmmdtyordfilluomperlot DCS Unit of Measure
CmmdtyOrderFillCurrencyPerLot cmmfdof_d_fill cmmdtyorderfillcurrencyperlot Currency
CmmdtyOrderFillQuantityInLots cmmfdof_d_fill cmmdtyorderfillquantityinlots Fill Lots
CmmdtyOrderFillPrice cmmfdof_d_fill cmmdtyorderfillprice Fill Price
CmmdtyOrderFillPriceCrcy cmmfdof_d_fill cmmdtyorderfillpricecrcy Fill Price Currency
CmmdtyOrdFillAssignOrder cmmfdof_d_fill cmmdtyordfillassignorder Assigned To Order
CmmdtyOrderFillPacketStatus cmmfdof_d_flpkt cmmdtyorderfillpacketstatus Fill Packet Status
CmmdtyFillPacketMsgOrdID cmmfdof_d_flpkt cmmdtyfillpacketmsgordid External Order Ref
CmmdtyFillPacketTrdExecutionID cmmfdof_d_flpkt cmmdtyfillpackettrdexecutionid Trade Exec. ID
CmmdtyOrderFillTotQuantityUnit cmmfdof_d_fill cmmdtyordfilluomperlot DCS Unit of Measure
CmmdtyOrderFillQtyToPriceUnit cmmfdof_d_fill cmmdtyordfilluomperlot DCS Unit of Measure
createdbyuserasCreatedByUser
CreationDateTime cmmfdof_d_fill creationdatetime Timestamp
LastChangedByUser cmmfdof_d_fill lastchangedbyuser User Name
LastChangeDateTime cmmfdof_d_fill lastchangedatetime Timestamp
CommodityOrderFillDecidedBy cmmfdof_d_fill decidedby Decided By
CommodityOrderFillDecidedOn cmmfdof_d_fill decidedon Decided On
CmmdtyOrdFillRejectionReason cmmfdof_d_fill cmmdtyordfillrejectionreason Rejection Reason
CmmdtyOrderFillCounterParty cmmfdof_d_fill cmmdtyorderfillcounterparty Counter Party
CmmdtyOrderIsFillWithOrder cmmfdof_d_fill cmmdtyorderisfillwithorder Fill With Order
CommodityProductSymbol cmmfdof_d_fill commodityproductsymbol Product Symbol
CmmdtyOrdFillIsMktClsPrcAssgd cmmfdof_d_fill cmmdtyordfillismktclsprcassgd Mkt Cls Prc Assigned
CmmdtyOrdFillMarketClosePrice cmmfdof_d_fill cmmdtyordfillmarketcloseprice Market Close Price
CmmdtyOrdFillMktPrcAtFwdCrtn cmmfdof_d_fill cmmdtyordfillmktprcatfwdcrtn Market Price
CmmdtyOrderReqIsTrdAtSettlmt cmmfdof_d_fill cmmdtyorderreqistrdatsettlmt Trade at Settlement
IsArchived cmmfdof_d_fill succ_archive Archive Status

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CommodityOrderFill.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICMMDTYORDERFILL

CREATE VIEW I_CommodityOrderFill AS
SELECT
  Fill.commodityorderfilluuid AS CommodityOrderFillUUID,
  Fill.commodityorderfillpacketuuid AS CommodityOrderFillPacketUUID,
  CommodityOrderFillPacket.commodityorderfillpacketid AS CommodityOrderFillPacketID,
  Fill.commodityorderfill AS CommodityOrderFill,
  CommodityOrderFillPacket.cmmdtyorderfillrequesttype AS CmmdtyOrderFillRequestType,
  Fill.cmmdtyorderfillpacket AS CmmdtyOrderFillPacket,
  Fill.cmmdtyorderfilldatetime AS CmmdtyOrderFillDateTime,
  Fill.commodityorderrequestuuid AS CommodityOrderRequestUUID,
  Fill.cmmdtyorderreqleguuid AS CmmdtyOrderReqLegUUID,
  CommodityOrderRequest.commodityorderrequest AS CommodityOrderRequest,
  CommodityOrderRequest.creationdatetime AS CmmdtyOrderDateTime,
  CommodityOrderRequest.cmmdtyorderrequesttype AS CmmdtyOrderRequestType,
  CommodityOrderRequest.cmmdtyorderrequestsource AS CmmdtyOrderRequestSource,
  CommodityOrderRequest.cmmdtyorderrequestreason AS CmmdtyOrderRequestReason,
  CommodityOrderRequest.cmmdtyordrequestquantityinlot AS CmmdtyOrdRequestQuantityInLot,
  CommodityOrderRequest.cmmdtyderivativequantityperlot AS CmmdtyDerivativeQuantityPerLot,
  Fill.cmmdtyorderfillstatus AS CmmdtyOrderFillStatus,
  Fill.commoditysubaccountuuid AS CommoditySubAccountUUID,
  CommoditySubaccount.commoditysubaccount AS CommoditySubAccount,
  CommoditySubaccount.commoditysubaccountname AS CommoditySubAccountName,
  Fill.commodityderivativebroker AS CommodityDerivativeBroker,
  Fill.referencebrokeraccount AS ReferenceBrokerAccount,
  Fill.cmmdtyordreqcntrptybroker AS CmmdtyOrdReqCntrPtyBroker,
  Fill.cmmdtyordreqcntrptysubacct AS CmmdtyOrdReqCntrPtySubAcct,
  Fill.cmmdtyorderreqlegownerrole AS CmmdtyOrderReqLegOwnerRole,
  CommoditySubaccount.profitcenter AS ProfitCenter,
  CommoditySubaccount.companycode AS CompanyCode,
  Fill.cmmdtyordfillfinancialtransid AS CmmdtyOrdFillFinancialTransID,
  Fill.cmmdtyorderrequestflowtype AS CmmdtyOrderRequestFlowType,
  Fill.cmmdtyorderfillfutureid AS CmmdtyOrderFillFutureID,
  Fill.commodity AS Commodity,
  Fill.marketidentifiercode AS MarketIdentifierCode,
  Fill.derivativecontrspecification AS DerivativeContrSpecification,
  Fill.maturitykeydate AS MaturityKeyDate,
  Fill.cmmdtyordfillquantityperlot AS CmmdtyOrdFillQuantityPerLot,
  Fill.cmmdtyordfilluomperlot AS CmmdtyOrdFillUoMPerLot,
  Fill.cmmdtyorderfillcurrencyperlot AS CmmdtyOrderFillCurrencyPerLot,
  Fill.cmmdtyorderfillquantityinlots AS CmmdtyOrderFillQuantityInLots,
  Fill.cmmdtyorderfillprice AS CmmdtyOrderFillPrice,
  Fill.cmmdtyorderfillpricecrcy AS CmmdtyOrderFillPriceCrcy,
  Fill.cmmdtyordfillassignorder AS CmmdtyOrdFillAssignOrder,
  CommodityOrderFillPacket.cmmdtyorderfillpacketstatus AS CmmdtyOrderFillPacketStatus,
  CommodityOrderFillPacket.cmmdtyfillpacketmsgordid AS CmmdtyFillPacketMsgOrdID,
  CommodityOrderFillPacket.cmmdtyfillpackettrdexecutionid AS CmmdtyFillPacketTrdExecutionID,
  Fill.cmmdtyordfilluomperlot AS CmmdtyOrderFillTotQuantityUnit,
  Fill.cmmdtyordfilluomperlot AS CmmdtyOrderFillQtyToPriceUnit,
  Fill.creationdatetime AS CreationDateTime,
  Fill.lastchangedbyuser AS LastChangedByUser,
  Fill.lastchangedatetime AS LastChangeDateTime,
  Fill.decidedby AS CommodityOrderFillDecidedBy,
  Fill.decidedon AS CommodityOrderFillDecidedOn,
  Fill.cmmdtyordfillrejectionreason AS CmmdtyOrdFillRejectionReason,
  Fill.cmmdtyorderfillcounterparty AS CmmdtyOrderFillCounterParty,
  Fill.cmmdtyorderisfillwithorder AS CmmdtyOrderIsFillWithOrder,
  Fill.commodityproductsymbol AS CommodityProductSymbol,
  Fill.cmmdtyordfillismktclsprcassgd AS CmmdtyOrdFillIsMktClsPrcAssgd,
  Fill.cmmdtyordfillmarketcloseprice AS CmmdtyOrdFillMarketClosePrice,
  Fill.cmmdtyordfillmktprcatfwdcrtn AS CmmdtyOrdFillMktPrcAtFwdCrtn,
  Fill.cmmdtyorderreqistrdatsettlmt AS CmmdtyOrderReqIsTrdAtSettlmt,
  Fill.succ_archive AS IsArchived
FROM cmmfdof_d_fill AS Fill
LEFT OUTER JOIN cmmfdor_d_order AS CommodityOrderRequest ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmmfsa_d_subacct AS CommoditySubaccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmmfdof_d_flpkt AS CommodityOrderFillPacket ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_CommodityOrderFill AS _Extension ON CommodityOrderFillUUID = _Extension.CommodityOrderFillUUID  -- association [0..1]
;

Learn More