I_EntProjProjectRespPersn

DDL: I_ENTPROJPROJECTRESPPERSN SQL: IEPRJPRJRESPPRSN Type: view BASIC

Responsible Person for Project Header

I_EntProjProjectRespPersn is a Basic CDS View that provides data about "Responsible Person for Project Header" in SAP S/4HANA. It reads from 2 data sources (I_EnterpriseProject, I_EntProjectResponsiblePerson) and exposes 16 fields with key field EntProjResponsiblePersonUUID. It has 1 association to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_EnterpriseProject _EnterpriseProject inner
I_EntProjectResponsiblePerson RespPerson from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EnterpriseProjectForUser _EnterpriseProjectForUser _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IEPRJPRJRESPPRSN view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey EntProjResponsiblePersonUUID view
EndUserText.label Responsible Person for Project Header view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY EntProjResponsiblePersonUUID I_EntProjectResponsiblePerson EntProjResponsiblePersonUUID
ProjectUUID I_EntProjectResponsiblePerson ProjectUUID
ReferencedObjectUUID I_EntProjectResponsiblePerson ReferencedObjectUUID
BusinessPartnerUUID I_EntProjectResponsiblePerson BusinessPartnerUUID
PersonWorkAgreement I_EntProjectResponsiblePerson PersonWorkAgreement
ProjectInternalID I_EntProjectResponsiblePerson ProjectInternalID
WBSElementInternalID I_EntProjectResponsiblePerson WBSElementInternalID
CreatedByUser I_EntProjectResponsiblePerson CreatedByUser
CreationDateTime I_EntProjectResponsiblePerson CreationDateTime
LastChangedByUser I_EntProjectResponsiblePerson LastChangedByUser
LastChangeDateTime I_EntProjectResponsiblePerson LastChangeDateTime
_EnterpriseProject I_EntProjectResponsiblePerson _EnterpriseProject
_WorkforcePerson I_EntProjectResponsiblePerson _WorkforcePerson
_BusinessPartner I_EntProjectResponsiblePerson _BusinessPartner
_PersonWorkAgreement_1 I_EntProjectResponsiblePerson _PersonWorkAgreement_1
_EnterpriseProjectForUser _EnterpriseProjectForUser 
@AbapCatalog.sqlViewName: 'IEPRJPRJRESPPRSN'
@VDM.viewType: #BASIC

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

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

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@ObjectModel.representativeKey: 'EntProjResponsiblePersonUUID'

@EndUserText.label: 'Responsible Person for Project Header'
define view I_EntProjProjectRespPersn
  as select from I_EntProjectResponsiblePerson as RespPerson
    inner join I_EnterpriseProject             as _EnterpriseProject 
            on RespPerson.ProjectUUID           = _EnterpriseProject.ProjectUUID
           and RespPerson.ReferencedObjectUUID  = _EnterpriseProject.ProjectSummaryTaskUUID
  //For Cat 7 Authorization                                                                                      

  association [0..1] to I_EnterpriseProjectForUser     as _EnterpriseProjectForUser on _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID
{
  key RespPerson.EntProjResponsiblePersonUUID as EntProjResponsiblePersonUUID,
      RespPerson.ProjectUUID                  as ProjectUUID,
      RespPerson.ReferencedObjectUUID         as ReferencedObjectUUID,
      RespPerson.BusinessPartnerUUID          as BusinessPartnerUUID,
      RespPerson.PersonWorkAgreement          as PersonWorkAgreement,
      RespPerson.ProjectInternalID            as ProjectInternalID,
      RespPerson.WBSElementInternalID         as WBSElementInternalID,
      RespPerson.CreatedByUser                as CreatedByUser,
      RespPerson.CreationDateTime             as CreationDateTime,
      RespPerson.LastChangedByUser            as LastChangedByUser,
      RespPerson.LastChangeDateTime           as LastChangeDateTime,
      
      /* Associations */
      RespPerson._EnterpriseProject,
      RespPerson._WorkforcePerson,
      RespPerson._BusinessPartner,
      RespPerson._PersonWorkAgreement_1,
      _EnterpriseProjectForUser
}

Learn More