C_CommodityOrdFillPacketTP

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_CommodityOrdFillPacketTP.
-- 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: CCMMDTYORDFPKTTP

CREATE VIEW C_CommodityOrdFillPacketTP AS
SELECT
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  FillPacket.CmmdtyFillPacketTrdExecutionID AS CmmdtyFillPacketTrdExecutionID,
  FillPacket.CmmdtyOrderFillRequestType AS CmmdtyOrderFillRequestType,
  _DocumentCount.CmmdtyFillPacketNrOfAssgdDocs AS CmmdtyFillPacketNrOfAssgdDocs,
  _AssignedFillsCount.CmmdtyFillPacketNrOfAssgdFills AS CmmdtyFillPacketNrOfAssgdFills
FROM I_CommodityOrdFillPacketTP AS FillPacket
LEFT OUTER JOIN C_CommodityOrderFillTP AS _Fill ON CommodityOrderFillPacketUUID = _Fill.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN C_CmmdtyOrdFillEnrichment AS _FillEnrich ON CommodityOrderFillPacketUUID = _FillEnrich.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN C_CommodityOrdFillPacketLogTP AS _FillPacketLog ON CommodityOrderFillPacketUUID = _FillPacketLog.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyText AS _Commodity ON Commodity = _Commodity.Commodity AND _Commodity.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CommodityOrdFillTypeText AS _CommodityFillPacketTypeText ON CmmdtyOrdFillPacketType = _CommodityFillPacketTypeText.CmmdtyOrderFillRequestType  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdFillPktStsText AS _CmmdtyOrdFillPacketStatusText ON CmmdtyOrderFillPacketStatus = _CmmdtyOrdFillPacketStatusText.CmmdtyOrderFillPacketStatus  -- association [0..1]
LEFT OUTER JOIN I_CmmdtySubAcctBrokerVH AS _CmmdtySubAcctBrokerVH ON CommodityDerivativeBroker = _CmmdtySubAcctBrokerVH.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdReqCntrPtyText AS _CmmdtyCounterPartyText ON CmmdtyOrdFillCounterPartyInfo = _CmmdtyCounterPartyText.CmmdtyOrdFillCounterPartyInfo  -- association [0..1]
LEFT OUTER JOIN I_CommodityOrderRequestVH AS _CmmdtyOrderRequestVH ON CommodityOrderRequest = _CmmdtyOrderRequestVH.CommodityOrderRequest  -- association [0..1]
LEFT OUTER JOIN C_CmmdtyOrdFillAssgdDocTP AS _Document ON CommodityOrderFillPacketUUID = _Document.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN C_CmmdtyOrdFillPacketAssgdFill AS _AssignedFills ON CommodityOrderFillPacketUUID = _AssignedFills.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN C_CmmdtyOrderFillPacketLog AS _ErrorLog ON CommodityOrderFillPacketUUID = _ErrorLog.CommodityOrderFillPacketUUID  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyOrderAssgdDocByPacket AS _DocumentCount ON CommodityOrderFillPacketUUID = _DocumentCount.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyOrderAssgdFillByPacket AS _AssignedFillsCount ON CommodityOrderFillPacketUUID = _AssignedFillsCount.CommodityOrderFillPacketUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyDrvtvOrderUserDetails AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyDrvtvOrderUserDetails AS _LastChangedBy ON LastChangedByUser = _LastChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyDrvtvOrderUserDetails AS _CommodityOrderFillDecidedBy ON CommodityOrderFillDecidedBy = _CommodityOrderFillDecidedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdRequestKindText AS _CommodityOrdReqKindText ON CmmdtyOrderRequestKind = _CommodityOrdReqKindText.CmmdtyOrderRequestKind  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyOrdReqReasonText AS _CommodityOrdReqReasonText ON CmmdtyOrderRequestReason = _CommodityOrdReqReasonText.CmmdtyOrderRequestReason  -- 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_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_CmmdtyOrderFillPacket AS _Extension ON CommodityOrderFillPacketUUID = _Extension.CommodityOrderFillPacketUUID  -- association [0..1]
;