R_ProjNtwkActivityMilestoneTP

DDL: R_PROJNTWKACTIVITYMILESTONETP Type: view_entity TRANSACTIONAL Package: VDM_PS_PROJECT_NETWORK_TP

Project Milestone Data – TP

R_ProjNtwkActivityMilestoneTP is a Transactional CDS View that provides data about "Project Milestone Data – TP" in SAP S/4HANA. It reads from 1 data source (I_ProjectMilestoneData) and exposes 36 fields with key fields ProjectMilestone, ProjectMilestoneInternalID. It has 2 associations to related views. Part of development package VDM_PS_PROJECT_NETWORK_TP.

1 data source(s) 36 fields

Data Sources (1)

SourceAliasJoin Type
I_ProjectMilestoneData _ProjectMilestoneData from

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_ProjectNetworkTP _ProjectNetwork $projection.ProjectNetwork = _ProjectNetwork.ProjectNetwork
[1..1] E_ProjectMilestone _Extension $projection.ProjectMilestone = _Extension.ProjectMilestone

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Milestone Data – TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ProjectMilestone ProjectMilestone
KEY ProjectMilestoneInternalID ProjectMilestoneInternalID
MlstnLangBsdDescription _MilestoneShortText LanguageBasedShortText
MilestoneDescription _Text MilestoneDescription
UsageCode UsageCode
ProjectNetworkInternalID ProjectNetworkInternalID
NetworkActivityInternalID NetworkActivityInternalID
ProjectNetwork
NetworkActivity
MlstnIsRelevantForTrendAnlys MlstnIsRelevantForTrendAnlys
MlstnIsRelevantForPrgrsAnlys MlstnIsRelevantForPrgrsAnlys
MlstnIsRelevantForDteInSlsDoc MlstnIsRelevantForDteInSlsDoc
CompletionRateInPercent CompletionRateInPercent
ProjCostToBeInvoicedPercent ProjCostToBeInvoicedPercent
FixedBasicDate FixedBasicDate
FixedBasicMilestoneTime FixedBasicMilestoneTime
ActualEndDate ActualEndDate
ActualMilestoneTime ActualMilestoneTime
ScheduledBasicDate ScheduledBasicDate
ScheduledBasicMilestoneTime ScheduledBasicMilestoneTime
DateIsOffsetToParentLtstDates DateIsOffsetToParentLtstDates
DateIsOffsetToParentEndDate DateIsOffsetToParentEndDate
MlstnDateOffsetDuration MlstnDateOffsetDuration
MlstnDateOffsetDurationUnit MlstnDateOffsetDurationUnit
MlstnDateOffsetPercent MlstnDateOffsetPercent
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
WBSElementInternalID WBSElementInternalID
AuthorizationGroup AuthorizationGroup
IsMarkedForDeletion IsDeleted
_NetworkActivity _NetworkActivity
_ProjectNetwork _ProjectNetwork
_Text _Text
_UsageText _UsageText 
@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

{
  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,
      CreatedByUser,
      CreationDate,
      LastChangedByUser,
      LastChangeDate,
      WBSElementInternalID,
      AuthorizationGroup,
      IsDeleted                                                   as IsMarkedForDeletion,

      /* Associations */
      _NetworkActivity,
      //_ProjectMilestoneData._NetworkActivity                      as _NetworkActivityData,

      _ProjectNetwork,
      //_ProjectMilestoneData._ProjectNetwork                       as _ProjectNetworkData,

      _Text,
      _UsageText
      //_WBSElement

}
where
  WBSElementInternalID is initial

Learn More