ATOV_XC_ITEM

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_XC_ITEM.
-- 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: ATOV_XC_I

CREATE VIEW ATOV_XC_ITEM AS
SELECT
  Item.item_type AS item_type,
  Item.item_id AS item_id,
  Item.changed_at AS changed_at,
  Item.changed_by AS changed_by,
  Item.package_name AS package_name,
  Item.prefix AS prefix,
  Item.notifiable AS notifiable,
  ItemVersions
FROM ATOV_U_ITEM_BASE AS Item
LEFT OUTER JOIN ATOV_U_ITEM_VERSION AS ItemVersions ON ItemVersions.item_type = Item.item_type AND ItemVersions.item_id = Item.item_id  -- association [1..*]
;