I_SourcingProjectMilestone

DDL: I_SOURCINGPROJECTMILESTONE Type: view_entity BASIC

Milestone for Sourcing Project

I_SourcingProjectMilestone is a Basic CDS View that provides data about "Milestone for Sourcing Project" in SAP S/4HANA. It reads from 1 data source (mmsrcgpmlstn) and exposes 10 fields with key field SourcingProjectMilestoneUUID. It has 3 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
mmsrcgpmlstn mmsrcgpmlstn from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SourcingProject _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
[0..1] I_SrcgProjMilestoneType _SrcgProjMilestoneType $projection.SourcingProjectMilestone = _SrcgProjMilestoneType.SourcingProjectMilestoneType
[0..1] I_SrcgProjMilestoneStatus _SrcgProjMilestoneStatus $projection.SourcingProjectMilestoneStatus = _SrcgProjMilestoneStatus.SourcingProjectMilestoneStatus

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SourcingProjectMilestoneUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
EndUserText.label Milestone for Sourcing Project view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectMilestoneUUID sourcingprojectmilestoneuuid
SourcingProjectUUID sourcingprojectuuid
SourcingProjectMilestone sourcingprojectmilestone
SrcgProjMilestoneDateTime srcgprojmilestonedatetime
SourcingProjectMilestoneStatus sourcingprojectmilestonestatus
SourcingOrigin sourcingorigin
SourcingScenario sourcingscenario
_SourcingProject _SourcingProject
_SrcgProjMilestoneType _SrcgProjMilestoneType
_SrcgProjMilestoneStatus _SrcgProjMilestoneStatus 
@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel:{ representativeKey: 'SourcingProjectMilestoneUUID',
               usageType.dataClass: #TRANSACTIONAL,
               usageType.serviceQuality: #A,
               usageType.sizeCategory: #M }

@VDM.viewType: #BASIC

@EndUserText.label: 'Milestone for Sourcing Project'

define view entity I_SourcingProjectMilestone
  as select from mmsrcgpmlstn

  association [1..1] to I_SourcingProject         as _SourcingProject         on $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID

  //foreign key associations

  association [0..1] to I_SrcgProjMilestoneType   as _SrcgProjMilestoneType   on $projection.SourcingProjectMilestone = _SrcgProjMilestoneType.SourcingProjectMilestoneType
  association [0..1] to I_SrcgProjMilestoneStatus as _SrcgProjMilestoneStatus on $projection.SourcingProjectMilestoneStatus = _SrcgProjMilestoneStatus.SourcingProjectMilestoneStatus

{

  key sourcingprojectmilestoneuuid   as SourcingProjectMilestoneUUID,
      sourcingprojectuuid            as SourcingProjectUUID,

      @ObjectModel.foreignKey.association: '_SrcgProjMilestoneType'
      sourcingprojectmilestone       as SourcingProjectMilestone,

      srcgprojmilestonedatetime      as SrcgProjMilestoneDateTime,

      @ObjectModel.foreignKey.association: '_SrcgProjMilestoneStatus'
      sourcingprojectmilestonestatus as SourcingProjectMilestoneStatus,

      sourcingorigin                 as SourcingOrigin, 
      sourcingscenario               as SourcingScenario, 
      
      /* Associations */
      _SourcingProject,

      //foreign key associations

      _SrcgProjMilestoneType,
      _SrcgProjMilestoneStatus

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MMSRCGPMLSTN"
],
"ASSOCIATED":
[
"I_SOURCINGPROJECT",
"I_SRCGPROJMILESTONESTATUS",
"I_SRCGPROJMILESTONETYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More