I_ProjectmilestoneVersion

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_ProjectmilestoneVersion.
-- 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: IPROJMLSTNVERSN

CREATE VIEW I_ProjectmilestoneVersion AS
SELECT
  vsmlst_cn.mlst_zaehl AS ProjectMilestone,
  cast(vsmlst_cn.vsnmr as ps_s4_vsnmr preserving type) AS Version,
  vsmlst_cn.zaehl AS ProjectMilestoneInternalID,
  cast (vsmlst_cn.loekz as lkenz) AS IsDeleted,
  vsmlst_cn.mlstn AS UsageCode,
  vsmlst_cn.aufpl AS ProjectNetworkInternalID,
  vsmlst_cn.aplzl AS NetworkActivityInternalID,
  cast (vsmlst_cn.pspnr as ps_s4_pspnr) AS WBSElementInternalID,
  cast(vsmlst_cn.tedat as ps_s4_mlst_tedat) AS ScheduledBasicDate,
  cast(vsmlst_cn.edatu as lop_fix_date) AS FixedBasicDate,
  cast(vsmlst_cn.kz_trend as ps_s4_mlst_trend) AS MlstnIsRelevantForTrendAnlys,
  cast(vsmlst_cn.kz_lstwr as ps_s4_mlst_lstwr) AS MlstnIsRelevantForPrgrsAnlys,
  cast(vsmlst_cn.kz_faktp as ps_s4_mlst_faktp) AS MlstnIsRelevantForDteInSlsDoc,
  cast (vsmlst_cn.lst_actdt as ppe_actual_date) AS ActualEndDate,
  cast(vsmlst_cn.autyp as cowb_autyp) AS OrderCategory,
  cast (vsmlst_cn.dateh as mlst_dateh) AS CreationDate,
  cast (vsmlst_cn.datev as mlst_datev) AS LastChangeDate,
  cast(vsmlst_cn.incnw as ps_s4_mlst_incnw) AS MlstnIsMarkedForCreateNtwk,
  cast(vsmlst_cn.incpn as ps_s4_mlst_incpn) AS MlstnIsMarkedForIncludeSubNtwk,
  cast(vsmlst_cn.incsn as ps_s4_mlst_incsn) AS MlstnIsMarkedForCreateSubNtwk,
  cast(vsmlst_cn.kz_frmst as ps_s4_kz_frmst) AS MlstnReleaseStopIsActive,
  cast(vsmlst_cn.kz_wflow as ps_s4_mlst_wflow) AS MlstnIsUsedforMlstnFunc,
  cast (vsmlst_cn.begru as begru) AS AuthorizationGroup,
  cast(vsmlst_cn.relms as ps_s4_mlst_relms) AS MlstnIsMarkedForRelUptoStopInd,
  cast(vsmlst_cn.relsu as ps_s4_mlst_relsu) AS MlstnIsMarkedForRelFllwngActy,
  cast (vsmlst_cn.userh as ernam) AS CreatedByUser,
  cast (vsmlst_cn.userv as aenam) AS LastChangedByUser,
  cast(vsmlst_cn.wkflw as ps_s4_mlst_wkflw) AS MlstnIsMarkedForStrtWrkflwTsk,
  cast(vsmlst_cn.dltas as ps_s4_mlst_dltas) AS DateIsOffsetToParentEndDate,
  cast(vsmlst_cn.prcnt as ps_s4_mlst_prcnt) AS MlstnDateOffsetPercent,
  cast(vsmlst_cn.delte as ps_s4_mlst_delte) AS MlstnDateOffsetDurationUnit,
  vsmlst_cn.delta AS MlstnDateOffsetDuration,
  cast(vsmlst_cn.lated as ps_s4_mlst_late) AS DateIsOffsetToParentLtstDates,
  cast(lst_fertg as ps_s4_cgpl_completion) AS CompletionRateInPercent,
  cast(fproz as fproz) AS ProjCostToBeInvoicedPercent,
  vsmlst_cn.task_id AS WorkflowTask
FROM vsmlst_cn
LEFT OUTER JOIN I_Projectmilestonetext AS _Text ON ProjectMilestone = _Text.ProjectMilestone AND ProjectMilestoneInternalID = _Text.ProjectMilestoneInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementVersion AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID AND Version = _WBSElement.Version  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetworkVersion AS _ProjectNetworkVersion ON ProjectNetworkInternalID = _ProjectNetworkVersion.ProjectNetworkInternalID AND Version = _ProjectNetworkVersion.Version  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityVersion AS _NetworkActivityVersion ON ProjectNetworkInternalID = _NetworkActivityVersion.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivityVersion.NetworkActivityInternalID AND Version = _NetworkActivityVersion.Version  -- association [0..1]
LEFT OUTER JOIN I_Projectmilestoneusage AS _UsageText ON UsageCode = _UsageText.UsageCode  -- association [0..1]
LEFT OUTER JOIN I_Projectmilestone AS _ProjectMilestone ON ProjectMilestone = _ProjectMilestone.ProjectMilestone  -- association [1..1]
LEFT OUTER JOIN E_ProjectMilestoneVersion AS _Extension ON vsmlst_cn.vsnmr = _Extension.Version AND vsmlst_cn.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]
;