ATOV_COL_VER_EXP_XC_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_COL_VER_EXP_XC_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_XC_CVEI

CREATE VIEW ATOV_COL_VER_EXP_XC_ITEM AS
SELECT
  Collection_Version_Item.item_type AS item_type,
  Collection_Version_Item.item_id AS item_id,
  Collection_Version_Item.last_notification AS timestamp,
  Collection_Version_Item.collection_item_status AS item_status,
  Collection_Version_Item.last_notification AS changed_at,
  Collection_Version_Item.last_notification_by AS changed_by,
  Adaptation_Type_Texts,
  Adaptation_Type,
  Col_Item_Status_Texts,
  Changed_By_Description,
  #ABAP_BOOLEAN.'X' AS is_exported
FROM ATOV_COL_XC_ITEM_BASE_LATEST AS Collection_Version_Item
LEFT OUTER JOIN ATOV_TEXT_ADAPTATION_TYPE AS Adaptation_Type_Texts ON Adaptation_Type_Texts.code = Collection_Version_Item.item_type AND Adaptation_Type_Texts.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ATOV_TEXT_COL_ITEM_STATUS AS Col_Item_Status_Texts ON Col_Item_Status_Texts.code = Collection_Version_Item.collection_item_status AND Col_Item_Status_Texts.language = $session.system_language  -- association [1]
LEFT OUTER JOIN ATOV_USER AS Changed_By_Description ON Changed_By_Description.name = Collection_Version_Item.last_notification_by  -- association [1]
LEFT OUTER JOIN ATOV_ADAPTATION_TYPE AS Adaptation_Type ON Adaptation_Type.code = Collection_Version_Item.item_type  -- association [1]
LEFT OUTER JOIN ato_cols AS Collection ON Collection.collection_id = Collection_Version_Item.collection_id  -- association [1]
LEFT OUTER JOIN ato_cols AS SourceCollection ON SourceCollection.collection_id = Collection_Version_Item.source_collection_id  -- association [1]
;