C_MilestoneVersGraphOverview

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_MilestoneVersGraphOverview.
-- 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: CMLSGRAPHVOV

CREATE VIEW C_MilestoneVersGraphOverview AS
SELECT
  cast(ProjectMilestone as ps_s4_mlst_zaehl preserving type) AS ProjectMilestone,
  ProjectMilestoneInternalID,
  Version,
  ProjectMilestone._WBSElement.WBSElementExternalID AS WBSElementExternalID,
  ProjectMilestone._WBSElement.WBSElementObject AS WBSElementObject,
  ProjectMilestone._WBSElement._Project.ProjectExternalID AS ProjectExternalID,
  ProjectMilestone._WBSElement.ProjectInternalID AS ProjectInternalID,
  ProjectMilestone._ProjectNetworkVersion.ProjectNetwork AS ProjectNetwork,
  lpad( cast( case when ProjectMilestone._NetworkActivityVersion.NetworkActivity is null then '' else ProjectMilestone._NetworkActivityVersion.NetworkActivity end as abap.char( 4 )), 4, '0' ) as NetworkActivity AS char440asNetworkActivity,
  lpad(_NetworkActivity.SuperiorNtwkActivityExternalID, 4, '0' ) AS SuperiorNtwkActivityExternalID,
  ProjectMilestone._WBSElement.WBSDescription AS WBSDescription,
  ProjectMilestone._WBSElement._Project.ProjectDescription AS ProjectDescription,
  ProjectMilestone._ProjectNetworkVersion.ProjectNetworkDescription AS ProjectNetworkDescription,
  ProjectMilestone._NetworkActivityVersion.NetworkActivityDescription AS NetworkActivityDescription,
  cast( WBSElementInternalID as ps_pspnr) AS WBSElementInternalID,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  AuthorizationGroup,
  MilestoneDescription,
  UsageCode,
  case when _UsageText._UsageCodeText[1:Language = $session.system_language].UsageCodeName is null then '' else _UsageText._UsageCodeText[1:Language = $session.system_language].UsageCodeName end as UsageCodeName AS UsageCodeNameendasUsageCodeName,
  cast(LastChangeDate as ps_s4_updat) AS LastChangeDate,
  ScheduledBasicDate,
  CreatedByUser,
  cast(CreationDate as erdat) AS CreationDate,
  cast(LastChangedByUser as ps_s4_aenam) AS LastChangedByUser,
  cast(ProjCostToBeInvoicedPercent as fproz ) AS ProjCostToBeInvoicedPercent,
  cast (IsDeleted as ps_s4_loevm) AS IsDeleted,
  MlstnIsRelevantForPrgrsAnlys,
  MlstnIsRelevantForDteInSlsDoc,
  MlstnIsRelevantForTrendAnlys,
  MlstnIsUsedforMlstnFunc,
  MlstnReleaseStopIsActive,
  _NetworkActivity.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  _NetworkActivity.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  _NetworkActivity.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  _NetworkActivity.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  _NetworkActivity.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  _NetworkActivity.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  DateIsOffsetToParentEndDate,
  MlstnDateOffsetPercent,
  MlstnDateOffsetDurationUnit,
  MlstnDateOffsetDuration,
  DateIsOffsetToParentLtstDates,
  WorkflowTask
FROM I_ProjectMilestoneVersionData AS ProjectMilestone
LEFT OUTER JOIN C_WBSElementVersForGraph AS _WBSElement ON _WBSElement.WBSElementInternalID = WBSElementInternalID AND _WBSElement.Version = Version  -- association [0..1]
LEFT OUTER JOIN C_ProjectVersForNetworkGraph AS _Project ON _Project.ProjectInternalID = ProjectInternalID AND _Project.Version = Version  -- association [0..1]
LEFT OUTER JOIN C_ProjectNetworkVersForGraph AS _ProjectNetwork ON _ProjectNetwork.ProjectNetwork = ProjectNetwork AND _ProjectNetwork.Version = Version  -- association [0..1]
LEFT OUTER JOIN C_NetworkActivityVersForGraph AS _NetworkActivity ON _NetworkActivity.ProjectNetworkInternalID = ProjectNetworkInternalID AND _NetworkActivity.NetworkActivityInternalID = NetworkActivityInternalID AND _NetworkActivity.Version = Version  -- association [0..1]
LEFT OUTER JOIN E_ProjectMilestoneVersion AS _Extension ON ProjectMilestone = _Extension.ProjectMilestone AND Version = _Extension.Version  -- association [1..1]
;