ATOV_REWORK_DEMAND_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_DEMAND_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: ATO_V_RWK_DMNDB

CREATE VIEW ATOV_REWORK_DEMAND_BASE AS
SELECT
  Task.Item_Id AS Item_Id,
  Task.Item_Type AS Item_Type,
  Task.Highest_Priority AS Highest_Priority,
  Task.Highest_Priority_Code AS Priority_Code,
  Priority_Text.Description AS Priority_Text,
  case when Task.Number_Of_Tasks > 0 then 'X' when Task.Number_Of_Tasks = 0 then '' end as Rework AS Number_Of_Tasks0thenendasRework,
  case when Number_Of_Categories.Number_Of_Categories > 1 then 'MULTIPLE' else Single_Category.category end as Rework_Category AS categoryendasRework_Category
FROM ATOV_REWORK_DEMAND_SUB_BASE AS Task
LEFT OUTER JOIN ATOV_REWORK_TASK_PRIORITY AS Priority_Text ON Priority_Text.Code = Task.Highest_Priority_Code  -- association [1]
LEFT OUTER JOIN ATOV_REWORK_TASK_CATEGORY_CNT AS Number_Of_Categories ON Number_Of_Categories.item_id = Task.Item_Id AND Number_Of_Categories.item_type = Task.Item_Type AND Number_Of_Categories.priority = Task.Highest_Priority  -- association [1]
LEFT OUTER JOIN ATOV_REWORK_TASK_BASE AS Single_Category ON Single_Category.item_id = Task.Item_Id AND Single_Category.item_type = Task.Item_Type AND Single_Category.priority = Task.Highest_Priority  -- association [1]
;