C_ProjNtwkVersRelationship

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_ProjNtwkVersRelationship.
-- 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: CPRNTWKVREL

CREATE VIEW C_ProjNtwkVersRelationship AS
SELECT
  PredecessorProjNtwkIntID,
  PredecessorNtwkActyIntID,
  SuccessorProjNtwkIntID,
  SuccessorNtwkActyIntID,
  NetworkActivityRelationType,
  MaxTimeIntvlIsUsedForSchedg,
  Version,
  _RelshpTypeText.PhaseRelationshipTypeDesc AS NetworkActyRelationDescription,
  ProjectNetworkObject,
  NetworkActivityIntmsnDuration,
  NetworkActivityIntmsnDurnUnit,
  ObjectIsDeleted,
  cast (ltrim(TimeIntvlBtwnRelshpInPct, '0') as aob_prznt ) AS TimeIntvlBtwnRelshpInPct,
  TimeInterval,
  _TimeIntervalVH.DomainValueName AS DomainValueName,
  FactoryCalendar,
  _FactoryCalendarText.FactoryCalendarName AS FactoryCalendarName,
  Plant,
  WorkCenterInternalID,
  _WorkCenterVH.WorkCenter AS WorkCenter,
  cast(substring(_NetworkActivityPredecessor.NetworkActivityObject,1,2) as ps_project_object_type) AS ProjectObjectNodeType,
  _ProjectNetworkPredecessor.ProjectNetwork AS PredecessorProjectNetwork,
  _NetworkActivityPredecessor.NetworkActivity AS PredecessorNetworkActivity,
  _NetworkActivityPredecessor.NetworkActivityObject AS PredecessorProjectObjectNode,
  _NetworkActivityPredecessor.NetworkActivityDescription AS PredecessorNtwkActDescription,
  _ProjectNetworkSuccessor.ProjectNetwork AS SuccessorProjectNetwork,
  _NetworkActivitySuccessor.NetworkActivity AS SuccessorNetworkActivity,
  _NetworkActivitySuccessor.NetworkActivityObject AS SuccessorProjectObjectNode,
  _NetworkActivitySuccessor.NetworkActivityDescription AS SuccessorNtwkActyDescription
FROM I_ProjNtwkVersRelationship
LEFT OUTER JOIN I_FactoryCalendarText AS _FactoryCalendarText ON _FactoryCalendarText.FactoryCalendar = FactoryCalendar AND _FactoryCalendarText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MasterRecipeRelshpTypeText AS _RelshpTypeText ON _RelshpTypeText.PhaseRelationshipTypeKey = NetworkActivityRelationType AND _RelshpTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityVersByIntKey AS _NetworkActivityPredecessor ON ( _NetworkActivityPredecessor.ProjectNetworkInternalID = PredecessorProjNtwkIntID AND _NetworkActivityPredecessor.NetworkActivityInternalID = PredecessorNtwkActyIntID AND _NetworkActivityPredecessor.Version = Version )  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityVersByIntKey AS _NetworkActivitySuccessor ON ( _NetworkActivitySuccessor.ProjectNetworkInternalID = SuccessorProjNtwkIntID AND _NetworkActivitySuccessor.NetworkActivityInternalID = SuccessorNtwkActyIntID AND _NetworkActivitySuccessor.Version = Version )  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetworkVersBasicData AS _ProjectNetworkPredecessor ON ( _ProjectNetworkPredecessor.ProjectNetworkInternalID = PredecessorProjNtwkIntID AND _ProjectNetworkPredecessor.Version = Version )  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetworkVersBasicData AS _ProjectNetworkSuccessor ON ( _ProjectNetworkSuccessor.ProjectNetworkInternalID = SuccessorProjNtwkIntID AND _ProjectNetworkSuccessor.Version = Version )  -- association [0..1]
LEFT OUTER JOIN I_NtwkActTimeIntervalRelshpVH AS _TimeIntervalVH ON _TimeIntervalVH.DomainValue = TimeInterval AND _TimeIntervalVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterVH AS _WorkCenterVH ON _WorkCenterVH.WorkCenterInternalID = WorkCenterInternalID AND _WorkCenterVH.WorkCenterTypeCode = 'A'  -- association [0..1]
;