R_NetworkActivityForGraphTP

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 R_NetworkActivityForGraphTP.
-- 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 R_NetworkActivityForGraphTP AS
SELECT
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  NetworkActivityDescription,
  NetworkActivity,
  cast ( _OperationControlProfileText.OperationControlProfileName as ps_s4_pph_steutxt ) AS OperationControlProfileName,
  NetworkActivityControlProfile,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  _NetworkActivityDatesQuantity.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  _NetworkActivityDatesQuantity.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  IsMarkedForDeletion,
  SuperiorNtwkActivityInternalID,
  Plant,
  _ProjectNetworkBasicData._ProjectData.ProjectObject AS ProjectObject,
  _WorkCenter.WorkCenter AS WorkCenter,
  Supplier,
  NetworkActivityObject,
  I_NetworkActivityByInternalKey.WorkCenterInternalID AS WorkCenterInternalID,
  I_NetworkActivityByInternalKey._WorkCenter AS _WorkCenter,
  WBSElementInternalID,
  ObjBasedAuthorizationIsActive,
  _WBSElement.ProjectInternalID AS ProjectInternalID,
  _WBSElement._Project AS _Project
FROM I_NetworkActivityByInternalKey
LEFT OUTER JOIN I_NetworkActivityDatesQuantity AS _NetworkActivityDatesQuantity ON ProjectNetworkInternalID = _NetworkActivityDatesQuantity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityDatesQuantity.NetworkActivityInternalID  -- association [1..1]
LEFT OUTER JOIN I_OperationControlProfileText AS _OperationControlProfileText ON NetworkActivityControlProfile = _OperationControlProfileText.OperationControlProfile AND _OperationControlProfileText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _Superior ON SuperiorNtwkActivityInternalID = _Superior.NetworkActivityInternalID AND ProjectNetworkInternalID = _Superior.ProjectNetworkInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;