A_ProjNtwkActivityMilestone

DDL: A_PROJNTWKACTIVITYMILESTONE Type: view_entity COMPOSITE Package: ODATA_PROJECT_NETWORK_API
31 Fields 1 Data Sources 1 Associations 1 OData Services

Project Network Activity Milestone

A_ProjNtwkActivityMilestone is a Composite CDS View that provides data about "Project Network Activity Milestone" in SAP S/4HANA. It reads from 1 data source (R_ProjNtwkActivityMilestoneTP) and exposes 31 fields with key fields ProjectMilestone, ProjectMilestoneInternalID. It has 1 association to related views. It is exposed through 1 OData service (API_PROJECTNETWORK). Part of development package ODATA_PROJECT_NETWORK_API.

Data Sources (1)

SourceAliasJoin Type
R_ProjNtwkActivityMilestoneTP R_ProjNtwkActivityMilestoneTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_ProjectMilestone _Extension $projection.ProjectMilestone = _Extension.ProjectMilestone

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Network Activity Milestone view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entitySet.name ProjNtwkActivityMilestone view
OData.entityType.name ProjNtwkActivityMilestone_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_PROJECTNETWORK API_PROJECTNETWORK V4 C2 C1

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ProjectMilestone ProjectMilestone
KEY ProjectMilestoneInternalID ProjectMilestoneInternalID
MilestoneDescription MilestoneDescription
MlstnLangBsdDescription MlstnLangBsdDescription
UsageCode UsageCode
ProjectNetworkInternalID ProjectNetworkInternalID Plan No.f.Oper.
NetworkActivityInternalID NetworkActivityInternalID Counter
ProjectNetwork ProjectNetwork Order
NetworkActivity NetworkActivity Operation/Activity
MlstnIsRelevantForTrendAnlys MlstnIsRelevantForTrendAnlys
MlstnIsRelevantForPrgrsAnlys MlstnIsRelevantForPrgrsAnlys
MlstnIsRelevantForDteInSlsDoc MlstnIsRelevantForDteInSlsDoc
CompletionRateInPercent CompletionRateInPercent
ProjCostToBeInvoicedPercent ProjCostToBeInvoicedPercent
FixedBasicDate FixedBasicDate
FixedBasicMilestoneTime FixedBasicMilestoneTime
ActualEndDate ActualEndDate Actual Finish
ActualMilestoneTime ActualMilestoneTime
ScheduledBasicDate ScheduledBasicDate
ScheduledBasicMilestoneTime ScheduledBasicMilestoneTime
DateIsOffsetToParentLtstDates DateIsOffsetToParentLtstDates
DateIsOffsetToParentEndDate DateIsOffsetToParentEndDate
MlstnDateOffsetDuration MlstnDateOffsetDuration
MlstnDateOffsetDurationUnit MlstnDateOffsetDurationUnit
MlstnDateOffsetPercent MlstnDateOffsetPercent
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data

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 A_ProjNtwkActivityMilestone.
-- 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.

CREATE VIEW A_ProjNtwkActivityMilestone AS
SELECT
  ProjectMilestone,
  ProjectMilestoneInternalID,
  MilestoneDescription,
  MlstnLangBsdDescription,
  UsageCode,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  ProjectNetwork,
  NetworkActivity,
  MlstnIsRelevantForTrendAnlys,
  MlstnIsRelevantForPrgrsAnlys,
  MlstnIsRelevantForDteInSlsDoc,
  CompletionRateInPercent,
  ProjCostToBeInvoicedPercent,
  FixedBasicDate,
  FixedBasicMilestoneTime,
  ActualEndDate,
  ActualMilestoneTime,
  ScheduledBasicDate,
  ScheduledBasicMilestoneTime,
  DateIsOffsetToParentLtstDates,
  DateIsOffsetToParentEndDate,
  MlstnDateOffsetDuration,
  MlstnDateOffsetDurationUnit,
  MlstnDateOffsetPercent,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  AuthorizationGroup,
  IsMarkedForDeletion
FROM R_ProjNtwkActivityMilestoneTP
LEFT OUTER JOIN E_ProjectMilestone AS _Extension ON ProjectMilestone = _Extension.ProjectMilestone  -- association [1..1]
;

Learn More