R_SOURCINGPROJECTMILESTONE

CDS View

Milestone for Sourcing Project

R_SOURCINGPROJECTMILESTONE is a CDS View in S/4HANA. Milestone for Sourcing Project. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_SourcingProjectMilestoneTP view_entity from TRANSACTIONAL Milestone for Sourcing Project - TP 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: { sqlViewName: 'RSRCGPROJMSTN',
                compiler.compareFilter: true,
                preserveKey: true }
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel:{representativeKey: 'SourcingProjectMilestoneUUID',
              semanticKey: ['SourcingProjectMilestone'],
              usageType.dataClass: #TRANSACTIONAL,
              usageType.serviceQuality: #B,
              usageType.sizeCategory: #L}
@VDM: {viewType: #BASIC,
       lifecycle.contract.type: #SAP_INTERNAL_API}
@EndUserText.label: 'Milestone for Sourcing Project'

define view R_SourcingProjectMilestone
  as select from mmsrcgpmlstn
  association [1..1] to R_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

}

Learn More