C_NetworkActivityVersForGraph

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_NetworkActivityVersForGraph.
-- 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: CNWACVFORGRAPH

CREATE VIEW C_NetworkActivityVersForGraph AS
SELECT
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  Version,
  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,
  _WorkCenter.WorkCenter AS WorkCenter,
  Supplier
FROM I_NetworkActivityVersByIntKey
LEFT OUTER JOIN I_NetworkActVersDatesQuantity AS _NetworkActivityDatesQuantity ON ProjectNetworkInternalID = _NetworkActivityDatesQuantity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityDatesQuantity.NetworkActivityInternalID AND Version = _NetworkActivityDatesQuantity.Version  -- 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_NetworkActivityVersByIntKey AS _Superior ON SuperiorNtwkActivityInternalID = _Superior.NetworkActivityInternalID AND ProjectNetworkInternalID = _Superior.ProjectNetworkInternalID AND Version = _Superior.Version  -- association [0..1]
;