I_ENTPROJECTRESPONSIBLEPERSON

CDS View

Responsible Person for Ent Projects

I_ENTPROJECTRESPONSIBLEPERSON is a CDS View in S/4HANA. Responsible Person for Ent Projects. It contains 15 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 15 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_CntrlInvcMgmtWBSElmntResp view_entity from CONSUMPTION WBS Element Responsible
Fins_Trr_Acc_Ass_Obj_prps view_entity left_outer Account Assignment Object
I_EntProjProjectRespPersn view from BASIC Responsible Person for Project Header
I_PPM_ProjectElementProgress view left_outer COMPOSITE Project Elements Progress
P_SingleResponsibleForProj view_entity from COMPOSITE Returns the calculated single resp for a Project

Fields (15)

KeyField CDS FieldsUsed in Views
KEY EntProjResponsiblePersonUUID EntProjResponsiblePersonUUID 1
KEY ProjectInternalID ProjectInternalID 2
_BusinessPartner _BusinessPartner 1
_EnterpriseProject _EnterpriseProject 1
_PersonWorkAgreement_1 _PersonWorkAgreement_1 1
_WorkforcePerson _WorkforcePerson 1
BusinessPartnerUUID BusinessPartnerUUID 3
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
PersonWorkAgreement PersonWorkAgreement 2
ProjectUUID ProjectUUID 1
ReferencedObjectUUID ReferencedObjectUUID 1
WBSElementInternalID WBSElementInternalID 1 
@AbapCatalog.sqlViewName: 'IEPRJRESPPERSN'
@VDM.viewType: #BASIC

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

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

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER

@ObjectModel.representativeKey: 'EntProjResponsiblePersonUUID'

@EndUserText.label: 'Responsible Person for Ent Projects'
define view I_EntProjectResponsiblePerson
  as select from /s4ppm/resppersn as RespPerson
  association [1..1] to I_EnterpriseProject     as _EnterpriseProject     on $projection.ProjectUUID = _EnterpriseProject.ProjectUUID
  association [1..1] to I_WorkforcePerson       as _WorkforcePerson       on $projection.BusinessPartnerUUID = _WorkforcePerson.BusinessPartnerUUID
  association [1..1] to I_BusinessPartner       as _BusinessPartner       on $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID
  association [1..1] to I_PersonWorkAgreement_1 as _PersonWorkAgreement_1 on $projection.PersonWorkAgreement = _PersonWorkAgreement_1.PersonWorkAgreement
  //For Cat 7 Authorization                                                                                      

  association [0..1] to I_EnterpriseProjectForUser     as _EnterpriseProjectForUser on _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID
{

  key entprojresponsiblepersonuuid as EntProjResponsiblePersonUUID,

      @ObjectModel.foreignKey.association: '_EnterpriseProject'
      projectuuid                  as ProjectUUID,

      referencedobjectuuid         as ReferencedObjectUUID,

      //    @ObjectModel.foreignKey.association: '_BusinessPartner'    // cannot be added as BUPA GUID is not the key

      businesspartneruuid          as BusinessPartnerUUID,

      @ObjectModel.foreignKey.association: '_PersonWorkAgreement_1'
      employmentinternalid         as PersonWorkAgreement,

      projectinternalid            as ProjectInternalID,

      wbselementinternalid         as WBSElementInternalID,
      
      createdbyuser                as CreatedByUser,
      
      creationdatetime             as CreationDateTime,
      
      lastchangedbyuser            as LastChangedByUser,
      
      lastchangeddatetime          as LastChangeDateTime,   
      
      _EnterpriseProject,
      _WorkforcePerson,
      _BusinessPartner,
      _PersonWorkAgreement_1,
      _EnterpriseProjectForUser

}

Learn More