P_ProjectManagerValueHelp

DDL: P_PROJECTMANAGERVALUEHELP Type: view_entity COMPOSITE Package: FINS_REV_REC_UI

Project Manager Value Help

P_ProjectManagerValueHelp is a Composite CDS View that provides data about "Project Manager Value Help" in SAP S/4HANA. It reads from 2 data sources (I_PersonWorkAgreement_1, I_Project) and exposes 11 fields with key fields EmploymentInternalID, CompanyCode. Part of development package FINS_REV_REC_UI.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_PersonWorkAgreement_1 _PWA inner
I_Project project from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.representativeKey EmploymentInternalID view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID I_PersonWorkAgreement_1 PersonWorkAgreement
KEY CompanyCode I_Project CompanyCode
PersonnelNumber I_Project ResponsiblePerson
Person I_PersonWorkAgreement_1 Person
EmployeeFullName
LastName
FirstName
MiddleName
AdditionalLastName
AuthorizationGroup
_CompanyCode I_Project _CompanyCode 
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ObjectModel.representativeKey: 'EmploymentInternalID'
//@Analytics.technicalName: 'PPROJMANAGERVH'

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

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #CUSTOMIZING

define view entity P_ProjectManagerValueHelp
  as

  select from I_Project as project
//  association [1..1] to I_PersonWorkAgreement_1 as _PWA on project.ResponsiblePerson = _PWA.PersonWorkAgreement

inner join I_PersonWorkAgreement_1 as _PWA on project.ResponsiblePerson = _PWA.PersonWorkAgreement
{
  key _PWA.PersonWorkAgreement                     as EmploymentInternalID,
      //  key project.Project,

  key project.CompanyCode                          as CompanyCode,
      project.ResponsiblePerson                    as PersonnelNumber,
      _PWA.Person                                  as Person,
      @Semantics.text
      _PWA._WorkforcePerson.PersonFullName         as EmployeeFullName,
      _PWA._WorkforcePerson.LastName,
      _PWA._WorkforcePerson.FirstName,
      _PWA._WorkforcePerson.MiddleName,
      _PWA._WorkforcePerson.AdditionalLastName,
      _PWA._WorkforcePerson.AuthorizationGroup,

//      _PWA,

      project._CompanyCode
}
where
      project.ProjectInternalID <> '00000000'
  and project.ProjectInternalID is not null

group by
  _PWA.PersonWorkAgreement,
  _PWA.Person,
  project.ResponsiblePerson,
  _PWA._WorkforcePerson.PersonFullName,
  _PWA._WorkforcePerson.LastName,
  _PWA._WorkforcePerson.FirstName,
  _PWA._WorkforcePerson.MiddleName,
  _PWA._WorkforcePerson.AdditionalLastName,
  _PWA._WorkforcePerson.AuthorizationGroup,
  project.CompanyCode



//  select from I_PersonWorkAgreement as pwa

//  association [1..1] to I_Project as _Project on $projection.EmploymentInternalID = _Project.ResponsiblePerson

//

//{

//  key pwa.PersonWorkAgreement                     as EmploymentInternalID,

//  key pwa.Person                                  as Person,

//      _Project.ResponsiblePerson                  as PersonnelNumber,

//      @Semantics.text

//      pwa._WorkforcePerson.PersonFullName         as EmployeeFullName,

//      pwa._WorkforcePerson.LastName,

//      pwa._WorkforcePerson.FirstName,

//      pwa._WorkforcePerson.MiddleName,

//      pwa._WorkforcePerson.AdditionalLastName,

//      pwa._WorkforcePerson.AuthorizationGroup,

//      _Project.CompanyCode,

//      _Project.Project,

//      _Project.ProjectInternalID,

//

//      _Project,

//      _Project._CompanyCode

//}

//where

//      _Project.ProjectInternalID <> '00000000'

//  and _Project.ProjectInternalID is not null

Learn More