R_WorkforcePersonRoleTP_3

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Workforce Person Role'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@ObjectModel: {
    supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
    //modelingPattern: #TRANSACTIONAL_INTERFACE

}
@AccessControl.personalData.blocking: #REQUIRED
@Consumption.dbHints:[ 'USE_HEX_PLAN' ]
define view entity R_WorkforcePersonRoleTP_3
  as select from I_BusinessPartner_to_BP_Role as _BusinessPartnerRole
//    inner join   P_BPUSRPERSONEXTERNALID      as _BPIdentification on _BPIdentification.BusinessPartner = _BusinessPartnerRole.BusinessPartner

//    inner join   bpu_rolecat_whl                                   on bpu_rolecat_whl.rolecategory = _BusinessPartnerRole.RoleCategory

   inner join R_BPUserIdentification as _BPIdentification on _BPIdentification.BusinessPartner = _BusinessPartnerRole.BusinessPartner
    inner join   R_BPUsrPersnExtID_2 as _RoleCat on  _RoleCat.RoleCategory            = _BusinessPartnerRole.RoleCategory
//  composition [0..*] of R_WrkfrcPersnRelshpToCoTP_3 as _WrkfrcPersnRelshpToCo

  association to parent R_WorkforcePersonTP_3       as _WorkforcePerson on $projection.WorkforcePersonExternalID = _WorkforcePerson.WorkforcePersonExternalID
{
  key  _BPIdentification.BPIdentificationNumber                                      as WorkforcePersonExternalID,
  key  _BusinessPartnerRole.BusinessPartnerRole,
       _BusinessPartnerRole.BusinessPartner,
       _BusinessPartnerRole.RoleCategory,
//       tstmp_to_dats(_BusinessPartnerRole.ValidFrom,'UTC',  $session.client, 'NULL') as ValidFrom,

       tstmp_to_dats(_BusinessPartnerRole.ValidFrom,'UTC',  $session.client, 'NULL') as BPUsrRoleValidFromDate,
//       tstmp_to_dats(_BusinessPartnerRole.ValidTo,'UTC',  $session.client, 'NULL')   as ValidTo,

       tstmp_to_dats(_BusinessPartnerRole.ValidTo,'UTC',  $session.client, 'NULL')   as BPUsrRoleValidToDate,

//      @Semantics.businessDate.from: true

//      case when _BusinessPartnerRole.ValidFrom != 00010101000000

//      then tstmp_to_dats(_BusinessPartnerRole.ValidFrom,'UTC',  $session.client, 'NULL')

//      else cast ( '00010103' as abap.dats )

//      end                                             as ValidFrom,

//      @Semantics.businessDate.to: true

//      case when _BusinessPartnerRole.ValidTo != 00010101000000

//      then tstmp_to_dats(_BusinessPartnerRole.ValidTo,'UTC',  $session.client, 'NULL')

//      else cast ( '99991231' as abap.dats)

//      end                                             as ValidTo,


       /* Associations */
       _WorkforcePerson
}