Atov_Col_Item_ContiDep_Join

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_Item_ContiDep_Join.
-- 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_COL_CONTID

CREATE VIEW Atov_Col_Item_ContiDep_Join AS
SELECT
  Item.item_type AS item_type,
  Item.item_id AS item_id,
  Item.item_status AS item_status,
  Item.last_notification AS changed_at,
  COALESCE(Conti.last_updated_at, 0) AS Dep_updated_at,
  COALESCE(Released_References.updated_at , 0) AS SAP_Ref_updated_at
FROM ato_items AS Item
LEFT OUTER JOIN Atov_Contidep_Item_Key AS Conti ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ATOV_CONTI_DEP_SAP_KEY AS Released_References ON /* join condition not captured in parsed metadata */
INNER JOIN ato_adapt_types AS Adapt_Type ON /* join condition not captured in parsed metadata */
;