ATOV_REWORK_TASK_BASE

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 ATOV_REWORK_TASK_BASE.
-- 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: ATOV_RWK_T_B

CREATE VIEW ATOV_REWORK_TASK_BASE AS
SELECT
  Task.item_id AS item_id,
  Task.item_type AS item_type,
  Task.origin AS origin,
  Task.task_id AS task_id,
  Task.msgid AS msgid,
  Task.msgno AS msgno,
  case Task.origin when 'R' then coalesce ( msgv3.description, Task.msgv3 ) else Task.msgv3 end as Msgv3 AS msgv3endasMsgv3,
  Task.priority AS priority,
  category,
  updated_at,
  first_found
FROM ato_rework_task AS Task
LEFT OUTER JOIN ATOV_DEPRECATION_TASK_OBJ_DESC AS msgv1 ON msgv1.object_type = Task.msgv1  -- association [1]
LEFT OUTER JOIN ATOV_DEPRECATION_TASK_OBJ_DESC AS msgv2 ON msgv2.object_type = Task.msgv2  -- association [1]
LEFT OUTER JOIN ATOV_DEPRECATION_TASK_OBJ_DESC AS msgv3 ON msgv3.object_type = Task.msgv3  -- association [0..1]
LEFT OUTER JOIN ATOV_DEPRECATION_TASK_OBJ_DESC AS msgv4 ON msgv4.object_type = Task.msgv4  -- association [1]
;