I_MstrProjWorkForcePerson

DDL: I_MSTRPROJWORKFORCEPERSON SQL: IMPWFPERSON Type: view COMPOSITE Package: VDM_CPM_WS

Master Project Workforce Person Details

I_MstrProjWorkForcePerson is a Composite CDS View that provides data about "Master Project Workforce Person Details" in SAP S/4HANA. It reads from 1 data source (I_WorkforcePerson) and exposes 9 fields with key field PersonnelNumber. Part of development package VDM_CPM_WS.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkforcePerson BP from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMPWFPERSON view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Master Project Workforce Person Details view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PersonnelNumber PersonWorkAgreement PersonWorkAgreement
Employee I_WorkforcePerson PersonExternalID
EmployeeInternalID I_WorkforcePerson Person
ValidityStartDate status StartDate
ValidityEndDate status EndDate
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
EmployeeFullName I_WorkforcePerson PersonFullName
FullName I_WorkforcePerson PersonFullName
BusinessPartnerUUID BusinessPartnerUUID 
@AbapCatalog.sqlViewName: 'IMPWFPERSON'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Master Project Workforce Person Details'
define view I_MstrProjWorkForcePerson as select from I_WorkforcePerson as BP 
left outer to many join  I_PersonWorkAgreement_1 as PersonWorkAgreement   on BP.Person = PersonWorkAgreement.Person
left outer to one join  I_PersonWorkAgrmtStatus as status on status.PersonWorkAgreement = PersonWorkAgreement.PersonWorkAgreement
{
    
  key PersonWorkAgreement.PersonWorkAgreement as PersonnelNumber,
//      PersonWorkAgreement.PersonWorkAgreement as Employee,                   NOTE:2994823

      BP.PersonExternalID as Employee,                                         //NOTE:2994823

      BP.Person as EmployeeInternalID,
      status.StartDate as ValidityStartDate,
      status.EndDate as ValidityEndDate,
      IsBusinessPurposeCompleted,
      @Semantics.text
      BP.PersonFullName as EmployeeFullName,
      BP.PersonFullName as FullName,
      BusinessPartnerUUID
}

Learn More