P_HrRelation_CP_P

@AbapCatalog.sqlViewName: 'PHRRELATNCPP'
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Read HRP1001 relation table and wfd_d_keymap table'

define view P_HrRelation_CP_P
  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 HumRsceObjectId,

//  key relation.rsign as HumRsceRelshpSpecification,

//  key relation.relat as HumRsceRelationship,

//      relation.istat as Status,

//      relation.begda as StartDate,

//      relation.endda as EndDate,

//      relation.sclas as RelatedObjectType,

//      relation.sobid as HumRsceRelatedObjectId

//

//

//}

//where

//     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          wfd_d_assgmt   as assgmt on assgmt.workforce_assgmt_id = wfd_d_keymap.workforce_assgmt_id
{

  key  ''                              as PlanVersion,
  key  'CP'                            as ObjectType,
  key  wfd_d_keymap.central_person     as HumRsceObjectId,
  key  'B'                             as HumRsceRelshpSpecification,
  key  '209'                           as HumRsceRelationship,
       ''                              as Status,
       assgmt.start_date               as StartDate,
       assgmt.end_date                 as EndDate,
       'P'                             as RelatedObjectType,
       wfd_d_keymap.workforce_assgmt_id as HumRsceRelatedObjectId
} 
  where assgmt.block_ind <> ''
//where

//  switch.switch = 'NEW'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"WFD_D_ASSGMT",
"WFD_D_KEYMAP",
"WFD_D_NEW_PERS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/