hrpy_pcc_activity

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Payroll Activities'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #L,
    dataClass: #MIXED
}
define view entity hrpy_pcc_activity
  as select from    pyt_d_act_reso   as run_time_activity
    left outer join pyc_d_tl_task_t  as activity_text          on  activity_text.ref_id = run_time_activity.ac_al_ref_id
                                                               and activity_text.sprsl  = $session.system_language
    left outer join pyt_d_exe_status as exe_status             on exe_status.status = run_time_activity.status
    left outer join pyt_d_err_sta_t  as error_status_text      on  error_status_text.error_status_id = exe_status.error_status_id
                                                               and error_status_text.sprsl           = $session.system_language
    left outer join pyt_d_proc_sta_t as processing_status_text on  processing_status_text.processing_status_id = exe_status.processing_status_id
                                                               and processing_status_text.sprsl                = $session.system_language
    left outer join I_User           as last_changed_user      on last_changed_user.UserID = run_time_activity.lc_user
    left outer join adrp             as last_changed_user_name on last_changed_user_name.persnumber = last_changed_user.AddressPersonID
    left outer join I_User           as created_user           on created_user.UserID = run_time_activity.cr_user
    left outer join adrp             as created_user_name      on created_user_name.persnumber = created_user.AddressPersonID
{
  key   run_time_activity.root_ref_id        as rec_ref_id,
  key   run_time_activity.ref_id             as ac_ref_id,
        run_time_activity.cfg_ref_id         as cfg_ref_id,
        run_time_activity.ac_is_prod_payroll as is_prod_payroll,
        run_time_activity.ac_category        as category,
        exe_status.processing_status_id      as processing_status_id,
        exe_status.error_status_id           as error_status_id,
        processing_status_text.name          as processing_status_name,
        error_status_text.name               as error_status_name,
        activity_text.name                   as name,
        run_time_activity.ac_al_id           as id,
        run_time_activity.lc_user            as lc_user,
        last_changed_user_name.name_text     as lc_user_name,
        run_time_activity.lc_user            as cr_user,
        created_user_name.name_text          as cr_user_name,
        run_time_activity.cr_dt              as cr_dt,
        run_time_activity.lc_dt              as lc_dt
}
where
  run_time_activity.is_shadow = ''