ATOV_COL_VER_IMP_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_COL_VER_IMP_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_CVI_B

CREATE VIEW ATOV_COL_VER_IMP_BASE AS
SELECT
  Collection_Version_Key.timestamp AS timestamp,
  Collection_Version_Key.status AS db_status,
  Collection_Version_Key.action_executed_by AS changed_by,
  Collection_Version_Key.action_executed_at AS changed_at,
  Collection_Version_Key.imported_at AS imported_at,
  Collection,
  Collection_Version_Items,
  Logs,
  Effective_Import_Logs,
  Effective_Import_Log_Counter,
  Latest_Log,
  Status_Texts,
  Changed_By_Description,
  Latest_Action_Texts,
  Latest_Action_Status_Texts,
  Collection_Merge,
  Notes
FROM ATOV_COL_VER_IMP_BASE1 AS Collection_Version_Key
LEFT OUTER JOIN ATOV_CHANGELIST_MINUS_IGN_TR AS Change_List ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_GET_ALL_CBC AS CBC ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_COL_VER_IMP_ITEM AS Collection_Version_Items ON Collection_Version_Items.collection_id = Collection_Version_Key.collection_id AND Collection_Version_Items.collection_version = Collection_Version_Key.collection_version  -- association [*]
LEFT OUTER JOIN ATOV_LOG AS Logs ON Logs.collection_id = Collection_Version_Key.collection_id AND Logs.collection_version = Collection_Version_Key.collection_version  -- association [*]
LEFT OUTER JOIN ATOV_LOG AS Effective_Import_Logs ON Effective_Import_Logs.collection_id = Collection_Version_Key.collection_id AND Effective_Import_Logs.collection_version = Collection_Version_Key.collection_version AND Effective_Import_Logs.action_category = 'I' AND Effective_Import_Logs.is_outdated = ''  -- association [*]
LEFT OUTER JOIN ATOV_COL_VER_COUNT_LOGS AS Effective_Import_Log_Counter ON Effective_Import_Log_Counter.collection_id = Collection_Version_Key.collection_id AND Effective_Import_Log_Counter.collection_version = Collection_Version_Key.collection_version AND Effective_Import_Log_Counter.action_category = 'I' AND Effective_Import_Log_Counter.is_outdated = ''  -- association [1]
LEFT OUTER JOIN atov_col_ver_imp_latest_ballog AS Latest_Log ON Latest_Log.collection_id = Collection_Version_Key.collection_id AND Latest_Log.version = Collection_Version_Key.collection_version  -- association [0..1]
LEFT OUTER JOIN ATOV_COL AS Collection ON Collection.collection_id = Collection_Version_Key.collection_id  -- association [1]
LEFT OUTER JOIN atov_text_collection_status AS Status_Texts ON Status_Texts.code = status  -- association [*]
LEFT OUTER JOIN ATOV_TEXT_ACTION AS Latest_Action_Texts ON Latest_Action_Texts.code = latest_action  -- association [*]
LEFT OUTER JOIN ATOV_TEXT_ACTION_STATUS AS Latest_Action_Status_Texts ON Latest_Action_Status_Texts.code = latest_action_status  -- association [*]
LEFT OUTER JOIN ATOV_TEXT_TRANS_AUTOMATION_MOD AS Trans_Auto_Mode_Texts ON Trans_Auto_Mode_Texts.code = Change_List.transport_automation_mode  -- association [0..1]
LEFT OUTER JOIN ATOV_USER AS Changed_By_Description ON Changed_By_Description.name = changed_by  -- association [1]
LEFT OUTER JOIN ATOV_COL_MERGE AS Collection_Merge ON Collection_Version_Key.collection_id = Collection_Merge.CollectionId AND Collection_Version_Key.collection_version = Collection_Merge.CollectionVersion  -- association [*]
LEFT OUTER JOIN ATOV_COL_NOTES AS Notes ON Notes.collection_id = Collection_Version_Key.collection_id AND Notes.collection_version = Collection_Version_Key.collection_version  -- association [*]
LEFT OUTER JOIN ATOV_COL_VER_COUNT_NOTES AS Notes_Counter ON Notes_Counter.collection_id = Collection_Version_Key.collection_id AND Notes_Counter.collection_version = Collection_Version_Key.collection_version  -- association [1]
LEFT OUTER JOIN atov_col_imp_ver_action_count AS Actions_Counter ON Actions_Counter.collection_id = Collection_Version_Key.collection_id AND Actions_Counter.version = Collection_Version_Key.collection_version  -- association [1]
;