I_PersWrkAgrmtToPartner

@AbapCatalog.sqlViewName: 'IPERSWRKAGRMTPT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL //#MASTER

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Internal for HCM : Donot Use'
@VDM.viewType: #BASIC
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view I_PersWrkAgrmtToPartner
as select from wfd_d_keymap as keymap
{
     cast(keymap.workforce_assgmt_id as persno preserving type) as PersonWorkAgreement,
     cast(keymap.business_partner_id as sobid )                 as Person,
     cast(keymap.central_person as sobid )                      as HumRsceRelatedObjectId
}
where keymap.block_ind = ''
/*  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

//}