ATOV_IMP_CL

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_IMP_CL.
-- 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.

CREATE VIEW ATOV_IMP_CL AS
SELECT
  Change_List.exported_at AS exported_at,
  Change_List.created_by AS created_by,
  Change_List.created_at AS created_at,
  Change_List.transport AS transport,
  Change_List.status AS status,
  Change_List_Items,
  Related_Collection_Version,
  Downtime_Required_Texts
FROM atov_changelist_minus_ignored AS Change_List
LEFT OUTER JOIN ATOV_CL_ITEM AS Change_List_Items ON Change_List_Items.changelist_id = Change_List.changelist_id  -- association [*]
LEFT OUTER JOIN ATOV_COL_VER AS Related_Collection_Version ON Related_Collection_Version.collection_id = Change_List.collection_id AND Related_Collection_Version.collection_version = Change_List.collection_version  -- association [1]
LEFT OUTER JOIN ATOV_TEXT_DOWNTIME_REQUIRED AS Downtime_Required_Texts ON Downtime_Required_Texts.code = Change_List.downtimer_required  -- association [*]
;