SWW_SDDL_SWW_USRATT

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SWW_SDDL_SWW_USRATT.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SWW_V_SWW_USRATT
-- Parameters: timeZoneUpdate : tznzone

CREATE VIEW SWW_SDDL_SWW_USRATT AS
SELECT
  sww_usratt.wi_id AS wi_id,
  tstmp_to_dats( sww_usratt.last_change, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as lastChangedDateZonlo AS clientNULLaslastChangedDateZonlo,
  tstmp_to_tims( sww_usratt.last_change, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as lastChangedTimeZonlo AS clientNULLaslastChangedTimeZonlo,
  sww_usratt.last_change AS last_change,
  sww_usratt.scenario AS scenario,
  sww_usratt.tab_index AS tab_index,
  sww_usratt.type AS type,
  sww_usratt.value_c AS value_c,
  sww_usratt.value_i AS value_i,
  sww_usratt.value_d AS value_d,
  sww_usratt.unit AS unit,
  sww_usratt.top_task AS top_task,
  sww_usratt.pfe_index AS pfe_index,
  sww_usratt.def_task AS def_task,
  sww_usratt.def_nodeid AS def_nodeid,
  tstmp_to_dats( swwwihead.crea_tmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as taskCreatedDateZonlo AS clientNULLastaskCreatedDateZonlo,
  tstmp_to_tims( swwwihead.crea_tmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as taskCreatedTimeZonlo AS clientNULLastaskCreatedTimeZonlo,
  swwwihead.crea_tmp AS crea_tmp,
  tstmp_to_dats( swwwihead.wi_aed_timestamp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as taskCompletedDateZonlo AS clientNULLastaskCompletedDateZonlo,
  tstmp_to_tims( swwwihead.wi_aed_timestamp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as taskCompletedTimeZonlo AS clientNULLastaskCompletedTimeZonlo,
  swwwihead.wi_type AS wi_type,
  swwwihead.wi_text AS wi_text,
  swwwihead.wi_stat AS wi_stat,
  swwwihead.wi_cruser AS wi_cruser,
  swwwihead.wi_rh_task AS wi_rh_task,
  swwwihead.wi_prio AS wi_prio,
  swwwihead.wi_release AS wi_release,
  swwwihead.wf_type AS wf_type,
  swwwihead.top_wi_id AS top_wi_id,
  swwwihead.prs_profil AS prs_profil,
  swwwihead.wi_chckwi AS wi_chckwi,
  swwwihead.wi_creator AS wi_creator,
  swwwihead.wi_lang AS wi_lang,
  swwwihead.wi_aagent AS wi_aagent,
  swwwihead.wi_aaddr AS wi_aaddr,
  swwwihead.wi_cbfb AS wi_cbfb,
  swwwihead.wi_confirm AS wi_confirm,
  swwwihead.wi_comp_ev AS wi_comp_ev,
  swwwihead.wi_forw_by AS wi_forw_by,
  swwwihead.wi_disable AS wi_disable,
  swwwihead.wi_reject AS wi_reject,
  swwwihead.tclass AS tclass,
  swwwihead.note_exist AS note_exist,
  swwwihead.notify AS notify,
  swwwihead.retry_cnt AS retry_cnt,
  swwwihead.max_retry AS max_retry,
  swwwihead.rc_modeled AS rc_modeled,
  swwwihead.cb_done AS cb_done,
  swwwihead.handle AS handle,
  swwwihead.syncchain AS syncchain,
  swwwihead.no_deadl AS no_deadl,
  swwwihead.wi_dh_stat AS wi_dh_stat,
  swwwihead.wlc_displ AS wlc_displ,
  swwwihead.wi_restlog AS wi_restlog,
  swwwihead.remote_id AS remote_id,
  swwwihead.remote_sys AS remote_sys,
  swwwihead.status_evt AS status_evt,
  swwwihead.wlc_flags AS wlc_flags,
  swwwihead.xmlprot AS xmlprot,
  swwwihead.wait4cb AS wait4cb,
  swwwihead.def_guid AS def_guid,
  swwwihead.exec_time AS exec_time,
  swwwihead.note_count AS note_count,
  swwwihead.check_stat AS check_stat,
  swwwihead.blocktype AS blocktype,
  swwwihead.parent_wi AS parent_wi,
  swwwihead.wfd_id AS wfd_id,
  swwwihead.wfd_version AS wfd_version,
  swwwihead.wfd_exetyp AS wfd_exetyp,
  swwwihead.proccat AS proccat,
  swwwihead.aging_state AS aging_state,
  swwwihead.step_id AS step_id,
  swwwihead.wi_text_id AS wi_text_id
FROM sww_usratt
LEFT OUTER JOIN swwwihead ON /* join condition not captured in parsed metadata */
;