I_GHONetworkObject

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_GHONetworkObject.
-- 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: IGHONTWKOBJ

CREATE VIEW I_GHONetworkObject AS
SELECT
  FunctionalLocation AS ProductionNetworkID,
  NetworkInternalID,
  NetworkObjectType,
  SecondaryGeogrlLocation,
  SecondaryGeogrlLocationName,
  NetworkToBeAllocated,
  NetworkTimeZone,
  ReferenceWell,
  NtwkObjectIsChained,
  DataIntegrationSystemID,
  _Link.NetworkInternalID AS AssignedToNetworkInternalID,
  _AlternateLabel.AlternateLabelingSystem AS AlternateLabelingSystem,
  _FunctionalLocation.FuncLocationStructure AS FuncLocationStructure,
  _FunctionalLocation.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _FunctionalLocation.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _FunctionalLocation.AuthorizationGroup AS AuthorizationGroup,
  _FunctionalLocation.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr
LEFT OUTER JOIN I_GhoFuncLocText AS _NetworkDescription ON ProductionNetworkID = _NetworkDescription.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_GhoNOTyp_Db AS _NetworkObjectType ON NetworkObjectType = _NetworkObjectType.NetworkObjectType  -- association [1..1]
LEFT OUTER JOIN I_GHONtwkObjLifeCycSts AS _LifeCycleStatus ON ProductionNetworkID = _LifeCycleStatus.ProductionNetworkID AND ( _LifeCycleStatus.LifecycleStsValidFromDate <= $session.system_date AND _LifeCycleStatus.LifecycleStsValidToDate >= $session.system_date )  -- association [0..*]
LEFT OUTER JOIN I_GHONtwkObjVarblData AS _ObjVariableData ON ProductionNetworkID = _ObjVariableData.ProductionNetworkID AND ( _ObjVariableData.VarblDataValidFromDate <= $session.system_date AND _ObjVariableData.VarblDataValidToDate >= $session.system_date )  -- association [0..*]
LEFT OUTER JOIN I_GHOProdnNtwkLink AS _Link ON ProductionNetworkID = _Link.FromNetworkObjectID OR ProductionNetworkID = _Link.ToNetworkObjectID  -- association [1..*]
LEFT OUTER JOIN I_GhoPnMedium_Db AS _Medium ON ProductionNetworkID = _Medium.NetworkID  -- association [0..*]
LEFT OUTER JOIN I_GhoPnFreq_Db AS _Frequency ON ProductionNetworkID = _Frequency.NetworkID  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON ProductionNetworkID = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_GHOAlternateLabelingSystem AS _AlternateLabel ON NetworkObjectType = _AlternateLabel.NetworkObjectType  -- association [0..1]
LEFT OUTER JOIN I_GHOProdnNtwkLabel AS _NetworkLabelInternal ON ProductionNetworkID = _NetworkLabelInternal.ProductionNetworkID AND FuncLocationStructure = _NetworkLabelInternal.FuncLocationStructure AND _NetworkLabelInternal.FunctionalLocLabelIsActive = 'X'  -- association [0..*]
;