I_CommodityOrderFillPacket

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_CommodityOrderFillPacket.
-- 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: ICMMDTYORDFLPKT

CREATE VIEW I_CommodityOrderFillPacket AS
SELECT
  FillPacket.commodityorderfillpacketuuid AS CommodityOrderFillPacketUUID,
  FillPacket.cmmdtyorderfillpacket AS CmmdtyOrderFillPacket,
  FillPacket.cmmdtyordfillpackettype AS CmmdtyOrdFillPacketType,
  FillPacket.commodityorderfillpacketid AS CommodityOrderFillPacketID,
  FillPacket.cmmdtyfillpacketmsgordid AS CmmdtyFillPacketMsgOrdID,
  FillPacket.cmmdtyfillpackettrdexecutionid AS CmmdtyFillPacketTrdExecutionID,
  FillPacket.cmmdtyorderfillrequesttype AS CmmdtyOrderFillRequestType,
  FillPacket.cmmdtyordfillcounterpartyinfo AS CmmdtyOrdFillCounterPartyInfo,
  FillPacket.cmmdtyordreqfilledqtyinlots AS CmmdtyOrdReqFilledQtyInLots,
  FillPacket.cmmdtyordreqrmngqtyinlots AS CmmdtyOrdReqRmngQtyInLots,
  FillPacket.cmmdtyordreqfilledqtyinlots AS CmmdtyOrderFillQuantityInLots,
  FillPacket.cmmdtyordfillrejectionreason AS CmmdtyOrdFillRejectionReason,
  FillPacket.cmmdtyordfillmultilegtype AS CmmdtyOrdFillMultiLegType,
  FillPacket.cmmdtyorderfillpacketstatus AS CmmdtyOrderFillPacketStatus,
  FillPacket.cmmdtyorderisfillwithorder AS CmmdtyOrderIsFillWithOrder,
  FillPacket.cmmdtyordfillfirstdistrddtetme AS CmmdtyOrdFillFirstDistrdDteTme,
  FillPacket.cmmdtyordfilllastdistrddatetme AS CmmdtyOrdFillLastDistrdDateTme,
  FillPacket.commodityorderrequesttrader AS CommodityOrderRequestTrader,
  FillPacket.decidedby AS CommodityOrderFillDecidedBy,
  FillPacket.decidedon AS CommodityOrderFillDecidedOn,
  FillPacketSubAcct.CommoditySubAccountUUID AS CommoditySubAccountUUID,
  FillPacketSubAcct.DerivativeContrSpecification AS DerivativeContrSpecification,
  FillPacketSubAcct.CommoditySubAccount AS CommoditySubAccount,
  FillPacketSubAcct.CommoditySubAccountName AS CommoditySubAccountName,
  FillPacketSubAcct.CommodityDerivativeBroker AS CommodityDerivativeBroker,
  FillPacketSubAcct.CompanyCode AS CompanyCode,
  FillPacketSubAcct.ProfitCenter AS ProfitCenter,
  _CommodityOrderRequest.creationdatetime AS CmmdtyOrderDateTime,
  _CommodityOrderRequest.cmmdtyorderrequesttype AS CmmdtyOrderRequestType,
  _CommodityOrderRequest.cmmdtyorderrequestsource AS CmmdtyOrderRequestSource,
  _CommodityOrderRequest.cmmdtyorderrequestreason AS CmmdtyOrderRequestReason,
  _CommodityOrderRequest.cmmdtyordrequestquantityinlot AS CmmdtyOrdRequestQuantityInLot,
  _CommodityOrderRequest.cmmdtydrvtvquantityunitperlot AS CmmdtyOrderRequestQuantityUnit,
  FillPacket.creationdatetime AS CreationDateTime,
  FillPacket.lastchangedbyuser AS LastChangedByUser,
  FillPacket.lastchangedatetime as LastChangeDateTime AS lastchangedatetimeasLastChangeDateTime
FROM cmmfdof_d_flpkt AS FillPacket
LEFT OUTER JOIN I_CmmdtyOrderFillPacketSubAcct AS FillPacketSubAcct ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cmmfdor_d_order AS _CommodityOrderRequest ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_CmmdtyOrderFillPacket AS _Extension ON CommodityOrderFillPacketUUID = _Extension.CommodityOrderFillPacketUUID  -- association [0..1]
;