I_GHONtwkObjAllocThrtclRslt

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_GHONtwkObjAllocThrtclRslt.
-- 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_GHONtwkObjAllocThrtclRslt AS
SELECT
  AllocationRunID,
  GHONetworkID,
  cast (_EstimatedTheo.GHOFromNtwkObjID as gho_ntwkobj_id preserving type ) AS GHOFromNtwkObjID,
  cast (_EstimatedTheo.GHOToNtwkObjID as gho_ntwkobj_id preserving type ) AS GHOToNtwkObjID,
  _EstimatedTheo.AllocationRuleUnitOfMsmt AS AllocationRuleUnitOfMsmt,
  NetworkMedium,
  AllocationFrequencyCode,
  ProductionAllocationDate,
  ProductionAllocationTime,
  ProdnAllocUTCDteTme,
  ProductionAllocationType,
  _EstimatedTheo.AllocationRuleMsmtValue AS AllocationRuleMsmtValue,
  _EstimatedTheo.GHOQuantityType AS GHOQuantityType,
  _EstimatedTheo.GHOQuantityCategory AS GHOQuantityCategory,
  _EstimatedTheo._NtwkAllocRuleQtyType AS _NtwkAllocRuleQtyType,
  _EstimatedTheo._QuantityCategory AS _QuantityCategory
FROM I_GHOProdnAllocationResults
LEFT OUTER JOIN I_GHOProdnAllocRsltsItems AS _AdjustedTheo ON GHOFromNtwkObjID = _AdjustedTheo.GHOFromNtwkObjID AND _AdjustedTheo.AllocRsltsThrtclOrActual = 'C' AND AllocationRunID = _AdjustedTheo.AllocationRunID AND allocationruleunitofmsmt = _AdjustedTheo.AllocationRuleUnitOfMsmt AND ghoquantitytype = _AdjustedTheo.GHOQuantityType  -- association [0..1]
LEFT OUTER JOIN I_GHONtwkObjects AS _NetworkObjectDetails ON GHOFromNtwkObjID = _NetworkObjectDetails.GHONetworkObjectID  -- association [1..1]
LEFT OUTER JOIN I_GHOProdnAllocRsltsItems AS _FormationTheoretical ON GHOFromNtwkObjID = _FormationTheoretical.GHOFromNtwkObjID AND _FormationTheoretical.AllocRsltsThrtclOrActual = 'X' AND AllocationRunID = _FormationTheoretical.AllocationRunID AND allocationruleunitofmsmt = _FormationTheoretical.AllocationRuleUnitOfMsmt  -- association [0..1]
LEFT OUTER JOIN I_GHOProdnAllocRsltsItems AS _GasLiftGasTheoretical ON GHOFromNtwkObjID = _GasLiftGasTheoretical.GHOFromNtwkObjID AND _GasLiftGasTheoretical.AllocRsltsThrtclOrActual = 'Y' AND AllocationRunID = _GasLiftGasTheoretical.AllocationRunID AND allocationruleunitofmsmt = _GasLiftGasTheoretical.AllocationRuleUnitOfMsmt  -- association [0..1]
LEFT OUTER JOIN I_GHOThrtclOvrrdeExpanded AS _ThrtclOvrrde ON GHONetworkID = _ThrtclOvrrde.GHONetworkID AND GHOFromNtwkObjID = _ThrtclOvrrde.GHONetworkObjectID AND NetworkMedium = _ThrtclOvrrde.NetworkMedium AND allocationruleunitofmsmt = _ThrtclOvrrde.AllocationRuleUnitOfMsmt AND AllocationFrequencyCode = _ThrtclOvrrde.AllocationFrequencyCode AND _ThrtclOvrrde.ValidFromDateTime <= ProdnAllocUTCDteTme AND _ThrtclOvrrde.ValidToDateTime >= ProdnAllocUTCDteTme  -- association [0..1]
;