C_CmmdtyOrdFillEnrichment

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 C_CmmdtyOrdFillEnrichment.
-- 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: CCMMDTYORDFILLEN

CREATE VIEW C_CmmdtyOrdFillEnrichment AS
SELECT
  FillEnrich.CommodityOrderRequestUUID AS CommodityOrderRequestUUID,
  FillEnrich.CommodityOrderFillPacketUUID AS CommodityOrderFillPacketUUID,
  FillEnrich.CmmdtyOrderReqLegOwnerRole AS CmmdtyOrderReqLegOwnerRole,
  FillEnrich.ControllingArea AS ControllingArea,
  FillEnrich.CommoditySubAccountUUID AS CommoditySubAccountUUID,
  FillEnrich.IsArchived AS IsArchived,
  FillEnrich.CmmdtyOrderReqLegUUID AS CmmdtyOrderReqLegUUID,
  FillEnrich.CmmdtyFillPacketTrdExecutionID AS CmmdtyFillPacketTrdExecutionID,
  FillEnrich.CmmdtyOrderReqDocCardinalValue AS CmmdtyOrderReqDocCardinalValue,
  FillEnrich.CmmdtyOrdFillAssignOrder AS CmmdtyOrdFillAssignOrder,
  _CommodityOrdFillTypeText.CmmdtyOrderFillIsMultiLegOrder AS CmmdtyOrderFillIsMultiLegOrder,
  _CommodityOrdFillTypeText.CmmdtyOrderFillAssignedToOrder AS CmmdtyOrderFillAssignedToOrder,
  _CommodityFutureID.CmmdtyOrderFillFutureName AS CmmdtyOrderFillFutureName,
  FillEnrich.CommodityOrderRequestTicks AS CommodityOrderRequestTicks,
  _Forward.CommodityOrderFillForwardID AS CommodityOrderFillForwardID,
  _Forward.CmmdtyOrdFillForwardFinTransID AS CmmdtyOrdFillForwardFinTransID,
  _Forward.CmmdtyOrdFillForwardStatusText AS CmmdtyOrdFillForwardStatusText,
  _DocumentCount.CmmdtyOrdFillNrOfAssignedDocs AS CmmdtyOrdFillNrOfAssignedDocs,
  _RelFillsCount.CmmdtyOrdFillNrOfRelatedFills AS CmmdtyOrdFillNrOfRelatedFills,
  FillEnrich.CmmdtyOrdReqFilledQuantity AS CmmdtyOrdReqFilledQuantity,
  FillEnrich.CmmdtyOrdReqToPriceTotQty AS CmmdtyOrdReqToPriceTotQty,
  FillEnrich.CmmdtyOrdReqPricedQuantityUnit AS CmmdtyOrdReqPricedQuantityUnit,
  _CommoditySubAccountVH.CommoditySubAccountName AS CommoditySubAccountName,
  FillEnrich.CreatedByUser AS CreatedByUser,
  FillEnrich.LastChangedByUser AS LastChangedByUser
FROM I_CommodityOrderFillTP AS FillEnrich
LEFT OUTER JOIN I_CmmdtyDrvtvContrKeyDates AS _DerivativeContractKeyDates ON FillEnrich.DerivativeContrSpecification = _DerivativeContractKeyDates.DerivativeContrSpecification AND FillEnrich.MaturityKeyDate = _DerivativeContractKeyDates.MaturityKeyDate  -- association [1..1]
LEFT OUTER JOIN C_CommodityOrdFillPacketTP AS _FillPacket ON CommodityOrderFillPacketUUID = _FillPacket.CommodityOrderFillPacketUUID  -- association [1..1]
LEFT OUTER JOIN i_MarketIdentifierCodeText AS _MarketIdentifierCodeText ON MarketIdentifierCode = _MarketIdentifierCodeText.MarketIdentifierCode AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContractSpecText AS _DerivativeContractSpecText ON DerivativeContrSpecification = _DerivativeContractSpecText.DerivativeContrSpecification AND Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdFillStatusText AS _CmmdtyOrdFillStatusText ON CmmdtyOrderFillStatus = _CmmdtyOrdFillStatusText.CmmdtyOrderFillStatus  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyDrvtvContrMicPhys AS _DrvtvContractSpecMicCommodity ON DerivativeContrSpecification = _DrvtvContractSpecMicCommodity.DerivativeContrSpecification AND MarketIdentifierCode = _DrvtvContractSpecMicCommodity.MarketIdentifierCode AND Commodity = _DrvtvContractSpecMicCommodity.Commodity  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdFillPosTypeText AS _CmmdtyOrdFillPositionText ON CmmdtyOrderRequestFlowType = _CmmdtyOrdFillPositionText.CmmdtyOrderFillPositionType  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyDrvtvOrderUserDetails AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyDrvtvOrderUserDetails AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyDrvtvOrderUserDetails AS _CommodityOrderFillDecidedBy ON CommodityOrderFillDecidedBy = _CommodityOrderFillDecidedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CommodityOrdFillTypeText AS _CommodityOrdFillTypeText ON CmmdtyOrderFillRequestType = _CommodityOrdFillTypeText.CmmdtyOrderFillRequestType  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrderFutureIDVH AS _CommodityFutureID ON CmmdtyOrderFillFutureID = _CommodityFutureID.CmmdtyOrderFillFutureID AND DerivativeContrSpecification = _CommodityFutureID.DerivativeContrSpecification AND MarketIdentifierCode = _CommodityFutureID.MarketIdentifierCode AND Commodity = _CommodityFutureID.Commodity  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdReqReasonText AS _CommodityOrdReqReasonText ON CmmdtyOrderRequestReason = _CommodityOrdReqReasonText.CmmdtyOrderRequestReason  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrderRequestType AS _CmmdtyOrderRequestType ON CmmdtyOrderRequestType = _CmmdtyOrderRequestType.CmmdtyOrderRequestType AND CmmdtyOrderRequestKind = _CmmdtyOrderRequestType.CmmdtyOrderRequestKind AND CmmdtyOrderRequestKindText = _CmmdtyOrderRequestType.CmmdtyOrderRequestKindText AND CmmdtyDrvtvCounterPartyInfo = _CmmdtyOrderRequestType.Counterparty AND CmmdtyDrvtvCounterPartyInfoTxt = _CmmdtyOrderRequestType.CmmdtyDrvtvCounterPartyInfoTxt  -- association [0..1]
LEFT OUTER JOIN I_CmmdtySubAcctBrokerVH AS _CmmdtySubAcctBrokerVH ON CommodityDerivativeBroker = _CmmdtySubAcctBrokerVH.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeVH AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdReqCntrPtyText AS _CmmdtyCounterPartyText ON CmmdtyDrvtvCounterPartyInfo = _CmmdtyCounterPartyText.CmmdtyOrdFillCounterPartyInfo  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON _ProfitCenterText.Language = $session.system_language AND _ProfitCenterText.ProfitCenter = ProfitCenter AND _ProfitCenterText.ValidityEndDate >= $session.system_date AND _ProfitCenterText.ValidityStartDate <= $session.system_date AND _ProfitCenterText.ControllingArea = ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CommoditySubAccountVH AS _CommoditySubAccountVH ON CommoditySubAccount = _CommoditySubAccountVH.CommoditySubAccount  -- association [0..1]
LEFT OUTER JOIN C_CmmdtyOrdFillAssgdDocTP AS _Document ON CommodityOrderFillPacketUUID = _Document.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN C_CmmdtyOrdFillRelatedFill AS _RelFills ON CommodityOrderFillUUID <> _RelFills.CommodityOrderFillUUID AND CommodityOrderRequestUUID = _RelFills.CommodityOrderRequestUUID AND CommodityOrderFillPacketUUID = _RelFills.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyOrderAssgdDocByOrdFill AS _DocumentCount ON CommodityOrderFillUUID = _DocumentCount.CommodityOrderFillUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyOrdReltdFillByOrdFill AS _RelFillsCount ON CommodityOrderFillUUID = _RelFillsCount.CommodityOrderFillUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyOrdFillPktStsText AS _CmmdtyOrdFillPacketStatusText ON CmmdtyOrderFillPacketStatus = _CmmdtyOrdFillPacketStatusText.CmmdtyOrderFillPacketStatus  -- association [0..1]
LEFT OUTER JOIN I_CommodityOrdFillKindText AS _CommodityOrdFillKindText ON CommodityOrderFillKind = _CommodityOrdFillKindText.CommodityOrderFillKind  -- association [0..1]
LEFT OUTER JOIN E_CommodityOrderFill AS _Extension ON CommodityOrderFillUUID = _Extension.CommodityOrderFillUUID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdFillForwardTP AS _Forward ON CommodityOrderFillUUID = _Forward.CommodityOrderFillUUID  -- association [0..1]
;