I_GHONetworkMasterDetail

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_GHONetworkMasterDetail.
-- 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.

CREATE VIEW I_GHONetworkMasterDetail AS
SELECT
  a.AllocationRunID AS AllocationRunID,
  a.GHONetworkID AS GHONetworkID,
  a.NetworkMedium AS NetworkMedium,
  a.ProductionAllocationType AS ProductionAllocationType,
  a.AllocationFrequencyCode AS AllocationFrequencyCode,
  a.ProductionAllocationDate AS ProductionAllocationDate,
  a.ProductionAllocationTime AS ProductionAllocationTime,
  a.NetworkAllocationPurpose AS NetworkAllocationPurpose,
  a.NetworkAllocationStatus AS NetworkAllocationStatus,
  a.GHOCreatedOnDateTime AS GHOCreatedOnDateTime,
  a.GHOChangedOnDateTime AS GHOChangedOnDateTime,
  case when a.LastChangedByUser is not initial then a.LastChangedByUser else a.CreatedByUser end AS LastChangedByUser,
  b.AllocationRuleUnitOfMsmt AS AllocationRuleUnitOfMsmt,
  b.AllocUnitOfMsmtGroup AS AllocUnitOfMsmtGroup,
  b.AllocConversionGroup AS AllocConversionGroup,
  a._ProductionNetworkDetails AS _ProductionNetworkDetails
FROM I_GHOProdnAllocationResults AS a
LEFT OUTER JOIN C_GHODefermentAnalysis AS _DefermentAnalysis ON GHONetworkID = _DefermentAnalysis.GHONetworkID AND NetworkMedium = _DefermentAnalysis.NetworkMedium AND AllocationFrequencyCode = _DefermentAnalysis.AllocationFrequencyCode AND ProductionAllocationDate = _DefermentAnalysis.ProductionDate AND ProductionAllocationTime = _DefermentAnalysis.UpstreamProductionTime AND AllocationRuleUnitOfMsmt = _DefermentAnalysis.AllocationRuleUnitOfMsmt  -- association [0..1]
LEFT OUTER JOIN I_GHONtwkObjVarblData AS _NetworkVarblData ON GHONetworkID = _NetworkVarblData.ProductionNetworkID AND ProdnAllocDateTime between _NetworkVarblData.ValidFrom AND _NetworkVarblData.ValidTo  -- association [0..1]
LEFT OUTER JOIN I_GHOAllocationRunVersion AS _AllocationRunVersion ON GHONetworkID = _AllocationRunVersion.GHONetworkID AND NetworkMedium = _AllocationRunVersion.NetworkMedium AND AllocationFrequencyCode = _AllocationRunVersion.AllocationFrequencyCode AND ProductionAllocationDate = _AllocationRunVersion.ProductionAllocationDate AND ProductionAllocationTime = _AllocationRunVersion.ProductionAllocationTime AND ProductionAllocationType = _AllocationRunVersion.ProductionAllocationType AND NetworkAllocationPurpose = _AllocationRunVersion.NetworkAllocationPurpose AND NetworkAllocationStatus = _AllocationRunVersion.NetworkAllocationStatus  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
;