sww_sddl_register

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_register.
-- 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_REGISTER
-- Parameters: timeZoneUpdate : tznzone

CREATE VIEW sww_sddl_register AS
SELECT
  sww_wiregister.application AS application,
  sww_wiregister.subcategory AS subcategory,
  sww_wiregister.wi_id AS wi_id,
  tstmp_to_dats( sww_wiregister.crt_tmstmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as createdDateZonlo AS clientNULLascreatedDateZonlo,
  tstmp_to_tims( sww_wiregister.crt_tmstmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as createdTimeZonlo AS clientNULLascreatedTimeZonlo,
  sww_wiregister.crt_tmstmp AS crt_tmstmp,
  tstmp_to_dats( sww_wiregister.chg_tmstmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as changedDateZonlo AS clientNULLaschangedDateZonlo,
  tstmp_to_tims( sww_wiregister.chg_tmstmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as changedTimeZonlo AS clientNULLaschangedTimeZonlo,
  sww_wiregister.chg_tmstmp AS chg_tmstmp,
  tstmp_to_dats( sww_wiregister.next_eval, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as nextEvaluationDateZonlo AS clientNULLasnextEvaluationDateZonlo,
  tstmp_to_tims( sww_wiregister.next_eval, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as nextEvaluationTimeZonlo AS clientNULLasnextEvaluationTimeZonlo,
  sww_wiregister.next_eval AS next_eval,
  sww_wiregister.retry_count AS retry_count,
  sww_wiregister.retries_left AS retries_left,
  sww_wiregister.status AS status,
  sww_wiregister.value AS value,
  SWW_SDDL_SWWWIHEAD.top_task AS top_task,
  SWW_SDDL_SWWWIHEAD.top_wi_id AS top_wi_id,
  SWW_SDDL_SWWWIHEAD.createdDateZonlo AS taskCreatedDateZonlo,
  SWW_SDDL_SWWWIHEAD.createdTimeZonlo AS taskCreatedTimeZonlo,
  SWW_SDDL_SWWWIHEAD.crea_tmp AS crea_tmp,
  SWW_SDDL_SWWWIHEAD.completedDateZonlo AS taskCompletedDateZonlo,
  SWW_SDDL_SWWWIHEAD.completedTimeZonlo AS taskCompletedTimeZonlo,
  SWW_SDDL_SWWWIHEAD.wi_type AS wi_type,
  SWW_SDDL_SWWWIHEAD.wi_text AS wi_text,
  SWW_SDDL_SWWWIHEAD.wi_stat AS wi_stat,
  SWW_SDDL_SWWWIHEAD.wi_cruser AS wi_cruser,
  SWW_SDDL_SWWWIHEAD.wi_chckwi AS wi_chckwi,
  SWW_SDDL_SWWWIHEAD.wi_rh_task AS wi_rh_task,
  SWW_SDDL_SWWWIHEAD.wi_prio AS wi_prio,
  SWW_SDDL_SWWWIHEAD.wi_comp_ev AS wi_comp_ev,
  SWW_SDDL_SWWWIHEAD.wi_forw_by AS wi_forw_by,
  SWW_SDDL_SWWWIHEAD.retry_cnt AS retry_cnt,
  SWW_SDDL_SWWWIHEAD.max_retry AS max_retry,
  SWW_SDDL_SWWWIHEAD.wi_release AS wi_release,
  SWW_SDDL_SWWWIHEAD.wf_type AS wf_type,
  SWW_SDDL_SWWWIHEAD.def_guid AS def_guid,
  SWW_SDDL_SWWWIHEAD.prs_profil AS prs_profil,
  SWW_SDDL_SWWWIHEAD.aging_state AS aging_state,
  SWW_SDDL_SWWWIHEAD.wi_creator AS wi_creator,
  SWW_SDDL_SWWWIHEAD.wi_rhtext AS wi_rhtext,
  SWW_SDDL_SWWWIHEAD.wi_cbfb AS wi_cbfb,
  SWW_SDDL_SWWWIHEAD.tclass AS tclass,
  SWW_SDDL_SWWWIHEAD.note_exist AS note_exist,
  SWW_SDDL_SWWWIHEAD.notify AS notify,
  SWW_SDDL_SWWWIHEAD.step_id AS step_id,
  SWW_SDDL_SWWWIHEAD.wi_lang AS wi_lang,
  SWW_SDDL_SWWWIHEAD.wi_aagent AS wi_aagent,
  SWW_SDDL_SWWWIHEAD.wi_aaddr AS wi_aaddr,
  SWW_SDDL_SWWWIHEAD.wi_craddr AS wi_craddr,
  SWW_SDDL_SWWWIHEAD.wi_confirm AS wi_confirm,
  SWW_SDDL_SWWWIHEAD.wi_disable AS wi_disable,
  SWW_SDDL_SWWWIHEAD.wi_reject AS wi_reject,
  SWW_SDDL_SWWWIHEAD.cb_done AS cb_done,
  SWW_SDDL_SWWWIHEAD.no_deadl AS no_deadl,
  SWW_SDDL_SWWWIHEAD.wi_dh_stat AS wi_dh_stat,
  SWW_SDDL_SWWWIHEAD.exec_time AS exec_time,
  SWW_SDDL_SWWWIHEAD.note_count AS note_count,
  SWW_SDDL_SWWWIHEAD.check_stat AS check_stat,
  SWW_SDDL_SWWWIHEAD.blocktype AS blocktype,
  SWW_SDDL_SWWWIHEAD.parent_wi AS parent_wi,
  SWW_SDDL_SWWWIHEAD.rndnumber AS rndnumber,
  SWW_SDDL_SWWWIHEAD.wfd_id AS wfd_id,
  SWW_SDDL_SWWWIHEAD.wfd_version AS wfd_version,
  SWW_SDDL_SWWWIHEAD.wfd_exetyp AS wfd_exetyp,
  SWW_SDDL_SWWWIHEAD.proccat AS proccat,
  SWW_SDDL_SWWWIHEAD.wi_text_id AS wi_text_id
FROM sww_wiregister
LEFT OUTER JOIN SWW_SDDL_SWWWIHEAD ON /* join condition not captured in parsed metadata */
;