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,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  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 C_HierRuntimeRprstnDplLeafNode AS _ProfitCenterHierLeafNode ON ProfitCenter = _ProfitCenterHierLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _ProfitCenterHierLeafNode.HierarchyNodeClass AND _ProfitCenterHierLeafNode.ValidityStartDate <= $session.system_date AND _ProfitCenterHierLeafNode.ValidityEndDate >= $session.system_date AND _ProfitCenterHierLeafNode.HierarchyType = '0106'  -- association [0..*]
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]
;