P_EmployeeLineManager

@AbapCatalog.sqlViewName: 'PLINEMANAGER'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
//@EndUserText.label: 'Employee Line Manager'

@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

define view P_EmployeeLineManager
  as select from    pa0001         as Employee
    left outer join wfd_d_new_pers as switch on switch.mandt = Employee.mandt

{

  key Employee.pernr as EmploymentInternalID,
  key Employee.begda as ValidityStartDate,
      Employee.endda as ValidityEndDate,
      //Employee.mstbr     as Manager,

      Employee.mstbr as ManagerPersonWorkAgreement

}
where
       Employee.mstbr <> ''
  and(
       switch.switch  is null
    or switch.switch  <> 'NEW'
  )

union all select from wfd_d_assgmtdets as assgmtdets
  inner join          wfd_d_new_pers   as switch on switch.mandt = assgmtdets.client

{
  key assgmtdets.workforce_assgmt_id as EmploymentInternalID,
  key assgmtdets.start_date          as ValidityStartDate,
      assgmtdets.end_date            as ValidityEndDate,
      assgmtdets.manager_work_assgmt as ManagerPersonWorkAgreement
}
where
      assgmtdets.manager_work_assgmt <> '00000000'
  and switch.switch                  =  'NEW'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PA0001",
"WFD_D_ASSGMTDETS",
"WFD_D_NEW_PERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/