P_ProjectRespPerson

DDL: P_PROJECTRESPPERSON Type: view_entity COMPOSITE Package: FINS_REV_REC_PECRUN

Project Responsible Person

P_ProjectRespPerson is a Composite CDS View that provides data about "Project Responsible Person" in SAP S/4HANA. It reads from 1 data source (I_Project) and exposes 8 fields with key field ResponsiblePerson. Part of development package FINS_REV_REC_PECRUN.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_Project Project from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Project Responsible Person view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ResponsiblePerson I_Project ResponsiblePerson
Employee
EmployeeFullName
ProjManagerUserID
ProjectResponsiblePerson I_Project ResponsiblePerson
IsBusinessPurposeCompleted
AuthorizationGroup
_ResponsiblePerson I_Project _ResponsiblePerson 
@VDM.private: true
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Project Responsible Person'

define view entity P_ProjectRespPerson

  as select from           I_Project               as Project
    left outer to one join I_PersonWorkAgreement_1 as PersonWorkAgreement on Project.ResponsiblePerson = PersonWorkAgreement.PersonWorkAgreement

{
  key Project.ResponsiblePerson,
      PersonWorkAgreement._WorkforcePerson.PersonExternalID     as Employee,
      cast ( Project.ResponsiblePersonName as bu_name1tx )      as EmployeeFullName,
      PersonWorkAgreement._WorkforcePerson._BusinessUser.UserID as ProjManagerUserID,
      Project.ResponsiblePerson                                 as ProjectResponsiblePerson,
      
      //Access control fields      

      Project._ResponsiblePerson.ResponsiblePersonIsBlocked     as IsBusinessPurposeCompleted,
      cast ( '    ' as bu_augrp preserving type )               as AuthorizationGroup,
      //cast ( ''   as bu_xpcpt preserving type )                 as IsBusinessPurposeCompleted,

      
      Project._ResponsiblePerson      
}
where
      Project.ResponsiblePerson <> '00000000'
  and Project.ResponsiblePerson is not null

group by
  Project.ResponsiblePerson,
  PersonWorkAgreement._WorkforcePerson.PersonExternalID,
  Project.ResponsiblePersonName,
  PersonWorkAgreement._WorkforcePerson.PersonFullName,
  PersonWorkAgreement._WorkforcePerson._BusinessUser.UserID,

  //Access control fields

  Project._ResponsiblePerson.ResponsiblePersonIsBlocked;

Learn More