P_PDRELATION_001

@VDM.private: true
@AbapCatalog.sqlViewName: 'PPDRELATION001'
@VDM.viewType: #BASIC
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PDRELATION_001
  as select from hrp1001        as relation
    inner join   t77s0          as systemtable on  grpid = 'PLOGI'
                                               and semid = 'PLOGI'
                                               and gsval = relation.plvar
    left outer join   wfd_d_new_pers as switch      on switch.mandt = systemtable.mandt
{
  key relation.plvar as PlanVersion,
  key relation.otype as ObjectType,
  key relation.objid as ObjectID,
  key relation.rsign as RelationShipDirection,
  key relation.relat as ReleationShip,

      relation.istat as RelationStatus,



      relation.begda as StartDate,
      relation.endda as EndDate,

      relation.sclas as RelatedObjectType,
      relation.sobid as RelatedObjectID
}
where
       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_assgmt as assgmt on wfd_d_keymap.workforce_assgmt_id = assgmt.workforce_assgmt_id
  inner join          wfd_d_new_pers as switch on wfd_d_keymap.client = switch.mandt
{
  key ''                          as PlanVersion,
  key 'CP'                        as ObjectType,
  key wfd_d_keymap.central_person as ObjectID,
  key 'B'                         as RelationShipDirection,
  key '209'                       as ReleationShip,
      ''                          as RelationStatus,
      assgmt.start_date           as StartDate,
      assgmt.end_date             as EndDate,
      'P'                         as RelatedObjectType,
      wfd_d_keymap.workforce_assgmt_id      as RelatedObjectID


}
where
assgmt.end_date = '99991231' and
switch.switch = 'NEW'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRP1001",
"T77S0",
"WFD_D_ASSGMT",
"WFD_D_KEYMAP",
"WFD_D_NEW_PERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/