atov_col_ver_set_as_imported

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_set_as_imported.
-- 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_col_ver_set_as_imported AS
SELECT
  set_as_imported.version AS version,
  set_as_imported.timestamp AS timestamp,
  set_as_imported.resource_id AS resource_id,
  set_as_imported.last_changed_at AS imported_at
FROM ato_col_versions AS set_as_imported
LEFT OUTER JOIN ato_cols AS col ON col.collection_id = set_as_imported.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 = set_as_imported.collection_id AND col_current_status.version = set_as_imported.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 [*]
;