A_WBSElementMilestone

DDL: A_WBSELEMENTMILESTONE Type: view_entity CONSUMPTION
29 Fields 1 Data Sources 1 Associations 1 OData Services

WBS Element Milestone Details

A_WBSElementMilestone is a Consumption CDS View that provides data about "WBS Element Milestone Details" in SAP S/4HANA. It reads from 1 data source (R_WBSElementMilestoneTP) and exposes 29 fields with key fields ProjectMilestone, ProjectMilestoneInternalID. It has 1 association to related views. It is exposed through 1 OData service (API_PROJECT_V3).

Data Sources (1)

SourceAliasJoin Type
R_WBSElementMilestoneTP R_WBSElementMilestoneTP projection

Associations (1)

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

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label WBS Element Milestone Details view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entitySet.name WBSMilestone view
OData.entityType.name WBSMilestone_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_PROJECT_V3 API_PROJECT_V3 V4 C2 C1

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ProjectMilestone ProjectMilestone
KEY ProjectMilestoneInternalID ProjectMilestoneInternalID
WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
ProjectInternalID ProjectInternalID Project Def.
ProjectExternalID ProjectExternalID Project def.
MlstnLangBsdDescription MlstnLangBsdDescription
MilestoneDescription MilestoneDescription
UsageCode UsageCode
MlstnIsRelevantForPrgrsAnlys MlstnIsRelevantForPrgrsAnlys
MlstnIsRelevantForDteInSlsDoc MlstnIsRelevantForDteInSlsDoc
MlstnIsRelevantForTrendAnlys MlstnIsRelevantForTrendAnlys
CompletionRateInPercent CompletionRateInPercent
ProjCostToBeInvoicedPercent ProjCostToBeInvoicedPercent
FixedBasicDate FixedBasicDate
ScheduledBasicDate ScheduledBasicDate
ActualEndDate ActualEndDate Actual Finish
DateIsOffsetToParentEndDate DateIsOffsetToParentEndDate
SetOfDatesForOffsets SetOfDatesForOffsets
MlstnDateOffsetDuration MlstnDateOffsetDuration
MlstnDateOffsetDurationUnit MlstnDateOffsetDurationUnit
MlstnDateOffsetPercent MlstnDateOffsetPercent
AuthorizationGroup AuthorizationGroup AuthorizGroup
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
_ProjectredirectedtoA_Project_3

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_WBSElementMilestone.
-- 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_WBSElementMilestone AS
SELECT
  ProjectMilestone,
  ProjectMilestoneInternalID,
  WBSElementInternalID,
  WBSElementExternalID,
  ProjectInternalID,
  ProjectExternalID,
  MlstnLangBsdDescription,
  MilestoneDescription,
  UsageCode,
  MlstnIsRelevantForPrgrsAnlys,
  MlstnIsRelevantForDteInSlsDoc,
  MlstnIsRelevantForTrendAnlys,
  CompletionRateInPercent,
  ProjCostToBeInvoicedPercent,
  FixedBasicDate,
  ScheduledBasicDate,
  ActualEndDate,
  DateIsOffsetToParentEndDate,
  SetOfDatesForOffsets,
  MlstnDateOffsetDuration,
  MlstnDateOffsetDurationUnit,
  MlstnDateOffsetPercent,
  AuthorizationGroup,
  CreatedByUser,
  CreationDate,
  LastChangeDate,
  LastChangedByUser,
  IsMarkedForDeletion
FROM R_WBSElementMilestoneTP
LEFT OUTER JOIN E_ProjectMilestone AS _Extension ON ProjectMilestone = _Extension.ProjectMilestone  -- association [1..1]
;

Learn More