P_PersWrkAgrmtToPartner

@AbapCatalog.sqlViewName: 'PPERSWRKAGRMTPT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Internal to HCM : Do not use'

@VDM.viewType: #BASIC
@VDM.private: true
define view P_PersWrkAgrmtToPartner
  as select from    hrp1001        as RelationP_CP
    inner join      hrp1001        as RelationCP_BP on  RelationCP_BP.objid = RelationP_CP.sobid
                                                    and RelationCP_BP.rsign = 'B'
                                                    and RelationCP_BP.relat = '207'
                                                    and RelationCP_BP.endda = '99991231'
                                                    and RelationCP_BP.plvar = RelationP_CP.plvar
    inner join      t77s0          as systemtable   on  grpid = 'PLOGI'
                                                    and semid = 'PLOGI'
                                                    and gsval = RelationCP_BP.plvar
    left outer join wfd_d_new_pers as switch        on switch.mandt = systemtable.mandt
{
  RelationP_CP.objid  as PersonWorkAgreement, //P

  RelationCP_BP.sobid as Person, //BP

  RelationP_CP.sobid  as HumRsceRelatedObjectId //CP.We donot have a defined GFN for this. Reusing name from I_HrRelation to be consistent

}
where
      RelationP_CP.otype =  'P'
  and RelationP_CP.sclas =  'CP'
  and RelationP_CP.rsign =  'A'
  and RelationP_CP.relat =  '209'
  and RelationP_CP.endda =  '99991231'
  and (switch.switch      is null
  or  switch.switch      <> 'NEW')

union all select from wfd_d_keymap   as wfd_d_keymap
  inner join          wfd_d_new_pers as switch      on wfd_d_keymap.client = switch.mandt
//  inner join          t77s0          as systemtable on  grpid = 'PLOGI'  => Do we need this join? 

//                                                    and semid = 'PLOGI'

{

  wfd_d_keymap.workforce_assgmt_id           as PersonWorkAgreement,
  wfd_d_keymap.business_partner_id as Person,
  wfd_d_keymap.central_person      as HumRsceRelatedObjectId
}
where
  switch.switch = 'NEW'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRP1001",
"T77S0",
"WFD_D_KEYMAP",
"WFD_D_NEW_PERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/