ATOV_ITEM

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_ITEM.
-- 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_I

CREATE VIEW ATOV_ITEM AS
SELECT
  Current_Item_Version.item_type AS item_type,
  Current_Item_Version.item_id AS item_id,
  Current_Item_Version.item_status AS item_status,
  Current_Item_Version.last_notification AS changed_at,
  Item_Versions,
  Latest_Item_Version,
  Adaptation_Type_Texts
FROM ato_items AS Current_Item_Version
LEFT OUTER JOIN ATOV_TEXT_ADAPTATION_TYPE AS Adaptation_Type_Texts ON Adaptation_Type_Texts.code = Current_Item_Version.item_type  -- association [*]
LEFT OUTER JOIN ATOV_ITEM_VER AS Item_Versions ON Item_Versions.item_type = Current_Item_Version.item_type AND Item_Versions.item_id = Current_Item_Version.item_id  -- association [*]
LEFT OUTER JOIN ATOV_ITEM_VER AS Latest_Item_Version ON Latest_Item_Version.item_type = Current_Item_Version.item_type AND Latest_Item_Version.item_id = Current_Item_Version.item_id AND Latest_Item_Version.is_latest_version = 'X'  -- association [1]
;