R_ENTPROJSTATUSAREA

CDS View

Enterprise Project Status Area

R_ENTPROJSTATUSAREA is a CDS View in S/4HANA. Enterprise Project Status Area. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_EntProjStatusAreaTP view_entity from TRANSACTIONAL Appl Interface for Ent Proj Status Area 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Enterprise Project Status Area'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
     serviceQuality:  #A,
     dataClass:       #TRANSACTIONAL, 
     sizeCategory:    #XL
}
@ObjectModel: {
   representativeKey: 'StatusAreaUUID',
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]   
}

@Metadata.allowExtensions:true

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@AbapCatalog: {
    dataMaintenance: #RESTRICTED
}


define view entity R_EntProjStatusArea as select from /s4ppm/stat_area as StatusAreaData
  association [1..1] to R_EnterpriseProject            as _Project                        on $projection.ProjectUUID         = _Project.ProjectUUID
 
  association [1 ] to I_PPM_StatusAreaCode       as _StatusAreaCode       on $projection.StatusArea         = _StatusAreaCode.StatusArea    
  association [1 ] to I_PPM_StatusAreaStatus     as _StatusAreaStatus     on $projection.StatusAreaStatus   = _StatusAreaStatus.Status
  association [1 ] to I_PPM_StatusAreaTrend      as _StatusAreaTrend      on $projection.StatusTrend        = _StatusAreaTrend.StatusTrend   
 {
 
    key StatusAreaData.guid       as StatusAreaUUID, 
      StatusAreaData.project_guid as ProjectUUID, 
      StatusAreaData.statusarea   as StatusArea,
      StatusAreaData.status       as StatusAreaStatus,  
      StatusAreaData.trend        as StatusTrend,
      StatusAreaData.comments     as StatusAreaNote,
      StatusAreaData.created_by   as CreatedByUser,
      StatusAreaData.created_on   as CreationDateTime,
      StatusAreaData.changed_on   as LastChangeDateTime,
      StatusAreaData.changed_by   as LastChangedByUser,
      _Project,
      _StatusAreaCode,
      _StatusAreaStatus,
      _StatusAreaTrend
}

Learn More