I_Projectmilestone

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 I_Projectmilestone.
-- 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: IPROJMILESTONE

CREATE VIEW I_Projectmilestone AS
SELECT
  mlst.mlst_zaehl AS ProjectMilestone,
  mlst.zaehl AS ProjectMilestoneInternalID,
  cast (mlst.loekz as ps_s4_loevm) AS IsDeleted,
  mlst.mlstn AS UsageCode,
  mlst.aufpl AS ProjectNetworkInternalID,
  mlst.aplzl AS NetworkActivityInternalID,
  cast (mlst.pspnr as ps_s4_pspnr) AS WBSElementInternalID,
  cast(mlst.tedat as ps_s4_mlst_tedat) AS ScheduledBasicDate,
  cast(mlst.edatu as lop_fix_date) AS FixedBasicDate,
  cast(mlst.kz_trend as ps_s4_mlst_trend) AS MlstnIsRelevantForTrendAnlys,
  cast(mlst.kz_lstwr as ps_s4_mlst_lstwr) AS MlstnIsRelevantForPrgrsAnlys,
  cast(mlst.kz_faktp as ps_s4_mlst_faktp) AS MlstnIsRelevantForDteInSlsDoc,
  cast (mlst.lst_actdt as ppe_actual_date) AS ActualEndDate,
  cast(mlst.autyp as cowb_autyp) AS OrderCategory,
  cast (mlst.dateh as erdat) AS CreationDate,
  cast (mlst.datev as ps_s4_updat) AS LastChangeDate,
  cast(mlst.incnw as ps_s4_mlst_incnw) AS MlstnIsMarkedForCreateNtwk,
  cast(mlst.incpn as ps_s4_mlst_incpn) AS MlstnIsMarkedForIncludeSubNtwk,
  cast(mlst.incsn as ps_s4_mlst_incsn) AS MlstnIsMarkedForCreateSubNtwk,
  cast(mlst.kz_frmst as ps_s4_kz_frmst) AS MlstnReleaseStopIsActive,
  cast(mlst.kz_wflow as ps_s4_mlst_wflow) AS MlstnIsUsedforMlstnFunc,
  cast (mlst.begru as begru) AS AuthorizationGroup,
  cast(mlst.relms as ps_s4_mlst_relms) AS MlstnIsMarkedForRelUptoStopInd,
  cast(mlst.relsu as ps_s4_mlst_relsu) AS MlstnIsMarkedForRelFllwngActy,
  cast (mlst.userh as ernam) AS CreatedByUser,
  cast (mlst.userv as ps_s4_aenam) AS LastChangedByUser,
  cast(mlst.wkflw as ps_s4_mlst_wkflw) AS MlstnIsMarkedForStrtWrkflwTsk,
  cast(mlst.dltas as ps_s4_mlst_dltas) AS DateIsOffsetToParentEndDate,
  cast(mlst.prcnt as ps_s4_mlst_prcnt) AS MlstnDateOffsetPercent,
  cast(mlst.delte as ps_s4_mlst_delte) AS MlstnDateOffsetDurationUnit,
  mlst.delta AS MlstnDateOffsetDuration,
  cast(mlst.lated as ps_s4_mlst_late) AS DateIsOffsetToParentLtstDates,
  cast(lst_fertg as ps_s4_cgpl_completion) AS CompletionRateInPercent,
  cast(fproz as fproz) AS ProjCostToBeInvoicedPercent,
  mlst.task_id AS WorkflowTask,
  mlst.lst_acttm AS ActualMilestoneTime,
  mlst.ezeit AS FixedBasicMilestoneTime,
  mlst.tetim AS ScheduledBasicMilestoneTime,
  _Text[1: Language = $session.system_language ].MilestoneDescription AS MilestoneDescription
FROM mlst
LEFT OUTER JOIN I_Projectmilestonetext AS _Text ON ProjectMilestone = _Text.ProjectMilestone AND ProjectMilestoneInternalID = _Text.ProjectMilestoneInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetworkInternalID = _ProjectNetwork.ProjectNetworkInternalID  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivity AS _NetworkActivity ON _NetworkActivity.ProjectNetworkInternalID = ProjectNetworkInternalID AND _NetworkActivity.NetworkActivityInternalID = NetworkActivityInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Projectmilestoneusage AS _UsageText ON UsageCode = _UsageText.UsageCode  -- association [0..1]
LEFT OUTER JOIN E_ProjectMilestone AS _Extension ON mlst.mlst_zaehl = _Extension.ProjectMilestone  -- association [1..1]
LEFT OUTER JOIN I_ProjectObjectShortText AS _MilestoneShortText ON _MilestoneShortText.Language = $session.system_language AND _MilestoneShortText.ProjectApplicationIdentifier = 'PS' AND ( _MilestoneShortText.ProjectObjectType = 'MW' OR _MilestoneShortText.ProjectObjectType = 'ML' ) AND ProjectMilestone = _MilestoneShortText.RelatedProjectObject  -- association [0..1]
;