I_WorkForcePersonSearch

@AbapCatalog.sqlViewName: 'IWORKPRSNSEARCH'
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType:  #COMPOSITE
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'I_WorkerFactSheetSearch' 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Workforce Person basic details'
define view I_WorkForcePersonSearch
  as select from           I_BusinessPartner            as bp
    inner join             I_WorkforceAssignment        as assgmt            on assgmt.BusinessPartner             = bp.BusinessPartner
                                                                             and(
                                                                               (
                                                                                 assgmt.WorkforceAssgmtStartDate   <= $session.system_date
                                                                                 and assgmt.WorkforceAssgmtEndDate >= $session.system_date
                                                                               )
                                                                               or(
                                                                                 assgmt.WorkforceAssgmtStartDate   >= $session.system_date
                                                                               )
                                                                             )




    inner join             I_WorkforceAssignmentDetails as assgmtdets        on assgmt.WorkforceAssignment             = assgmtdets.WorkforceAssignment
                                                                             and(
                                                                               (
                                                                                 assgmtdets.WorkforceAssgmtStartDate   <= $session.system_date
                                                                                 and assgmtdets.WorkforceAssgmtEndDate >= $session.system_date
                                                                               )
                                                                               or(
                                                                                 assgmtdets.WorkforceAssgmtStartDate   >= $session.system_date
                                                                               )
                                                                             )

    inner join             I_BPUsrExternalID            as bpexid            on bp.BusinessPartner         = bpexid.BusinessPartner
                                                                             and(
                                                                               bpexid.BPIdentificationType = 'HCM001'
                                                                               or // HCM001 - Employee ID

                                                                               bpexid.BPIdentificationType = 'HCM030'
                                                                               or // HCM030 - Service Agent

                                                                               bpexid.BPIdentificationType = 'HCM031'
                                                                             )    // HCM031 - Freelancer


  inner join      I_WorkforceAssignmentKeyMap       as keymap           on  keymap.WorkforceAssignment = assgmt.WorkforceAssignment


   left outer to one join I_EmployeeskillTags   as EmployeeSkillTags on  EmployeeSkillTags.PersonnelNumber      = keymap.CentralPerson
                                                                     and EmployeeSkillTags.EmployeeSkillTagType = 'U'


   // left outer to one join I_EmployeeskillTags          as EmployeeSkillTags on  EmployeeSkillTags.PersonnelNumber      = assgmt.WorkforceAssignment

    //                                                                         and EmployeeSkillTags.EmployeeSkillTagType = 'U'



{
  key bp.BusinessPartner                     as EmployeeInternalID,
      bpexid.BPIdentificationNumber          as Employee,
      bp.PersonFullName                      as EmployeeFullName,
      bp.LastName                            as LastName,
      bp.FirstName                           as FirstName,

      EmployeeSkillTags.EmployeeSkillTagName as EmployeeSkillTagName,
      bp.AuthorizationGroup                  as AuthorizationGroup,
      bp.IsBusinessPurposeCompleted          as IsBusinessPurposeCompleted


}
where
          bp.BusinessPartnerCategory           = '1'
  and     assgmtdets.WorkforceAssignmentStatus = '1'
  and
  (
    (
          assgmtdets.WorkforceAssgmtStartDate  <= $session.system_date
      and assgmtdets.WorkforceAssgmtEndDate    >= $session.system_date
    )
    or(
          assgmtdets.WorkforceAssgmtStartDate  >= $session.system_date
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPUSREXTERNALID",
"I_BUSINESSPARTNER",
"I_EMPLOYEESKILLTAGS",
"I_WORKFORCEASSIGNMENT",
"I_WORKFORCEASSIGNMENTDETAILS",
"I_WORKFORCEASSIGNMENTKEYMAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/