SWW_DATAAGING_INCONSISTENT

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

CREATE VIEW SWW_DATAAGING_INCONSISTENT AS
SELECT
  header.wi_id AS wi_id,
  header.wi_type AS wi_type,
  header.wi_stat AS wi_stat,
  header.aging_state AS aging_state,
  header.wi_rh_task AS wi_rh_task,
  header.top_task AS top_task,
  header.wi_text AS wi_text,
  header.wi_lang AS wi_lang,
  tstmp_to_dats( header.crea_tmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as createdDateZonlo AS clientNULLascreatedDateZonlo,
  tstmp_to_tims( header.crea_tmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as createdTimeZonlo AS clientNULLascreatedTimeZonlo,
  header.crea_tmp AS crea_tmp,
  tstmp_to_dats( header.wi_aed_timestamp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as completedDateZonlo AS clientNULLascompletedDateZonlo,
  tstmp_to_tims( header.wi_aed_timestamp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as completedTimeZonlo AS clientNULLascompletedTimeZonlo,
  tstmp_to_dats( top_header.crea_tmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as topHeaderCreatedDateZonlo AS clientNULLastopHeaderCreatedDateZonlo,
  tstmp_to_tims( top_header.crea_tmp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as topHeaderCreatedTimeZonlo AS clientNULLastopHeaderCreatedTimeZonlo,
  tstmp_to_dats( top_header.wi_aed_timestamp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as topHeaderCompletedDateZonlo AS clientNULLastopHeaderCompletedDateZonlo,
  tstmp_to_tims( top_header.wi_aed_timestamp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as topHeaderCompletedTimeZonlo AS clientNULLastopHeaderCompletedTimeZonlo
FROM swwwihead AS header
LEFT OUTER JOIN swwwihead AS top_header ON /* join condition not captured in parsed metadata */
;