atov_cmn_col_ver_imp_his_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_cmn_col_ver_imp_his_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.

CREATE VIEW atov_cmn_col_ver_imp_his_base AS
SELECT
  history.version AS version,
  history.timestamp AS timestamp,
  history.resource_id AS resource_id,
  resource.last_changed_at AS imported_at
FROM ato_col_versions AS history
INNER JOIN ato_cmn_imp AS resource ON /* join condition not captured in parsed metadata */
INNER JOIN atov_collection_type_import AS collection_type ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ato_cols AS col ON col.collection_id = history.collection_id  -- association [1]
LEFT OUTER JOIN ATOV_COLLECTION_TYPE AS collection_type_desc ON collection_type_desc.code = collection_type  -- association [1]
LEFT OUTER JOIN ato_col_v_status AS col_current_status ON col_current_status.collection_id = history.collection_id AND col_current_status.version = history.version AND col_current_status.status_schema = 'I'  -- association [0..1]
LEFT OUTER JOIN atov_text_collection_status AS status_after_import_descripton ON status_after_import_descripton.code = status_after_import  -- association [*]
LEFT OUTER JOIN atov_text_collection_status AS current_status_description ON current_status_description.code = current_status  -- association [*]
LEFT OUTER JOIN ATOV_TEXT_IMPORT_CHANNEL AS import_channel_description ON import_channel_description.code = resource.import_channel  -- association [0..1]
;