I_WORKASSIGNMENTKEYMAPPING

@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory: #L,
  dataClass: #MASTER
}
@EndUserText.label: 'Work Assignment Key Mappings'
define view entity I_WorkAssignmentKeyMapping 
                as select from wfd_d_keymap  as keymap 
                    inner join wfd_d_assgmt  as assgmt on keymap.workforce_assgmt_id = assgmt.workforce_assgmt_id   
{
  key keymap.workforce_assgmt_id    as WorkAssignment,
      keymap.business_partner_id    as BusinessPartner,
      keymap.person_id_external     as WorkforcePersonExternalID,
      assgmt.start_date             as WorkAssignmentStartDate,
      assgmt.end_date               as WorkAssignmentEndDate,
      assgmt.is_contingent_worker   as IsContingentWorker,
      keymap.central_person         as CentralPerson,
      keymap.worker_id              as WorkforcePersonID,
      keymap.country                as Country2DigitISOCode,
      cast(keymap.user_id as wfd_assgmt_ext_id preserving type) as WorkAssignmentExternalID,
      keymap.bp_model_type          as WorkforceBPModelType,
      keymap.data_source            as WorkAssignmentDataSource,
      keymap.block_ind              as IsBlocked       
}