C_CommodityOrderFillTP

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_CommodityOrderFillTP.
-- 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: CCMMDTYORDFILLTP

CREATE VIEW C_CommodityOrderFillTP AS
SELECT
  Fill.CommodityOrderRequestUUID AS CommodityOrderRequestUUID,
  Fill.CommodityOrderFillPacketUUID AS CommodityOrderFillPacketUUID,
  Fill.CmmdtyOrderReqLegOwnerRole AS CmmdtyOrderReqLegOwnerRole,
  cast( Fill.CommodityOrderRequest as cmmfdor_orderrequestid preserving type ) AS CommodityOrderRequest,
  Fill.ControllingArea AS ControllingArea,
  Fill.CommoditySubAccountUUID AS CommoditySubAccountUUID,
  Fill.IsArchived AS IsArchived,
  Fill.CmmdtyOrderReqLegUUID AS CmmdtyOrderReqLegUUID
FROM I_CommodityOrderFillTP AS Fill
LEFT OUTER JOIN I_CmmdtyDrvtvContrKeyDates AS DerivativeContractKeyDates ON Fill.DerivativeContrSpecification = DerivativeContractKeyDates.DerivativeContrSpecification AND Fill.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 _DcsMicCommodity ON DerivativeContrSpecification = _DcsMicCommodity.DerivativeContrSpecification AND MarketIdentifierCode = _DcsMicCommodity.MarketIdentifierCode AND Commodity = _DcsMicCommodity.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 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]
;