SWW_SDDL_SWW_USRATT

@AbapCatalog.sqlViewName: 'SWW_V_SWW_USRATT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Workflow: Work item custom values'
define view SWW_SDDL_SWW_USRATT
  with parameters
    timeZoneUpdate :tznzone
  as select from    sww_usratt
    left outer join swwwihead on swwwihead.wi_id = sww_usratt.wi_id
{
  key sww_usratt.wi_id,
      tstmp_to_dats( sww_usratt.last_change,
                     $parameters.timeZoneUpdate,
                     $session.client,
                     'NULL' )     as lastChangedDateZonlo,
      tstmp_to_tims( sww_usratt.last_change,
                     $parameters.timeZoneUpdate,
                     $session.client,
                     'NULL' )     as lastChangedTimeZonlo,
      sww_usratt.last_change,
      sww_usratt.scenario,
      sww_usratt.attribute_name,
      sww_usratt.tab_index,
      sww_usratt.type,
      sww_usratt.value_c,
      sww_usratt.value_i,
      sww_usratt.value_d,
      sww_usratt.unit,
      sww_usratt.top_task,
      sww_usratt.wi_stat as sww_usratt_wi_stat,
      sww_usratt.pfe_index,
      sww_usratt.def_task,
      sww_usratt.def_nodeid,
      tstmp_to_dats( swwwihead.crea_tmp,
                     $parameters.timeZoneUpdate,
                     $session.client,
                     'NULL' )     as taskCreatedDateZonlo,
      tstmp_to_tims( swwwihead.crea_tmp,
                     $parameters.timeZoneUpdate,
                     $session.client,
                     'NULL' )     as taskCreatedTimeZonlo,
      swwwihead.crea_tmp,
      tstmp_to_dats( swwwihead.wi_aed_timestamp,
                     $parameters.timeZoneUpdate,
                     $session.client,
                     'NULL' )     as taskCompletedDateZonlo,
      tstmp_to_tims( swwwihead.wi_aed_timestamp,
                     $parameters.timeZoneUpdate,
                     $session.client,
                     'NULL' )     as taskCompletedTimeZonlo,
      swwwihead.wi_aed_timestamp,
      swwwihead.wi_type,
      swwwihead.wi_text,
      swwwihead.wi_stat,
      swwwihead.wi_cruser,
      swwwihead.wi_rh_task,
      swwwihead.wi_prio,
      swwwihead.wi_release,
      swwwihead.wf_type,
      swwwihead.top_wi_id,
      swwwihead.prs_profil,
      swwwihead.reference_nodeid,
      swwwihead.wi_chckwi,
      swwwihead.wi_creator, 
      swwwihead.wi_lang, 
      swwwihead.wi_aagent, 
      swwwihead.wi_aaddr, 
      swwwihead.wi_cbfb, 
      swwwihead.wi_confirm, 
      swwwihead.wi_comp_ev, 
      swwwihead.wi_forw_by, 
      swwwihead.wi_disable, 
      swwwihead.wi_reject, 
      swwwihead.tclass, 
      swwwihead.note_exist, 
      swwwihead.notify, 
      swwwihead.retry_cnt, 
      swwwihead.max_retry, 
      swwwihead.rc_modeled, 
      swwwihead.cb_done, 
      swwwihead.handle, 
      swwwihead.syncchain, 
      swwwihead.no_deadl, 
      swwwihead.wi_dh_stat, 
      swwwihead.wlc_displ, 
      swwwihead.wi_restlog, 
      swwwihead.remote_id, 
      swwwihead.remote_sys, 
      swwwihead.status_evt, 
      swwwihead.wlc_flags, 
      swwwihead.xmlprot, 
      swwwihead.wait4cb, 
      swwwihead.def_guid, 
      swwwihead.exec_time, 
      swwwihead.note_count, 
      swwwihead.check_stat, 
      swwwihead.blocktype, 
      swwwihead.parent_wi, 
      swwwihead.wfd_id, 
      swwwihead.wfd_version, 
      swwwihead.wfd_exetyp, 
      swwwihead.proccat, 
      swwwihead.aging_state, 
      swwwihead.aging_temperature, 
      swwwihead.wlc_flags_ext, 
      swwwihead.step_id, 
      swwwihead.agent_rule_id, 
      swwwihead.wi_text_id
}