I_ENTPROJECTENTITLEMENT

CDS View

Enterprise Project Entitlement

I_ENTPROJECTENTITLEMENT is a CDS View in S/4HANA. Enterprise Project Entitlement. It contains 3 fields. 9 CDS views read from this table.

Used by 9 CDS view(s) 3 fields

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_EntProjTeamMbrRoleStaffing view_entity from COMPOSITE Team Member Role Staffing of Enterprise Project
I_EntProjTeamRoleStaffInternal view_entity inner COMPOSITE Project Team Role Staffing Internal
I_PPM_ProjectManager view inner COMPOSITE Enterprise Project Manager
I_PPM_TeamMemberRoleStaffing view from COMPOSITE Team Member Role Staffing
P_EngmntProjectRoleAssgmt view left_outer COMPOSITE Engagement Project Roles
P_EngmntProjWithStdRoles view left_outer COMPOSITE Engagement Project Roles With Standard Roles
P_EntProjAccCtrlListCompare view_entity from COMPOSITE Compare old and new ACL
R_EntProjTeamMbrEntitlementTP view_entity from TRANSACTIONAL Appl Interface for Ent Proj Entitlement
R_EntProjTeamRoleStaffIntTP view_entity from TRANSACTIONAL Enterprise Project Role Staffing Internal

Fields (3)

KeyField CDS FieldsUsed in Views
KEY ProjectEntitlementUUID ProjectEntitlementUUID 2
ProjectRoleUUID RoleUUID 1
ProjectUUID ProjectUUID 1 
@VDM.viewType: #BASIC

@EndUserText.label: 'Enterprise Project Entitlement'

@AbapCatalog: {
    sqlViewName: 'IENTPROJENT',
    compiler.compareFilter: true,
    preserveKey: true,
    dataMaintenance: #RESTRICTED
}

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
//   semanticKey:       [ 'ProjectEntitlement' ], no semantic key, as this one has no real id at the moment

   representativeKey: 'ProjectEntitlementUUID',
   sapObjectNodeType.name: 'EntProjTeamMemberEntitlement',
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #EXTRACTION_DATA_SOURCE ],
   usageType: {
     serviceQuality:  #B,
     dataClass:       #MASTER,
     sizeCategory:    #XL
   }
}

@Metadata.ignorePropagatedAnnotations: true

@VDM.lifecycle.contract.type:  #PUBLIC_LOCAL_API

@Analytics.dataExtraction: {
        enabled: true
}

@Analytics.dataExtraction.delta.changeDataCapture.automatic: true

define view I_EntProjectEntitlement

  as select from /s4ppm/entitlmnt as entitlmnt

  association [1..1] to I_EnterpriseProject           as _Project      on _Project.ProjectUUID = $projection.ProjectUUID

  association [1..1] to I_EnterpriseProjectRole       as _Role         on _Role.ProjectRoleUUID = $projection.ProjectRoleUUID

  association [1..1] to I_EnterpriseProjectTeamMember as _TeamMember   on _TeamMember.TeamMemberUUID = $projection.TeamMemberUUID

  
{
  key entitlmnt.guid             as ProjectEntitlementUUID,
      @ObjectModel.foreignKey.association: '_Project'
      entitlmnt.project_guid     as ProjectUUID,
      @ObjectModel.foreignKey.association: '_Role'
      entitlmnt.role_guid        as ProjectRoleUUID,
      @ObjectModel.foreignKey.association: '_TeamMember'
      entitlmnt.team_member_guid as TeamMemberUUID,
 


      @Semantics.user.createdBy: true
      entitlmnt.created_by       as CreatedByUser,
      @Semantics.systemDateTime.createdAt: true
      entitlmnt.created_on       as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      entitlmnt.changed_by       as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      entitlmnt.changed_on       as LastChangeDateTime,

      _Project,
      _TeamMember,
      _Role

}

Learn More