C_NtwkActVersGraphOverview

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_NtwkActVersGraphOverview.
-- 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: CNTWKACTVGROVW

CREATE VIEW C_NtwkActVersGraphOverview AS
SELECT
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  Version,
  _ProjectNetworkBasicData.ProjectNetwork AS ProjectNetwork,
  NetworkActivity,
  NetworkActivityDescription,
  _ProjectNetworkBasicData.ProjectInternalID AS ProjectInternalID,
  WBSElementInternalID,
  SuperiorNtwkActivityInternalID,
  Supplier,
  NetworkActivityObject,
  CostCtrActivityType,
  NetworkActivityControlProfile,
  OperationImportance,
  WorkCenterInternalID,
  NetworkActivityCurrency,
  ExternalProcessingPrice,
  CostElement,
  IsMarkedForDeletion,
  _NetworkActivityDatesQuantity.StandardDuration AS StandardDuration,
  _NetworkActivityDatesQuantity.StandardDurationUnit AS StandardDurationUnit,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  _NetworkActivityDatesQuantity.NetworkActivityQuantityUnit AS NetworkActivityQuantityUnit,
  _NetworkActivityDatesQuantity.NtwkActivityWorkQuantityUnit AS NtwkActivityWorkQuantityUnit,
  _NetworkActivityDatesQuantity.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  _NetworkActivityDatesQuantity.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NetworkActivityDatesQuantity.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NetworkActivityDatesQuantity.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  _NetworkActivityDatesQuantity.ActualStartDate AS ActualStartDate,
  _NetworkActivityDatesQuantity.ActualEndDate AS ActualEndDate,
  _NetworkActivityDatesQuantity.BasicDatesFreeFloat AS BasicDatesFreeFloat,
  _NetworkActivityDatesQuantity.PlannedWorkQuantity AS PlannedWorkQuantity,
  _NetworkActivityDatesQuantity.ActualWorkQuantity AS ActualWorkQuantity,
  _NetworkActivityDatesQuantity.RemainingWorkQuantity AS RemainingWorkQuantity,
  _NetworkActivityDatesQuantity.ActivityQuantity AS ActivityQuantity,
  _NetworkActivityDatesQuantity.TotalFloatForBasicDates AS TotalFloatForBasicDates,
  _NetworkActivityDatesQuantity.StartDateOffsetDuration AS StartDateOffsetDuration,
  _NetworkActivityDatesQuantity.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  _NetworkActivityDatesQuantity.EndDateOffsetDuration AS EndDateOffsetDuration,
  _NetworkActivityDatesQuantity.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  _ProjectNetworkBasicData.ProdAvailyCheckPlanningType AS ProdAvailyCheckPlanningType,
  _ProjectNetworkBasicData.ControllingArea AS ControllingArea,
  Plant,
  _ProjectNetworkBasicData.ProjectNetworkDescription AS ProjectNetworkDescription,
  _ProjectNetworkBasicData.ProjectNetworkType AS ProjectNetworkType,
  case when _WorkCenter.WorkCenter is null then '' else _WorkCenter.WorkCenter end as WorkCenter AS WorkCenterendasWorkCenter,
  _WBSElement.WBSDescription AS WBSDescription,
  _NetworkActivityUserFields.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  _NetworkActivityUserFields._UserFieldLabel.FreeDfndTableFieldSemanticName AS FreeDfndTableFieldSemanticName,
  _NetworkActivityUserFields.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  _NetworkActivityUserFields.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  _NetworkActivityUserFields.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  _NetworkActivityUserFields.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  _NetworkActivityUserFields.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  _NetworkActivityUserFields.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  _NetworkActivityUserFields.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  _NetworkActivityUserFields.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  _NetworkActivityUserFields.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  _NetworkActivityUserFields.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  _NetworkActivityUserFields.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  cast ( _NetworkActivityUserFields.FreeDefinedAmount1 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount1,
  cast ( _NetworkActivityUserFields.FreeDefinedAmount2 as abap.curr( 13, 2 ) ) AS FreeDefinedAmount2,
  _NetworkActivityUserFields.FreeDefinedDate1 AS FreeDefinedDate1,
  _NetworkActivityUserFields.FreeDefinedDate2 AS FreeDefinedDate2,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAttribute01Label AS FreeDefinedAttribute01Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAttribute02Label AS FreeDefinedAttribute02Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAttribute03Label AS FreeDefinedAttribute03Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAttribute04Label AS FreeDefinedAttribute04Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedIndicator1Label AS FreeDefinedIndicator1Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedIndicator2Label AS FreeDefinedIndicator2Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedQuantity1Label AS FreeDefinedQuantity1Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedQuantity2Label AS FreeDefinedQuantity2Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAmount1Label AS FreeDefinedAmount1Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedAmount2Label AS FreeDefinedAmount2Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedDate1Label AS FreeDefinedDate1Label,
  _NetworkActivityUserFields._UserFieldLabel.FreeDefinedDate2Label AS FreeDefinedDate2Label,
  _ProjectNetworkBasicData._OrderType.StatusProfile AS MaintUserStatusProfileCode,
  cast ( _ActivityTypeText[1:Language = $session.system_language ].CostCtrActivityTypeName as ps_s4_lstar_text ) AS CostCtrActivityTypeName,
  cast ( _OperationControlProfileText.OperationControlProfileName as ps_s4_pph_steutxt ) AS OperationControlProfileName,
  _Plant.PlantName AS PlantName,
  cast ( _PriorityCode._Text[1:Language = $session.system_language].PriorityCodeName as ps_s4_priotext ) AS PriorityCodeName,
  cast ( _WorkCenter._Text[1:Language = $session.system_language].WorkCenterText as ps_s4_workcentertext ) AS WorkCenterText,
  cast ( _ProjectNetworkBasicData._OrderType._Text[1: Language = $session.system_language ].OrderTypeName as ps_s4_auarttext) AS OrderTypeName,
  _NetworkActivityCtrlProfile.IsCostActivity AS IsCostActivity,
  _NetworkActivityCtrlProfile.IsServiceActivity AS IsServiceActivity,
  cast( '' as vdm_j_systemstatusname ) AS SystemStatusName,
  cast( '' as vdm_j_user_status_short_t ) AS UserStatusShortName,
  cast( 'X' as boole_d ) AS NetworkActivityHasPredecessor,
  cast( 'X' as boole_d ) AS NetworkActivityHasSuccessor,
  cast( '' as char3 ) AS NetworkActivityType,
  cast( '' as char1 ) AS NtwkActivityConfirmationStatus,
  _NetworkActivityDatesQuantity.ActyBscStartDateConstraintType AS ActyBscStartDateConstraintType,
  _NetworkActivityDatesQuantity._BscStartConstraintTypeText[1:Language = $session.system_language].StartConstraintTypeText AS ActyBscStartDateConstraintText,
  _NetworkActivityDatesQuantity.ConstraintDateForBscStartDate AS ConstraintDateForBscStartDate,
  _NetworkActivityDatesQuantity.ActyBscEndDateConstraintType AS ActyBscEndDateConstraintType,
  _NetworkActivityDatesQuantity._BscFinishConstraintTypeText[1:Language = $session.system_language].FinishConstraintTypeText AS ActyBscEndDateConstraintText,
  _NetworkActivityDatesQuantity.ConstraintDateForBscEndDate AS ConstraintDateForBscEndDate,
  _ProjectNetworkBasicData.PlannedStartDate AS PlannedStartDate,
  _ProjectNetworkBasicData.PlannedEndDate AS PlannedEndDate,
  _ProjectNetworkBasicData.ForecastedStartDate AS FcstStartDate,
  _ProjectNetworkBasicData.ForecastedEndDate AS FcstEndDate,
  _ProjectNetworkBasicData.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _ProjectNetworkBasicData.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _NetworkActivityDatesQuantity.ActyConfFcstdEndDate AS ActyConfFcstdEndDate,
  _NetworkActivityDatesQuantity.ActyFcstStartDteConstraintType AS ActyFcstStartDteConstraintType,
  _NetworkActivityDatesQuantity._FcstStartConstraintTypeText[1:Language = $session.system_language].StartConstraintTypeText AS ActyFcstStartDteConstraintText,
  _NetworkActivityDatesQuantity.ActyFcstEndDateConstraintType AS ActyFcstEndDateConstraintType,
  _NetworkActivityDatesQuantity._FcstFinishConstraintTypeText[1:Language = $session.system_language].FinishConstraintTypeText AS ActyFcstEndDateConstraintText,
  CompanyCode
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_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Prioritycode AS _PriorityCode ON OperationImportance = _PriorityCode.PriorityCode  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterInternalID = _WorkCenter.WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _ConcatenatedStsObjActiveSts ON _ConcatenatedStsObjActiveSts.StatusObject = NetworkActivityObject  -- association [1..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _ActivityConfirmed ON NetworkActivityObject = _ActivityConfirmed.StatusObject AND _ActivityConfirmed.StatusCode = 'I0009'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _ActivityPartiallyConfirmed ON NetworkActivityObject = _ActivityPartiallyConfirmed.StatusObject AND _ActivityPartiallyConfirmed.StatusCode = 'I0010'  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_NtwkActivityVersUserFields AS _NetworkActivityUserFields ON _NetworkActivityUserFields.ProjectNetworkInternalID = ProjectNetworkInternalID AND _NetworkActivityUserFields.NetworkActivityInternalID = NetworkActivityInternalID AND _NetworkActivityUserFields.Version = Version  -- association [1..1]
LEFT OUTER JOIN I_WBSElementVersionData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND Version = _WBSElement.Version  -- association [1..1]
LEFT OUTER JOIN I_NetworkActivityVersByIntKey AS _Superior ON SuperiorNtwkActivityInternalID = _Superior.NetworkActivityInternalID AND ProjectNetworkInternalID = _Superior.ProjectNetworkInternalID AND Version = _Superior.Version  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityCtrlProfile AS _NetworkActivityCtrlProfile ON _NetworkActivityCtrlProfile.OperationControlProfile = NetworkActivityControlProfile  -- association [1..1]
LEFT OUTER JOIN C_ProjNtwkVersRelationship AS _Successor ON _Successor.PredecessorProjNtwkIntID = ProjectNetworkInternalID AND _Successor.PredecessorNtwkActyIntID = NetworkActivityInternalID AND _Successor.Version = Version  -- association [0..*]
LEFT OUTER JOIN C_ProjNtwkVersRelationship AS _Predecessor ON _Predecessor.SuccessorProjNtwkIntID = ProjectNetworkInternalID AND _Predecessor.SuccessorNtwkActyIntID = NetworkActivityInternalID AND _Predecessor.Version = Version  -- association [0..*]
LEFT OUTER JOIN C_NtwkActivityVersAssignedObj AS _NtwkActyVersAssignedObjects ON _NtwkActyVersAssignedObjects.ProjectNetworkInternalID = ProjectNetworkInternalID AND _NtwkActyVersAssignedObjects.NetworkActivityInternalID = NetworkActivityInternalID AND _NtwkActyVersAssignedObjects.Version = Version  -- association [0..1]
;