I_CommodityOrderRequestFill

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_CommodityOrderRequestFill.
-- 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: ICMMDTYORDFILL

CREATE VIEW I_CommodityOrderRequestFill 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,
  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,
  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.succ_archive AS IsArchived
FROM cmmfdof_d_fill AS Fill
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 */
;