EITV_EXP_TEMPL

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 EITV_EXP_TEMPL.
-- 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: EIT_V_EXP_TEMPL

CREATE VIEW EITV_EXP_TEMPL AS
SELECT
  Collection.collection_id AS template_id,
  Collection.created_by AS created_by,
  Collection.created_at AS created_at,
  Latest_Version.status AS status,
  Latest_Version.action AS action,
  Items AS _Items,
  Changed_By_Description AS _Changed_By_Description,
  Created_By_Description AS _Created_By_Description,
  Status_Texts AS _Status_Texts,
  Action_Status_Texts AS _Action_Status_Texts,
  Action_Texts AS _Action_Text,
  Items_to_add AS _Items_to_add,
  Latest_Log AS _Latest_Log,
  Log AS _Log,
  Log_Counter AS _Log_Counter,
  Files AS _Files
FROM ato_cols AS Collection
INNER JOIN EITV_EXP_TEMPL_LATEST_VER AS Latest_Version ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_USER AS Changed_By_Description ON Changed_By_Description.name = last_changed_by  -- association [1]
LEFT OUTER JOIN ATOV_USER AS Created_By_Description ON Created_By_Description.name = Collection.created_by  -- association [1]
LEFT OUTER JOIN EITV_EXP_ACTION_STATUS_TEXT AS Status_Texts ON Status_Texts.code = status  -- association [*]
LEFT OUTER JOIN ATOV_TEXT_ACTION AS Action_Texts ON Action_Texts.code = action  -- association [*]
LEFT OUTER JOIN ATOV_TEXT_ACTION_STATUS AS Action_Status_Texts ON Action_Status_Texts.code = action_status  -- association [*]
LEFT OUTER JOIN EITV_EXP_TEMPL_ITEMS AS Items ON Items.template_id = Collection.collection_id  -- association [*]
LEFT OUTER JOIN EITV_EXP_ITEMS_ADD AS Items_to_add ON Items_to_add.template_id = Collection.collection_id  -- association [*]
LEFT OUTER JOIN ATOV_LOG AS Latest_Log ON Latest_Log.collection_id = template_id AND Latest_Log.collection_version = latest_version AND Latest_Log.ballog_handle = latest_ballog_handle  -- association [0..1]
LEFT OUTER JOIN ATOV_LOG AS Log ON Log.collection_id = template_id AND Log.collection_version = latest_version AND Log.is_outdated = ''  -- association [*]
LEFT OUTER JOIN ATOV_COL_VER_COUNT_LOGS AS Log_Counter ON Log_Counter.collection_id = template_id AND Log_Counter.collection_version = latest_version AND Log_Counter.is_outdated = ''  -- association [1]
LEFT OUTER JOIN EITV_EXP_FILES AS Files ON Files.template_id = Collection.collection_id  -- association [0..*]
;