P_ProjScheduleMilestoneAttrib

@AbapCatalog.sqlViewName: 'PMLSTATTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #M
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_ProjScheduleMilestoneAttrib
  as select from I_ProjectMilestoneData as ProjectMilestone
  association [0..1] to I_WBSElementBasicData as _WBSElement on _WBSElement.WBSElementInternalID = $projection.WBSElementInternalID
{
  key ProjectMilestone,
      ProjectMilestoneInternalID,
      case when WBSElementInternalID is not initial then 'WML'
           else 'ML' end                                   as ObjectType,
      //ProjectMilestone._WBSElement.WBSElementExternalID as WBSElementExternalID,

       case
       when  ProjectMilestone._MilestoneShortText.LanguageBasedShortText is not initial
           then ProjectMilestone._MilestoneShortText.LanguageBasedShortText
       else
        _Text.MilestoneDescription
       // case

       // when _Text[1: Language = $session.system_language ].MilestoneDescription is not initial

       // then cast(_Text[1: Language = $session.system_language ].MilestoneDescription as ps_s4_mlst_ktext)

       // else cast(_Text[1: Language = 'E' ].MilestoneDescription as ps_s4_mlst_ktext)

       // end

       end as MilestoneDescription,       
      ScheduledBasicDate,
      ScheduledForecastedDate,
      ActualEndDate,
      CompletionRateInPercent,
      WBSElementInternalID,
      ProjectNetworkInternalID,
      NetworkActivityInternalID,
      OrderCategory,
      //concat(ProjectMilestone, ProjectMilestoneInternalID) as ProjectMistoneObjectID,

      cast(ProjectMilestone as j_objnr)                    as MilestoneObjectID,
      case when WBSElementInternalID is not initial then ProjectMilestone._WBSElement._Project.ProjectObject
           else _ProjectNetwork._Project.ProjectObject end as ProjectObject,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      FixedBasicDate,
      ForecastedFixedDate,
      @Consumption:{ hidden: true}
      AuthorizationGroup,

      _WBSElement
}
where
        WBSElementInternalID      is not initial
  or(
        ProjectNetworkInternalID  is not initial
    and NetworkActivityInternalID is not initial
    and OrderCategory             = '20'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBASICDATA",
"I_PROJECTDATA_2",
"I_PROJECTMILESTONEDATA",
"I_PROJECTMILESTONETEXT",
"I_PROJECTNETWORKBASICDATA",
"I_PROJECTOBJECTSHORTTEXT",
"I_WBSELEMENTDATA_2"
],
"ASSOCIATED":
[
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/