SWW_SDDL_SWWWITEXT

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

CREATE VIEW SWW_SDDL_SWWWITEXT AS
SELECT
  SWW_SDDL_SWWWIHEAD.wi_id AS wi_id,
  swwwitext.wi_lang AS wi_lang,
  swwwitext.wi_text AS wi_text,
  tstmp_to_dats( swwwitext.crea_tmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as witextCreatedDateZonlo AS clientNULLaswitextCreatedDateZonlo,
  tstmp_to_tims( swwwitext.crea_tmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as witextCreatedTimeZonlo AS clientNULLaswitextCreatedTimeZonlo,
  swwwitext.crea_tmp AS crea_tmp,
  error_code,
  top_task,
  top_wi_id,
  createdDateZonlo,
  createdTimeZonlo,
  completedDateZonlo,
  completedTimeZonlo,
  wi_type,
  wi_stat,
  wi_cruser,
  wi_chckwi,
  wi_rh_task,
  wi_prio,
  wi_comp_ev,
  wi_forw_by,
  retry_cnt,
  max_retry,
  wi_release,
  wf_type,
  def_guid,
  prs_profil,
  aging_state,
  wi_creator,
  wi_rhtext,
  wi_cbfb,
  tclass,
  note_exist,
  notify,
  step_id,
  wi_aagent,
  wi_aaddr,
  wi_craddr,
  wi_confirm,
  wi_disable,
  wi_reject,
  cb_done,
  no_deadl,
  wi_dh_stat,
  exec_time,
  note_count,
  check_stat,
  blocktype,
  parent_wi,
  rndnumber,
  wfd_id,
  wfd_version,
  wfd_exetyp,
  proccat,
  wi_text_id,
  code,
  errortype,
  name,
  workarea,
  message,
  variable1,
  variable2,
  variable3,
  variable4,
  catid,
  excp_type,
  exc_clsnam,
  startedDateZonlo,
  startedTimeZonlo,
  wi_asts,
  guid
FROM swwwitext
LEFT OUTER JOIN SWW_SDDL_SWWWIHEAD ON /* join condition not captured in parsed metadata */
;