I_PersWrkAgrmtToPartner

@AbapCatalog.sqlViewName: 'IPERSWRKAGRMTPT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Internal for HCM : Donot Use'
@VDM.viewType: #BASIC
define view I_PersWrkAgrmtToPartner
  as select from WFD_TF_PersWrkAgrmttopartner( p_client:$session.client ) 
{
 PersonWorkAgreement, 
 Person,
 HumRsceRelatedObjectId 
}

//define view I_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

//{

//  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'



// as select from P_PersWrkAgrmtToPartner

//{

//  PersonWorkAgreement, //P

//  Person, //BP

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

//}