I_MstrProjWorkForcePerson

@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,
      
  /////// Start of Datacontroller 10+1 fields -  Not to be consumed by any other views//////////      

        
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      BP.DataController10
        
 ////////////// End of Datacontroller 10+1 fields//////////

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PERSONWORKAGREEMENT_1",
"I_PERSONWORKAGRMTSTATUS",
"I_WORKFORCEPERSON"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/