@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Project Milestone Data – TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType:{
serviceQuality: #C,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
define view entity R_ProjNtwkActivityMilestoneTP
as select from I_ProjectMilestoneData as _ProjectMilestoneData
association to parent R_ProjectNetworkActivityTP as _NetworkActivity on $projection.ProjectNetworkInternalID = _NetworkActivity.ProjectNetworkInternalID
and $projection.NetworkActivityInternalID = _NetworkActivity.ProjNetworkActivityInternalID
association [0..1] to R_ProjectNetworkTP as _ProjectNetwork on $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork
association [1..1] to E_ProjectMilestone as _Extension on $projection.ProjectMilestone = _Extension.ProjectMilestone
//added 27.07.2023
association [0..*] to I_UserStatusText as _UserStatusTextMaster on _UserStatusTextMaster.Language = $projection.MasterLanguage
{
key ProjectMilestone,
key ProjectMilestoneInternalID,
@Semantics.text: true
_MilestoneShortText.LanguageBasedShortText as MlstnLangBsdDescription,
@Semantics.text: true
_Text.MilestoneDescription as MilestoneDescription,
UsageCode,
ProjectNetworkInternalID,
NetworkActivityInternalID,
_ProjectMilestoneData._ProjectNetwork[inner].ProjectNetwork as ProjectNetwork,
_ProjectMilestoneData._NetworkActivity.NetworkActivity as NetworkActivity,
MlstnIsRelevantForTrendAnlys,
MlstnIsRelevantForPrgrsAnlys,
MlstnIsRelevantForDteInSlsDoc,
CompletionRateInPercent,
ProjCostToBeInvoicedPercent,
FixedBasicDate,
FixedBasicMilestoneTime,
ForecastedFixedDate,
FixedForecastMilestoneTime,
ActualEndDate,
ActualMilestoneTime,
ScheduledBasicDate,
ScheduledBasicMilestoneTime,
ScheduledForecastedDate,
ScheduledForecastMilestoneTime,
DateIsOffsetToParentLtstDates,
DateIsOffsetToParentEndDate,
@Semantics.quantity.unitOfMeasure: 'MlstnDateOffsetDurationUnit'
MlstnDateOffsetDuration,
MlstnDateOffsetDurationUnit,
MlstnDateOffsetPercent,
//Added 27.07.2023
MlstnIsUsedforMlstnFunc,
MlstnReleaseStopIsActive,
MlstnIsMarkedForRelFllwngActy,
MlstnIsMarkedForRelUptoStopInd,
MlstnIsMarkedForIncludeStdNtwk,
MlstnIsMarkedForCreateNtwk,
MlstnIsMarkedForIncludeSubNtwk,
MlstnIsMarkedForStrtWrkflwTsk,
_ProjectMilestoneData._SystemStatusText[left outer where SystemStatus = $projection.syststsforrelfllwngactivities].SystemStatusShortName as SystStsForRelFllwngActiesTxt,
_ProjectMilestoneData._SystemStatusText[left outer where SystemStatus = $projection.syststsforreluptostopindcode].SystemStatusShortName as SystStsForRelUpToStopIndTxt,
_ProjectMilestoneData._SystemStatusText[left outer where SystemStatus = $projection.syststsforincldstandardnetwork].SystemStatusShortName as SystStsForIncldStdNetworkText,
_ProjectMilestoneData._SystemStatusText[left outer where SystemStatus = $projection.systemstatusforcreatenetwork].SystemStatusShortName as SystStatusForCreateNetworkText,
_ProjectMilestoneData._SystemStatusText[left outer where SystemStatus = $projection.syststatusforincludesubnetwork].SystemStatusShortName as SystStsForIncludeSubNetworkTxt,
_ProjectMilestoneData._SystemStatusText[left outer where SystemStatus = $projection.syststatusforstartworkflowtask].SystemStatusShortName as SystStsForStrtWorkflowTaskText,
case
when _ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforrelfllwngactivities and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName is not initial and
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforrelfllwngactivities and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName <> ''
then
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforrelfllwngactivities and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
else _UserStatusTextMaster[left outer where UserStatus = $projection.UserStsForRelFllwngActivities and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
end as UserStsForRelFllwngActiesTxt,
case
when _ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforreluptostopindcode and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName is not initial and
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforreluptostopindcode and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName <> ''
then
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforreluptostopindcode and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
else _UserStatusTextMaster[left outer where UserStatus = $projection.UserStsForRelUpToStopIndCode and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
end as UserStsForRelUpToStopIndTxt,
case
when _ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforincldstandardnetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName is not initial and
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforincldstandardnetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName <> ''
then
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstsforincldstandardnetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
else _UserStatusTextMaster[left outer where UserStatus = $projection.UserStsForIncldStandardNetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
end as UserStsForIncldStdNetworkText,
case
when _ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforcreatenetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName is not initial and
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforcreatenetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName <> ''
then
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforcreatenetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
else _UserStatusTextMaster[left outer where UserStatus = $projection.UserStatusForCreateNetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
end as UserStatusForCreateNetworkText,
case
when _ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforincludesubnetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName is not initial and
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforincludesubnetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName <> ''
then
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforincludesubnetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
else _UserStatusTextMaster[left outer where UserStatus = $projection.UserStatusForIncludeSubNetwork and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
end as UsrStsForIncludeSubNetworkText,
case
when _ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforstartworkflowtask and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName is not initial and
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforstartworkflowtask and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName <> ''
then
_ProjectMilestoneData._UserStatusText[left outer where UserStatus = $projection.userstatusforstartworkflowtask and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
else _UserStatusTextMaster[left outer where UserStatus = $projection.UserStatusForStartWorkflowTask and StatusProfile = _ProjectMilestoneData.StatusProfile].UserStatusShortName
end as UserStsForStrtWorkflowTaskText,
SystStsForRelFllwngActivities,
SystStsForRelUpToStopIndCode,
SystStsForIncldStandardNetwork,
SystemStatusForCreateNetwork,
SystStatusForIncludeSubNetwork,
SystStatusForStartWorkflowTask,
UserStsForRelFllwngActivities,
UserStsForRelUpToStopIndCode,
UserStsForIncldStandardNetwork,
UserStatusForCreateNetwork,
UserStatusForIncludeSubNetwork,
UserStatusForStartWorkflowTask,
SelPrflForRelFllwngActivities,
SelPrflForRelUpToStopIndCode,
SelPrflForIncldStandardNetwork,
SelProfileForCreateNetworkCode,
SelProfileForIncludeSubNetwork,
SelProfileForStartWorkflowTask,
StsChgForRelFllwngActivities,
StsChgForRelUpToStopIndCode,
StsChgForIncldStandardNetwork,
StatusChangeForCreateNetwork,
StsChangeForIncludeSubNetwork,
StsChangeForStartWorkflowTask,
MlstnIsRelFllwngActiesExecOnce,
MlstnIsRelUpToStpIndExectOnce,
MlstnIsIncldStdNtwkExecuteOnce,
MlstnIsCrteNtwkExectOnce,
MlstnIsIncldSubNtwkExecuteOnce,
MlstnIsStrtWrkflwTskExectOnce,
ActvtFuncForRelFllwngActies,
ActvtFuncForRelUpToStopIndCode,
ActvtFuncForIncldStdNetwork,
ActvtFuncForCreateNetwork,
ActvtFuncForIncludeSubNetwork,
ActvtFuncForStartWorkflowTask,
StdNtwkForIncldStandardNetwork,
AltvStdNtwkForIncldStdNetwork,
NtwkActyPrecdgStdNtwkToBeIncld,
NtwkActyFllwngStdNtwkToBeIncld,
StdNetworkTypeForCreateNetwork,
StdNetworkForCreateNetwork,
AltvStdNetworkForCreateNetwork,
StdNetworkForIncludeSubNetwork,
AltStdNtwkForIncludeSubNetwork,
NtwkActyForIncludeSubNetwork,
WorkflowTask,
CreatedByUser,
CreationDate,
LastChangedByUser,
LastChangeDate,
AuthorizationGroup,
IsDeleted as IsMarkedForDeletion,
MasterLanguage,
/* Associations */
_NetworkActivity,
_ProjectNetwork,
_Text,
_UsageText
}
where
_ProjectMilestoneData.WBSElementInternalID is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_NETWORKACTIVITYBYINTERNALKEY",
"I_PROJECTMILESTONEDATA",
"I_PROJECTMILESTONETEXT",
"I_PROJECTNETWORKBASICDATA",
"I_PROJECTOBJECTSHORTTEXT",
"I_SYSTEMSTATUSTEXT",
"I_USERSTATUSTEXT"
],
"ASSOCIATED":
[
"I_PROJECTMILESTONETEXT",
"I_PROJECTMILESTONEUSAGE",
"R_PROJECTNETWORKACTIVITYTP",
"R_PROJECTNETWORKTP"
],
"BASE":
[
"I_PROJECTMILESTONEDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/