I_EntProjectPublicSector

DDL: I_ENTPROJECTPUBLICSECTOR Type: view_entity BASIC Package: VDM_PPM_OBJECTS_TP_PROJECT

Public Sector Management for Ent Project

I_EntProjectPublicSector is a Basic CDS View that provides data about "Public Sector Management for Ent Project" in SAP S/4HANA. It reads from 3 data sources (/s4ppm/project, prps, /s4ppm/task) and exposes 11 fields with key field ProjectUUID. It has 1 association to related views. Part of development package VDM_PPM_OBJECTS_TP_PROJECT.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
/s4ppm/project project from
prps prps inner
/s4ppm/task task inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_EnterpriseProject _EnterpriseProject $projection.ProjectUUID = _EnterpriseProject.ProjectUUID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Public Sector Management for Ent Project view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name EnterpriseProjectPublicSector view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataExtraction.enabled true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID /s4ppm/project guid
ProjectSummaryTaskUUID /s4ppm/task guid
WBSElementInternalID
Fund prps rfund
FundIsFixAssigned prps fund_fix_assign
FunctionalAreaIsFixAssigned prps func_area_fix_assigned
GrantID prps rgrant_nbr
GrantIsFixAssigned prps grant_fix_assigned
SponsoredProgram prps sponsoredprog
WBSIsAvailyControlControlObj prps is_avc_check_level
_EnterpriseProject _EnterpriseProject 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Public Sector Management for Ent Project'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{
  usageType:{
    serviceQuality: #C,
    sizeCategory: #L,
    dataClass: #MIXED
  },
  supportedCapabilities: [ #EXTRACTION_DATA_SOURCE, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ],
  sapObjectNodeType.name: 'EnterpriseProjectPublicSector'
}
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Analytics: {
  dataExtraction: {
    enabled: true,
    delta.changeDataCapture: {
      mapping: [
        {
            table: '/s4ppm/project', role: #MAIN,
            viewElement: ['ProjectUUID'],
            tableElement: ['guid']
        },
        {
            table: '/s4ppm/task', role: #LEFT_OUTER_TO_ONE_JOIN,
            viewElement: ['ProjectSummaryTaskUUID'],
            tableElement: ['guid']
        },
        {
            table: 'prps', role: #LEFT_OUTER_TO_ONE_JOIN,
            viewElement: ['WBSElementInternalID'],
            tableElement: ['pspnr']
        }
      ]
    }
  }
}
define view entity I_EntProjectPublicSector
  as select from /s4ppm/project as project
    inner join   /s4ppm/task    as task on task.guid = project.projectsummarytaskuuid
    inner join   prps           as prps on prps.pspnr = task.pspnr
  association [1..1] to I_EnterpriseProject as _EnterpriseProject on $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
{
  key project.guid                                      as ProjectUUID,
      task.guid                                         as ProjectSummaryTaskUUID,
      cast( prps.pspnr as ps_s4_pspnr preserving type ) as WBSElementInternalID,

      prps.rfund                                        as Fund,
      prps.fund_fix_assign                              as FundIsFixAssigned,
      prps.func_area_fix_assigned                       as FunctionalAreaIsFixAssigned,
      prps.rgrant_nbr                                   as GrantID,
      prps.grant_fix_assigned                           as GrantIsFixAssigned,
      prps.sponsoredprog                                as SponsoredProgram,
      prps.is_avc_check_level                           as WBSIsAvailyControlControlObj,

      _EnterpriseProject
}

Learn More